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              someemail@host.domain.us
2              email@host.domain.us
3              otheremail@host.domain.us
4              someotheremail@host.domain.us

The SQL command to change the first identity number 1 would be:

UPDATE `roundcubemail`.`identities` SET `email` = 'someemail@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 <carloswill@gmail.com>
On Mon, May 18, 2009 at 3:01 PM, Eden Caldas <edencaldas@gmail.com> wrote:
> Set your domain there, to make mail be sent as user@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/