FreeRadius with MySQL

2003-12-10 Thread apellido jr., wilfredo p
Leandro, See to it you included sql in authorization and accounting. Another helpful information ... http://www.frontios.com/freeradius.html = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm i

dialup_admin (cvs last 12-04-2003)

2003-12-05 Thread apellido jr., wilfredo p
hello guys, NAS doesnt show in User's Online Information. = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? New Yahoo! Photos - e

CHAP authentication

2003-11-18 Thread apellido jr., wilfredo p
hello here's debug output and the error, thanks mysql> select * from radgroupcheck; ++---+--+++ | id | GroupName | Attribute| op | Value | ++---+--+++ | 1 | admin | Auth-Type| ==

CHAP authentication

2003-11-16 Thread apellido jr., wilfredo p
Good day Mr. Dekok, sorry if im asking stupid question. Im just asking so that i can sure that chap authentication doesnt work and maybe someone could give some comment. Hoping maybe i miss something. I test it already before asking this in mailing list and it doesnt work. = wilfredo pahilang

CHAP authentication

2003-11-15 Thread apellido jr., wilfredo p
Good day Mr. Dekok, sorry what i mean is im using mysql to store user's information and pap authentication to authenticatite them. what im asking is if i can use chap? = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear

CHAP authentication

2003-11-15 Thread apellido jr., wilfredo p
can i use chap authentication in rlm_sql? = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? Protect your identity with Yahoo! Mail

dialup_admin

2003-11-14 Thread apellido jr., wilfredo p
Good day Mr. Kalevras, as your suggestion im tried to create a script to perform manual reset in GDBM database(db.monthly). I want to synchronize the update of GDBM database and MySQL. My question is after sucessfully reseting user's counter in GDBM database then how can i update user's status in d

failed login (log_badlogins script)

2003-11-14 Thread apellido jr., wilfredo p
dialup_admin failed login doesnt show any report -- sql debug - # login time server terminate cause callerid DEBUG(SQL,MYSQL DRIVER): Query: SELECT AcctStopTime,UserName,NASIPAddress,NASPortId,AcctTerminateC

dialup_admin statistic report?

2003-11-13 Thread apellido jr., wilfredo p
Good day, why isnt it User Statistic and Statistic Report doesnt show anthing? = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!?

dialup_admin statistic report ?

2003-11-13 Thread apellido jr., wilfredo p
Good day, = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.y

Sql Counter ?

2003-11-12 Thread apellido jr., wilfredo p
try to run radiusd in debugging mode ... it will show the next reset ... in your case this will be reset @ first day of december. = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 If you can't hear me, it's because i'm in parentheses.

rlm_counter question

2003-10-29 Thread apellido jr., wilfredo p
Hello Mr. Kalevras, i already look @ rad_counter.pl and i understand the flow of this script. It open the database as READONLY, print the information where u can specify the db filename, user, how the counter will be shown, second (default), minutes, hours and match. My problem is i dont have any h

rlm_counter question

2003-10-28 Thread apellido jr., wilfredo p
hello , after searching for any documents and tutorial regarding GDBM and perl got no luck. i want to write a script that would reset the counter in GDBM database using perl. Anyone know documentation or maybe tutorial, books... thanks very much = wilfredo pahilanga apellido jr. technical sup

SQLcounter unwanted Session-Reply ( from development mailing list )

2003-10-23 Thread apellido jr., wilfredo p
Navid, here's my email address: [EMAIL PROTECTED] thanks. I been trying ot test from 0.9.0 to 0.9.2 and latest CVS but no luck. Reading your post in development mailing list answered my question regarding rlm_sqlcounter and rlm_counter, difference between them. = wilfredo pahilanga apellido j

SQLcounter unwanted Session-Reply ( from development mailing list )

2003-10-23 Thread apellido jr., wilfredo p
Good day, im surfing in development mailing list and one of the list posted there is SQLcounter unwanted Session-Reply. It seems it is related to sqlcounter count-attribute. Any development for this? thanks ... = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, phi

dialup_admin latest cvsup

2003-10-22 Thread apellido jr., wilfredo p
Good day Mr. Kalevras. statistics, user's statistics and online users doesnt show anything in latest dialup_admin cvsup. here's my config - admin.conf - # # Main Configuration File # # it can be defa

dialup_admin latest cvsup

2003-10-21 Thread apellido jr., wilfredo p
I tried the latest cvsup of dialup_admin and there's a new feature in user's information, the open session however the online user command is not working, then i switch to dialup_admin which included in freeradiu-0.9.0 package and it is working as i expected. what is the file to be update in dialup

rlm_counter and rlm_sqlcounter

2003-10-19 Thread apellido jr., wilfredo p
7; AND AcctStartTime > FROM_UNIXTIME('%b')" sqlcounter: reset = "3m" rlm_sqlcounter: Counter attribute Monthly-Session-Time is number 1081 rlm_sqlcounter: Check attribute Max-Monthly-Session is number 1082 rlm_sqlcounter: num=1, last=m rlm_sqlcounter: Current Time: 1

rlm_counter costume reset

2003-10-17 Thread apellido jr., wilfredo p
-10-01 00:00:00] Module: Instantiated sqlcounter (monthlycounter) why isnt it the next reset still first day of the month eventhough it is set for 3 month? = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __

rad_counter.pl error

2003-10-16 Thread apellido jr., wilfredo p
seting the counter attribute. what im missing here? what other dependencies should i install to run this script? thanks ... = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!

Help on FreBSD

2003-10-16 Thread apellido jr., wilfredo p
try to install gmake using port: cd /usr/port/dev/gmake make install clean = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved prod

rlm_counter question

2003-10-15 Thread apellido jr., wilfredo p
without waiting for an hour, day , week or month ? Thanks = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://sho

rlm_sqlcounter

2003-10-12 Thread apellido jr., wilfredo p
and again and again, disconnecting every 10 hours. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shoppin

Login-Time Problem Freeradius-0.9.1

2003-10-11 Thread apellido jr., wilfredo p
documentation in web but unfortunately im still hanging looking for anything. Do u have any Suggestion ? thanks very much = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!

Login-Time Problem Freeradius-0.9.1

2003-10-10 Thread apellido jr., wilfredo p
ctober 2003 | | 13 | cache| Expiration | == | 31 October 2003 | | 15 | cache| Login-Time | := | 2300-2400 | ++--+-++-+ 10 rows in set (0.03 sec) ===== [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't he

dialup_admin

2003-10-09 Thread apellido jr., wilfredo p
in which include in freeradius-0.9.0 package. Thanks = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.

rlm_sqlcounter ( Monthly Limit)

2003-10-09 Thread apellido jr., wilfredo p
e]: module "monthlycounter" returns noop i just added sqlcounter.conf in /etc/raddb and added monthlycounter in radius.conf under authorization. The user can authenticate but the Login-Time doesnt work. They can still Login eventhough they are not in the time span. What im missing here? thanks

FreeBSD 4.8 FreeRadius-0.9.1 and MySQL 4.0.15 sucessfully compiled

2003-10-08 Thread apellido jr., wilfredo p
hello, good day guys i just wanna share for those who got error (gethostbyname_r) in compiling Freebsd 4.8, FreeRadius-0.9.1 and Mysql with rlm_sqlcounter. Try to update the entire port your FreeBSD 4.8. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's b

dialup_admin

2003-10-06 Thread apellido jr., wilfredo p
Thanks you, thank you, thank you, thank you very much Mr. Kalevras. :) it works after overwrite the origal user_admin.php3. hehehehe im very happy maybe i can replace our buggy and slow radius server after a few week of testing. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can&#

dialup_admin

2003-10-06 Thread apellido jr., wilfredo p
type anoncvs, nothing happens. Just came back to root. im using freebsd4.8 = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved prod

dialup_admin

2003-10-06 Thread apellido jr., wilfredo p
Thank you very much Mr. Kalevras, maybe it work after updating the user_admin.php3 but my BIG problem now is to how to use CVS? :( but anyway thank you very much. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm

dialup_admin

2003-10-06 Thread apellido jr., wilfredo p
have no monthly,weekly,daily limit, no user login period, no expiration date. The Problem bout in displaying the Monthly Limit is solve, same with the statistic report. Once again here's my dialup_admin: http://203.177.22.190 . thanks ===== [ apellido jr., wilfredo p. ] +63 034 4880-449 I

dialup_admin

2003-10-05 Thread apellido jr., wilfredo p
ius 0.9.0 distribution. Thanks thanks thanks once again. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping

dialup_admin

2003-10-03 Thread apellido jr., wilfredo p
kItem Max-Monthly-Session Max-Monthly-Session What im missing here? Feel free to see the website http://203.177.22.190 thanks ... ===== [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. ___

dialup_admin

2003-10-02 Thread apellido jr., wilfredo p
on is unlimited. Any suggestion, comment is highly appreciated. ===== [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http:

rlm_sqlcounter cannot compile in FreeBSD 4.8

2003-08-26 Thread apellido jr., wilfredo p
e 123: Need an operator "../rules.mak", line 129: Need an operator make: fatal errors encountered -- cannot continue = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm in parentheses. __ Do you Yaho

cannot compile with --with-experimental-modules in freebsd 4.8

2003-08-21 Thread apellido jr., wilfredo p
stall: http://203.177.22.150:8080/make-install.txt Sir i want to test the another option, what Mr. Paul Hampson said. how to add rlm_sqlcounter? Thank you very much ===== [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i&#

cannot compile with --with-experimental-modules in freebsd 4.8

2003-08-21 Thread apellido jr., wilfredo p
20/src' gmake[1]: Leaving directory `/usr/local/freeradius-snapshot-20030820/src' *** Error code 2 Stop in /usr/local/freeradius-snapshot-20030820. anyone can suggest, please .... thanks = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't

users configuration using mysql

2003-08-19 Thread apellido jr., wilfredo p
hello, good day, i just want to know what is the users configuration if im using mysql as user information (database).i want to use chap as authentication. = [ apellido jr., wilfredo p. ] +63 034 4880-449 If you can't hear me, it's because i'm

Freeradius FAQ (14.3)

2003-08-17 Thread apellido jr., wilfredo p
[apellido/apellido] (from client localhost port 0) Sending Access-Accept of id 243 to 127.0.0.1:1052 Framed-Compression = Van-Jacobson-TCP-IP Framed-Protocol = PPP Service-Type = Framed-User Framed-MTU = 1500 Finished request 1 Going to the next request Thread 2

Authentication problem

2003-08-16 Thread apellido jr., wilfredo p
177.22.191.router: RIPv1-resp [items 13]: {dialup-009.mactan.ph}(1) {dialup-011.mactan.ph}(1)[|rip] 10:59:24.326142 portmaster.mactan.ph.router > 203.177.22.191.router: RIPv1-resp [items 13]: {dialup-009.mactan.ph}(1) {dialup-011.mactan.ph}(1)[|rip] = [ apellido jr., wi

(no subject)

2003-08-16 Thread apellido jr., wilfredo p
juha, The NAS dont even send any auth request to radius server. When i run radiusd -xxyz -l stdout the Log doesnt show even some problem or what just saying ready to process. Do i need to put some Auth-Type in my users file? what is it? Thanks = [ apellido jr., wilfredo p. ] +63

Authentication problem

2003-08-16 Thread apellido jr., wilfredo p
{NAS-Port-Type}', '0', '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}

whats wrong with my configuration?

2003-08-16 Thread apellido jr., wilfredo p
{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', &