Hi, I'm using Freeradius 1.1.6 with PostgreSQL 8.1. When I try to do #radtest joao senhasecreta 127.0.0.1:1812 0 testing123
Te radiusd (in debug mode) returns: #rad_recv: Access-Request packet from host 127.0.0.1:32779, id=220, length=56 # User-Name = "joao" # User-Password = "senhasecreta" # NAS-IP-Address = 255.255.255.255 # NAS-Port = 0 # Processing the authorize section of radiusd.conf #modcall: entering group authorize for request 0 # modcall[authorize]: module "preprocess" returns ok for request 0 # rlm_realm: No '@' in User-Name = "joao", looking up realm NULL # rlm_realm: No such realm "NULL" # modcall[authorize]: module "suffix" returns noop for request 0 #radius_xlat: 'joao' #rlm_sql (sql): sql_set_user escaped user --> 'joao' #radius_xlat: 'SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'joao' ??ORDER BY id' #rlm_sql (sql): Reserving sql socket id: 4 #rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'joao' ? ORDER BY id #rlm_sql_postgresql: Status: PGRES_FATAL_ERROR #rlm_sql_postgresql: affected rows = #rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning SQL_DOWN #rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4 #rlm_sql (sql): Connected new DB handle, #4 #rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE Username = 'joao' ??ORDER BY id #rlm_sql_postgresql: Status: PGRES_FATAL_ERROR #rlm_sql_postgresql: affected rows = #rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, 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: 4 # modcall[authorize]: module "sql" returns fail for request 0 #modcall: leaving group authorize (returns fail) for request 0 #Finished request 0 When I saw the "??" int the queries i changed te query in postgresql.conf putting al the query on the same line (deleting the "/")... but it doesn't work. I'm new on using freeradius, I don't know what I can do. Thank you.. Daniel Bojczuk - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html