Does the vpopmail password you used match /home/vpopmail/etc/vpopmail.mysql
Erik
On 6/27/06, Roxanne Sandesara <[EMAIL PROTECTED]> wrote:
> 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]
