I think I figured out what I did wrong. I rsynced the whole /home/vpopmail directory to the new server. including /vpopmail/lib/ and /vpopmail/include/. oops. is it possible to reinstall the vpopmail toaster with out nuking all the mail? Its a lot of mail. Thanks for the help
Dan On Mon, 2009-02-23 at 15:46 -0600, Dan Page wrote: > I don't think I have an old version of mysqlclient. I did a > 'locate mysqlclient' > > and got this output > /usr/lib/mysql/libmysqlclient.a > /usr/lib/mysql/libmysqlclient.so > /usr/lib/mysql/libmysqlclient.so.15 > /usr/lib/mysql/libmysqlclient.so.15.0.0 > /usr/lib/mysql/libmysqlclient_r.a > /usr/lib/mysql/libmysqlclient_r.so > /usr/lib/mysql/libmysqlclient_r.so.15 > /usr/lib/mysql/libmysqlclient_r.so.15.0.0 > > but I did a backup on an cent04.4 system which had mysql4. and did a > restore on a 5.1 system. Some where vpopmail is calling an old binary, > I just don't know where to look. > > > > On Mon, 2009-02-23 at 13:33 -0700, Eric Shubert wrote: > > Looks like you have something mismatched. Why's it looking for > > libmysqlclient.so.14? I have libmysqlclient.so.15 on my COS5 toaster, > > which belongs to mysql-5.0.45-7.el5. Do you have mysql-4 installed on > > COS5? If so, why? > > > > Dan Page wrote: > > > the database works fine when I log in with mysql but when trying to > > > use /home/vpopmail/bin/vuser, or any command I get > > > > > > /home/vpopmail/bin/vuserinfo: error while loading shared libraries: > > > libmysqlclie nt.so.14: cannot open shared object file: No such file or > > > directory > > > > > > > > > in /home/vpopmail/etc/vpopmail.sql I have > > > localhost|0|vpopmail|FAKEPASSWORD|vpopmail > > > > > > any ideas? > > > > > > > > > Dan > > > > > > On Mon, 2009-02-23 at 20:35 +0100, Johannes Weberhofer, Weberhofer GmbH > > > wrote: > > >> On the old system: > > >> > > >> mysqldump vpopmail -uvpopmail -p > vpopmail-dump.sql > > >> > > >> On the new one: > > >> > > >> mysql vpopmail -uvpopmail -p < vpopmail-dump.sql > > >> > > >> Good luck, > > >> Johannes > > >> > > >> > > >> Am 23.02.2009 20:31, schrieb Dan Page: > > >>> I'm doing a similar backup and restore. But the old machine is a 2 year > > >>> old toaster on cnt4.4. the new machine is fresh install with cnt5.1. > > >>> I got everything to move over fine, except the mysql data base I think > > >>> the old server has a different version of mysql. I'm experimenting with > > >>> my sql dump and a restore. Does anyone have any advice as to the best > > >>> way to move the database manually? > > >>> > > >>> I can log in from both machines with > > >>> mysql -u vpopmail -pqwerty vpopmail (the password is changed here for > > >>> security) but when doing a > > >>> show tables; I get no output on the new server. > > >>> > > >>> and the full list on the old one. Any advice on doing a manual mysql > > >>> backup restore would be appreciated. > > >>> > > >>> Oh and thanks to everyone. I found so much useful information in the > > >>> mailing list archive. I could never have never got this far with out > > >>> it. > > >>> > > >>> Dan > > >>> > > >>> On Thu, 2008-05-08 at 17:44 -0700, Eric Shubert wrote: > > >>>> dnk wrote: > > >>>>> Hey there, > > >>>>> > > >>>>> I was going through a test run today trying out the qtp-backup and > > >>>>> qtp-restore. > > >>>>> > > >>>>> I made sure both machines had the same version of qtp. > > >>>>> > > >>>>> One was a toaster that has been running for some months and is now > > >>>>> centos 4.6. > > >>>>> The new one is a brand spanking new centos 5.1 install, with a blank > > >>>>> set of domains. > > >>>>> > > >>>>> SO for sh**s and giggles I wanted to see if i could restore back onto > > >>>>> the new toaster. > > >>>>> > > >>>>> All my data appears to be there. The vqadmin reports back all of the > > >>>>> users and passwords. As does the vpopmail bin tools. > > >>>>> > > >>>>> Now when I attempt to log into webmail, I get the dreaded "ERROR: > > >>>>> Connection dropped by IMAP server." error (google returns many many > > >>>>> reasons and apparent solutions - none of which have yet worked for me > > >>>>> thus far). When I attempt to login to the qmailadmin, I get an > > >>>>> "invalid password" error. > > >>>>> > > >>>>> I double checked and I have the ports listening (so it seems). > > >>>>> > > >>>>> Here is the output of netstats -pant: > > >>>>> > > >>>>> # netstat -pant > > >>>>> Active Internet connections (servers and established) > > >>>>> Proto Recv-Q Send-Q Local Address Foreign Address > > >>>>> State PID/Program name > > >>>>> tcp 0 0 0.0.0.0:993 0.0.0.0:* > > >>>>> LISTEN 16192/tcpserver > > >>>>> tcp 0 0 0.0.0.0:995 0.0.0.0:* > > >>>>> LISTEN 16154/tcpserver > > >>>>> tcp 0 0 0.0.0.0:3306 0.0.0.0:* > > >>>>> LISTEN 2603/mysqld > > >>>>> tcp 0 0 0.0.0.0:587 0.0.0.0:* > > >>>>> LISTEN 16151/tcpserver > > >>>>> tcp 0 0 0.0.0.0:110 0.0.0.0:* > > >>>>> LISTEN 16180/tcpserver > > >>>>> tcp 0 0 127.0.0.1:783 0.0.0.0:* > > >>>>> LISTEN 16133/perl > > >>>>> tcp 0 0 0.0.0.0:143 0.0.0.0:* > > >>>>> LISTEN 16230/tcpserver > > >>>>> tcp 0 0 127.0.0.1:53 0.0.0.0:* > > >>>>> LISTEN 30042/named > > >>>>> tcp 0 0 0.0.0.0:25 0.0.0.0:* > > >>>>> LISTEN 16221/tcpserver > > >>>>> tcp 0 0 127.0.0.1:953 0.0.0.0:* > > >>>>> LISTEN 30042/named > > >>>>> tcp 0 0 :::80 :::* > > >>>>> LISTEN 16417/httpd > > >>>>> tcp 0 0 ::1:53 :::* > > >>>>> LISTEN 30042/named > > >>>>> tcp 0 0 :::22 :::* > > >>>>> LISTEN 2416/sshd > > >>>>> tcp 0 0 ::1:953 :::* > > >>>>> LISTEN 30042/named > > >>>>> tcp 0 0 :::443 :::* > > >>>>> LISTEN 16417/httpd > > >>>>> tcp 0 1728 ::ffff:my.remote.ip.addy:22 > > >>>>> ::ffff:my.office.ip.addy:51994 ESTABLISHED 15897/0 > > >>>>> > > >>>>> Now could this simply be due to the fact that the OS versions are > > >>>>> different? Is this a lost cause? > > >>>>> > > >>>>> DNK > > >>>>> > > >>>> I highly doubt it (but anything's possible), and no. > > >>>> > > >>>> I wouldn't trust vqadmin at all, but some folks say it's ok for looking > > >>>> things up. > > >>>> > > >>>> My first guess would be MySQL grants. Did you run the mysqladmin > > >>>> commands in > > >>>> the cnt50-svcs.sh script? I would expect so since you can retrieve > > >>>> information with /home/vpopmail/bin/vuserinfo. Is the password there > > >>>> the > > >>>> same as what's in /home/vpopmail/etc/vpopmail.mysql ? > > >>>> > > >>>> (Hey, it's just a guess) > > >>>> > > >>> > > >>> --------------------------------------------------------------------- > > >>> To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com > > >>> For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com > > >>> > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com > For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com > --------------------------------------------------------------------- To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com