[vchkpw] Upgrading the MySQL, I crask my vpopmail :(
Hi! I have a Debian system. I had mysql 3.23.49-8 from my apt-get of my Woody. I downloaded and instaled, previous remove the old mysql and dumped the all databases, the mysql-standard-4.0.18-pc-linux-i686. I restore de backup-dump. All my aplication with access to the sql database work well, except vpopmail. When I try to check a mailbox from there I get an error which says, in a Outlook Express:'could not create vlog table CREATE TABLE vlog [...]'. I have this table. With the command line client, now I need to write the '-h 127.0.0.1'. In vchkpw/etc/vpopmail.mysql i have localhost|3306|root|myrootpass|vpopmail Any Idea? Sorry for my english Luciano Bello
Re: [vchkpw] Upgrading the MySQL, I crask my vpopmail :(
Try to recompile vpopmail. Luciano Bello wrote: Hi! I have a Debian system. I had mysql 3.23.49-8 from my apt-get of my Woody. I downloaded and instaled, previous remove the old mysql and dumped the all databases, the mysql-standard-4.0.18-pc-linux-i686. I restore de backup-dump. All my aplication with access to the sql database work well, except vpopmail. When I try to check a mailbox from there I get an error which says, in a Outlook Express:'could not create vlog table CREATE TABLE vlog [...]'. I have this table. With the command line client, now I need to write the '-h 127.0.0.1'. In vchkpw/etc/vpopmail.mysql i have localhost|3306|root|myrootpass|vpopmail Any Idea? Sorry for my english Luciano Bello
Re: [vchkpw] Upgrading the MySQL, I crask my vpopmail :(
sorry, forget about it. vpopmail connects to mysql using a socket. check if vpopmail is accessing mysql through a tcp socket and that mysql is listening on a tcp socket aswell. IIRC, on Debian, mysql's default is UNIX socket only. Regards, Celso Celso Pinto wrote: Try to recompile vpopmail. Luciano Bello wrote: Hi! I have a Debian system. I had mysql 3.23.49-8 from my apt-get of my Woody. I downloaded and instaled, previous remove the old mysql and dumped the all databases, the mysql-standard-4.0.18-pc-linux-i686. I restore de backup-dump. All my aplication with access to the sql database work well, except vpopmail. When I try to check a mailbox from there I get an error which says, in a Outlook Express:'could not create vlog table CREATE TABLE vlog [...]'. I have this table. With the command line client, now I need to write the '-h 127.0.0.1'. In vchkpw/etc/vpopmail.mysql i have localhost|3306|root|myrootpass|vpopmail Any Idea? Sorry for my english Luciano Bello
Re: [vchkpw] Upgrading the MySQL, I crask my vpopmail :(
On May 19, 2004, at 12:25 PM, Luciano Bello wrote: With the command line client, now I need to write the '-h 127.0.0.1'. In vchkpw/etc/vpopmail.mysql i have localhost|3306|root|myrootpass|vpopmail Try replacing 'localhost' with '127.0.0.1'. I seem to recall reading somewhere that MySQL would use a socket connection (in the file system) instead of a TCP connection when given localhost. Using 127.0.0.1 forces the use of TCP. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] Upgrading the MySQL, I crask my vpopmail :(
On mié, 2004-05-19 at 19:22, Rick Widmer wrote: Tom Collins wrote: On May 19, 2004, at 12:25 PM, Luciano Bello wrote: With the command line client, now I need to write the '-h 127.0.0.1'. In vchkpw/etc/vpopmail.mysql i have localhost|3306|root|myrootpass|vpopmail Try replacing 'localhost' with '127.0.0.1'. I seem to recall reading somewhere that MySQL would use a socket connection (in the file system) instead of a TCP connection when given localhost. Using 127.0.0.1 forces the use of TCP. While that is a good idea for a test, if you find it works with 127.0.0.1 and not localhost, you should then find out what is wrong with the socket connection. If you are running qmailadmin and MySQL on the same machine, the socket connection via 'localhost' will be faster. Usually it is permission on or above the directory where the socket is located, or a mismatch between where a distribution specific MySQL install, and a user compiled version place the socket. Does the MySQL command line program work with localhost connections when run by the web server user? Is there more than one version of MySQL installed on the machine? Rick No... i just have one MySQL server.
