Re: [qmailtoaster] User Access now failing: Help?
Thank you, George, for including that information. Unfortunately, it seems that my system is not having any problems - or not reporting any problems - finding any of those libraries. Does anyone have any further ideas or suggestions as to what I can do to try to correct this problem? To restate the problem for clarity: I have a Fedora Core 5 box, with MySQL 5.0.22, Apache 2.2, PHP5 installed. To this, I have added the latest qmail-toaster installation. I am using BIND rather than the little caching DNS server. I can access all of the administrative functions of Qmail and Qmail Toaster. But I cannot log in as any user to view their e-mail through Squirrelmail, or through IMAP, or IMAP-SSL. I know I have the username and password correct, as I can still log in to the Qmail administration screen as these users and view their specific, individual settings. The following is a segment of the imap4-ssl Current log: 2006-06-27 13:54:30.035390500 tcpserver: status: 0/40 2006-06-27 14:00:11.873804500 tcpserver: status: 1/40 2006-06-27 14:00:11.874041500 tcpserver: pid 3364 from 216.127.141.199 2006-06-27 14:00:11.874117500 tcpserver: ok 3364 mail.gitcamerica.com: 216.127.141.200:993 :216.127.141.199::60979 2006-06-27 14:00:12.062831500 DEBUG: Connection, ip=[216.127.141.199] 2006-06-27 14:00:12.143233500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[216.127.141.199] 2006-06-27 14:00:17.158872500 INFO: LOGOUT, ip=[216.127.141.199], rcvd=56, sent=225 2006-06-27 14:00:17.159622500 tcpserver: end 3364 status 0 2006-06-27 14:00:17.159629500 tcpserver: status: 0/40 The following is a segment of the authlib Current log: 2006-06-27 13:54:31.642186500 INFO: modules=authshadow authvchkpw, daemons=15 2006-06-27 13:54:31.642195500 INFO: Installing libauthshadow 2006-06-27 13:54:32.126208500 INFO: Installation complete: authshadow 2006-06-27 13:54:32.126261500 INFO: Installing libauthvchkpw 2006-06-27 13:54:32.132647500 INFO: Installation complete: authvchkpw 2006-06-27 13:57:16.209559500 vmysql: sql error[3]: MySQL server has gone away My MySQL database is up and running and the vpopmail tables do not show any apparent corruption. I have tried adding new users, and get the same behaviors as with original users. Is it time to back up the mailboxes and wipe the machine, rebuild from scratch? I need an answer, as I have a deadline approaching by which I must move our mail services from an off-site mail server that is running currently to an on-site mail server - the one I have been trying to build and get running. On Jun 25, 2006, at 12:07 AM, George Sweetnam wrote: The ones specifically created to solve issues in my logs were fixed with these links: libcrypto.so.4 - /lib/libcrypto.so.0.9.8a libssl.so.4 - /lib/libssl.so.0.9.8a libc.so.6 - libc-2.4.so Here is a full list of the ones I created, or that re-installing programs made after my initial install (to fix installations of mysql5,apache2.2,php5,courier, ect: libgcc_s.so.1 - libgcc_s-4.1.1-20060525.so.1 libutil.so.1 - libutil-2.4.so libthread_db.so.1 - libthread_db-1.0.so librt.so.1 - librt-2.4.so libresolv.so.2 - libresolv-2.4.so libpthread.so.0 - libpthread-2.4.so libnss_nis.so.2 - libnss_nis-2.4.so libnss_nisplus.so.2 - libnss_nisplus-2.4.so libnss_hesiod.so.2 - libnss_hesiod-2.4.so libnss_files.so.2 - libnss_files-2.4.so libnss_dns.so.2 - libnss_dns-2.4.so libnss_compat.so.2 - libnss_compat-2.4.so libnsl.so.1 - libnsl-2.4.so libm.so.6 - libm-2.4.so libdl.so.2 - libdl-2.4.so libc.so.6 - libc-2.4.so libcrypt.so.1 - libcrypt-2.4.so libcidn.so.1 - libcidn-2.4.so libBrokenLocale.so.1 - libBrokenLocale-2.4.so libanl.so.1 - libanl-2.4.so ld-linux.so.2 - ld-2.4.so libpam.so.0 - libpam.so.0.81.3 libpam_misc.so.0 - libpam_misc.so.0.81.2 libpamc.so.0 - libpamc.so.0.81.0 libdbus-1.so.2 - libdbus-1.so.2.0.0 libasound.so.2 - libasound.so.2.0.0 libssl.so.4 - /lib/libssl.so.0.9.8a libcrypto.so.4 - /lib/libcrypto.so.0.9.8a Hope it helps. I'll warn you though, be VERY carefull when playing with simlinks. If you remove one to create another you'll likely segfault your system and have a really nasty time fixing it. Library files I normally only play with when I have something in my error logs telling me a particular version is missing. Then I create a link for that name to point to the version I am running. You should NEVER remove them! When in doubt, google is your friend. George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 7:04 PM Subject: Re: [qmailtoaster] User Access now failing: Help? George -- If you could compile for me a list of the simlinks you created, I would be interested in seeing that list and attempting to recreate them on my
Re: [qmailtoaster] User Access now failing: Help?
Subject: Re: [qmailtoaster] User Access now failing: Help? George -- If you could compile for me a list of the simlinks you created, I would be interested in seeing that list and attempting to recreate them on my system to see if they would manage to change the behavior. I confess, what I want most right this second is a way to reconfigure vpopmail so that it attempts a new connection to the MySQL server every time it needs to check information. Anyway. I'm eagerly awaiting. On Jun 24, 2006, at 7:38 PM, George Sweetnam wrote: Im running a bastardized FC5 installation (a crashed FC2 install I wiped /boot and /lib due to some corruption problems). This machine had a working copy of the previous toaster version. To make this very long story short I had to upgrade to mysql 5 and php 5, redo apache, chroot dns, ect ... ect.. ect. To make toaster authenticate for imap and pop3 I had to create a series of simlinks for some lib files. After creating them I haven't had any issues with authentication on FC5. I've missed most of this thread, but would be willing to compare or try and duplicate your problem on one of my systems if needed. Not all of my toaster apps are current, but they should work for testing. Here they are: qmail-toaster-1.03-1.2.10 control-panel-toaster-0.5-1.2.8 qmailmrtg-toaster-4.2-1.2.8 vqadmin-toaster-2.3.4-1.2.12 spamassassin-toaster-3.1.1-1.2.14 daemontools-toaster-0.76-1.2.9 vpopmail-toaster-5.4.10-1.2.10 autorespond-toaster-2.0.4-1.2.8 qmailadmin-toaster-1.2.9-1.2.11 isoqlog-toaster-2.1-1.2.9 courier-imap-toaster-3.0.8-1.2.9 ezmlm-cgi-toaster-0.53.324-1.2.10 maildrop-toaster-devel-1.8.1-1.2.10 clamav-toaster-0.88.2-1.2.15 ucspi-tcp-toaster-0.88-1.2.9 qmail-pop3d-toaster-1.03-1.2.10 ezmlm-toaster-0.53.324-1.2.10 maildrop-toaster-1.8.1-1.2.10 squirrelmail-toaster-1.4.5-1.2.13 simscan-toaster-1.1-1.2.7 George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 2:22 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Eric is correct. I'm running on an FC5 box, which is running mysql-5.0.22-1.FC5.1. On 6/24/06, Eric Shubes [EMAIL PROTECTED] wrote: Jake Vickers wrote: Roxanne Sandesara wrote:see No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - 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
Re: [qmailtoaster] User Access now failing: Help?
libasound.so.2 - libasound.so.2.0.0 libssl.so.4 - /lib/libssl.so.0.9.8a libcrypto.so.4 - /lib/libcrypto.so.0.9.8a Hope it helps. I'll warn you though, be VERY carefull when playing with simlinks. If you remove one to create another you'll likely segfault your system and have a really nasty time fixing it. Library files I normally only play with when I have something in my error logs telling me a particular version is missing. Then I create a link for that name to point to the version I am running. You should NEVER remove them! When in doubt, google is your friend. George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 7:04 PM Subject: Re: [qmailtoaster] User Access now failing: Help? George -- If you could compile for me a list of the simlinks you created, I would be interested in seeing that list and attempting to recreate them on my system to see if they would manage to change the behavior. I confess, what I want most right this second is a way to reconfigure vpopmail so that it attempts a new connection to the MySQL server every time it needs to check information. Anyway. I'm eagerly awaiting. On Jun 24, 2006, at 7:38 PM, George Sweetnam wrote: Im running a bastardized FC5 installation (a crashed FC2 install I wiped /boot and /lib due to some corruption problems). This machine had a working copy of the previous toaster version. To make this very long story short I had to upgrade to mysql 5 and php 5, redo apache, chroot dns, ect ... ect.. ect. To make toaster authenticate for imap and pop3 I had to create a series of simlinks for some lib files. After creating them I haven't had any issues with authentication on FC5. I've missed most of this thread, but would be willing to compare or try and duplicate your problem on one of my systems if needed. Not all of my toaster apps are current, but they should work for testing. Here they are: qmail-toaster-1.03-1.2.10 control-panel-toaster-0.5-1.2.8 qmailmrtg-toaster-4.2-1.2.8 vqadmin-toaster-2.3.4-1.2.12 spamassassin-toaster-3.1.1-1.2.14 daemontools-toaster-0.76-1.2.9 vpopmail-toaster-5.4.10-1.2.10 autorespond-toaster-2.0.4-1.2.8 qmailadmin-toaster-1.2.9-1.2.11 isoqlog-toaster-2.1-1.2.9 courier-imap-toaster-3.0.8-1.2.9 ezmlm-cgi-toaster-0.53.324-1.2.10 maildrop-toaster-devel-1.8.1-1.2.10 clamav-toaster-0.88.2-1.2.15 ucspi-tcp-toaster-0.88-1.2.9 qmail-pop3d-toaster-1.03-1.2.10 ezmlm-toaster-0.53.324-1.2.10 maildrop-toaster-1.8.1-1.2.10 squirrelmail-toaster-1.4.5-1.2.13 simscan-toaster-1.1-1.2.7 George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 2:22 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Eric is correct. I'm running on an FC5 box, which is running mysql-5.0.22-1.FC5.1. On 6/24/06, Eric Shubes [EMAIL PROTECTED] wrote: Jake Vickers wrote: Roxanne Sandesara wrote:see No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED
Re: [qmailtoaster] User Access now failing: Help?
Roxanne Sandesara wrote: I'd do that, but I have no idea how to administer or deal with CentOS of any version or variety. I'd never even heard of it before running into mentions of it with qmail-toaster. All of the other servers here are Fedora Core, and I would prefer to hand over a homogenous setup to the next person who has this job. When I came in, I had 8 servers, each one with a different OS, and I've spent over a year migrating off dead and dying hardware and obsolute OSes to get to this point. I really hesitate to take what seems like a step backwards in order to get this working ... but I also don't see much of a choice. I am beyond my wit's end. Unfortunately, I have no good idea or guess as to what the problem is. CentOS is based off of RedHat Enterprise Linux. The guys at CentOS downloaded the RHEL source code (since it is GPL), removed the RH logos and rerolled it into an OS that does not REQUIRE a subscription for updates. There's not too much difference between CentOS (RHEL) and Fedora as far as administration. CentOS just has a kernel that was built for the business environment. You could take a small step back to FC4. I just set up a machine last week on FC4 (albeit I did use a slightly older version of Toaster), and have not had a problem to date. - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
Roxanne Sandesara wrote: Is it time to back up the mailboxes and wipe the machine, rebuild from scratch? I need an answer, as I have a deadline approaching by which I must move our mail services from an off-site mail server that is running currently to an on-site mail server - the one I have been trying to build and get running. why cling to fedora 5 for the install if you don't have to? will you re-build in another 4-5 months they will release fc6? if this is a dedicated mailserver box/blade, why not use centos? as i believe the developers all use that distribution. there is an inferred (by me) guarantee that if i use the platform they develop/work on, the packages they produce will work flawlessly (which they have). yes they support other distributions, but i took the path of least resistance. centos is enterprise-grade and binary-compatible with the 800-pound gorilla, rhel4. (the box will be supported for a long time, and rebuilds will not be required ever 6 months. all provided software is stable and secure enough for rh, who am i to argue? seems like a no-brainer.) i am not, by any stretch of the imagination, a linux or email guru---but install-to-configure-to-production in 4 hours on the first attempt speaks volumes as to the quality of software and integration provided by the toaster team. i did the easy install with kde as my security gui-blanket. fc5 is a quality distribution, fine for a desktop or workstation...maybe even for a server (i know people use it as such). but the point of having a server (mail or otherwise) is stability and security. you get both of those for the cost of a download of centos 4.3 (they will accept donations). and hey, it's even red-hat'ish. my .02 david - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
Roxanne, It sounds like you don't have mysql set to accept connections from localhost. Can you access via pop3 or pop3-ssl? Is this really only an imap (and thus squirrelmail) issue? #Test with this: mysql -u root -h 127.0.0.1 -p #If you can't access it, try running sql in safe mode (from there you can modify permissions for localhost if needed): safe_mysqld --skip-grant-tables #check status of mysql: mysqladmin -u root -p status I reset the sql permissions on my system to allow only localhost in... no fqdn allowed (localhost is the default usually if you don't use the -h option). George excerpt from imap4-ssl logs: 2006-06-27 14:18:24.408813500 INFO: LOGIN, [EMAIL PROTECTED], ip=[206.111.111.111], protocol=IMAP 2006-06-27 14:18:24.413817500 DEBUG: Unexpected SSL connection shutdown. 2006-06-27 14:18:24.413824500 tcpserver: end 9073 status 0 2006-06-27 14:18:24.413827500 tcpserver: status: 0/40 2006-06-27 14:18:24.413830500 INFO: LOGOUT, [EMAIL PROTECTED], ip=[206.111.111.111], headers=0, body=0, time=0 - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Tuesday, June 27, 2006 1:25 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Thank you, George, for including that information. Unfortunately, it seems that my system is not having any problems - or not reporting any problems - finding any of those libraries. Does anyone have any further ideas or suggestions as to what I can do to try to correct this problem? To restate the problem for clarity: I have a Fedora Core 5 box, with MySQL 5.0.22, Apache 2.2, PHP5 installed. To this, I have added the latest qmail-toaster installation. I am using BIND rather than the little caching DNS server. I can access all of the administrative functions of Qmail and Qmail Toaster. But I cannot log in as any user to view their e-mail through Squirrelmail, or through IMAP, or IMAP-SSL. I know I have the username and password correct, as I can still log in to the Qmail administration screen as these users and view their specific, individual settings. The following is a segment of the imap4-ssl Current log: 2006-06-27 13:54:30.035390500 tcpserver: status: 0/40 2006-06-27 14:00:11.873804500 tcpserver: status: 1/40 2006-06-27 14:00:11.874041500 tcpserver: pid 3364 from 216.127.141.199 2006-06-27 14:00:11.874117500 tcpserver: ok 3364 mail.gitcamerica.com: 216.127.141.200:993 :216.127.141.199::60979 2006-06-27 14:00:12.062831500 DEBUG: Connection, ip=[216.127.141.199] 2006-06-27 14:00:12.143233500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[216.127.141.199] 2006-06-27 14:00:17.158872500 INFO: LOGOUT, ip=[216.127.141.199], rcvd=56, sent=225 2006-06-27 14:00:17.159622500 tcpserver: end 3364 status 0 2006-06-27 14:00:17.159629500 tcpserver: status: 0/40 The following is a segment of the authlib Current log: 2006-06-27 13:54:31.642186500 INFO: modules=authshadow authvchkpw, daemons=15 2006-06-27 13:54:31.642195500 INFO: Installing libauthshadow 2006-06-27 13:54:32.126208500 INFO: Installation complete: authshadow 2006-06-27 13:54:32.126261500 INFO: Installing libauthvchkpw 2006-06-27 13:54:32.132647500 INFO: Installation complete: authvchkpw 2006-06-27 13:57:16.209559500 vmysql: sql error[3]: MySQL server has gone away My MySQL database is up and running and the vpopmail tables do not show any apparent corruption. I have tried adding new users, and get the same behaviors as with original users. Is it time to back up the mailboxes and wipe the machine, rebuild from scratch? I need an answer, as I have a deadline approaching by which I must move our mail services from an off-site mail server that is running currently to an on-site mail server - the one I have been trying to build and get running. On Jun 25, 2006, at 12:07 AM, George Sweetnam wrote: The ones specifically created to solve issues in my logs were fixed with these links: libcrypto.so.4 - /lib/libcrypto.so.0.9.8a libssl.so.4 - /lib/libssl.so.0.9.8a libc.so.6 - libc-2.4.so Here is a full list of the ones I created, or that re-installing programs made after my initial install (to fix installations of mysql5,apache2.2,php5,courier, ect: libgcc_s.so.1 - libgcc_s-4.1.1-20060525.so.1 libutil.so.1 - libutil-2.4.so libthread_db.so.1 - libthread_db-1.0.so librt.so.1 - librt-2.4.so libresolv.so.2 - libresolv-2.4.so libpthread.so.0 - libpthread-2.4.so libnss_nis.so.2 - libnss_nis-2.4.so libnss_nisplus.so.2 - libnss_nisplus-2.4.so libnss_hesiod.so.2 - libnss_hesiod-2.4.so libnss_files.so.2 - libnss_files-2.4.so libnss_dns.so.2 - libnss_dns-2.4.so libnss_compat.so.2 - libnss_compat-2.4.so libnsl.so.1 - libnsl-2.4.so libm.so.6 - libm-2.4.so libdl.so.2 - libdl-2.4.so libc.so.6 - libc-2.4.so libcrypt.so.1 - libcrypt-2.4.so libcidn.so.1 - libcidn-2.4.so libBrokenLocale.so.1 - libBrokenLocale-2.4
Re: [qmailtoaster] User Access now failing: Help?
mysql -u root -h 127.0.0.1 -p works properly. I can log in. mysql -u vpopmail -h 127.0.0.1 -p also works properly, logging in. On 6/27/06, George [EMAIL PROTECTED] wrote: Roxanne, It sounds like you don't have mysql set to accept connections from localhost. Can you access via pop3 or pop3-ssl? Is this really only an imap (and thus squirrelmail) issue? #Test with this: mysql -u root -h 127.0.0.1 -p #If you can't access it, try running sql in safe mode (from there you can modify permissions for localhost if needed): safe_mysqld --skip-grant-tables #check status of mysql: mysqladmin -u root -p status I reset the sql permissions on my system to allow only localhost in... no fqdn allowed (localhost is the default usually if you don't use the -h option). George excerpt from imap4-ssl logs: 2006-06-27 14:18:24.408813500 INFO: LOGIN, [EMAIL PROTECTED], ip=[206.111.111.111], protocol=IMAP 2006-06-27 14:18:24.413817500 DEBUG: Unexpected SSL connection shutdown. 2006-06-27 14:18:24.413824500 tcpserver: end 9073 status 0 2006-06-27 14:18:24.413827500 tcpserver: status: 0/40 2006-06-27 14:18:24.413830500 INFO: LOGOUT, [EMAIL PROTECTED], ip=[206.111.111.111], headers=0, body=0, time=0 - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Tuesday, June 27, 2006 1:25 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Thank you, George, for including that information. Unfortunately, it seems that my system is not having any problems - or not reporting any problems - finding any of those libraries. Does anyone have any further ideas or suggestions as to what I can do to try to correct this problem? To restate the problem for clarity: I have a Fedora Core 5 box, with MySQL 5.0.22, Apache 2.2, PHP5 installed. To this, I have added the latest qmail-toaster installation. I am using BIND rather than the little caching DNS server. I can access all of the administrative functions of Qmail and Qmail Toaster. But I cannot log in as any user to view their e-mail through Squirrelmail, or through IMAP, or IMAP-SSL. I know I have the username and password correct, as I can still log in to the Qmail administration screen as these users and view their specific, individual settings. The following is a segment of the imap4-ssl Current log: 2006-06-27 13:54:30.035390500 tcpserver: status: 0/40 2006-06-27 14:00:11.873804500 tcpserver: status: 1/40 2006-06-27 14:00:11.874041500 tcpserver: pid 3364 from 216.127.141.199 2006-06-27 14:00:11.874117500 tcpserver: ok 3364 mail.gitcamerica.com: 216.127.141.200:993 :216.127.141.199::60979 2006-06-27 14:00:12.062831500 DEBUG: Connection, ip=[216.127.141.199] 2006-06-27 14:00:12.143233500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[216.127.141.199] 2006-06-27 14:00:17.158872500 INFO: LOGOUT, ip=[216.127.141.199], rcvd=56, sent=225 2006-06-27 14:00:17.159622500 tcpserver: end 3364 status 0 2006-06-27 14:00:17.159629500 tcpserver: status: 0/40 The following is a segment of the authlib Current log: 2006-06-27 13:54:31.642186500 INFO: modules=authshadow authvchkpw, daemons=15 2006-06-27 13:54:31.642195500 INFO: Installing libauthshadow 2006-06-27 13:54:32.126208500 INFO: Installation complete: authshadow 2006-06-27 13:54:32.126261500 INFO: Installing libauthvchkpw 2006-06-27 13:54:32.132647500 INFO: Installation complete: authvchkpw 2006-06-27 13:57:16.209559500 vmysql: sql error[3]: MySQL server has gone away My MySQL database is up and running and the vpopmail tables do not show any apparent corruption. I have tried adding new users, and get the same behaviors as with original users. Is it time to back up the mailboxes and wipe the machine, rebuild from scratch? I need an answer, as I have a deadline approaching by which I must move our mail services from an off-site mail server that is running currently to an on-site mail server - the one I have been trying to build and get running. On Jun 25, 2006, at 12:07 AM, George Sweetnam wrote: The ones specifically created to solve issues in my logs were fixed with these links: libcrypto.so.4 - /lib/libcrypto.so.0.9.8a libssl.so.4 - /lib/libssl.so.0.9.8a libc.so.6 - libc-2.4.so Here is a full list of the ones I created, or that re-installing programs made after my initial install (to fix installations of mysql5,apache2.2,php5,courier, ect: libgcc_s.so.1 - libgcc_s-4.1.1-20060525.so.1 libutil.so.1 - libutil-2.4.so libthread_db.so.1 - libthread_db-1.0.so librt.so.1 - librt-2.4.so libresolv.so.2 - libresolv-2.4.so libpthread.so.0 - libpthread-2.4.so libnss_nis.so.2 - libnss_nis-2.4.so libnss_nisplus.so.2 - libnss_nisplus-2.4.so libnss_hesiod.so.2 - libnss_hesiod-2.4.so libnss_files.so.2 - libnss_files-2.4.so libnss_dns.so.2 - libnss_dns-2.4.so libnss_compat.so.2 - libnss_compat-2.4.so libnsl.so.1 - libnsl-2.4.so libm.so.6 - libm-2.4.so libdl.so.2
Re: [qmailtoaster] User Access now failing: Help?
Oh. And no, I can't access via pop3 or pop3-ssl. On 6/27/06, Roxanne Sandesara [EMAIL PROTECTED] wrote: mysql -u root -h 127.0.0.1 -p works properly. I can log in. mysql -u vpopmail -h 127.0.0.1 -p also works properly, logging in. On 6/27/06, George [EMAIL PROTECTED] wrote: Roxanne, It sounds like you don't have mysql set to accept connections from localhost. Can you access via pop3 or pop3-ssl? Is this really only an imap (and thus squirrelmail) issue? #Test with this: mysql -u root -h 127.0.0.1 -p #If you can't access it, try running sql in safe mode (from there you can modify permissions for localhost if needed): safe_mysqld --skip-grant-tables #check status of mysql: mysqladmin -u root -p status I reset the sql permissions on my system to allow only localhost in... no fqdn allowed (localhost is the default usually if you don't use the -h option). George excerpt from imap4-ssl logs: 2006-06-27 14:18:24.408813500 INFO: LOGIN, [EMAIL PROTECTED], ip=[206.111.111.111], protocol=IMAP 2006-06-27 14:18:24.413817500 DEBUG: Unexpected SSL connection shutdown. 2006-06-27 14:18:24.413824500 tcpserver: end 9073 status 0 2006-06-27 14:18:24.413827500 tcpserver: status: 0/40 2006-06-27 14:18:24.413830500 INFO: LOGOUT, [EMAIL PROTECTED], ip=[206.111.111.111], headers=0, body=0, time=0 - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Tuesday, June 27, 2006 1:25 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Thank you, George, for including that information. Unfortunately, it seems that my system is not having any problems - or not reporting any problems - finding any of those libraries. Does anyone have any further ideas or suggestions as to what I can do to try to correct this problem? To restate the problem for clarity: I have a Fedora Core 5 box, with MySQL 5.0.22, Apache 2.2, PHP5 installed. To this, I have added the latest qmail-toaster installation. I am using BIND rather than the little caching DNS server. I can access all of the administrative functions of Qmail and Qmail Toaster. But I cannot log in as any user to view their e-mail through Squirrelmail, or through IMAP, or IMAP-SSL. I know I have the username and password correct, as I can still log in to the Qmail administration screen as these users and view their specific, individual settings. The following is a segment of the imap4-ssl Current log: 2006-06-27 13:54:30.035390500 tcpserver: status: 0/40 2006-06-27 14:00:11.873804500 tcpserver: status: 1/40 2006-06-27 14:00:11.874041500 tcpserver: pid 3364 from 216.127.141.199 2006-06-27 14:00:11.874117500 tcpserver: ok 3364 mail.gitcamerica.com: 216.127.141.200:993 :216.127.141.199::60979 2006-06-27 14:00:12.062831500 DEBUG: Connection, ip=[216.127.141.199] 2006-06-27 14:00:12.143233500 INFO: LOGIN FAILED, [EMAIL PROTECTED], ip=[216.127.141.199] 2006-06-27 14:00:17.158872500 INFO: LOGOUT, ip=[216.127.141.199], rcvd=56, sent=225 2006-06-27 14:00:17.159622500 tcpserver: end 3364 status 0 2006-06-27 14:00:17.159629500 tcpserver: status: 0/40 The following is a segment of the authlib Current log: 2006-06-27 13:54:31.642186500 INFO: modules=authshadow authvchkpw, daemons=15 2006-06-27 13:54:31.642195500 INFO: Installing libauthshadow 2006-06-27 13:54:32.126208500 INFO: Installation complete: authshadow 2006-06-27 13:54:32.126261500 INFO: Installing libauthvchkpw 2006-06-27 13:54:32.132647500 INFO: Installation complete: authvchkpw 2006-06-27 13:57:16.209559500 vmysql: sql error[3]: MySQL server has gone away My MySQL database is up and running and the vpopmail tables do not show any apparent corruption. I have tried adding new users, and get the same behaviors as with original users. Is it time to back up the mailboxes and wipe the machine, rebuild from scratch? I need an answer, as I have a deadline approaching by which I must move our mail services from an off-site mail server that is running currently to an on-site mail server - the one I have been trying to build and get running. On Jun 25, 2006, at 12:07 AM, George Sweetnam wrote: The ones specifically created to solve issues in my logs were fixed with these links: libcrypto.so.4 - /lib/libcrypto.so.0.9.8a libssl.so.4 - /lib/libssl.so.0.9.8a libc.so.6 - libc-2.4.so Here is a full list of the ones I created, or that re-installing programs made after my initial install (to fix installations of mysql5,apache2.2,php5,courier, ect: libgcc_s.so.1 - libgcc_s-4.1.1-20060525.so.1 libutil.so.1 - libutil-2.4.so libthread_db.so.1 - libthread_db-1.0.so librt.so.1 - librt-2.4.so libresolv.so.2 - libresolv-2.4.so libpthread.so.0 - libpthread-2.4.so libnss_nis.so.2 - libnss_nis-2.4.so libnss_nisplus.so.2 - libnss_nisplus-2.4.so libnss_hesiod.so.2 - libnss_hesiod-2.4.so libnss_files.so.2
Re: [qmailtoaster] User Access now failing: Help?
Roxanne Sandesara wrote: No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
Jake Vickers wrote: Roxanne Sandesara wrote: No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -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] User Access now failing: Help?
Eric is correct. I'm running on an FC5 box, which is running mysql-5.0.22-1.FC5.1. On 6/24/06, Eric Shubes [EMAIL PROTECTED] wrote: Jake Vickers wrote: Roxanne Sandesara wrote: No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -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] User Access now failing: Help?
Im running a bastardized FC5 installation (a crashed FC2 install I wiped /boot and /lib due to some corruption problems). This machine had a working copy of the previous toaster version. To make this very long story short I had to upgrade to mysql 5 and php 5, redo apache, chroot dns, ect ... ect.. ect. To make toaster authenticate for imap and pop3 I had to create a series of simlinks for some lib files. After creating them I haven't had any issues with authentication on FC5. I've missed most of this thread, but would be willing to compare or try and duplicate your problem on one of my systems if needed. Not all of my toaster apps are current, but they should work for testing. Here they are: qmail-toaster-1.03-1.2.10 control-panel-toaster-0.5-1.2.8 qmailmrtg-toaster-4.2-1.2.8 vqadmin-toaster-2.3.4-1.2.12 spamassassin-toaster-3.1.1-1.2.14 daemontools-toaster-0.76-1.2.9 vpopmail-toaster-5.4.10-1.2.10 autorespond-toaster-2.0.4-1.2.8 qmailadmin-toaster-1.2.9-1.2.11 isoqlog-toaster-2.1-1.2.9 courier-imap-toaster-3.0.8-1.2.9 ezmlm-cgi-toaster-0.53.324-1.2.10 maildrop-toaster-devel-1.8.1-1.2.10 clamav-toaster-0.88.2-1.2.15 ucspi-tcp-toaster-0.88-1.2.9 qmail-pop3d-toaster-1.03-1.2.10 ezmlm-toaster-0.53.324-1.2.10 maildrop-toaster-1.8.1-1.2.10 squirrelmail-toaster-1.4.5-1.2.13 simscan-toaster-1.1-1.2.7 George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 2:22 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Eric is correct. I'm running on an FC5 box, which is running mysql-5.0.22-1.FC5.1. On 6/24/06, Eric Shubes [EMAIL PROTECTED] wrote: Jake Vickers wrote: Roxanne Sandesara wrote:see No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -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] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
George -- If you could compile for me a list of the simlinks you created, I would be interested in seeing that list and attempting to recreate them on my system to see if they would manage to change the behavior. I confess, what I want most right this second is a way to reconfigure vpopmail so that it attempts a new connection to the MySQL server every time it needs to check information. Anyway. I'm eagerly awaiting. On Jun 24, 2006, at 7:38 PM, George Sweetnam wrote: Im running a bastardized FC5 installation (a crashed FC2 install I wiped /boot and /lib due to some corruption problems). This machine had a working copy of the previous toaster version. To make this very long story short I had to upgrade to mysql 5 and php 5, redo apache, chroot dns, ect ... ect.. ect. To make toaster authenticate for imap and pop3 I had to create a series of simlinks for some lib files. After creating them I haven't had any issues with authentication on FC5. I've missed most of this thread, but would be willing to compare or try and duplicate your problem on one of my systems if needed. Not all of my toaster apps are current, but they should work for testing. Here they are: qmail-toaster-1.03-1.2.10 control-panel-toaster-0.5-1.2.8 qmailmrtg-toaster-4.2-1.2.8 vqadmin-toaster-2.3.4-1.2.12 spamassassin-toaster-3.1.1-1.2.14 daemontools-toaster-0.76-1.2.9 vpopmail-toaster-5.4.10-1.2.10 autorespond-toaster-2.0.4-1.2.8 qmailadmin-toaster-1.2.9-1.2.11 isoqlog-toaster-2.1-1.2.9 courier-imap-toaster-3.0.8-1.2.9 ezmlm-cgi-toaster-0.53.324-1.2.10 maildrop-toaster-devel-1.8.1-1.2.10 clamav-toaster-0.88.2-1.2.15 ucspi-tcp-toaster-0.88-1.2.9 qmail-pop3d-toaster-1.03-1.2.10 ezmlm-toaster-0.53.324-1.2.10 maildrop-toaster-1.8.1-1.2.10 squirrelmail-toaster-1.4.5-1.2.13 simscan-toaster-1.1-1.2.7 George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 2:22 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Eric is correct. I'm running on an FC5 box, which is running mysql-5.0.22-1.FC5.1. On 6/24/06, Eric Shubes [EMAIL PROTECTED] wrote: Jake Vickers wrote: Roxanne Sandesara wrote:see No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -Eric 'shubes' - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [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] User Access now failing: Help?
At the prompt type 'hostname -s' and send it here. It should be the fqdn, a name that resolves in DNS and is in /etc/hosts. Otherwise MySQL could have issues with everything. Erik On 6/23/06, Roxanne Sandesara [EMAIL PROTECTED] wrote: No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. On 6/23/06, Jake Vickers [EMAIL PROTECTED] wrote: Roxanne Sandesara wrote: That file has in it exactly what it is supposed to have in it, and nothing about MySQL has changed, and the server is not hanging. Somehow, I need to reconfigure vpopmail to actually re-attempt its login every time it goes to access the database, since it's not possible to establish a permanent always-on connection. I'm sure you checked this file to make sure the format is correct. Alright, when you say that a permanent always-on connection is not possible, is the machine connecting to an outside mysql server? I may have missed some details in the earlier posts, so bear with me please. - 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] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
The ones specifically created to solve issues in my logs were fixed with these links: libcrypto.so.4 - /lib/libcrypto.so.0.9.8a libssl.so.4 - /lib/libssl.so.0.9.8a libc.so.6 - libc-2.4.so Here is a full list of the ones I created, or that re-installing programs made after my initial install (to fix installations of mysql5,apache2.2,php5,courier, ect: libgcc_s.so.1 - libgcc_s-4.1.1-20060525.so.1 libutil.so.1 - libutil-2.4.so libthread_db.so.1 - libthread_db-1.0.so librt.so.1 - librt-2.4.so libresolv.so.2 - libresolv-2.4.so libpthread.so.0 - libpthread-2.4.so libnss_nis.so.2 - libnss_nis-2.4.so libnss_nisplus.so.2 - libnss_nisplus-2.4.so libnss_hesiod.so.2 - libnss_hesiod-2.4.so libnss_files.so.2 - libnss_files-2.4.so libnss_dns.so.2 - libnss_dns-2.4.so libnss_compat.so.2 - libnss_compat-2.4.so libnsl.so.1 - libnsl-2.4.so libm.so.6 - libm-2.4.so libdl.so.2 - libdl-2.4.so libc.so.6 - libc-2.4.so libcrypt.so.1 - libcrypt-2.4.so libcidn.so.1 - libcidn-2.4.so libBrokenLocale.so.1 - libBrokenLocale-2.4.so libanl.so.1 - libanl-2.4.so ld-linux.so.2 - ld-2.4.so libpam.so.0 - libpam.so.0.81.3 libpam_misc.so.0 - libpam_misc.so.0.81.2 libpamc.so.0 - libpamc.so.0.81.0 libdbus-1.so.2 - libdbus-1.so.2.0.0 libasound.so.2 - libasound.so.2.0.0 libssl.so.4 - /lib/libssl.so.0.9.8a libcrypto.so.4 - /lib/libcrypto.so.0.9.8a Hope it helps. I'll warn you though, be VERY carefull when playing with simlinks. If you remove one to create another you'll likely segfault your system and have a really nasty time fixing it. Library files I normally only play with when I have something in my error logs telling me a particular version is missing. Then I create a link for that name to point to the version I am running. You should NEVER remove them! When in doubt, google is your friend. George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 7:04 PM Subject: Re: [qmailtoaster] User Access now failing: Help? George -- If you could compile for me a list of the simlinks you created, I would be interested in seeing that list and attempting to recreate them on my system to see if they would manage to change the behavior. I confess, what I want most right this second is a way to reconfigure vpopmail so that it attempts a new connection to the MySQL server every time it needs to check information. Anyway. I'm eagerly awaiting. On Jun 24, 2006, at 7:38 PM, George Sweetnam wrote: Im running a bastardized FC5 installation (a crashed FC2 install I wiped /boot and /lib due to some corruption problems). This machine had a working copy of the previous toaster version. To make this very long story short I had to upgrade to mysql 5 and php 5, redo apache, chroot dns, ect ... ect.. ect. To make toaster authenticate for imap and pop3 I had to create a series of simlinks for some lib files. After creating them I haven't had any issues with authentication on FC5. I've missed most of this thread, but would be willing to compare or try and duplicate your problem on one of my systems if needed. Not all of my toaster apps are current, but they should work for testing. Here they are: qmail-toaster-1.03-1.2.10 control-panel-toaster-0.5-1.2.8 qmailmrtg-toaster-4.2-1.2.8 vqadmin-toaster-2.3.4-1.2.12 spamassassin-toaster-3.1.1-1.2.14 daemontools-toaster-0.76-1.2.9 vpopmail-toaster-5.4.10-1.2.10 autorespond-toaster-2.0.4-1.2.8 qmailadmin-toaster-1.2.9-1.2.11 isoqlog-toaster-2.1-1.2.9 courier-imap-toaster-3.0.8-1.2.9 ezmlm-cgi-toaster-0.53.324-1.2.10 maildrop-toaster-devel-1.8.1-1.2.10 clamav-toaster-0.88.2-1.2.15 ucspi-tcp-toaster-0.88-1.2.9 qmail-pop3d-toaster-1.03-1.2.10 ezmlm-toaster-0.53.324-1.2.10 maildrop-toaster-1.8.1-1.2.10 squirrelmail-toaster-1.4.5-1.2.13 simscan-toaster-1.1-1.2.7 George. - Original Message - From: Roxanne Sandesara [EMAIL PROTECTED] To: qmailtoaster-list@qmailtoaster.com Sent: Saturday, June 24, 2006 2:22 PM Subject: Re: [qmailtoaster] User Access now failing: Help? Eric is correct. I'm running on an FC5 box, which is running mysql-5.0.22-1.FC5.1. On 6/24/06, Eric Shubes [EMAIL PROTECTED] wrote: Jake Vickers wrote: Roxanne Sandesara wrote:see No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. Which distro is rolling out Mysql 5 so I can look into it? I run all Cent4 and FC4 machines, and they all run mysql 4.1. I saw in an earlier post that she's running FC5. -- -Eric 'shubes
Re: [qmailtoaster] User Access now failing: Help?
hostname -s returns 'mail' hostname returns 'mail.gitcamerica.com' mail.gitcamerica.com resolves in DNS to the external IP address for this machine. On Jun 24, 2006, at 10:16 PM, Erik Espinoza wrote: At the prompt type 'hostname -s' and send it here. It should be the fqdn, a name that resolves in DNS and is in /etc/hosts. Otherwise MySQL could have issues with everything. Erik On 6/23/06, Roxanne Sandesara [EMAIL PROTECTED] wrote: No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. On 6/23/06, Jake Vickers [EMAIL PROTECTED] wrote: Roxanne Sandesara wrote: That file has in it exactly what it is supposed to have in it, and nothing about MySQL has changed, and the server is not hanging. Somehow, I need to reconfigure vpopmail to actually re-attempt its login every time it goes to access the database, since it's not possible to establish a permanent always-on connection. I'm sure you checked this file to make sure the format is correct. Alright, when you say that a permanent always-on connection is not possible, is the machine connecting to an outside mysql server? I may have missed some details in the earlier posts, so bear with me please. - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: qmailtoaster-list- [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [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] User Access now failing: Help?
Fernando Azevedo wrote: Let me reinforce Roxanne's problem as I have been trying to get help on the same matter but no one helped so far, with the exception of Johannes Weberhofer. His reply (with my original mail) is attached, in case it can be of any help. What does the file /home/vpopmail/etc/vpopmail.mysql have in it? If vpopmail has a problem connecting to mysql, then their's either a port problem, or mysql is hanging. Hard to tell without being there to check stuff. Has anything changed, such as changing the mysql config to allow outside access or anything? - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
That file has in it exactly what it is supposed to have in it, and nothing about MySQL has changed, and the server is not hanging. Somehow, I need to reconfigure vpopmail to actually re-attempt its login every time it goes to access the database, since it's not possible to establish a permanent always-on connection. On Jun 23, 2006, at 9:10 PM, Jake Vickers wrote: Fernando Azevedo wrote: Let me reinforce Roxanne's problem as I have been trying to get help on the same matter but no one helped so far, with the exception of Johannes Weberhofer. His reply (with my original mail) is attached, in case it can be of any help. What does the file /home/vpopmail/etc/vpopmail.mysql have in it? If vpopmail has a problem connecting to mysql, then their's either a port problem, or mysql is hanging. Hard to tell without being there to check stuff. Has anything changed, such as changing the mysql config to allow outside access or anything? - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: qmailtoaster-list- [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] User Access now failing: Help?
Roxanne Sandesara wrote: That file has in it exactly what it is supposed to have in it, and nothing about MySQL has changed, and the server is not hanging. Somehow, I need to reconfigure vpopmail to actually re-attempt its login every time it goes to access the database, since it's not possible to establish a permanent always-on connection. I'm sure you checked this file to make sure the format is correct. Alright, when you say that a permanent always-on connection is not possible, is the machine connecting to an outside mysql server? I may have missed some details in the earlier posts, so bear with me please. - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
No. It is connecting to the mysql server running on the same machine. But MySQL v5+ does not hold even localhost persistent connections permanently. If it can be set to allow such, I do not know where or how, as nothing I have found in my.conf or mysql.config speaks to such. On 6/23/06, Jake Vickers [EMAIL PROTECTED] wrote: Roxanne Sandesara wrote: That file has in it exactly what it is supposed to have in it, and nothing about MySQL has changed, and the server is not hanging. Somehow, I need to reconfigure vpopmail to actually re-attempt its login every time it goes to access the database, since it's not possible to establish a permanent always-on connection. I'm sure you checked this file to make sure the format is correct. Alright, when you say that a permanent always-on connection is not possible, is the machine connecting to an outside mysql server? I may have missed some details in the earlier posts, so bear with me please. - 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] User Access now failing: Help?
Roxanne Sandesara wrote: I haven't seen this one come through from the list. I'm not sure why. So I'm re-sending. Please forgive me if this is a duplicate for anyone. I had an installation that seemed to be up and running just fine. I had been able to log in to Squirrelmail as the users and send messages. I tried to send e-mail from outside, specifying the explicit server name since I was not yet ready to redirect my MX records in DNS to point to this new server. These messages have now all bounced out, with the following message: Your first post did come through. Check to make sure that mysqld is running, and then double check your qmail daemon to make sure IMAP is working right (qmailctl stat). I suspect that if it was working before and now stopped, that something messed with IMAP or mysql. Was anything changed just before it stopped working? - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
It appears that all of my qmail process daemons are up and running and have not been shut down since I started them. (see below) As I just managed to respond to Eric, mysqld is up and running, hasn't stopped, and all of the users are there just fine. The only thing I changed was an attempt to alter the named files to insert the domainkeys. In case it gives anyone a hint or a clue, creating a new account - which was created successfully - does not help; I still can't log into that new account, nor can I log into any of the other accounts. While I'm asking for help in troubleshooting this, I'll ask: where can I find the logs for these processes? I'd like to be able to look at the logs and see if anything in there is more explicative than my current problems. qmailctl stat authlib: up (pid 27485) 190299 seconds clamd: up (pid 27488) 190299 seconds imap4: up (pid 27494) 190299 seconds imap4-ssl: up (pid 27481) 190299 seconds pop3: up (pid 27491) 190299 seconds pop3-ssl: up (pid 27497) 190299 seconds send: up (pid 27498) 190299 seconds smtp: up (pid 27495) 190299 seconds spamd: up (pid 27486) 190299 seconds authlib/log: up (pid 27489) 190299 seconds clamd/log: up (pid 27493) 190299 seconds imap4/log: up (pid 27490) 190299 seconds imap4-ssl/log: up (pid 27482) 190299 seconds pop3/log: up (pid 27483) 190299 seconds pop3-ssl/log: up (pid 27496) 190299 seconds send/log: up (pid 27484) 190299 seconds smtp/log: up (pid 27492) 190299 seconds spamd/log: up (pid 27487) 190299 seconds On 6/22/06, Jake Vickers [EMAIL PROTECTED] wrote: Your first post did come through. Check to make sure that mysqld is running, and then double check your qmail daemon to make sure IMAP is working right (qmailctl stat). I suspect that if it was working before and now stopped, that something messed with IMAP or mysql. Was anything changed just before it stopped working? - 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] User Access now failing: Help?
Roxanne Sandesara wrote: It appears that all of my qmail process daemons are up and running and have not been shut down since I started them. (see below) As I just managed to respond to Eric, mysqld is up and running, hasn't stopped, and all of the users are there just fine. The only thing I changed was an attempt to alter the named files to insert the domainkeys. In case it gives anyone a hint or a clue, creating a new account - which was created successfully - does not help; I still can't log into that new account, nor can I log into any of the other accounts. While I'm asking for help in troubleshooting this, I'll ask: where can I find the logs for these processes? I'd like to be able to look at the logs and see if anything in there is more explicative than my current problems. The log files can be located in /var/log/qmail The different daemons will have their own folders with the logs in them. The current file will be the one that is showing what's happening (mine rotates about twice a day). To help read the logs, view them like this: cat current | tai64nlocal tai64nlocal will convert the time notation used by the daemons into a more human-readable format for you. - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] User Access now failing: Help?
This was the result from authlib: cat current | tai64nlocal 2006-06-20 10:38:03.211413500 INFO: modules=authshadow authvchkpw, daemons=15 2006-06-20 10:38:03.211419500 INFO: Installing libauthshadow 2006-06-20 10:38:03.211424500 INFO: Installation complete: authshadow 2006-06-20 10:38:03.211429500 INFO: Installing libauthvchkpw 2006-06-20 10:38:03.393843500 INFO: Installation complete: authvchkpw 2006-06-21 13:03:44.507654500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:04:00.188161500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:04:21.309831500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:07:25.535829500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:38:05.785656500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:38:55.695611500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:39:31.479426500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:42:07.489138500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:42:11.337928500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:44:54.882470500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:58:18.953102500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 13:58:43.619141500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 14:11:23.310489500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 15:53:39.270785500 vmysql: sql error[3]: MySQL server has gone away 2006-06-21 15:53:54.859545500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 10:15:17.352392500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 10:15:17.409137500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 10:56:52.765066500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 11:06:01.053537500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 11:11:39.341441500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 12:36:15.276978500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 12:47:13.637794500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 12:48:27.082270500 vmysql: sql error[3]: MySQL server has gone away 2006-06-22 15:34:47.365264500 vmysql: sql error[3]: MySQL server has gone away But as you can see below, my MySQL server is up and running: root 17122 0.0 0.1 4448 1260 ?S16:09 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log mysql17158 0.0 1.7 136672 18336 ?Sl 16:09 0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock Any thoughts anyone can offer as to why autblib is not able to plug into the MySQL server, or how to convince it to start doing so? On 6/22/06, Jake Vickers [EMAIL PROTECTED] wrote: Roxanne Sandesara wrote: It appears that all of my qmail process daemons are up and running and have not been shut down since I started them. (see below) As I just managed to respond to Eric, mysqld is up and running, hasn't stopped, and all of the users are there just fine. The only thing I changed was an attempt to alter the named files to insert the domainkeys. In case it gives anyone a hint or a clue, creating a new account - which was created successfully - does not help; I still can't log into that new account, nor can I log into any of the other accounts. While I'm asking for help in troubleshooting this, I'll ask: where can I find the logs for these processes? I'd like to be able to look at the logs and see if anything in there is more explicative than my current problems. The log files can be located in /var/log/qmail The different daemons will have their own folders with the logs in them. The current file will be the one that is showing what's happening (mine rotates about twice a day). To help read the logs, view them like this: cat current | tai64nlocal tai64nlocal will convert the time notation used by the daemons into a more human-readable format for you. - 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]