Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread 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
  tcp0  0 0.0.0.0:993 0.0.0.0:*
   LISTEN  16192/tcpserver
  tcp0  0 0.0.0.0:995 0.0.0.0:*
   LISTEN  16154/tcpserver
  tcp0  0 0.0.0.0:33060.0.0.0:*
   LISTEN  2603/mysqld
  tcp0  0 0.0.0.0:587 0.0.0.0:*
   LISTEN  16151/tcpserver
  tcp0  0 0.0.0.0:110 0.0.0.0:*
   LISTEN  16180/tcpserver
  tcp0  0 127.0.0.1:783   0.0.0.0:*
   LISTEN  16133/perl
  tcp0  0 0.0.0.0:143 0.0.0.0:*
   LISTEN  16230/tcpserver
  tcp0  0 127.0.0.1:530.0.0.0:*
   LISTEN  30042/named
  tcp0  0 0.0.0.0:25  0.0.0.0:*
   LISTEN  16221/tcpserver
  tcp0  0 127.0.0.1:953   0.0.0.0:*
   LISTEN  30042/named
  tcp0  0 :::80   :::*
   LISTEN  16417/httpd
  tcp0  0 ::1:53  :::*
   LISTEN  30042/named
  tcp0  0 :::22   :::*
   LISTEN  2416/sshd
  tcp0  0 ::1:953 :::*
   LISTEN  30042/named
  tcp0  0 :::443  :::*
   LISTEN  16417/httpd
  tcp0   1728 :::my.remote.ip.addy:22
  :::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



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Johannes Weberhofer, Weberhofer GmbH

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
tcp0  0 0.0.0.0:993 0.0.0.0:*
  LISTEN  16192/tcpserver
tcp0  0 0.0.0.0:995 0.0.0.0:*
  LISTEN  16154/tcpserver
tcp0  0 0.0.0.0:33060.0.0.0:*
  LISTEN  2603/mysqld
tcp0  0 0.0.0.0:587 0.0.0.0:*
  LISTEN  16151/tcpserver
tcp0  0 0.0.0.0:110 0.0.0.0:*
  LISTEN  16180/tcpserver
tcp0  0 127.0.0.1:783   0.0.0.0:*
  LISTEN  16133/perl
tcp0  0 0.0.0.0:143 0.0.0.0:*
  LISTEN  16230/tcpserver
tcp0  0 127.0.0.1:530.0.0.0:*
  LISTEN  30042/named
tcp0  0 0.0.0.0:25  0.0.0.0:*
  LISTEN  16221/tcpserver
tcp0  0 127.0.0.1:953   0.0.0.0:*
  LISTEN  30042/named
tcp0  0 :::80   :::*
  LISTEN  16417/httpd
tcp0  0 ::1:53  :::*
  LISTEN  30042/named
tcp0  0 :::22   :::*
  LISTEN  2416/sshd
tcp0  0 ::1:953 :::*
  LISTEN  30042/named
tcp0  0 :::443  :::*
  LISTEN  16417/httpd
tcp0   1728 :::my.remote.ip.addy:22
:::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



--


|-
|  weberhofer GmbH   | Johannes Weberhofer
|  information technologies
|  Austria, 1080 Wien, Blindengasse 52/3
|---

-
To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com
For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Phil
It's not an answer to your problem but you might want to look at getting
the free Navicat.  It's a great GUI MySQL manager that will keep you from
having to deal with CLI.

 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
  tcp0  0 0.0.0.0:993 0.0.0.0:*
   LISTEN  16192/tcpserver
  tcp0  0 0.0.0.0:995 0.0.0.0:*
   LISTEN  16154/tcpserver
  tcp0  0 0.0.0.0:33060.0.0.0:*
   LISTEN  2603/mysqld
  tcp0  0 0.0.0.0:587 0.0.0.0:*
   LISTEN  16151/tcpserver
  tcp0  0 0.0.0.0:110 0.0.0.0:*
   LISTEN  16180/tcpserver
  tcp0  0 127.0.0.1:783   0.0.0.0:*
   LISTEN  16133/perl
  tcp0  0 0.0.0.0:143 0.0.0.0:*
   LISTEN  16230/tcpserver
  tcp0  0 127.0.0.1:530.0.0.0:*
   LISTEN  30042/named
  tcp0  0 0.0.0.0:25  0.0.0.0:*
   LISTEN  16221/tcpserver
  tcp0  0 127.0.0.1:953   0.0.0.0:*
   LISTEN  30042/named
  tcp0  0 :::80   :::*
   LISTEN  16417/httpd
  tcp0  0 ::1:53  :::*
   LISTEN  30042/named
  tcp0  0 :::22   :::*
   LISTEN  2416/sshd
  tcp0  0 ::1:953 :::*
   LISTEN  30042/named
  tcp0  0 :::443  :::*
   LISTEN  16417/httpd
  tcp0   1728 :::my.remote.ip.addy:22
  :::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



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Dan Page
Thanks for the wicked fast reply :)  I'll let you know how it works 

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
  tcp0  0 0.0.0.0:993 0.0.0.0:*
LISTEN  16192/tcpserver
  tcp0  0 0.0.0.0:995 0.0.0.0:*
LISTEN  16154/tcpserver
  tcp0  0 0.0.0.0:33060.0.0.0:*
LISTEN  2603/mysqld
  tcp0  0 0.0.0.0:587 0.0.0.0:*
LISTEN  16151/tcpserver
  tcp0  0 0.0.0.0:110 0.0.0.0:*
LISTEN  16180/tcpserver
  tcp0  0 127.0.0.1:783   0.0.0.0:*
LISTEN  16133/perl
  tcp0  0 0.0.0.0:143 0.0.0.0:*
LISTEN  16230/tcpserver
  tcp0  0 127.0.0.1:530.0.0.0:*
LISTEN  30042/named
  tcp0  0 0.0.0.0:25  0.0.0.0:*
LISTEN  16221/tcpserver
  tcp0  0 127.0.0.1:953   0.0.0.0:*
LISTEN  30042/named
  tcp0  0 :::80   :::*
LISTEN  16417/httpd
  tcp0  0 ::1:53  :::*
LISTEN  30042/named
  tcp0  0 :::22   :::*
LISTEN  2416/sshd
  tcp0  0 ::1:953 :::*
LISTEN  30042/named
  tcp0  0 :::443  :::*
LISTEN  16417/httpd
  tcp0   1728 :::my.remote.ip.addy:22
  :::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



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Dan Page
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
  tcp0  0 0.0.0.0:993 0.0.0.0:*
LISTEN  16192/tcpserver
  tcp0  0 0.0.0.0:995 0.0.0.0:*
LISTEN  16154/tcpserver
  tcp0  0 0.0.0.0:33060.0.0.0:*
LISTEN  2603/mysqld
  tcp0  0 0.0.0.0:587 0.0.0.0:*
LISTEN  16151/tcpserver
  tcp0  0 0.0.0.0:110 0.0.0.0:*
LISTEN  16180/tcpserver
  tcp0  0 127.0.0.1:783   0.0.0.0:*
LISTEN  16133/perl
  tcp0  0 0.0.0.0:143 0.0.0.0:*
LISTEN  16230/tcpserver
  tcp0  0 127.0.0.1:530.0.0.0:*
LISTEN  30042/named
  tcp0  0 0.0.0.0:25  0.0.0.0:*
LISTEN  16221/tcpserver
  tcp0  0 127.0.0.1:953   0.0.0.0:*
LISTEN  30042/named
  tcp0  0 :::80   :::*
LISTEN  16417/httpd
  tcp0  0 ::1:53  :::*
LISTEN  30042/named
  tcp0  0 :::22   :::*
LISTEN  2416/sshd
  tcp0  0 ::1:953 :::*
LISTEN  30042/named
  tcp0  0 :::443  :::*
LISTEN  16417/httpd
  tcp0   1728 :::my.remote.ip.addy:22
  :::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: 

Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Eric Shubert
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
tcp0  0 0.0.0.0:993 0.0.0.0:*
  LISTEN  16192/tcpserver
tcp0  0 0.0.0.0:995 0.0.0.0:*
  LISTEN  16154/tcpserver
tcp0  0 0.0.0.0:33060.0.0.0:*
  LISTEN  2603/mysqld
tcp0  0 0.0.0.0:587 0.0.0.0:*
  LISTEN  16151/tcpserver
tcp0  0 0.0.0.0:110 0.0.0.0:*
  LISTEN  16180/tcpserver
tcp0  0 127.0.0.1:783   0.0.0.0:*
  LISTEN  16133/perl
tcp0  0 0.0.0.0:143 0.0.0.0:*
  LISTEN  16230/tcpserver
tcp0  0 127.0.0.1:530.0.0.0:*
  LISTEN  30042/named
tcp0  0 0.0.0.0:25  0.0.0.0:*
  LISTEN  16221/tcpserver
tcp0  0 127.0.0.1:953   0.0.0.0:*
  LISTEN  30042/named
tcp0  0 :::80   :::*
  LISTEN  16417/httpd
tcp0  0 ::1:53  :::*
  LISTEN  30042/named
tcp0  0 :::22   :::*
  LISTEN  2416/sshd
tcp0  0 ::1:953 :::*
  LISTEN  30042/named
tcp0  0 :::443  :::*
  LISTEN  16417/httpd
tcp0   1728 :::my.remote.ip.addy:22
:::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: 

Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Dan Page
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
  tcp0  0 0.0.0.0:993 0.0.0.0:*
LISTEN  16192/tcpserver
  tcp0  0 0.0.0.0:995 0.0.0.0:*
LISTEN  16154/tcpserver
  tcp0  0 0.0.0.0:33060.0.0.0:*
LISTEN  2603/mysqld
  tcp0  0 0.0.0.0:587 0.0.0.0:*
LISTEN  16151/tcpserver
  tcp0  0 0.0.0.0:110 0.0.0.0:*
LISTEN  16180/tcpserver
  tcp0  0 127.0.0.1:783   0.0.0.0:*
LISTEN  16133/perl
  tcp0  0 0.0.0.0:143 0.0.0.0:*
LISTEN  16230/tcpserver
  tcp0  0 127.0.0.1:530.0.0.0:*
LISTEN  30042/named
  tcp0  0 0.0.0.0:25  0.0.0.0:*
LISTEN  16221/tcpserver
  tcp0  0 127.0.0.1:953   0.0.0.0:*
LISTEN  30042/named
  tcp0  0 :::80   :::*
LISTEN  16417/httpd
  tcp0  0 ::1:53  :::*
LISTEN  30042/named
  tcp0  0 :::22   :::*
LISTEN  2416/sshd
  tcp0  0 ::1:953 :::*
LISTEN  30042/named
  tcp0  0 

Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Eric Shubert

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


That's the same as I have on a current COS5 toaster, so that part 
appears to be ok.



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. 


I agree.
Where did the vpopmail-toaster binary rpm come from that you used for 
installing on the COS5 (new) machine? Was it built on the COS5 box? Was 
the --with-cnt50 option used on the rpmbuild command?




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
tcp0  0 0.0.0.0:993 0.0.0.0:*
  LISTEN  16192/tcpserver
tcp0  0 0.0.0.0:995 0.0.0.0:*
  LISTEN  16154/tcpserver
tcp0  0 0.0.0.0:33060.0.0.0:*
  LISTEN  2603/mysqld
tcp0  0 0.0.0.0:587 0.0.0.0:*
  LISTEN  16151/tcpserver
tcp0  0 0.0.0.0:110 0.0.0.0:*
  LISTEN  16180/tcpserver
tcp0  0 127.0.0.1:783   0.0.0.0:*
  LISTEN  16133/perl
tcp0  0 0.0.0.0:143 0.0.0.0:*
  LISTEN  16230/tcpserver
tcp0  0 127.0.0.1:530.0.0.0:*
  LISTEN  30042/named
tcp0  0 0.0.0.0:25  0.0.0.0:*
  LISTEN  16221/tcpserver
tcp0  0 127.0.0.1:953   0.0.0.0:*
  LISTEN  30042/named
tcp0  0 :::80   :::*
  LISTEN  16417/httpd
tcp0  0 ::1:53  :::*
  LISTEN  30042/named
tcp0  0 :::22   :::*
  LISTEN  2416/sshd

RE: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2009-02-23 Thread Dan Page
I do still have the binary but when I try and install it with the
--replacefiles I just get output saying that it is already installed.   I
got it to work using --force.  It left my mail and all is working as it
should.  Thanks 

Dan Page  

-Original Message-
From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric Shubert
Sent: Monday, February 23, 2009 4:12 PM
To: qmailtoaster-list@qmailtoaster.com
Subject: Re: [qmailtoaster] testing restore - now no authentication works
(IE squirrelmail, imap client or qmailadmin)

That would do it. :(

You still have the binary rpm for vpopmail-toaster, I hope.
I believe that re-installing the package with --replacefiles will fix 
you up:
# rpm -Uvh --replacefiles vpopmail-toaster-*.i?86.rpm

Dan Page wrote:
 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
 tcp0  0 0.0.0.0:993 0.0.0.0:*
   LISTEN  16192/tcpserver
 tcp0  0 0.0.0.0:995 0.0.0.0:*
   LISTEN  16154/tcpserver
 tcp0  0 0.0.0.0:33060.0.0.0:*
   LISTEN  2603/mysqld
 tcp

Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread dnk
Hey guys, I had checked that out already yesterday prior to posting,
and it is in fact the same I also logged in VIA the mysql utility
as well. No issues there (so it seems).

DNK

On Thu, May 8, 2008 at 5:47 PM, Jake Vickers [EMAIL PROTECTED] 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.



 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.


 Sounds like the vpopmail password may be different. Look at
 /home/vpopmail/etc/vpopmail.mysql and make sure it matches the password for
 the database.

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread Eric Shubert
cli commands (vdominfo vuserinfo) work ok?

dnk wrote:
 Hey guys, I had checked that out already yesterday prior to posting,
 and it is in fact the same I also logged in VIA the mysql utility
 as well. No issues there (so it seems).
 
 DNK
 
 On Thu, May 8, 2008 at 5:47 PM, Jake Vickers [EMAIL PROTECTED] 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.



 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.

 Sounds like the vpopmail password may be different. Look at
 /home/vpopmail/etc/vpopmail.mysql and make sure it matches the password for
 the database.

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 
 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 


-- 
-Eric 'shubes'

-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread dnk
That they do!

All good there. THE exceptions are when i enter anythign that needs a
password to do it's job, IE change a password.

DNK



On Fri, May 9, 2008 at 10:30 AM, Eric Shubert [EMAIL PROTECTED] wrote:
 cli commands (vdominfo vuserinfo) work ok?

 dnk wrote:
 Hey guys, I had checked that out already yesterday prior to posting,
 and it is in fact the same I also logged in VIA the mysql utility
 as well. No issues there (so it seems).

 DNK

 On Thu, May 8, 2008 at 5:47 PM, Jake Vickers [EMAIL PROTECTED] 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.



 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.

 Sounds like the vpopmail password may be different. Look at
 /home/vpopmail/etc/vpopmail.mysql and make sure it matches the password for
 the database.

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



 --
 -Eric 'shubes'

 -
 QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread Eric Shubert
What about cli command that update?
Try adding a test domain with vadddomain?

dnk wrote:
 That they do!
 
 All good there. THE exceptions are when i enter anythign that needs a
 password to do it's job, IE change a password.
 
 DNK
 
 
 
 On Fri, May 9, 2008 at 10:30 AM, Eric Shubert [EMAIL PROTECTED] wrote:
 cli commands (vdominfo vuserinfo) work ok?

 dnk wrote:
 Hey guys, I had checked that out already yesterday prior to posting,
 and it is in fact the same I also logged in VIA the mysql utility
 as well. No issues there (so it seems).

 DNK

 On Thu, May 8, 2008 at 5:47 PM, Jake Vickers [EMAIL PROTECTED] 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.



 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.

 Sounds like the vpopmail password may be different. Look at
 /home/vpopmail/etc/vpopmail.mysql and make sure it matches the password for
 the database.

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 --
 -Eric 'shubes'

 -
 QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 
 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 


-- 
-Eric 'shubes'

-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread dnk
Yes without issue, no errors for adding users and domains. And any
domains, users added after the restore work fine. Only tested local
mail delivery though. But I can login with them, etc.

DNK



On Fri, May 9, 2008 at 11:11 AM, Eric Shubert [EMAIL PROTECTED] wrote:
 What about cli command that update?
 Try adding a test domain with vadddomain?

 dnk wrote:
 That they do!

 All good there. THE exceptions are when i enter anythign that needs a
 password to do it's job, IE change a password.

 DNK



 On Fri, May 9, 2008 at 10:30 AM, Eric Shubert [EMAIL PROTECTED] wrote:
 cli commands (vdominfo vuserinfo) work ok?

 dnk wrote:
 Hey guys, I had checked that out already yesterday prior to posting,
 and it is in fact the same I also logged in VIA the mysql utility
 as well. No issues there (so it seems).

 DNK

 On Thu, May 8, 2008 at 5:47 PM, Jake Vickers [EMAIL PROTECTED] 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.



 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.

 Sounds like the vpopmail password may be different. Look at
 /home/vpopmail/etc/vpopmail.mysql and make sure it matches the password 
 for
 the database.

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 --
 -Eric 'shubes'

 -
 QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



 --
 -Eric 'shubes'

 -
 QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread Jake Vickers

dnk wrote:

That they do!

All good there. THE exceptions are when i enter anythign that needs a
password to do it's job, IE change a password.

  


Check your /etc/passwd file; does vpopmail have the uid/gid of 89:89?

-
QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread Eric Shubert
That would seem to indicate that something in the restore might have failed,
as if a piece of some sort is missing. All I can think to do at this point
would be to compare everything you can find between a restored user and a
newly added user. Keep in mind, there are multiple tables in the vpopmail
database.

dnk wrote:
 Yes without issue, no errors for adding users and domains. And any
 domains, users added after the restore work fine. Only tested local
 mail delivery though. But I can login with them, etc.
 
 DNK
 
 
 
 On Fri, May 9, 2008 at 11:11 AM, Eric Shubert [EMAIL PROTECTED] wrote:
 What about cli command that update?
 Try adding a test domain with vadddomain?

 dnk wrote:
 That they do!

 All good there. THE exceptions are when i enter anythign that needs a
 password to do it's job, IE change a password.

 DNK



 On Fri, May 9, 2008 at 10:30 AM, Eric Shubert [EMAIL PROTECTED] wrote:
 cli commands (vdominfo vuserinfo) work ok?

 dnk wrote:
 Hey guys, I had checked that out already yesterday prior to posting,
 and it is in fact the same I also logged in VIA the mysql utility
 as well. No issues there (so it seems).

 DNK

 On Thu, May 8, 2008 at 5:47 PM, Jake Vickers [EMAIL PROTECTED] 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.



 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.

 Sounds like the vpopmail password may be different. Look at
 /home/vpopmail/etc/vpopmail.mysql and make sure it matches the password 
 for
 the database.

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]

 --
 -Eric 'shubes'

 -
 QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 -
  QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]


 --
 -Eric 'shubes'



-- 
-Eric 'shubes'

-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread dnk
No, it does not.

When I went through the initial install on that box, the vpopmail user
and the vchkpd were not found and I had to add them manually.

I was actually hunting through those files as I read this.

Testing it now..

DNK

On Fri, May 9, 2008 at 11:43 AM, Jake Vickers [EMAIL PROTECTED] wrote:
 dnk wrote:

 That they do!

 All good there. THE exceptions are when i enter anythign that needs a
 password to do it's job, IE change a password.



 Check your /etc/passwd file; does vpopmail have the uid/gid of 89:89?

 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread Jake Vickers

dnk wrote:

No, it does not.

When I went through the initial install on that box, the vpopmail user
and the vchkpd were not found and I had to add them manually.

I was actually hunting through those files as I read this.

Testing it now..

  


Common with Cent5; the uid/gid 89:89 is already in use so vpopmail can't 
use it.
If you look into the restore script you'll see a section that deals with 
the newu command. Vpopmail expects to use uid/gid 89:89 and that will be 
where your problem came in.



-
QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread dnk
So what is best, assign that (89) to the user, or is there another
place better suited to make the changes with the ones the system had
installed with?

DNK

On Fri, May 9, 2008 at 1:21 PM, Jake Vickers [EMAIL PROTECTED] wrote:
 dnk wrote:

 No, it does not.

 When I went through the initial install on that box, the vpopmail user
 and the vchkpd were not found and I had to add them manually.

 I was actually hunting through those files as I read this.

 Testing it now..



 Common with Cent5; the uid/gid 89:89 is already in use so vpopmail can't use
 it.
 If you look into the restore script you'll see a section that deals with the
 newu command. Vpopmail expects to use uid/gid 89:89 and that will be where
 your problem came in.


 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]



-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread Jake Vickers

dnk wrote:

So what is best, assign that (89) to the user, or is there another
place better suited to make the changes with the ones the system had
installed with?
  


you'll need to rebuild the whole vpopmail package after removing 
whatever was using 89:89



-
QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-09 Thread dnk
Ok, after getting my base toaster vpopmail recompiled with the proper
uid/guid,s the dump and restore worked perfectly (from what I can
see)!

Jake nailed that one!

DNK

On Fri, May 9, 2008 at 1:24 PM, dnk [EMAIL PROTECTED] wrote:
 So what is best, assign that (89) to the user, or is there another
 place better suited to make the changes with the ones the system had
 installed with?

 DNK

 On Fri, May 9, 2008 at 1:21 PM, Jake Vickers [EMAIL PROTECTED] wrote:
 dnk wrote:

 No, it does not.

 When I went through the initial install on that box, the vpopmail user
 and the vchkpd were not found and I had to add them manually.

 I was actually hunting through those files as I read this.

 Testing it now..



 Common with Cent5; the uid/gid 89:89 is already in use so vpopmail can't use
 it.
 If you look into the restore script you'll see a section that deals with the
 newu command. Vpopmail expects to use uid/gid 89:89 and that will be where
 your problem came in.


 -
QmailToaster hosted by: VR Hosted http://www.vr.org
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]




-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-08 Thread Eric Shubert
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
 tcp0  0 0.0.0.0:993 0.0.0.0:*
  LISTEN  16192/tcpserver
 tcp0  0 0.0.0.0:995 0.0.0.0:*
  LISTEN  16154/tcpserver
 tcp0  0 0.0.0.0:33060.0.0.0:*
  LISTEN  2603/mysqld
 tcp0  0 0.0.0.0:587 0.0.0.0:*
  LISTEN  16151/tcpserver
 tcp0  0 0.0.0.0:110 0.0.0.0:*
  LISTEN  16180/tcpserver
 tcp0  0 127.0.0.1:783   0.0.0.0:*
  LISTEN  16133/perl
 tcp0  0 0.0.0.0:143 0.0.0.0:*
  LISTEN  16230/tcpserver
 tcp0  0 127.0.0.1:530.0.0.0:*
  LISTEN  30042/named
 tcp0  0 0.0.0.0:25  0.0.0.0:*
  LISTEN  16221/tcpserver
 tcp0  0 127.0.0.1:953   0.0.0.0:*
  LISTEN  30042/named
 tcp0  0 :::80   :::*
  LISTEN  16417/httpd
 tcp0  0 ::1:53  :::*
  LISTEN  30042/named
 tcp0  0 :::22   :::*
  LISTEN  2416/sshd
 tcp0  0 ::1:953 :::*
  LISTEN  30042/named
 tcp0  0 :::443  :::*
  LISTEN  16417/httpd
 tcp0   1728 :::my.remote.ip.addy:22
 :::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)

-- 
-Eric 'shubes'

-
 QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: [qmailtoaster] testing restore - now no authentication works (IE squirrelmail, imap client or qmailadmin)

2008-05-08 Thread Jake Vickers

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.



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.
  


Sounds like the vpopmail password may be different. Look at 
/home/vpopmail/etc/vpopmail.mysql and make sure it matches the password 
for the database.


-
QmailToaster hosted by: VR Hosted http://www.vr.org
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]