Hi, also asked this om the forum.
I'm in a situation where I need to pre-load (prime) the database tables with correct data. Getting the data ready for loading isn't the problem, I do this all the time with the postfixadmin tables. A bit of perl and some copy ans pasting fits the job. The roundcube tables, however, are cleverly linked with foreign keys which prevents me to just delete a table and re-generating an filling it with my own data. Unnessessary to say that ['auto_create_user'] = FALSE here.
Is there anybody out there who could put me om the right trace? I realize that this is more a MySQL question but I thought trying it here first.
TIA Egbert Jan (NL)
List info: http://lists.roundcube.net/users/
You could use a plugin for that:
there is a hook that allows you to execute your own code after a login. There are for instance plugins out there that copy the contents from a MySQL based addressbook to the RC addressbook.
Br,
Dennis
Op 15 mei 2010, om 23:22 heeft Egbert Jan het volgende geschreven:
Hi, also asked this om the forum.
I'm in a situation where I need to pre-load (prime) the database tables with correct data. Getting the data ready for loading isn't the problem, I do this all the time with the postfixadmin tables. A bit of perl and some copy ans pasting fits the job. The roundcube tables, however, are cleverly linked with foreign keys which prevents me to just delete a table and re-generating an filling it with my own data. Unnessessary to say that ['auto_create_user'] = FALSE here.
Is there anybody out there who could put me om the right trace? I realize that this is more a MySQL question but I thought trying it here first.
TIA Egbert Jan (NL)
List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/
TNX Dennis. I was looking at the 'new_user_identity' plugin. After all it was enough to use the 'virtuser_query' on an existing postfixadmin table like this:
"SELECT address FROM postfixadmin.alias2 WHERE goto = '%u' AND address != '%u';"
In that table two entries for the same person: one is identical to %u and I want the other in 'identities'.
cheers Egbert Jan
-----Oorspronkelijk bericht----- Van: Dennis Ortsen [mailto:dortsen@gmail.com] Verzonden: zondag 16 mei 2010 19:10 Aan: Egbert Jan CC: users@lists.roundcube.net Onderwerp: Re: [RCU] priming the mysql tables with data
You could use a plugin for that:
there is a hook that allows you to execute your own code after a login. There are for instance plugins out there that copy the contents from a MySQL based addressbook to the RC addressbook.
Br,
Dennis
Op 15 mei 2010, om 23:22 heeft Egbert Jan het volgende geschreven:
Hi, also asked this om the forum.
I'm in a situation where I need to pre-load (prime) the database tables with correct data. Getting the data ready for
loading isn't the
problem, I do this all the time with the postfixadmin
tables. A bit of
perl and some copy ans pasting fits the job. The roundcube tables, however, are cleverly linked with foreign keys which prevents me to just delete a table and re-generating an filling it with my
own data.
Unnessessary to say that ['auto_create_user'] = FALSE here.
Is there anybody out there who could put me om the right trace? I realize that this is more a MySQL question but I thought trying it here first.
TIA Egbert Jan (NL)
List info: http://lists.roundcube.net/users/
List info: http://lists.roundcube.net/users/
On 05/15/10 17:22, Egbert Jan wrote:
Hi, also asked this om the forum.
I'm in a situation where I need to pre-load (prime) the database tables with correct data. Getting the data ready for loading isn't the problem, I do this all the time with the postfixadmin tables. A bit of perl and some copy ans pasting fits the job. The roundcube tables, however, are cleverly linked with foreign keys which prevents me to just delete a table and re-generating an filling it with my own data. Unnessessary to say that ['auto_create_user'] = FALSE here.
Is there anybody out there who could put me om the right trace? I realize that this is more a MySQL question but I thought trying it here first.
Just turn off the foreign key checks while you're importing data:
SET foreign_key_checks = 0;
Reference:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
Search for foreign_key_checks.
List info: http://lists.roundcube.net/users/
-
Dennis Ortsen -
Egbert Jan -
Michael Orlitzky