dialup_admin,user expired
Hi all, I want to create a user account that has time login expired = 10 hours. How to do this ? Thanks and Regards, *** Truong M?nh Cu?ng Engineer of R&D - ERD Research & Development Division - RDD Mobile: 84-90-8392986 Work Phone: 84-08-9321001 - 664 Email[EMAIL PROTECTED] EIS Service, Inc. http://www.globaleis.com Saigon Software Park, 2nd Floor. 123 Truong Dinh St., Dist. 3, HCM City, Vietnam. Tel 84-8-932 1001 Fax 84-8-932 1002 *** - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dial_up admin
/conf/admin.conf - Original Message - From: "Eka Anjas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 12:30 PM Subject: dial_up admin > How to configure dial_up admin > > > - > 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 and user password change ?
No problem, dialup_admin web page has a module for this. You can rewrite this file (change_passwd.php3) and run it on apache server. then user can connect to change passwd online. If you don't know how to do, I can write a sample for you when I have free time Manh Cuong - Original Message - From: "Zoup" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 16, 2003 4:39 AM Subject: dialup_admin and user password change ? > > Is there any way to make a webpage so users can change they password online ? > > -- > Wish You Were Here ... > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
prepaid account
Hi all, How can I create a prepaid account? that user will have an amount of time, for example 1 month, or 14 hours to access. Thank you . ***Trương Mạnh CườngEngineer of R&D - ERDResearch & Development Division - RDDMobile: 84-90-8392986Work Phone: 84-08-9321001 - 664 Email [EMAIL PROTECTED] EIS Service, Inc.http://www.globaleis.com Saigon Software Park, 2nd Floor.123 Truong Dinh St., Dist. 3, HCM City, Vietnam.Tel 84-8-932 1001 Fax 84-8-932 1002***
dialup_admin :: case sensitive
Hi all,
I'm using postgresql and dialup_admin for
freeradius 0.9
with dialup_admin, if I let it in orginal source
code, it does not work correct. because case-sensitive. I must try to convert to
lower_case and it work well.
Because when I import radius tables, it is in
lowercase and postgres work well with free-radius. SOme problems will accour
when I try to create tables that has fields in uppercase , such as: "Username",
"AcctStartTime" instead of "username", "acctstoptime"
so that in dialup_admin, I have to let all field in
row[] in lowercase:
$link = @da_sql_pconnect($config);if
($link){
$search =
@da_sql_query($link,$config,
"SELECT * FROM $config[sql_badusers_table]
WHERE UserName
$usercheck AND
Date <= '$now_str'
AND Date >=
'$prev_str'
ORDER BY Date ASC $limit;");
if ($search){
while( $row = @da_sql_fetch_array($search,$config) ){
$num++;
$user =
"$row[username]";
$date =
"$row[date]";
$reason =
"$row[reason]";
$admin =
"$row[admin]";
if ($admin == '')
$admin =
'-';
if ($reason == '')
$reason =
'-';
echo <<
$num
$user
$date
$admin
$reason
EOM;
}
}
This code segment is work OK.
Any suggestion for me?
Thank you for all who are developing dialup_admin
and free-radius.
I had to rewrite dialup_admin because if I
extracted the source code and lease it in orginal, it can't work well because
case sensitive, and in the old version, I added to it some new features, but I
didn't post to list. I'm sory because I don't think it would usefull for
another.
I found that in new version, free-radius and
dialup_admin are added some new features that I did in my old version. I
think I will send my own new update version to mailling list.
Thanks and best Regards,
***Trương
Mạnh CườngEngineer of R&D - ERDResearch & Development Division - RDDMobile:
84-90-8392986Work Phone: 84-08-9321001 - 664 Email [EMAIL PROTECTED]
EIS Service, Inc.http://www.globaleis.com Saigon Software Park, 2nd
Floor.123 Truong Dinh St., Dist. 3, HCM City, Vietnam.Tel 84-8-932 1001 Fax 84-8-932
1002***
dialup_admin - postgresql
Hi all, I use PostgresSQL and I have problem with database: freeradius dies when user connects to server so I must change radacct::AcctStart/StopTime : datetime -> TIMESTAMP with time zone in Dialup_admin::user_finger.php3 SELECT ... WHERE AcctStopTime = '0' And error report: query-error. AcctStopTime is NULL in database, not = 0. I don't know how to correct it. So at page online user page, I can't show online user with SELECT ... WHERE AcctStopTime = '0' Please help me. Thanks and Regards *** Truong M?nh Cu?ng System Engineer - SE Research & Development Division - RDD Mobile: 84-90-8392986 Work Phone: 84-08-9321001 - 664 Email[EMAIL PROTECTED] EIS Service, Inc. http://www.globaleis.com Saigon Software Park, 2nd Floor. 123 Truong Dinh St., Dist. 3, HCM City, Vietnam. Tel 84-8-932 1001 Fax 84-8-932 1002 *** - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup_admin - user_finger.php3
This is an error when I use user_finger.php3: $search = @da_sql_query($link,$config, "SELECT UserName,AcctStartTime,FramedIPAddress,CallingStationId FROM radacct WHERE AcctStopTime IS NOT NULL AND NASIPAddress = '$name_data' $extra GROUP BY username ORDER BY AcctStartTime;") or die(da_sql_error($link,$config)); Error: ERROR: Attribute radacct.acctstarttime must be GROUPed or used in an aggregate function Could someone help me? Thanks ***Trương Mạnh CườngEngineer of R&D - ERDResearch & Development Division - RDDMobile: 84-90-8392986Work Phone: 84-08-9321001 - 664 Email [EMAIL PROTECTED] EIS Service, Inc.http://www.globaleis.com Saigon Software Park, 2nd Floor.123 Truong Dinh St., Dist. 3, HCM City, Vietnam.Tel 84-8-932 1001 Fax 84-8-932 1002***
how to stop radius
how to stop radiusd ? I often use "kill -9 1234", 1234 is pid is there another way ? Thanks alot. ***Trương Mạnh CườngSystem Engineer - SEResearch & Development Division - RDDMobile: 84-90-8392986Work Phone: 84-08-9321001 - 664 Email [EMAIL PROTECTED] EIS Service, Inc.http://www.globaleis.com Saigon Software Park, 2nd Floor.123 Truong Dinh St., Dist. 3, HCM City, Vietnam.Tel 84-8-932 1001 Fax 84-8-932 1002***
cannot send stop request
Dear all,
I'm using NTRadPing
I send "accounting Start" request, it's
ok.
then I send "accounting Stop" request, it
fail:
modcall: group preacct returns noopmodcall:
entering group accountingrlm_acct_unique: WARNING: Attribute NAS-Port-Id was
not found in request, unique ID MAY be inconsistentrlm_acct_unique: Hashing
',Client-IP-Address = 172.16.66.68,NAS-IP-Address = 172.16.66.68,Acct-Session-Id
= "1608",User-Name = "tmcuong"'rlm_acct_unique: Acct-Unique-Session-ID =
"ae4cb6976fb4d60f". modcall[accounting]: module "acct_unique" returns
okradius_xlat:
'/usr/local/var/log/radius/radacct/172.16.66.68/detail-20030807'rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to
/usr/local/var/log/radius/radacct/172.16.66.68/detail-20030807
modcall[accounting]: module "detail" returns ok modcall[accounting]:
module "unix" returns noopradius_xlat: 'tmcuong'rlm_sql (sql):
sql_set_user escaped user --> 'tmcuong'radius_xlat: 'UPDATE radacct
??SET AcctStopTime = (now() - '0'::interval),AcctSessionTime = '',
??AcctInputOctets = (('0'::bigint << 32) + '0'::bigint),
??AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint),
??AcctTerminateCause = '', 'radius_xlat:
'/usr/local/var/log/radius/sqltrace.sql'rlm_sql (sql): Reserving sql socket
id: 3rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime = (now() -
'0'::interval),AcctSessionTime = '', ??AcctInputOctets = (('0'::bigint <<
32) + '0'::bigint), ??AcctOutputOctets = (('0'::bigint << 32) +
'0'::bigint), ??AcctTerminateCause = '',rlm_sql_postgresql: Status:
PGRES_FATAL_ERRORrlm_sql_postgresql: affected rows =rlm_sql_postgresql:
Postgresql check_error: PGRES_FATAL_ERROR, returning SQL_DOWNrlm_sql (sql):
Attempting to connect rlm_sql_postgresql #3rlm_sql (sql): Connected new DB
handle, #3rlm_sql_postgresql: query: UPDATE radacct ??SET AcctStopTime =
(now() - '0'::interval),AcctSessionTime = '', ??AcctInputOctets = (('0'::bigint
<< 32) + '0'::bigint), ??AcctOutputOctets = (('0'::bigint << 32) +
'0'::bigint), ??AcctTerminateCause = '',rlm_sql_postgresql: Status:
PGRES_FATAL_ERRORrlm_sql_postgresql: affected rows =rlm_sql_postgresql:
Postgresql check_error: PGRES_FATAL_ERROR, returning SQL_DOWNrlm_sql (sql):
failed after re-connectrlm_sql (sql): Couldn't update SQL accounting STOP
record - ERROR: parser: parse error at or near ""rlm_sql (sql):
Released sql socket id: 3 modcall[accounting]: module "sql" returns
failmodcall: group accounting returns failFinished request
6
***Trương
Mạnh CườngSystem Engineer - SEResearch & Development Division - RDDMobile:
84-90-8392986Work Phone: 84-08-9321001 - 664 Email [EMAIL PROTECTED]
EIS Service, Inc.http://www.globaleis.com Saigon Software Park, 2nd
Floor.123 Truong Dinh St., Dist. 3, HCM City, Vietnam.Tel 84-8-932 1001 Fax 84-8-932
1002***
Re: postgresql - dialup-admin
I try to create table in dialup_admin/sql
directory, and it come to fail.
ERROR: parser: parse error at or near
"("and dialup_admin will not work with database fields in lower
case. because of query sentence like this:
SELECT UserName,AcctStopTime
... FROM..WHERE UserName ..
and the result of that query sentence will
differ to SELECT username,acctstoptime ... FROM..WHERE username
..
If all database is in lower case, I must change all
code (PHP file) in dialup_admin. do you understand ?
Thanks for your support.
Manh Cuong.
- Original Message -
From: "Peter Nixon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 07, 2003 4:39
PM
Subject: Re: postgresql -
dialup-admin
> On Thu August 7 2003 12:29, Truong Manh Cuong wrote:> > I
wonder is there anyone use postgresql for freeradius? there is so many>
> thing I have to fix if I want to use postgres.> > But freeradius
staffs do not fix it. or may be I do wrong ?> > Tell us and we
will either fix the problems or explain to you why we did it > that way
:-)> > > is there any type like this:> > CREATE TABLE
badusers (> > id int(10) DEFAULT '0' NOT NULL auto_increment,>
> ...> > "Date" timestamp
with timezone DEFAULT '-00-00 00:00:00' NOT> > NULL,>
> ... );> > What do you wish this table to do? There is no such
table in MySQL either, so > I think you are mistaken if you believe this
is a Postgres "problem".> > We can add such a table if there is a
reason and the general public will find > it useful. Please
explain..> > > and with postgresql_db.sql, every fields must
have " " when they are> > declared, but I don't see, so as the result,
my db will have tables with> > all fields in lowercase> >
Here is my sql file that fixed.(file attact)> > What is wrong with
that? Lower case field names are much better all round. Why > would you
want case sensitive field names??> > -- > > Peter
Nixon> http://www.peternixon.net/> PGP
Key: http://www.peternixon.net/public.asc> > > - > List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
postgresql - dialup-admin
I wonder is there anyone use postgresql for freeradius? there is so many thing I have to fix if I want to use postgres. But freeradius staffs do not fix it. or may be I do wrong ? is there any type like this: CREATE TABLE badusers ( id int(10) DEFAULT '0' NOT NULL auto_increment, ... "Date"timestamp with timezone DEFAULT '-00-00 00:00:00' NOT NULL, ... ); and with postgresql_db.sql, every fields must have " " when they are declared, but I don't see, so as the result, my db will have tables with all fields in lowercase Here is my sql file that fixed.(file attact) *** Truong M?nh Cu?ng System Engineer - SE Research & Development Division - RDD Mobile: 84-90-8392986 Work Phone: 84-08-9321001 - 664 Email[EMAIL PROTECTED] EIS Service, Inc. http://www.globaleis.com Saigon Software Park, 2nd Floor. 123 Truong Dinh St., Dist. 3, HCM City, Vietnam. Tel 84-8-932 1001 Fax 84-8-932 1002 *** EIS-radius.sql Description: Binary data
uninstall freeradius
Hi all, How to uninstall freeradius ? I compiled it to a Redhat Linux box. Now I want to install new version of freeradius (0.9) Thank you. *** Truong M?nh Cu?ng System Engineer - SE Research & Development Division - RDD Mobile: 84-90-8392986 Work Phone: 84-08-9321001 - 664 Email[EMAIL PROTECTED] EIS Service, Inc. http://www.globaleis.com Saigon Software Park, 2nd Floor. 123 Truong Dinh St., Dist. 3, HCM City, Vietnam. Tel 84-8-932 1001 Fax 84-8-932 1002 *** - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
new version of radius
Hi all, I want to install new version of freeRadius. How to uninstall old version ? Thanks and Regards ***Trương Mạnh CườngSystem Engineer - SEResearch & Development Division - RDDMobile: 84-90-8392986Work Phone: 84-08-9321001 - 664 Email [EMAIL PROTECTED] EIS Service, Inc.http://www.globaleis.com Saigon Software Park, 2nd Floor.123 Truong Dinh St., Dist. 3, HCM City, Vietnam.Tel 84-8-932 1001 Fax 84-8-932 1002***
Re: dialup_admin
sorry, rename *.php3 -> *.php > global_register Off -> On > rename *.php3 -> php4, you don'n need to change files in /conf, /lib..., > just all files in /dialup_admin directory. > open all file *.php to edit and modify the name having in any line code that > you renamed. for example, /html/buttons/default/buttons.php3 > href="accounting.php3" -> href="accounting.php > > My English is still bad, do you understand what I mean ? > > If you don't want to rename php3 -> php, you need to modify /etc/php.ini so > that httpd can accept php3, I don't remember which option, you can search in > mailling list because this question was asked by me and there is a person > replyed to help me. thanks him. > > Manh Cuong. > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup_admin
IE is independent to script language (PHP,ASP,JSP) because these language is server side based language. httpd will read php file, see if there is any line code is PHP script, it will interpret to html format (tag) and send to web browser client. hope that will help you. Manh Cuong. - Original Message - From: "Alex Chen" <[EMAIL PROTECTED]> To: "FreeRADIUS Users (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, July 24, 2003 2:14 PM Subject: dialup_admin > This question is not directly related to RADIUS, but > a utility 'dialup_admin' that ships with FreeRadius. > > I tried to use dialup_admin in Linux, but the browser (Microsoft IE) > did not show the page correctly. > > I copied the dialup_admin directory to /var/www/html/dialup_admin > Which I type the following URL in the browser, I got an dialup_admin > image on the right and some text bearing > According to the FAQ in dialup_admin, the php needs to be configured to > handle files with php3 suffix. I have changed the > directive in /etc/httpd/conf.d/php.conf to > > from > > to > > > and restarted the httpd daemon. It still did not work. > > I would appreciate any help from someone who has successfully used > dialup_admin > from IE. > > Thanks. > > > - > 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
I use dialup_admin and then, I must rewrite all the code of PHP files, to fix my need. But I know your problem, and I know why and how to correct it. you should open /etc/php.ini and change global_register Off -> On rename *.php3 -> php4, you don'n need to change files in /conf, /lib..., just all files in /dialup_admin directory. open all file *.php to edit and modify the name having in any line code that you renamed. for example, /html/buttons/default/buttons.php3 href="accounting.php3" -> href="accounting.php My English is still bad, do you understand what I mean ? If you don't want to rename php3 -> php, you need to modify /etc/php.ini so that httpd can accept php3, I don't remember which option, you can search in mailling list because this question was asked by me and there is a person replyed to help me. thanks him. Manh Cuong. - Original Message - From: "Alex Chen" <[EMAIL PROTECTED]> To: "FreeRADIUS Users (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, July 24, 2003 2:14 PM Subject: dialup_admin > This question is not directly related to RADIUS, but > a utility 'dialup_admin' that ships with FreeRadius. > > I tried to use dialup_admin in Linux, but the browser (Microsoft IE) > did not show the page correctly. > > I copied the dialup_admin directory to /var/www/html/dialup_admin > Which I type the following URL in the browser, I got an dialup_admin > image on the right and some text bearing > According to the FAQ in dialup_admin, the php needs to be configured to > handle files with php3 suffix. I have changed the > directive in /etc/httpd/conf.d/php.conf to > > from > > to > > > and restarted the httpd daemon. It still did not work. > > I would appreciate any help from someone who has successfully used > dialup_admin > from IE. > > Thanks. > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
new group in "dialup-admin
May I ask a question about dialup-admin:
This is some code line of group-new
if ($attr_type["$key"] ==
'checkItem'){
$table = "$config[sql_groupcheck_table]";
$type = 1;
}
else if ($attr_type["$key"] == 'replyItem'){
$table = "$config[sql_groupreply_table]";
$type = 2;
}
When dies $attr_type[$key] is set value checkItem or replyItem ? in which
file? I try to find, but couldn't see how the $table is set name == groupcheck
or groupreply.
Anytime I add new group, it is always added in radgroupreply, not in
radgroupcheck. why ?
dialup-admin question
I use dialup-admin and this is my questions: -- I open the radcheck table: user's password is raw, not encript. so anyone that can access to postgresql database then he or she can see password. in PHP code of user_new.php3, I see password encript procedure, how to use this procedure ? -- Why I need "bad users" table? -- If I use radgroupcheck and use groups in this table for usergroup, and I don't use "radgroupreply" table, what happens ? I mean that I drop radgroupreply table. Thanks in advance. Manh Cuong.
radgroupreply, radreply
what is the defferent of radgroupcheck, radgroupreply? radcheck and radreply?
Re: postgres error
This is a flault that I met when I began to use with postgresql. so , have fun: AcctStartTime timestamptz, AcctStopTime timestamptz,--> AcctStartTime timestamp without time zone AcctStopTime timestamp without time zone Cheers! Manh Cuong. - Original Message - From: Salvin Kumar To: [EMAIL PROTECTED] Sent: Friday, July 11, 2003 7:50 AM Subject: postgres error When I am trying to start the radius server and do accounting ith postgres I get some errors when the values are being inserted: ERROR: "Bad numeric input format ''LOG: connection received: host=localhost.is.com.fj[127.0.0.1] port=1121LOG: connection authorized: user=postgres database=radiusERROR: "Bad numeric input format '' and this is how my radacct table looks: RadAcctId SERIAL, AcctSessionId VARCHAR(32) DEFAULT '' NOT NULL, AcctUniqueId VARCHAR(32) DEFAULT '' NOT NULL, UserName VARCHAR(32) DEFAULT '' NOT NULL, Realm VARCHAR(30) DEFAULT '', NASIPAddress VARCHAR(15) DEFAULT '' NOT NULL, NASPortId NUMERIC(12), NASPortType VARCHAR(32), AcctStartTime timestamptz, AcctStopTime timestamptz, AcctSessionTime NUMERIC(12), AcctAuthentic VARCHAR(32), ConnectInfo_start VARCHAR(32), ConnectInfo_stop VARCHAR(32), AcctInputOctets NUMERIC(12), AcctOutputOctets NUMERIC(12), CalledStationId VARCHAR(10) DEFAULT '' NOT NULL, CallingStationId VARCHAR(10) DEFAULT '' NOT NULL, AcctTerminateCause VARCHAR(32) DEFAULT '' NOT NULL, ServiceType VARCHAR(32), FramedProtocol VARCHAR(32), FramedIPAddress VARCHAR(15) DEFAULT '' NOT NULL, AcctStartDelay NUMERIC(12), AcctStopDelay NUMERIC(12), PRIMARY KEY (RadAcctId));
stored procedure
I have to change to postgresql because I want to update amount of money into database each time user logout. I use trigger and stored procedure. How can I do it with mySQL ? how to rebuild radius that it can deal with another database server? for example, my customer want to use MS SQL server instead of postgresSQL or Oracle. Thank you. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mySQL + radius
Can I ask a question : How can I update to mySQL database automatically a table that store money that users must charge for the sections their connection? does mySQL have trigger or function that I can write function inside mySQL ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
PHP
it seems not to work with php3. I change *.php3 to
*.php, it work.
this is small code of accounting.php3
help me to correct this problem
if(!$queryflag)
{
echo <<
$val)
echo <<$val
EOM;
echo <<
$val)
if ($val ==
'UserName')
echo <<
$val) echo << Order by: EOM; foreach($items as $key
=> $val) if ($val == 'UserName') echo << Max
results returned:
Selection criteria:
--Attribute-- EOM; foreach($items as $key =>
$val) print("$val");
echo <get("w$number"); ${"w$designator"}->show();
$number++; } } if($add==1) { ${"w$number"} = new
Qi("w$number","$item_name","$operators[0]"); ${"w$number"}->show(); }
echo <<
EOM; }
?>
