SQL failover test
Hello! I've setup two SQL servers for 'failover' feature testing, my config looks like this: accounting { acct_unique detail group { sql_my { fail = 1 notfound = 2 noop = return ok = return updated = return reject = return userlock = return invalid = return handled = return } sql_ms { fail = 1 notfound = 2 noop = return ok = return updated = return reject = return userlock = return invalid = return handled = return } } unix radutmp sradutmp } When I manually shutdown first SQL, it works fine, but when I simulating complete server crash, by dropping all packets to SQL by firewall, sql module seems to be stuck forever in waiting state. Maybe I just configure something wrong? Any ideas would be fine. And just noticed some feature/bug: rlm_sql_mysql: MYSQL check_error: 2002 received rlm_sql (sql_my): Couldn't update SQL accounting for START packet - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) radius_xlat: '' rlm_sql (sql_my): Released sql socket id: 0 modcall[accounting]: module sql_my returns ok modcall: group group returns ok Why it returns 'ok' ? -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRadius with Oracle = crash
Hello I'm trying to setup FreeRadius working with remote Oracle Database from the command line - sqlplus - all fine, I can do select, insert, etc RH Linux 7.2, Local Oracle is 8.1.7, Remote is 8.0.5 FreeRadius dump a core with following output #0 0x40592bd8 in kpcxk2u () from /usr/local/lib/libclntsh.so.8.0 (gdb) where #0 0x40592bd8 in kpcxk2u () from /usr/local/lib/libclntsh.so.8.0 #1 0x405adb92 in ttccfpg () from /usr/local/lib/libclntsh.so.8.0 #2 0x405ad229 in ttcfour () from /usr/local/lib/libclntsh.so.8.0 #3 0x403cc096 in kpufCopyPrefRows () from /usr/local/lib/libclntsh.so.8.0 #4 0x403cc57e in kpufch0 () from /usr/local/lib/libclntsh.so.8.0 #5 0x403cd611 in kpufch () from /usr/local/lib/libclntsh.so.8.0 #6 0x40373582 in OCIStmtFetch () from /usr/local/lib/libclntsh.so.8.0 #7 0x4024e673 in sql_fetch_row (sqlsocket=0x8107890, config=0x80bdad8) at sql_oracle.c:365 #8 0x40249b98 in sql_getvpdata (inst=0x80bc618, sqlsocket=0x8107890, pair=0x40a2fb68, query=0x40a2fd7c SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'test' ORDER BY id, mode=1) at sql.c:303 #9 0x40248dd9 in rlm_sql_authorize (instance=0x80bc618, request=0x8132f60) at rlm_sql.c:284 #10 0x080550e9 in call_modsingle (component=1, sp=0x80bc4c8, request=0x8132f60, default_result=6) at modcall.c:205 #11 0x08055232 in modcall (component=1, c=0x80bc4c8, request=0x8132f60) at modcall.c:288 #12 0x08055133 in call_modgroup (component=1, g=0x80b8a80, request=0x8132f60, default_result=6) at modcall.c:227 #13 0x080551f9 in modcall (component=1, c=0x80b8a80, request=0x8132f60) at modcall.c:281 #14 0x08054d27 in module_authorize (autz_type=0, request=0x8132f60) at modules.c:633 #15 0x08051c70 in rad_authenticate (request=0x8132f60) at auth.c:518 #16 0x0804d8ac in rad_respond (request=0x8132f60, fun=0x8051b08 rad_authenticate) at radiusd.c:1526 #17 0x08056bb0 in request_handler_thread (arg=0x8130de0) at threads.c:172 #18 0x4004dc6f in pthread_start_thread (arg=0x40a31be0) at manager.c:284 Any help would be fine -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
duplicate accounting requests
Hello! I have NAS Ascend MAX and it seems to ignore replys for accounting requests from freeradius and continue to send the same STOP accounting requests, DB is MySQL. How I can fix it? I know about FAQ 4.8, but my NAS has one IP and freeradius already bind to IP on the same network. -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: SQL modules aren't allowed ...
AD Michael Vasilenko [EMAIL PROTECTED] wrote: AD Module: Instantiated sql (sql) AD radiusd.conf: SQL modules aren't allowed in 'authenticate' sections -- AD they have no such method. AD AD What is that means? AD AD Remove 'sql' from 'authenticate'? Then what about DEFAULT Auth-Type := SQL in 'users' How can I set default auth to SQL in this case? AD Alan DeKok. -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
SQL modules aren't allowed ...
Hello On fresh CVS I 've got rlm_sql: Driver rlm_sql_mysql loaded and linked rlm_sql: Attempting to connect to radius@localhost:/radius rlm_sql: Connected new DB handle, #0 rlm_sql: Connected new DB handle, #1 rlm_sql: Connected new DB handle, #2 rlm_sql: Connected new DB handle, #3 rlm_sql: Connected new DB handle, #4 Module: Instantiated sql (sql) radiusdconf: SQL modules aren't allowed in 'authenticate' sections -- they have no such method What is that means? -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://wwwfreeradiusorg/list/usershtml
SQL accounting_stop complex query
Hello I need setup complex accounting_stop_query to decrease time/money ammount for user. Any advice, working example will be good. Thanks -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: SQL accounting_stop complex query
On Sun, 24 Feb 2002, Michael Vasilenko wrote: MV Hello MV MV I need setup complex accounting_stop_query to decrease time/money ammount MV for user. Any advice, working example will be good. MV MV Thanks And one more quesion - can I execute more then one query on, for example, Accounting Stop packet? I've tried to patch rlm_sql.c, but got only segfault, any help would be great. -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRADIUS with MS SQL
On Sun, 10 Feb 2002, Alan DeKok wrote: AD Michael Vasilenko [EMAIL PROTECTED] wrote: AD I need to setup RADIUS wich works with MS SQL, can somebody give me an AD advice? Does FreeRADIUS can do this? ODBC or something? AD AD ODBC should work in the latest CVS snapshot. in latest CVS snapshot make is just broken: Making static in rlm_sql_unixodbc... gmake[9]: Entering directory `/usr/local/src/freeradius/radiusd/src/modules/rlm_sql/drivers/rlm_sql_unixodbc' gmake[9]: *** No rule to make target `static'. Stop. gmake[9]: Leaving directory `/usr/local/src/freeradius/radiusd/src/modules/rlm_sql/drivers/rlm_sql_unixodbc' gmake[8]: *** [common] Error 1 radius:/usr/local/src/freeradius/radiusd/src/modules/rlm_sql/drivers/rlm_sql_unixodbc# ./configure loading cache ./config.cache checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for sql.h... yes checking for SQLConnect in -lodbc... yes updating cache ./config.cache creating ./config.status creating Makefile sed: ./Makefile.in: No such file or directory AD Alan DeKok. -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeRADIUS with MS SQL
Hello I need to setup RADIUS wich works with MS SQL, can somebody give me an advice? Does FreeRADIUS can do this? ODBC or something? Thanks -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeRADIUS with MS SQL
On Sun, 10 Feb 2002, Alan DeKok wrote: AD Michael Vasilenko [EMAIL PROTECTED] wrote: AD I need to setup RADIUS wich works with MS SQL, can somebody give me an AD advice? Does FreeRADIUS can do this? ODBC or something? AD AD ODBC should work in the latest CVS snapshot. in latest CVS snapshot make is just broken: Making static in rlm_sql_unixodbc... gmake[9]: Entering directory `/usr/local/src/freeradius/radiusd/src/modules/rlm_sql/drivers/rlm_sql_unixodbc' gmake[9]: *** No rule to make target `static'. Stop. gmake[9]: Leaving directory `/usr/local/src/freeradius/radiusd/src/modules/rlm_sql/drivers/rlm_sql_unixodbc' gmake[8]: *** [common] Error 1 radius:/usr/local/src/freeradius/radiusd/src/modules/rlm_sql/drivers/rlm_sql_unixodbc# ./configure loading cache ./config.cache checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for sql.h... yes checking for SQLConnect in -lodbc... yes updating cache ./config.cache creating ./config.status creating Makefile sed: ./Makefile.in: No such file or directory AD Alan DeKok. -- Michael Vasilenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html