Freeradius 0.5 + mysql stop to authenticate
Hi to all... I use freeradius 0.5 with mysql 3.23.39 on slackware 8.0. The problem now is happened 2 times. After 10-15 days of work the radius server stop to authenticate requests tha it have to handle directly with mysql, while it continue perfectly to authenticate request that are proxied to another server. I have a infinite list of Login Incorrect in my log and only Login OK for proxied requests. I tried to kill -1 the main radius process and the problem persist. I had to kill -9 the main radius process and restart it manually. There was 12 radius processes at that time. This is some logs. Mon Jul 29 10:44:18 2002 : Auth: Login incorrect: [seff/] (from nas as53001 port 20025) Mon Jul 29 10:44:19 2002 : Auth: Login incorrect: [emanuele/] (from nas main port 10116 cli 035x) Mon Jul 29 10:44:19 2002 : Auth: Login incorrect: [valligran/xxx] (from nas main port 10126 cli 035x) Mon Jul 29 10:44:20 2002 : Auth: Login OK: [pg.23@pg] (from nas main port 10131 cli 0363x) Mon Jul 29 10:44:20 2002 : Auth: Login incorrect: [grcsrl/] (from nas as53001 port 20028 cli 035x) Mon Jul 29 10:44:23 2002 : Auth: Login incorrect: [leidi/] (from nas main port 10122 cli 035) Mon Jul 29 10:44:24 2002 : Auth: Login incorrect: [emanuele/] (from nas main port 10109 cli 035x) Mon Jul 29 10:44:25 2002 : Info: Sending duplicate authentication reply to client main:63431 - ID: 243 Mon Jul 29 10:44:25 2002 : Info: Sending duplicate authentication reply to client main:63431 - ID: 244 Mon Jul 29 10:44:27 2002 : Auth: Login incorrect: [valligran/xxx] (from nas main port 10115 cli 035xx) Mon Jul 29 10:44:27 2002 : Info: Sending duplicate authentication reply to client main:63431 - ID: 245 Have you any suggestion? There is a way to have logged all the debug output of radius -xxyy to a file instead of stdout? So i can try to leave for 15 days it on with the debug and after i can see what he is doing? Thank you bye, MArcello - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: COMPARE module
Hi, I need it.. I need a way to let a user to login, with his user & password, only from 1 telephone line ( for a flat service). And if it is possible that after 2 hours of contiguous connection he is kicked out and can't reconnect for 10 minutes. Is it possible?? Thank you, Bye Marcello 3APA3A wrote: > > Dear [EMAIL PROTECTED], > > I wrote simple module which can perform authentication by comparing > attribute in NAS request with some attribute from configure or reply > list. For example it may be used to authenticate user without password > if > >Calling-Station-Id > > in request matches > >Callback-Number > > configured in reply list. > > It can also be used to authenticate user if some attribute is present > in either request or configured items or reply attributes (for example > to authenticate user without password if Calling-Station-Id presents > in request). > > The question is: > > does somebody else need it? :) > > -- > http://www.security.nnov.ru > /\_/\ > { , . } |\ > +--oQQo->{ ^ }<-+ \ > | ZARAZA U 3APA3A } > +-o66o--+ / > |/ > You know my name - look up my number (The Beatles) > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql
Hi, look at the doc/RADIUS-SQL.schema. Bye MArcello fernando velasco wrote: > > Hi > > I´m newbie and my question may sounds stupid, but I > don´t find howto create users database > > I must run some script? > > thanks for your patience > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin FATAL error in apache repost
*** Kostas Kalevras wrote: > > On Wed, 3 Jul 2002, Marcello Lupo wrote: > > > HI to all ... > > i repost this message becouse i very need help. > > > > > > I have installed the dialup_admin package on freeradius 0.5, apache > > 1.3.26 and php > > 4.2.1. > > WHen i try to get some user information and the query return some > > results, i get this error on apache-php logs > > > > FATAL: emalloc(): Unable to allocate 1087359016 bytes > > [Mon Jul 1 09:47:26 2002] [notice] child pid 16608 exit signal > > Segmentation fault (11) > > > > > > If for example i query the database for a user that doesn't exist the > > problem don't occur. I only get the error message user does not exist. > > If the user exist i get the error. > > > > Other than i have always this kind of notice in the logs: > > > > [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined > > constant sql_date_format - assumed 'sql_date_format' in > > /usr/local/dialup_admin/htdocs/user_admin.php3 on line 60 > > /usr/local/dialup_admin/htdocs/user_admin.php3(60) : Notice - Use of > > undefined constant sql_date_format - assumed 'sql_date_format' > > [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined > > constant sql_date_format - assumed 'sql_date_format' in > > /usr/local/dialup_admin/htdocs/user_admin.php3 on line 64 > > /usr/local/dialup_admin/htdocs/user_admin.php3(64) : Notice - Use of > > undefined constant sql_date_format - assumed 'sql_date_format' > > > > Any ideas?? > > Thank you > > MArcello > > > > - > > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > Are you using an ldap database or sql? > When you access the other pages (accounting,online users,create user) what do > you get? > Did you create the user through the create user page or manually? > Could you post your admin.conf and a user entry that triggers the problem? > > -- > Kostas Kalevras Network Operations Center > [EMAIL PROTECTED] National Technical University of Athens, Greece > Work Phone: +30 10 7721861 > 'Go back to the shadow' Gandalf > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin FATAL error in apache repost
HI to all ... i repost this message becouse i very need help. I have installed the dialup_admin package on freeradius 0.5, apache 1.3.26 and php 4.2.1. WHen i try to get some user information and the query return some results, i get this error on apache-php logs FATAL: emalloc(): Unable to allocate 1087359016 bytes [Mon Jul 1 09:47:26 2002] [notice] child pid 16608 exit signal Segmentation fault (11) If for example i query the database for a user that doesn't exist the problem don't occur. I only get the error message user does not exist. If the user exist i get the error. Other than i have always this kind of notice in the logs: [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 60 /usr/local/dialup_admin/htdocs/user_admin.php3(60) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 64 /usr/local/dialup_admin/htdocs/user_admin.php3(64) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' Any ideas?? Thank you MArcello - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup_admin and apache Fatal error and segmentation fault
Hi to all, I have installed the dialup_admin package on apache 1.3.20 and php 4.2.1. WHen i try to get some user information and the query return some results, i get thi error on apache-php FATAL: emalloc(): Unable to allocate 1087359016 bytes [Mon Jul 1 09:47:26 2002] [notice] child pid 16608 exit signal Segmentation fault (11) If for example i query the database for a user that doesn't exist the problem don't occur. I only get the error message user does not exist. If the user exist i get the error. Other than i have always this kind of notice in the logs: [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 60 /usr/local/dialup_admin/htdocs/user_admin.php3(60) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 64 /usr/local/dialup_admin/htdocs/user_admin.php3(64) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 64 /usr/local/dialup_admin/htdocs/user_admin.php3(64) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 72 /usr/local/dialup_admin/htdocs/user_admin.php3(72) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 72 /usr/local/dialup_admin/htdocs/user_admin.php3(72) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 72 /usr/local/dialup_admin/htdocs/user_admin.php3(72) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 72 /usr/local/dialup_admin/htdocs/user_admin.php3(72) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Use of undefined constant sql_date_format - assumed 'sql_date_format' in /usr/local/dialup_admin/htdocs/user_admin.php3 on line 72 /usr/local/dialup_admin/htdocs/user_admin.php3(72) : Notice - Use of undefined constant sql_date_format - assumed 'sql_date_format' [Mon Jul 1 09:47:25 2002] [error] PHP Notice: Undefined variable: str in /usr/local/dialup_admin/lib/functions.php3 on line 22 /usr/local/dialup_admin/lib/functions.php3(22) : Notice - Undefined variable: str I think this is not a major problem was only for information. Thank you in advice for help. Bye, Marcello - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Solaris 8 and rlm_sql_mysql library link problem
Ho to all, I'm tyying to installa freeradius 0.5 on a Sun Solaris 5.8. I had some problem while compiling the mysql module due to fact i was using the binary release of mysql, it don't find the libmysqlclient. After i get the source distribution of mysql, compiled and installed the rlm_sql_mysql module compile fine and was installed in /usr/local/lib . But the system is giving me this error (the same as before): rlm_sql: Could not link driver rlm_sql_mysql: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[4]: sql: Module instantiation failed. this time the file il present but the system don't see it. I think may be a problem of the LD_LIBRARY_PATH that on SOlaris (i read) is not supported and there is not a ldconfig tool. So have you any idea to let Solaris see that libraries? Thank you in Advice. MArcello - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html