You need to determine why you are tring to insert a duplicate key. My wild guess from looking at your log is that you shut the system down and then restarted it, and when you restart, it is trying to reinsert records that already exist. Relational databases will not allow that on tables with a primary key or columns defined as 'unique'.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of leaobicalho > Sent: Wednesday, February 19, 2003 12:52 PM > To: [EMAIL PROTECTED] > Subject: Help-ME...radcheck: Permission denied > > > Always when im check, show this > message, How can i do for work? > Above have logs of postmaster, radiusd > and radclient > > Log of postmaster > --------------------- > DEBUG: database system was shut down > at 2003-02-19 15:33:25 BRT > DEBUG: checkpoint record is at 0/19D420 > DEBUG: redo record is at 0/19D420; > undo record is at 0/0; shutdown TRUE > DEBUG: next transaction id: 875; next > oid: 16633 > DEBUG: database system is ready > ERROR: pg_atoi: error in "fredf": > can't parse "fredf" > ERROR: Cannot insert a duplicate key > into unique index usergroup_pkey > DEBUG: pq_recvbuf: unexpected EOF on > client connection > ERROR: radcheck: Permission denied. > ERROR: radcheck: Permission denied. > ERROR: radcheck: Permission denied. > ERROR: radcheck: Permission denied. > ---------------------------- > > Log of Radius Server > ---------------------------- > lm_sql (sql): Attempting to connect > rlm_sql_postgresql #0 > rlm_sql (sql): Connected new DB handle, #0 > rlm_sql_postgresql: query: SELECT > id,UserName,Attribute,Value,Op FROM > radcheck WHERE Username = 'fredf' > ORDER BY id > rlm_sql_postgresql: Status: > PGRES_FATAL_ERROR > rlm_sql_postgresql: affected rows = > rlm_sql_postgresql: Postgresql > check_error: s, returning SQL_DOWN > rlm_sql (sql): failed after re-connect > rlm_sql_getvpdata: database query error > rlm_sql (sql): SQL query error; > rejecting user > rlm_sql (sql): Released sql socket id: 0 > rad_recv: Access-Request packet from > host 200.253.21.202:32792, id=97, > length=57 > Dropping packet from client Leao:32792 > - ID: 97 due to dead request 2 > ---------------------------- > > > Log of Radius Client > ---------------------------- > [root@dev1 radius]# radclient -q -s > 127.0.0.1 auth test123 > user-name=test > radclient: no response from server > ---------------------------- > > > > __________________________________________________________________________ > E-mail Premium BOL > Antiv�rus, anti-spam e at� 100 MB de espa�o. Assine j�! > http://email.bol.com.br/ > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
