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:[email protected]] > Verzonden: zondag 16 mei 2010 19:10 > Aan: Egbert Jan > CC: [email protected] > 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/
