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