Re: Dialup Admin

2004-10-26 Thread apellido jr., wilfredo p.
Try to create a user and include in those group. - Original Message - From: Edward Rempala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:56 AM Subject: Dialup Admin I am having a problem creating groups under dialupadmin. When I create a group and then save

Re: Freeradius and dialup_admin

2004-09-04 Thread apellido jr., wilfredo p.
check httpd.conf if php3 support is added AddType application/x-httpd-php .php3 then check httpd-error.log - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius and dialup_admin

2004-09-03 Thread apellido jr., wilfredo p.
maybe this will help ... ? phpinfo() ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius and dialup_admin

2004-09-03 Thread apellido jr., wilfredo p.
php.ini, but I really dont know what I am looking for in there. I dont see any configuration parameter that makes reference to mysql, so I dont know whether that means it is enabled or not. regards Herbert. apellido jr., wilfredo p. wrote: maybe this will help ... ? phpinfo() ? - List

Re: Old postgresl query config

2004-08-09 Thread apellido jr., wilfredo p.
Is their any difference if i will use the latest postgresql.conf eventhough im freeradius-1.0.0-pre3? thanks ... - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: working sample config of radiusd.conf using rlm_counter

2004-08-08 Thread apellido jr., wilfredo p.
hi, #Instantiation instantiate { daily } .. #Authorize authorize { daily ** instead of counter *** sql counter } ... accounting { daily ** instead of counter *** radutmp sql }

Re: Freeradius compilation ERROR

2004-08-02 Thread apellido jr., wilfredo p.
02, 2004 4:03 PM Subject: Freeradius compilation ERROR Hello, I have same problem as apellido jr., wilfredo p with compilation of freeradius (more http://lists.cistron.nl/pipermail/freeradius-users/2004-July/033716.html ). I read previous response in archive and I maked change

Re: Simultaneous Login Problem

2004-07-27 Thread apellido jr., wilfredo p.
| := | 30 July 2004 257 | cache| Max-Monthly-Session | := | 72011 766 | cache| Simultaneous-Use| := | 1 1 | cache| User-Password | := | apellido (4 rows) But still i got this error; Tue Jul 27 23:21:22 2004 : Error: Discarding duplicate request from client

show_groups.php3

2004-07-26 Thread apellido jr., wilfredo p.
Im tried the latest dev of dialup_admin and i got this warning and it doesnt show groups. Warning: main(../lib/sql_group_info.php3): failed to open stream: No such file or directory in /usr/local/www/data-dist/dialup_admin/htdocs/show_groups.php3 on line 74Warning: main(): Failed

Re: show_groups.php3

2004-07-26 Thread apellido jr., wilfredo p.
Just update show_groups.php3, same error... Warning: main(../lib/$config[general_lib_type]/group_info.php3): failed to open stream: No such file or directory in /usr/local/www/data-dist/dialup_admin/htdocs/show_groups.php3 on line 74 Warning: main(): Failed opening

Simultaneous Login Problem

2004-07-25 Thread apellido jr., wilfredo p.
Hello, im using freeradius-1.0.0-pre3 and postgresql as database backend.I got this error when implemeting Simultaneous Use. Just reading docs( Simultaneous Use) and here's my radgroupcheck... radius=# select * from radgroupcheck;id | groupname | attribute | op |

Re: pap + md5

2004-07-23 Thread apellido jr., wilfredo p.
Hi, im also using freeradius-1.0.0-pre3 + Postgres + pap + md5 without any problem. Im using DIALUP_ADMIN to create user with md5 password. - Original Message - From: Sergei Koveshnikov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:44 PM Subject: pap + md5

Re: Is free-radius authenticates with newly added entry into users file without restart?

2004-07-21 Thread apellido jr., wilfredo p.
you, Sathish, -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of apellido jr., wilfredo p.Sent: Wednesday, July 21, 2004 3:19 PMTo: [EMAIL PROTECTED]Subject: Re: Is free-radius authenticates with newly added entry into users file

Re: Using rlm_sqlcounter to restrict dialup access.

2004-07-20 Thread apellido jr., wilfredo p.
Hello just try to change from your sqlcounter.conf config sqlmod-inst = sqlcca3 sqlmod-inst = sql or just upgrade to freeradius-1.0.0-pre3 - Original Message - From: Shannon Sariman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 21, 2004 8:34 AM Subject: Using

Re: dialup_admin ERROR

2004-07-09 Thread apellido jr., wilfredo p.
On Thu, 8 Jul 2004, apellido jr., wilfredo p. wrote: Hello Kostas, got an error after successfully patch user_finger.php3. Parse error: parse error, unexpected T_STRING in /usr/local/www/data-dist/dialup_admin/htdocs/user_finger.php3 on line 87 Something might have gone wrong in your

Re: Freeradius compilation ERROR

2004-07-09 Thread apellido jr., wilfredo p.
, July 09, 2004 6:23 PM Subject: Re: Freeradius compilation ERROR Hi Apellido, this is a known issue - here is Alan's previous response (it's in the archives too!): - The solution is to edit libltdl/Makefile, and change: top_builddir = . to: top_builddir

Re: dialup_admin ERROR

2004-07-08 Thread apellido jr., wilfredo p.
ORDER at character 16 thanks.. - Original Message - From: Kostas Kalevras [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 9:57 PM Subject: Re: dialup_admin ERROR On Tue, 6 Jul 2004, apellido jr., wilfredo p. wrote: Hello guys, got this error under Online Users

dialup_admin ERROR

2004-07-05 Thread apellido jr., wilfredo p.
Hello guys, got this error under Online Users (user_finger.php3) Jul 6 13:22:46 diameter postgres[496]: [2-1] ERROR: column radacct.acctstarttime must appear in the GROUP BY clause or be used in an aggregate function FreeRADIUS Version 1.0.0-pre3, for host , built on Jul 6 2004 at 01:54:36

ERROR freeradius compilation

2004-07-02 Thread apellido jr., wilfredo p.
Freebsd 4.10 Freeradius latest development CVS July 07, 2004 gmake[1]: Entering directory `/usr/local/radiusd/libltdl' /bin/sh ./libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -pthread -D_THREAD_SAFE -DOPENSSL _NO_KRB5 -Wall -D_GNU_SOURCE -g -Wshadow -Wpointer-arith

ERROR freeradius compilation

2004-07-02 Thread apellido jr., wilfredo p.
Just part of the error solved, i got new one after trying to change The solution is to edit libltdl/Makefile, and change: top_builddir = . to: top_builddir = ./.. here's the new one: ../../lib/.libs/libradius.so: undefined reference to `pthread_mutex_unlock' ../../lib/.libs/libradius.so:

Re: POSTGRESQL ERROR -- please help --- dialup_admin ERROR

2004-06-29 Thread apellido jr., wilfredo p.
] ERROR: syntax error at or near ORDER at character 16 - Original Message - From: apellido jr., wilfredo p. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 12:33 PM Subject: POSTGRESQL ERROR -- please help Hello guys just posting a day ago, maybe nothing notice so

POSTGRESQL ERROR -- please help

2004-06-28 Thread apellido jr., wilfredo p.
Hello guys just posting a day ago, maybe nothing notice so im post it again bout the error i've encounter running freeradius-1.0.0-pre2 . Jun 27 20:12:47 radius postgres[10318]: [2-1] ERROR: column radacct.acctstarttime must appear in the GROUP BY clause or be used in an aggregate function Now

Re: Restricting daily session limits to users using rlm_sqlcounter.

2004-06-28 Thread apellido jr., wilfredo p.
Try to change sqlmod-inst = sqlcca3 --- sqlmod-inst = sql or maybe use the new pre-release of Freeradius. - Original Message - From: Shannon Sariman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 11:21 AM Subject: Restricting daily session limits to users using

POSTGRESQL ERROR

2004-06-27 Thread apellido jr., wilfredo p.
Hello, I got this error while running Freeradius and Postgresql: Jun 27 20:12:47 radius postgres[10318]: [2-1] ERROR: column radacct.acctstarttime must appear in the GROUP BY clause or be used in an aggregate function Jun 27 20:12:47 radius postgres[10318]: [3-1] ERROR: column

Re: dialup_admin question.

2004-06-25 Thread apellido jr., wilfredo p.
under admin.conf # Default values for the various user limits in case the counter module # is used to impose such limits. # The value should be the user limit in seconds or none for nothing counter_default_daily: change for whatever daily limit you want counter_default_weekly: change for

Re: Suspending Users

2004-06-24 Thread apellido jr., wilfredo p.
that. According to the FAQ, that is only suppose to be used if Freeradius is set up to use the flat user file, if i'm correct. In my case, i'm using the MySql setup. -- Original Message -- From: apellido jr., wilfredo p. [EMAIL PROTECTED] Reply-To: [EMAIL

Re: Suspending Users

2004-06-23 Thread apellido jr., wilfredo p.
If your reading Freeradius FAQ, probabbly you wereoverlook of using Type-Auth := Reject.Which simply rejecting the user instead of changing user/s password. - Original Message - From: Linda Pagillo To: [EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 10:39 PM

freeradius

2004-06-22 Thread apellido jr., wilfredo p.
Currently im running freeradius as authentication server usingpostgresql as database backend, which authenticating user base on their monthly usage (prepaid). Now im trying to create user which only can authenticate withintimespan period e.g from6 am-10 pmand this can simply done by adding

dialup_admin add new user error

2004-06-19 Thread apellido jr., wilfredo p.
Hello guys i got this error using dialup_admin in postgresql but before im using mysql and its workin. im just edited radius.conf sql_type: pgsql_server: localhostsql_port: 5432sql_command: /usr/local/bin/psql Unable to add user test: ERROR: duplicate key violates unique constraint

dialup_admin/sql using postgresql

2004-06-17 Thread apellido jr., wilfredo p.
mysql -h mysql.host.com -u username -p radius badusers.sql this is for MYSQL. what about POSTGRESQL? i tried this cat mtotacct.sql | psql radius and i got this : ERROR: syntax error at or near "(" at character 44 thanks

rlm_sqlcounter query parameter

2004-06-16 Thread apellido jr., wilfredo p.
Hello it is possible to define the query parameter in sqlcounter.conf? %k = %b = I just want to specify the date where the AcctSessionTime will be compute(SUM).

Re: radius log

2004-06-15 Thread apellido jr., wilfredo p.
Jun 13 23:36:40 2004 : Auth: Login OK: [apellido] (from client = portmaster.mactan.ph port 0) Sun Jun 13 23:38:05 2004 : Auth: Login incorrect: [gunday/molendijk] = (from client portmaster.mactan.ph port 13) Sun Jun 13 23:38:40 2004 : Auth: Login OK: [gunday] (from client = portmaster.mactan.ph

Re: Re: rlm_sqlcounter Max-Daily-Session??

2004-06-14 Thread apellido
hi, are you referring in sqlcounter dailycounter in sqlcounter.conf? Do u want to configure the daily counter? it doesnt hurt you if you cannot find it, what will hurt you is there is wrong using it as an attribute. As well as i know, we have to include a dictionary.XXX file in

radius log

2004-06-14 Thread apellido jr., wilfredo p.
to disconnect then stop message appear also. But when i tried to run freeradius and tail radius.log, Only Auth: Login OK message appear and not Disconnect or Stop. Sun Jun 13 23:36:40 2004 : Auth: Login OK: [apellido] (from client portmaster.mactan.ph port 0)Sun Jun 13 23:38:05 2004 : Auth

dialup_admin online user problem

2004-06-13 Thread apellido
/default.vals #general_ld_library_path: /usr/local/snmpd/lib general_finger_type: #general_nas_type: cisco #general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger #general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient general_test_account_login: apellido general_test_account_password

certs.sh

2004-06-10 Thread apellido
how do i adjust certs.sh to run in freebsd? since openssl is already installed and i dont have a /usr/local/ssl directory. ive just edited certs.sh openssl location from /bin/openssl to /usr/bin/openssl and SSL=/usr/local/ssl to SSL=/usr/src/crypto/openssl/ssl but no luck. thanks. - List

Re: dialup_admin

2004-06-04 Thread apellido
thanks kostas :) i will look for user_state.php3 as reference. On Thu, 3 Jun 2004, apellido jr., wilfredo p. wrote: Hello is their any plan to include in dialup_admin, a feature which the USER can check his/her account, edit his/her information and change password authenticated via

accounting backup

2004-05-22 Thread apellido jr., wilfredo p
Just reading docs/configurable_failover, at the example # Handle accounting packets accounting { detail# always log to detail, stopping if it fails redundant { sql1# try module sql1 sql2# if that's down, try

Segmentation fault (core dumped)

2004-05-21 Thread apellido jr., wilfredo p
Hello guys, just a follow up report. I still got Segmentation fault (core dumped) errror after running Freeradius with rlm_sql (mysql) module. Here's the output when running in debugging mode: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting

Re: May 19 CVS snaphot --- Segmentation fault (core dumped) --- core dump output

2004-05-19 Thread apellido
(gdb) bt #0 0x28398a35 in sql_init_socket (sqlsocket=0x809e640, config=0x80a2300) at sql_mysql.c:71 #1 0x2834bdee in connect_single_socket (sqlsocket=0x809e640, inst=0x809e580) at sql.c:70 #2 0x2834bf4f in sql_init_socketpool (inst=0x809e580) at sql.c:130 #3 0x2834a84a in

Re: May 19 CVS snaphot --- Segmentation fault (core dumped) --- core dump output

2004-05-19 Thread apellido
On Wed, 19 May 2004 [EMAIL PROTECTED] wrote: hell guys, im trying to install Freeradius using May 19 CVS snapshot and strangely i got this error when running in debugging mode: Thu May 20 02:04:34 2004 : Debug: sql: group_membership_query = SELECT GroupName FROM usergroup WHERE

Re: core dump output

2004-05-19 Thread apellido
Hello Paul, i just edited sql_mysql.c and added what you suggested. like this: mysql_sock = sqlsocket-conn; radlog(L_DBG, rlm_sql_mysql: *mysql_sock: %d, rlm_sql_mysql_sock: %d, sizeof(*mysql_sock), sizeof(rlm_sql_mysql_sock)); memset(mysql_sock, 0, sizeof(*mysql_sock)); radlog(L_INFO,

Re: core dump output

2004-05-19 Thread apellido
Sorry, heres the debug output: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: *mysql_sock: 556,

Re: setting up accounting in mysql

2004-04-27 Thread apellido
Hello milver, i already test what you said. example for user X has a session time of 10 hrs (43200 secs). After 1 month he/she update his/her account then what i did add another 10 hrs, which will 43200 + 43200 = session timeout. but as i said we have a client with constant username, adding 10

Re: setting up accounting in mysql

2004-04-27 Thread apellido
Actually im using dialup admin for user account management, thanks very much for reply, i really appreciate it. I have another idea what else if i have 2 database which update user accounting realtime, it is possible? i would create 2 sql.conf in radius.conf. but i dont know what will be the

Re: setting up accounting in mysql

2004-04-26 Thread apellido
Hello milver, what i mean is in noresetcounter configuration in rlm_sqlcounter. Where resetcounter add all accounting of the user and compare to session timeout. My problem is i have a client with constant username. example: user X have a connection of 10 hrs starting from date, April 26 which

Re: setting up accounting in mysql

2004-04-23 Thread apellido
Hello Milver, Do u have any idea how to update the user account? example im setup prepaid internet access using freeradius. im include rlm_sqlcounter in the config and it works perfectly. Now my problem is because im configured rlm_sqlcounter for noresetcounter it works when

Re: sqlcounter: count=0 ?????

2004-03-22 Thread apellido
!!! apellido dijo: To to change the following : Try to change the following in your sqlcounter dailycounter and montlycounter. sqlmod-inst = sqlcca3 sqlmod-inst = sql - Original Message - From: Juan Pablo Fava [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday

Re: sqlcounter: count=0 ?????

2004-03-21 Thread apellido
: Re: sqlcounter: count=0 ? Here it is. Thanks! apellido dijo: can we take a look at your sqlcounter.conf? - Original Message - From: Juan Pablo Fava [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 20, 2004 10:12 AM Subject: sqlcounter: count=0

Re: sqlcounter: count=0 ?????

2004-03-19 Thread apellido
can we take a look at your sqlcounter.conf? - Original Message - From: Juan Pablo Fava [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 20, 2004 10:12 AM Subject: sqlcounter: count=0 ? Hi, the problem is that my instalation of sqlcounter doesn`t work, i think

accounting to mysql database

2004-03-14 Thread apellido
hello does anyone have example config of what Mr. Allan Dekok Suggestion? Have two accounting databases: One used by your RADIUS server fordaily/weekly/monthly accounting for "live" sessions, and another formulti-year backups. Alan DeKok. Thanks very much

Re: Session-Timeout and Cisco

2004-03-04 Thread apellido
Hello, your NAS is the one who responsible to disconnect the user. Try to check your NAS. - Original Message - From: Truong Manh Cuong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 04, 2004 4:17 PM Subject: RE: Session-Timeout and Cisco Hi, I've try to use

Account Interim

2004-02-20 Thread apellido
how do i enable account interim? what i should include in sql.conf query?

Account Interim

2004-02-20 Thread apellido
how do i enable account interim? what i should include in sql.conf query?

Re: Account Interim

2004-02-20 Thread apellido
-Interim-Interval | := | 2 | 0 |++---+---++-+--+ and i got this reply when i try to test using radtest Sending Access-Request of id 68 to 127.0.0.1:1645 User-Name = "apellido" User-Password = "apellido&

Accounting Directory

2004-02-19 Thread apellido jr., wilfredo p
tables. = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools - List info/subscribe/unsubscribe? See

rlm_python

2004-02-16 Thread apellido jr., wilfredo p
./config.status creating Makefile = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311 __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html - List info/subscribe

rlm_ippool error

2004-02-13 Thread apellido jr., wilfredo p
] Error 1 gmake[2]: Leaving directory `/usr/local/radiusd/src' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/usr/local/radiusd/src' gmake: *** [common] Error 1 *** Error code 2 = wilfredo pahilanga apellido jr. technical support mactan online bacolod city, philippines +63 34 4348311

Free Access Time

2004-01-09 Thread apellido jr., wilfredo p
. Any idea? what are the best solution for this? thanks ... = 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!? Yahoo! Hotjobs: Enter