I'm not an sql expert but I'll at least give you some directions. First you need to know the users
SELECT identity_id, email FROM identities You will get some output like this: *identity_id email* 1 someem...@host.domain.us 2 em...@host.domain.us 3 otherem...@host.domain.us 4 someotherem...@host.domain.us The SQL command to change the first identity number 1 would be: UPDATE `roundcubemail`.`identities` SET `email` = 'someem...@domain.us' WHERE `identities`.`identity_id` =1 This example assumes the database name is roundcubemail. I think you can do a mass change doing a joint sql command. You can also use some spreadsheet software or advanced text file editor to replicate the UPDATE command to the other users. Hope this is a good start MAKE BACKUPS! Eden Caldas 2009/5/18 Carlos Williams <carlosw...@gmail.com> > On Mon, May 18, 2009 at 3:01 PM, Eden Caldas <edencal...@gmail.com> wrote: > > Set your domain there, to make mail be sent as u...@domain.us > > This setting will only be applied to new users because existing users > > already logged in roundcube once and got the wrong settings. > > Thanks. I did think to change that but when I tested it, I saw no > change but that makes sense because you stated > it's for new users since RC got it wrong in MySQL already. > > > Since roundcube keeps its configuration in a database (mysql, postgres, > > sqlite) you can always use sql to mass change the existing settings for > > previous users. If you use mysql as your database, the web application > > phpmyadmin can help. > > I don't have or use phpadmin so do you per chance happen to know how I > can manually do this via MySQL? > _______________________________________________ > List info: http://lists.roundcube.net/users/ >
_______________________________________________ List info: http://lists.roundcube.net/users/
