Ack, the mysql41-server port killed my box

[Matt Rechkemmer]

Lately my FreeBSD 5.3R system has been running fine. Tonight I decided to
load the mysql 4.1.x port. After loading it, glancing at mysql-server.sh, and
firing it up, things went haywire.

At the time I had two root sessions open, as well as two normal users. My
normal users started getting permission denied for everything, new users are
unable to login receiving this via SSHd:

No supported authentication methods left to try!

Root cannot query any user information. /etc/passwd and /etc/master.passwd
look fine. MySQL.d is NOT running, it never did startup, and now I am
effectively locked out of the system if I logout.

It's obviously authenticated since /var/log/auth.log reports:
Feb 19 04:51:17 hybrid sshd[79901]: Accepted keyboard-interactive/pam for
theuser from 172.17.1.11 port 2101 ssh2

Any help is GREATLY appreciated, Google has so far yieled nothing on this
topic.

Thanks!

Matt Rechkemmer
[email]tiberius@trancell.org[/email]

[Emanuel Strobl]

Am Samstag, 19. Februar 2005 12:06 schrieb Matt Rechkemmer:

> Lately my FreeBSD 5.3R system has been running fine. Tonight I decided to
> load the mysql 4.1.x port. After loading it, glancing at mysql-server.sh,
> and firing it up, things went haywire.
>
> At the time I had two root sessions open, as well as two normal users. My
> normal users started getting permission denied for everything, new users
> are unable to login receiving this via SSHd:
>
> No supported authentication methods left to try!

Just a wild guess, perhaps there is any pam module which tries to authenticate
against the mysql database?. It sounds like....

-Harry

>
> Root cannot query any user information. /etc/passwd and /etc/master.passwd
> look fine. MySQL.d is NOT running, it never did startup, and now I am
> effectively locked out of the system if I logout.
>
> It's obviously authenticated since /var/log/auth.log reports:
> Feb 19 04:51:17 hybrid sshd[79901]: Accepted keyboard-interactive/pam for
> theuser from 172.17.1.11 port 2101 ssh2
>
> Any help is GREATLY appreciated, Google has so far yieled nothing on this
> topic.
>
> Thanks!
>
> Matt Rechkemmer
> [email]tiberius@trancell.org[/email]
> _______________________________________________
> [email]freebsd-questions@freebsd.org[/email] mailing list
> [url]http://lists.freebsd.org/mailman/listinfo/freebsd-questions[/url]
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe@freebsd.org"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)

iD8DBQBCGdUzBylq0S4AzzwRAs1mAKCCM4WD/xXniACN1EFY42+gLZufqACfQ3ly
8gVSKIYsVJp/dSfJ3ZncRTo=
=0G7U
-----END PGP SIGNATURE-----

[Matt Rechkemmer]

On Mon, Feb 21, 2005 at 01:33:50PM +0100, Emanuel Strobl wrote:

>
> Just a wild guess, perhaps there is any pam module which tries to
> authenticate against the mysql database?. It sounds like....
>
> -Harry

Actually after much effort I figured it out. The mysql41-server port (v
4.1.10), set the permissions on /. and /.. to 0700 instead of 0755. Once I
set these back to normal, things on the system returned to normal operation.