[v-webmail] Re: external mysql
- From: "David Slagel" <davids@xxxxxxxxxxx>
- To: <v-webmail@xxxxxxxxxxxxx>
- Date: Fri, 7 Nov 2003 13:21:58 -0600
The userpref hosts column in the MySQL database most likely says localhost
for each user preference. Now that the MySQL DB and the webmail are on
different machines, it should be the address (or name?) of the webmail
server instead.
Simply login to webmail and change some prefs or address book, look at the
database to see what it put in for the host column (now that they are on
different machines), then delete all the records that have the new host info
(to revert back to before the move), then run an update query to change the
hosts column from localhost to whatever it puts in there now (either IP
address of webmail server or name of webmail server)..
Good Luck!
David
> -----Original Message-----
> From: v-webmail-bounce@xxxxxxxxxxxxx
> [mailto:v-webmail-bounce@xxxxxxxxxxxxx]On Behalf Of Marius Herea / MCD
> Sent: Friday, November 07, 2003 10:42 AM
> To: v-webmail@xxxxxxxxxxxxx
> Subject: [v-webmail] external mysql
>
>
> Hi,
>
> I have moved my mysql on another machine and suddenly, all user lost their
> preferences.
> Their mail rules, external account .. etc..
>
> And another thing.. they got subscribed to send-mail, deleted-mail, drafts
>
> Where did I did wrong?
>
> Marius
>
> --
> V-webmail Support Mailing List (http://www.v-webmail.org)
> Archives: //www.freelists.org/archives/v-webmail/
> To unsubscribe, send mail to: v-webmail-request@xxxxxxxxxxxxx
> with "unsubscribe" in the subject
>
>
--
V-webmail Support Mailing List (http://www.v-webmail.org)
Archives: //www.freelists.org/archives/v-webmail/
To unsubscribe, send mail to: v-webmail-request@xxxxxxxxxxxxx
with "unsubscribe" in the subject
Other related posts:
