| View previous topic :: View next topic |
| Author |
Message |
alexbgl
Apprentice
Joined: 05 Jul 2006
Posts: 240
Location: Verona
|
 Posted: Tue Feb 27, 2007 9:05 pm Post subject: pam_mysql.so |
 |
|
Ho tentato di far autenticare un utente tramite mysql, appunto con pam_mysql, tanto per provare, però non vuole proprio decidersi a funzionare.
Ecco i log (ho messo verbose):
| Code: | Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option debug is set to ""
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option verbose is set to ""
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option user is set to "root"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option passwd is set to "<password del db>"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option host is set to "localhost"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option db is set to "usersdb"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option table is set to "users"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option usercolumn is set to "username"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option passwdcolumn is set to "passwd"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option statcolumn is set to "state"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option crypt is set to "plain"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option logtable is set to "logs"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option logmsgcolumn is set to "operations"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option logusercolumn is set to "autenticated"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option logpidcolumn is set to "pid"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option loghostcolumn is set to "host"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option logrhostcolumn is set to "rhost"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - option logtimecolumn is set to "timestamp"
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_close_db() called.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_sm_authenticate() called.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_open_db() called.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_open_db() returning 0.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_check_passwd() called.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_format_string() called
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_quick_escape() called.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - SELECT passwd FROM users WHERE username = 'prova'
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_check_passwd() returning 6.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_sql_log() called.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_sql_log() returning 0.
Feb 27 21:58:18 RVSYS login[7393]: pam_mysql - pam_mysql_converse() called.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_open_db() called.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_check_passwd() called.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_format_string() called
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_quick_escape() called.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - SELECT passwd FROM users WHERE username = 'prova'
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_check_passwd() returning 0.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_sql_log() called.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_mysql_sql_log() returning 0.
Feb 27 21:58:21 RVSYS login[7393]: pam_mysql - pam_sm_authenticate() returning 0.
Feb 27 21:58:24 RVSYS login(pam_unix)[7393]: check pass; user unknown
Feb 27 21:58:24 RVSYS pam_tally[7393]: pam_tally: pam_get_uid; no such user prova
Feb 27 21:58:26 RVSYS login[7393]: FAILED LOGIN (2) on 'tty1' FOR `UNKNOWN', Permission denied
|
Dov'è che potrei aver sbagliato? |
|
| Back to top |
|
 |
MeMyselfAndI
l33t
Joined: 15 Nov 2005
Posts: 784
Location: Between the monitor and the chair
|
| Posted: Wed Feb 28, 2007 12:36 pm Post subject: |
|
|
| Cosi' a occhio e croce sembra che gli passi nome utente=root all'inizio e poi cerca la passwd per nome utente=prova, io partirei da li per trovae l'inghippo |
|
| Back to top |
|
|
alexbgl
Apprentice
Joined: 05 Jul 2006
Posts: 240
Location: Verona
|
| Posted: Wed Feb 28, 2007 2:11 pm Post subject: |
|
|
| MeMyselfAndI wrote: | | Cosi' a occhio e croce sembra che gli passi nome utente=root all'inizio e poi cerca la passwd per nome utente=prova, io partirei da li per trovae l'inghippo |
Ma infatti dovrebbe essere giusto: si connette al database come root con la password che gli dico io e poi cerca la password per l'utente prova...insomma, fa proprio quello che deve fare |
|
| Back to top |
|
|
|
Forum italiano (Italian) 
