LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 02-24-2006, 05:09 AM   #1
server-solution
Member
 
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
server-solution
Member
 
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
 
  


Reply


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/Novell 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


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

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