Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 02-24-2006, 05:09 AM   #1
Registered: Sep 2005
Posts: 33

Rep: Reputation: 15
Exclamation Pam Mysql Nss

I have a real big problem

I have converted my system to use pam_mysql as its authentifacation, I have a table called auth and another called shadow, the auth table is for passwd and the shadow for shadow

pam_sql works fine when loggin users in, as in they are authenticated, however, only the root account can resolve uid to names.

so when I 'ls' as root the files owned by users in the mysql database have there names

when a user from the mysql database logs in the prompt says I have no name and the 'ls' on files show uid's instead of names.

/usr/bin/id will work fine when logged in as root

root@Genesis-2:/etc# id stuart
uid=5032(stuart) gid=5000(students) groups=5000(students)
root@Genesis-2:/etc# su stuart
I have no name!@Genesis-2:/etc$ id stuart
id: stuart: No such user

it seems only root can access the database???

Many thanks for any help
Old 02-24-2006, 10:39 AM   #2
Registered: Sep 2005
Posts: 33

Original Poster
Rep: Reputation: 15
Well, I have found a workaround, if i change the permissions on /rtc/libnns_mysql-root.conf to world viewable then it works this is not good as it holds the root password for the mysql database

The reason I found this out was to use strace on id, it showed it trying to open /etc/libnss_mysql-root.conf and it had access denied, as it should, however this stopped /usr/bin/id from working with pam_mysql

I am in need of a real expert as I only know a little about a lot


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to understand Relationship of NSS and PAM saneax Linux - General 0 09-16-2005 04:14 AM
PAM-mysql seems not work adrianmak Linux - Software 1 08-22-2005 03:00 AM
NSS won't compile because of something to do with nspr juliensteel Linux - Newbie 0 01-21-2005 07:13 PM
pam mysql dlublink SUSE / openSUSE 3 01-20-2005 07:03 AM
vsftpd + pam + virtual users - Pam cannot load database file. mdkelly069 Linux - Networking 3 09-22-2004 11:07 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:02 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration