Well, mail would have to be working to log I guess...you can try it with any of the tables you see too. You can use a domain, lastauth, or whatever you see there.
George ----- Original Message ----- From: "Roxanne Sandesara" <[EMAIL PROTECTED]> To: <qmailtoaster-list@qmailtoaster.com> Sent: Tuesday, June 27, 2006 4:31 PM Subject: Re: [qmailtoaster] Re: User Access now failing: Help? Table vpopmail.vlog does not exist. On 6/27/06, George <[EMAIL PROTECTED]> wrote: > Hummm... > Try this: > mysql -uvpopmail -hlocalhost -p vpopmail > > #at the prompt: > show tables; > > #you'll see a list, then at the prompt do this: > select count(*) from vlog; > > It should show you a number (in a box). Originally i thought this test > would have failed, but it sounds like it'll work now. > > > George > > > ----- Original Message ----- > From: "Roxanne Sandesara" <[EMAIL PROTECTED]> > To: <qmailtoaster-list@qmailtoaster.com> > Sent: Tuesday, June 27, 2006 4:02 PM > Subject: Re: [qmailtoaster] Re: User Access now failing: Help? > > > Yes. That's where I copied the password from to execute those commands. > > On 6/27/06, Erik Espinoza <[EMAIL PROTECTED]> wrote: > > 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] > > > > > > --------------------------------------------------------------------- > 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]