Roxanne,
There is either a permissions problem on the tables (which you just checked
for Erik and seem ok) or the password is stored wrong... so lets assume that
the tables are ok. If the tables are an issue we'll check the mysql.sock
file, but lets try something easier first.
cat /home/vpopmail/etc/vpopmail.mysql
you should see your password stored in there. I'd recommend backing up the
file before making any changes. Change if needed to make it match what you
use with vpopmail.
cp -ax /home/vpopmail/etc/vpopmail.mysql
/home/vpopmail/etc/vpopmail.mysql.20060627
Here is what i have in mine (with the password set to the word password):
localhost|0|vpopmail|password|vpopmail
Oh, you should see localhost in the first field since that's what we tested
to access.
------------------------------------------
Test it:
telnet mail.yourdomain.com 110
user [EMAIL PROTECTED]
pass password
list
quit
----- Original Message -----
From: "Roxanne Sandesara" <[EMAIL PROTECTED]>
To: <qmailtoaster-list@qmailtoaster.com>
Sent: Tuesday, June 27, 2006 3:50 PM
Subject: Re: [qmailtoaster] Re: User Access now failing: Help?
Successfully dumps the contents of the vpopmail database to my screen.
On 6/27/06, Erik Espinoza <[EMAIL PROTECTED]> wrote:
> What about mysqldump -u vpopmail -p vpopmail
>
> 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 -> 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'
> > > >>>
> > > >>> --------------------------------------------------------------------
> > > >>> -
> > > >>> 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]
> > > 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]
>
>
---------------------------------------------------------------------
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]
