[Decaf-devel] pam decaf

[Joachim Breitner]

Hi,

Am Donnerstag, den 14.12.2006, 11:32 +0000 schrieb LINUXKAFE:
> > Am Mittwoch, den 13.12.2006, 15:41 +0000 schrieb LINUXKAFE:
> > > > yes, currently the check is case sensitive, which is of course not what
> > > > we want. I’ll just fixed that immediately, and commited to svn (revision
> > > > 42). It should work with NPAZG though.
> > > i've tried that :(
> > 
> > Strange. What happens if you run this SQL query from hand, using psql:
> > 
> > SELECT time_credits > 0 as credits, starttime IS NULL as free FROM   \
> >        timecodes WHERE upper(timecode)=upper('<some valid timecode>')
> > 
> 
> decaf=> SELECT time_credits > 0 as credits, starttime IS NULL as free
> FROM timecode WHERE upper(timecode)=upper('IZXVQ')
> decaf-> ;
> credits | free 
> ---------+------
> t       | t
> (1 row)
> 
> decaf=> 
> 
> > If that does not return anything, then something is wrong with the data
> > in the database, in that case a 'SELECT * from timecode' might help me.
> > 
> decaf=> select * from timecode;
> timecode | lastseen | workstation |   time_credits   | starttime 
> ----------+----------+-------------+------------------+-----------
> NPAZQ    |          |             | -20:26:33.761429 | 
> XUKNP    |          |             | -19:50:16.989365 | 
> IZXVQ    |          |             | 01:00:00         | 
> (3 rows)
> 
> > If that does return something, then, well, I must have made a mistake in
> > pam_decaf, but I wouldn’t know what :-(

That’s strange. I thought that it would only print „no valid timecode“
if that select would return no result. At the moment I have no idea what
went wrong. Does it happen with every valid timecode?

Greetings,
Joachim