[vchkpw] no mysql tables after Vpopmail install
I don't have any vpopmail related tables in my Mysql vpopmail database after installation. I discovered that during the install of vpopmail I typo'd the vpopmail password I wanted to use in the mysql db. I assume that as a result of that error that the tables didn't created properly. I've tried rerunning the `make install` and `make install-strip` with all my passwords aligned and db access verified, but no soup. I can't find a schema dump for the vpopmail tables by Googling either. What should I do? (please be kind with that sort of question ;-) ) THANKS! Dave.
Re: [vchkpw] no mysql tables after Vpopmail install
As long as the permissions are correct, and you allow CREATE permission to the id/password you put in vmysql.h, then the tables will auto-create when you run the system, i.e. create a domain. Thanks, Brian I don't have any vpopmail related tables in my Mysql vpopmail database after installation. I discovered that during the install of vpopmail I typo'd the vpopmail password I wanted to use in the mysql db. I assume that as a result of that error that the tables didn't created properly. I've tried rerunning the `make install` and `make install-strip` with all my passwords aligned and db access verified, but no soup. I can't find a schema dump for the vpopmail tables by Googling either. What should I do? (please be kind with that sort of question ;-) ) THANKS! Dave.
Re: [vchkpw] no mysql tables after Vpopmail install
Thanks to the lists' advice to make distclean and reconfig and recompile was great! HOWEVER, something laying around (maybe not vpopmail?) is generating this 'maillog' entry (Redhat linux 7.3): Feb 20 08:32:07 (edited hostname) imapd: could not connect to mysql update server Access denied for user: 'root@localhost' (Using password: YES) This is blocking authentication requests. Above this error in the log are the correct username and password values coming from the running checkpassword (or vchkpw?) I've checked the vpopmail mysql tables, they're all square after I did vadddomain and vadduser. Obviously most of vpopmail knows how to talk to the mysql db as the vpopmail defined user (which isn't root) Knowing that I screwed up the initial install and then recompiled from clean, is there an obvious place to see if the username/password is misdefined elsewhere? I appreciate the help! Dave (again) -- Original Message -- From: Brian Kolaci [EMAIL PROTECTED] Reply-To: Brian Kolaci [EMAIL PROTECTED] Date: Thu, 20 Feb 2003 08:44:51 -0500 (EST) As long as the permissions are correct, and you allow CREATE permission to the id/password you put in vmysql.h, then the tables will auto-create when you run the system, i.e. create a domain. Thanks, Brian I don't have any vpopmail related tables in my Mysql vpopmail database after installation. I discovered that during the install of vpopmail I typo'd the vpopmail password I wanted to use in the mysql db. I assume that as a result of that error that the tables didn't created properly. I've tried rerunning the `make install` and `make install-strip` with all my passwords aligned and db access verified, but no soup. I can't find a schema dump for the vpopmail tables by Googling either. What should I do? (please be kind with that sort of question ;-) ) THANKS! Dave.
Re: [vchkpw] no mysql tables after Vpopmail install
On Thursday 20 February 2003 09:41, David Richardson wrote: Thanks to the lists' advice to make distclean and reconfig and recompile was great! HOWEVER, something laying around (maybe not vpopmail?) is generating this 'maillog' entry (Redhat linux 7.3): Feb 20 08:32:07 (edited hostname) imapd: could not connect to mysql update server Access denied for user: 'root@localhost' (Using password: YES) Not too sure about the history behind this thread, but I know that if you change anything in vpopmail and recompile, you'll have to recompile Courier-IMAP too. Of coarse, you may not be using courier-imap. In that case, what are you using, and how are you authenticating? (Direct MySQL? vpopmail auth module? etc...) This is blocking authentication requests. Above this error in the log are the correct username and password values coming from the running checkpassword (or vchkpw?) I've checked the vpopmail mysql tables, they're all square after I did vadddomain and vadduser. Obviously most of vpopmail knows how to talk to the mysql db as the vpopmail defined user (which isn't root) Knowing that I screwed up the initial install and then recompiled from clean, is there an obvious place to see if the username/password is misdefined elsewhere? I appreciate the help! Dave (again) -- Original Message -- From: Brian Kolaci [EMAIL PROTECTED] Reply-To: Brian Kolaci [EMAIL PROTECTED] Date: Thu, 20 Feb 2003 08:44:51 -0500 (EST) As long as the permissions are correct, and you allow CREATE permission to the id/password you put in vmysql.h, then the tables will auto-create when you run the system, i.e. create a domain. Thanks, Brian I don't have any vpopmail related tables in my Mysql vpopmail database after installation. I discovered that during the install of vpopmail I typo'd the vpopmail password I wanted to use in the mysql db. I assume that as a result of that error that the tables didn't created properly. I've tried rerunning the `make install` and `make install-strip` with all my passwords aligned and db access verified, but no soup. I can't find a schema dump for the vpopmail tables by Googling either. What should I do? (please be kind with that sort of question ;-) ) THANKS! Dave. -- Jesse Guardiani, Systems Administrator WingNET Internet Services, P.O. Box 2605 // Cleveland, TN 37320-2605 423-559-LINK (v) 423-559-5145 (f) http://www.wingnet.net We are actively looking for companies that do a lot of long distance faxing and want to cut their long distance bill by up to 50%. Contact [EMAIL PROTECTED] for more info.
Re: [vchkpw] no mysql tables after Vpopmail install
Woo hoo! Recompile of Courier did the trick! (minor snafu, must 'make' Courier as root now to have rights to the libs in /home/vpopmail/lib) Thanks gang, this has been a long, hard journey. Finally working: qmail w/patches, courier, vpopmail, mysql 3.23, smtp-auth. I'm off to try SSL auth. Thanks again! Dave. -- Original Message -- From: Jesse Guardiani [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 20 Feb 2003 09:46:16 -0500 On Thursday 20 February 2003 09:41, David Richardson wrote: Thanks to the lists' advice to make distclean and reconfig and recompile was great! HOWEVER, something laying around (maybe not vpopmail?) is generating this 'maillog' entry (Redhat linux 7.3): Feb 20 08:32:07 (edited hostname) imapd: could not connect to mysql update server Access denied for user: 'root@localhost' (Using password: YES) Not too sure about the history behind this thread, but I know that if you change anything in vpopmail and recompile, you'll have to recompile Courier-IMAP too. Of coarse, you may not be using courier-imap. In that case, what are you using, and how are you authenticating? (Direct MySQL? vpopmail auth module? etc...) This is blocking authentication requests. Above this error in the log are the correct username and password values coming from the running checkpassword (or vchkpw?) I've checked the vpopmail mysql tables, they're all square after I did vadddomain and vadduser. Obviously most of vpopmail knows how to talk to the mysql db as the vpopmail defined user (which isn't root) Knowing that I screwed up the initial install and then recompiled from clean, is there an obvious place to see if the username/password is misdefined elsewhere? I appreciate the help! Dave (again) -- Original Message -- From: Brian Kolaci [EMAIL PROTECTED] Reply-To: Brian Kolaci [EMAIL PROTECTED] Date: Thu, 20 Feb 2003 08:44:51 -0500 (EST) As long as the permissions are correct, and you allow CREATE permission to the id/password you put in vmysql.h, then the tables will auto-create when you run the system, i.e. create a domain. Thanks, Brian I don't have any vpopmail related tables in my Mysql vpopmail database after installation. I discovered that during the install of vpopmail I typo'd the vpopmail password I wanted to use in the mysql db. I assume that as a result of that error that the tables didn't created properly. I've tried rerunning the `make install` and `make install-strip` with all my passwords aligned and db access verified, but no soup. I can't find a schema dump for the vpopmail tables by Googling either. What should I do? (please be kind with that sort of question ;-) ) THANKS! Dave.
