Topic: Webmail MySQL error

[Des Dougan]

I've just enabled Webmail on my home server. However, when I try to access it via the browser, I get a MySQL error:

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/horde-phplib/db_mysql.inc on line 73

There are three mysql processes running, but when I tried a restart (service mysqld restart), it returned Failed for stopping and OK for starting.

I'd appreciate any help as to why this might be happening.

Thanks,

Des Dougan

[Des Dougan]

Hmmn - killing the processes and restarting mysql seems to have resolved the problem. Anyone have an idea why this might have happened?

Thanks,

Des Dougan

[Des Dougan]

As noted in my previous post, I got mysql restarted and was able to access Webmail. However, each time I try, it tells me:

Either you have logged in incorrectly or your login has expired.

Neither is the case. In fact, I have tried with all 5 users on my LAN, and only one is getting access. Checking the user pane in the manager, all seem fine. I did a visual check of /etc/passwd, and all are there and look the same.

I appear to have some kind of configuration problem, perhaps with IMAP, per the messages log:

Sep 23 18:10:29 jeeves imapd[1541]: Login failure user=des
host=jeeves.xxx.xxx[192.168.0.1]
Sep 23 18:10:32 jeeves imapd[1541]: AUTHENTICATE LOGIN failure host=jeeves.xxx.xxx[192.168.0.1]
Sep 23 18:10:32 jeeves PAM_pwdb[1541]: get passwd; pwdb: request not recognized

Can anyone provide a solution or pointers to what has happened here?

Thanks,

Des Dougan

[Dan Brown]

No solution, but one pointer--try logging in with another imap client.  If that doesn't work, try a POP client.

Have you installed the Update 1 blade?

[Des Dougan]

Dan,

Thanks for your reply.

Dan Brown wrote:
>
> No solution, but one pointer--try logging in with another
> imap client.  If that doesn't work, try a POP client.

I tried by setting up an IMAP account on Eudora - it responds "The server replied: LOGIN failed"

The messages log gave a different message this time:

Sep 23 20:57:03 jeeves PAM_pwdb[2332]: get passwd; pwdb: request not recognized
Sep 23 20:57:04 jeeves imapd[2332]: Login failure user=des host=pc-00065.xxx.xxx [192.168.0.65]
Sep 23 20:57:08 jeeves imapd[2332]: Command stream end of file, while reading line user=des host=pc-00065.xxx.xxx [192.168.0.65]

>
> Have you installed the Update 1 blade?

This is still on 4.1.2. I have had no problems with 4.1.2 until I tried activating Webmail. I did upgrade from 4.1 rather than install from new. One of the odd things here is that the id which does work was, IIRC, set up again after I'd moved to 4.1.2, so perhaps something went wrong somewhere along the upgrade path.

I don't know much about how PAM works, either, so I don't quite know where to go from here.


Des

[Des Dougan]

I did some more checking on this tonight, and have found that the problem IDs have no entries in the /etc/shadow file. I assume something must have happened when I had space problems when I did a restore a couple of months ago (testing software RAID which went wrong).

From the fact that all these users can log into the domain, I assume that /etc/shadow doesn't get used for Samba authentication, but that LDAP does use it.

Can I rebuild the /etc/shadow entries without having to re-create the users?


Thanks,

Des Dougan

[Des Dougan]

I have managed to resolve the problem. For anyone else who may get in the same boat:

I ran pwconv, which created the missing /etc/shadow entries. I then had to create updated passwords for the 5 users ("passwd username").

Following this, I was able to access Webmail.


Des Dougan