Re: Dialup Admin with PostgreSQL and NetSNMP support
I sent the tarball to Peter Nixon. Since I changed all the filename extensions from .php3 to .php, a patch would be twice as large, unless I did some trickery. I'll look into it. Kostas Kalevras wrote: On Fri, 28 Nov 2003, Guy Fraser wrote: Hmm... The updated version of dialup admin I sent in didn't seem to show up on the list. The attachment was 70kB, I presume thats why. Where should I send this updated source, so it can be tested, and put into the main source? I 'd rather prefer a patch to the current CVS version rather than the whole thing. Either put it on a web page somewhere, or send it to me directly. Though i don't use postgresql -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin with PostgreSQL and NetSNMP support
http://www.peternixon.net/tmp/dialupadmin-pg-netsnmp.tar.bz I have not yet had time to look at it. Cheers Peter On Monday 01 December 2003 18:00, Guy Fraser wrote: I sent the tarball to Peter Nixon. Since I changed all the filename extensions from .php3 to .php, a patch would be twice as large, unless I did some trickery. I'll look into it. Kostas Kalevras wrote: On Fri, 28 Nov 2003, Guy Fraser wrote: Hmm... The updated version of dialup admin I sent in didn't seem to show up on the list. The attachment was 70kB, I presume thats why. Where should I send this updated source, so it can be tested, and put into the main source? I 'd rather prefer a patch to the current CVS version rather than the whole thing. Either put it on a web page somewhere, or send it to me directly. Though i don't use postgresql -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED]National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- 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
Re: Dialup Admin with PostgreSQL and NetSNMP support
Guy Fraser wrote: Hmm... The updated version of dialup admin I sent in didn't seem to show up on the list. The attachment was 70kB, I presume thats why. Where should I send this updated source, so it can be tested, and put into the main source? Mail it to me directly.. Peter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin with PostgreSQL and NetSNMP support
On Fri, 28 Nov 2003, Guy Fraser wrote: Hmm... The updated version of dialup admin I sent in didn't seem to show up on the list. The attachment was 70kB, I presume thats why. Where should I send this updated source, so it can be tested, and put into the main source? I 'd rather prefer a patch to the current CVS version rather than the whole thing. Either put it on a web page somewhere, or send it to me directly. Though i don't use postgresql -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin with PostgreSQL and NetSNMP support
Hmm... The updated version of dialup admin I sent in didn't seem to show up on the list. The attachment was 70kB, I presume thats why. Where should I send this updated source, so it can be tested, and put into the main source? -- Guy Fraser Network Administrator The Internet Centre 780-450-6787 , 1-888-450-6787 There is a fine line between genius and lunacy, fear not, walk the line with pride. Not all things will end up as you wanted, but you will certainly discover things the meek and timid will miss out on. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin / new help-pages
On Thu, 30 Oct 2003, Ulrich Walcher wrote: HI, I have done some additions to user_edit.attrs and some help pages... They're all on http://www.walcher.co.at/fr/ Added, thanks a lot Greets, Uli -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup-admin / new help-pages
HI, I have done some additions to user_edit.attrs and some help pages... They're all on http://www.walcher.co.at/fr/ Greets, Uli - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin
Am Die, 2003-10-28 um 17.59 schrieb Bruno Gianelli Braido: Hello all, I'd like to use the Dialup_Admin, I tried use the example from http://kstadler.ch/index.php?topgroupid=1subgroupid=14groupid=11 but not success. Who knows where I get a good example??? My equipament is a PM3, Freeradius with Auth Mysql. Thanks for your help. [...] Do you have FR with MySQL working? No success is not very precise. Give us a little more details and maybe someone con help you. Uli - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin
Am Mit, 2003-10-29 um 12.57 schrieb Bruno Gianelli Braido: Thanks for your help Uli, So my FR is working with Mysql, my problem is configure the Dialup Admin, I used the help come with DialupAdmin but not work. Where I get a example to configure the Dialup Admin [...] Most important is to have php working properly. apache with php4: http://www.php.net/manual/en/install.apache.php All attributes are well explained in conf/admin.conf There you might have to change: general_base_dir: /usr/local/dialup_admin general_radiusd_base_dir: /usr/local/radiusd general_test_account_login: test general_test_account_password: testpass general_radius_server: localhost [IP-Address_of_RADIUS_server] general_radius_server_auth_proto: pap general_encryption_method: crypt sql_server: localhost [IP-Address_of_sql_server] sql_username: dialup_admin sql_database: radius sql_accounting_table: radacct sql_badusers_table: badusers sql_check_table: radcheck sql_reply_table: radreply sql_user_info_table: userinfo sql_groupcheck_table: radgroupcheck sql_groupreply_table: radgroupreply sql_usergroup_table: usergroup sql_total_accounting_table: totacct You'll have to change: general_radius_server_secret: XX sql_password: XX The rest should work by default. Little more information on what's not working is helpful. Otherwise the answer will be be: You misconfigured something... Uli - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin
Hello all, I'd like to use the "Dialup_Admin", I tried use the example from http://kstadler.ch/index.php?topgroupid=1subgroupid=14groupid=11 but not success. Who knows where I get a good example??? My equipament is a PM3, Freeradius with Auth Mysql. Thanks for your help. - Oi pra todos Eu gostaria de utilizar o "Dialup_Admin",eu tentei usar o exemplo http://kstadler.ch/index.php?topgroupid=1subgroupid=14groupid=11mas não tive sucesso. Alguém sabe ondeeuconseguiria um bom exemplo? Meuequipamento é um PM3, Freeradius comAutenticação Mysql. Obrigado pelo sua ajuda. [],Bruno Gianelli BraidoLinux User# 32000ICQ:71059588[EMAIL PROTECTED]
Issue regarding radius logs dialup admin
Greetings,
I have just replaced my old radius server with FreeRadius dialup
admin. The authorization works perfectly and everyone can log in but
however I cant see any statistics about the persons that are logged in.
The Statistics page of the dialup admin returns the correct number of
session but no information regarding the total usage time and the
downloads. The Failed logins page is working as it should. The
accounting page only returns information about failed logins while the
page for each user does not return any statistics apart the failed
connection attempts. (For example It returns that the user has never
logged in even though he is currently online) Same for User Statistics
that return nothing.
The radius.conf contains the following:
prefix = /usr/local
exec_prefix = ${prefix}
sysconfdir = /etc
localstatedir = /var
sbindir = ${exec_prefix}/sbin
logdir = ${localstatedir}/log/radius
raddbdir = ${sysconfdir}/raddb
radacctdir = ${logdir}/radacct
confdir = ${raddbdir}
run_dir = ${localstatedir}/run/radiusd
log_file = ${logdir}/radius.log
libdir = ${exec_prefix}/lib
pidfile = ${run_dir}/radiusd.pid
user = radius
group = radius
max_request_time = 30
delete_blocked_requests = no
cleanup_delay = 5
max_requests = 1024
bind_address = *
port = 0
hostname_lookups = no
allow_core_dumps = no
regular_expressions = yes
extended_expressions= yes
log_stripped_names = no
log_auth = yes
log_auth_badpass = yes
log_auth_goodpass = yes
usercollide = no
lower_user = no
lower_pass = no
nospace_user = no
nospace_pass = no
checkrad = ${sbindir}/checkrad
security {
max_attributes = 200
reject_delay = 1
status_server = no
}
proxy_requests = yes
$INCLUDE ${confdir}/proxy.conf
$INCLUDE ${confdir}/clients.conf
snmp= yes
$INCLUDE ${confdir}/snmp.conf
thread pool {
start_servers = 5
max_servers = 32
min_spare_servers = 3
max_spare_servers = 10
max_requests_per_server = 0
}
modules {
pap {
encryption_scheme = clear
}
chap {
authtype = CHAP
}
pam {
pam_auth = radiusd
}
unix {
cache = no
cache_reload = 600
radwtmp = ${logdir}/radwtmp
}
eap {
default_eap_type = md5
timer_expire = 60
md5 {
}
leap {
}
}
mschap {
authtype = MS-CHAP
}
ldap {
server = ldap.your.domain
basedn = o=My Org,c=UA
filter = (uid=%{Stripped-User-Name:-%{User-Name}})
start_tls = no
access_attr = dialupAccess
dictionary_mapping = ${raddbdir}/ldap.attrmap
ldap_connections_number = 5
timeout = 4
timelimit = 3
net_timeout = 1
}
realm realmslash {
format = prefix
delimiter = /
}
realm suffix {
format = suffix
delimiter = @
}
realm realmpercent {
format = suffix
delimiter = %
}
preprocess {
huntgroups = ${confdir}/huntgroups
hints = ${confdir}/hints
with_ascend_hack = no
ascend_channels_per_line = 23
with_ntdomain_hack = no
with_specialix_jetstream_hack = no
with_cisco_vsa_hack = no
}
files {
usersfile = ${confdir}/users
acctusersfile = ${confdir}/acct_users
compat = no
}
detail {
detailfile =
${radacctdir}/%{Client-IP-Address}/detail-%Y%m%d
detailperm = 0600
}
detail auth_log {
detailfile =
${radacctdir}/%{Client-IP-Address}/auth-detail-Y%m%d
detailperm = 0600
}
detail reply_log {
detailfile =
${radacctdir}/%{Client-IP-Address}/reply-detail-%Y%m%d
detailperm = 0600
}
acct_unique {
key = User-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port-Id
}
$INCLUDE ${confdir}/sql.conf
radutmp {
filename = ${logdir}/radutmp
username = %{User-Name}
case_sensitive = yes
check_with_nas = yes
perm = 0600
callerid = yes
}
radutmp sradutmp {
filename = ${logdir}/sradutmp
perm = 0644
callerid = no
}
attr_filter {
attrsfile = ${confdir}/attrs
}
counter daily {
filename = ${raddbdir}/db.daily
key
Re: Dialup Admin Users File
Are there any perl scripts for use for web administration when using a plain users file? I would think it would be possible. Matt On Mon, 29 Sep 2003, Matt wrote: Is it possible to use Dialup Admin with a plain users file? If so how? No it isn't possible. Matt - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin Users File
Is it possible to use Dialup Admin with a plain users file? If so how? Matt - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin Users File
On Mon, 29 Sep 2003, Matt wrote: Is it possible to use Dialup Admin with a plain users file? If so how? No it isn't possible. Matt - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin patch
Forgot one case...
--- /usr/local/cvs/radiusd/dialup_admin/htdocs/show_groups.php3
2003-05-11 16:03
:37.0 +0200
+++ /usr/local/dialup_admin/htdocs/show_groups.php3 2003-09-16
15:17:24.
0 +0200
@@ -58,13 +58,23 @@
$link = @da_sql_pconnect($config);
if ($link){
$search = @da_sql_query($link,$config,
- SELECT COUNT(*),GroupName FROM $config[sql_usergroup_table]
GROUP BY Gr
oupName;);
+ SELECT DISTINCT s.groupname FROM $config[sql_groupcheck_table]
CROSS JO
IN (SELECT DISTINCT u.groupname FROM $config[sql_groupreply_table] CROSS
JOIN $c
onfig[sql_usergroup_table] u) as s;);
if ($search){
if (@da_sql_num_rows($search,$config)){
while( $row =
@da_sql_fetch_array($search,$config) ){
$num++;
- $group = $row[GroupName];
- $num_members = $row['COUNT(*)'];
+ $group = $row[groupname];
+ $search2 = @da_sql_query($link,$config,
+ SELECT COUNT(*) FROM
$config[sql_usergroup_tabl
e] WHERE groupname = '$group';);
+ if ($search2) {
+ if
(@da_sql_num_rows($search,$config)){
+ while( $row2 =
@da_sql_fetch_arr
ay($search2,$config) ){
+ $num_members =
$row2['co
unt'];
+ }
+ }
+ }
+ else
+ echo bDatabase query failed:
. da_s
ql_error($link,$config) . /bbr\n;
echo EOM
tr align=center
td$num/td
Am Fre, 2003-09-12 um 15.52 schrieb Ulrich Walcher:
Hi,
a little patch that solves the problem of groups with no members
assigned not being displayed. (At least it works for Postgres).
OoLee
--- /usr/local/cvs/radiusd/dialup_admin/htdocs/show_groups.php3
2003-05-11 16:03:37.0 +0200
+++ /usr/local/dialup_admin/htdocs/show_groups.php3 2003-09-12
15:45:18.0 +0200
@@ -58,13 +58,23 @@
$link = @da_sql_pconnect($config);
if ($link){
$search = @da_sql_query($link,$config,
- SELECT COUNT(*),GroupName FROM $config[sql_usergroup_table]
GROUP BY GroupName;);
+ SELECT DISTINCT c.groupname FROM $config[sql_groupcheck_table]
c CROSS JOIN $config[sql_groupreply_table] r;);
if ($search){
if (@da_sql_num_rows($search,$config)){
while( $row =
@da_sql_fetch_array($search,$config) ){
$num++;
- $group = $row[GroupName];
- $num_members = $row['COUNT(*)'];
+ $group = $row[groupname];
+ $search2 = @da_sql_query($link,$config,
+ SELECT COUNT(*) FROM
$config[sql_usergroup_table] WHERE groupname = '$group';);
+ if ($search2) {
+ if
(@da_sql_num_rows($search,$config)){
+ while( $row2 =
@da_sql_fetch_array($search2,$config) ){
+ $num_members =
$row2['count'];
+ }
+ }
+ }
+ else
+ echo bDatabase query failed:
. da_sql_error($link,$config) . /bbr\n;
echo EOM
tr align=center
td$num/td
-
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 patch2
and here also...
--- /usr/local/cvs/radiusd/dialup_admin/lib/sql/defaults.php3
2003-01-28 15:14:53.0 +0100
+++ /usr/local/dialup_admin/lib/sql/defaults.php3 2003-09-16
15:18:27.0 +0200
@@ -121,10 +121,10 @@
$link = @da_sql_pconnect($config);
if ($link){
$res = @da_sql_query($link,$config,
- SELECT DISTINCT GroupName FROM
$config[sql_usergroup_table];);
+ SELECT DISTINCT s.groupname FROM
$config[sql_groupcheck_table] CROSS JOIN (SELECT DISTINCT u.groupname
FROM $config[sql_groupreply_table] CROSS JOIN
$config[sql_usergroup_table] u) as s;);
if ($res){
while(($row =
@da_sql_fetch_array($res,$config)))
- $member_groups[] = $row[GroupName];
+ $member_groups[] = $row[groupname];
}
else
echo bDatabase query failed: .
da_sql_error($link,$config) . /bbr\n;
Am Fre, 2003-09-12 um 16.08 schrieb Ulrich Walcher:
Oops,
forgot to add this one...
OoLee
--- /usr/local/cvs/radiusd/dialup_admin/lib/sql/defaults.php3
2003-01-28 15:14:53.0 +0100
+++ /usr/local/dialup_admin/lib/sql/defaults.php3 2003-09-12
16:04:15.0 +0200
@@ -121,10 +121,10 @@
$link = @da_sql_pconnect($config);
if ($link){
$res = @da_sql_query($link,$config,
- SELECT DISTINCT GroupName FROM
$config[sql_usergroup_table];);
+ SELECT DISTINCT c.groupname FROM
$config[sql_groupcheck_table] c CROSS JOIN $config[sql_groupreply_table]
r;);
if ($res){
while(($row =
@da_sql_fetch_array($res,$config)))
- $member_groups[] = $row[GroupName];
+ $member_groups[] = $row[groupname];
}
else
echo bDatabase query failed: .
da_sql_error($link,$config) . /bbr\n;
-
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 | stats.php3
On Wed, 27 Aug 2003, Ulrich Walcher wrote: Replacing line 92/93 if ($server != 'all') $s = AND NASIPAddress = '$server'; with if ($server != '' $server != 'all') $s = AND NASIPAddress = '$server'; solves a problem when running with PostgreSQL. Database query failed: ERROR: invalid INET value '' Fixed, thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup-admin | stats.php3
Replacing line 92/93 if ($server != 'all') $s = AND NASIPAddress = '$server'; with if ($server != '' $server != 'all') $s = AND NASIPAddress = '$server'; solves a problem when running with PostgreSQL. Database query failed: ERROR: invalid INET value '' - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin | new help pages
On Wed, 20 Aug 2003, Ulrich Walcher wrote: http://www.bcore.de/data/dialup_admin.help.tar.gz Added, thanks Am Mit, 2003-08-20 um 16.17 schrieb Alan DeKok: Ulrich Walcher [EMAIL PROTECTED] wrote: I just wrote some new help pages for dialup-admin and altered user_edit.attrs. Where to should I mail the diff and the pages? Put them in a 'tar' file on a web page, and mail the URL to the list. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup-admin | new help pages
I just wrote some new help pages for dialup-admin and altered user_edit.attrs. Where to should I mail the diff and the pages? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin | new help pages
Ulrich Walcher [EMAIL PROTECTED] wrote: I just wrote some new help pages for dialup-admin and altered user_edit.attrs. Where to should I mail the diff and the pages? Put them in a 'tar' file on a web page, and mail the URL to the list. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin | new help pages
http://www.bcore.de/data/dialup_admin.help.tar.gz Am Mit, 2003-08-20 um 16.17 schrieb Alan DeKok: Ulrich Walcher [EMAIL PROTECTED] wrote: I just wrote some new help pages for dialup-admin and altered user_edit.attrs. Where to should I mail the diff and the pages? Put them in a 'tar' file on a web page, and mail the URL to the list. Alan DeKok. - 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: 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:
SELECTUserName,AcctStopTime
...FROM..WHERE UserName ..
and the result of that query sentence will
differ to SELECTusername,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, ... Datetimestamp 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
Re: postgresql - dialup-admin
On Thu August 7 2003 12:54, Truong Manh Cuong wrote: 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 .. hmm. They are sql tables for MySQL, not Postgres. I have not used dialup_admin before, but I will take a look at it. If all database is in lower case, I must change all code (PHP file) in dialup_admin. do you understand ? This should not be the case. Have you tested this? Postgres is case insensitive by default, and should work with FieldName as well as fieldname in a SQL query. Please confirm if you have actually tested this. -- 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
Re: dialup-admin question
On Mon, 14 Jul 2003, Truong Manh Cuong wrote: 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 ? In conf/admin.conf: general_encryption_method: crypt -- Why I need bad users table? It's a way to keep track of unauthorized actions performed by your users. It's only an informative 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. Probably nothing should happen. Thanks in advance. Manh Cuong. -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: new group in dialup-admin
On Mon, 14 Jul 2003, Truong Manh Cuong wrote:
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 ?
Take a look at conf/sql.attrmap
Only those attributes defined as checkItem get added in radgroupcheck
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 thatcan accessto 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.
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 ?
Re: Little problem with default.vars in Dialup Admin
On Tue, 8 Jul 2003, Nickitas wrote: On Mon, 2003-07-07 at 14:08, Kostas Kalevras wrote: On Mon, 7 Jul 2003, Nickitas wrote: Hi , I am having a little problem setting a default value in default.vals . I want the default value for Callback-Number to be lcp:callback-dialstring= . The problem is the : symbol . Since it is a seperator it ignores what follows it . Is there any way to bypass this one ? Thanx in advance . If you are using the latest dialup admin it should work just fine. It doesn't work for me :( Still having the same problem ... This works in version 1.63 of dialupadmin: cat Changelog [...] * Limit the split() to 2 elements in lib/defaults.php3 -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin
heloo, why in my dialup_admin ,section find user , edit user , new user edit group and new group still not the same with the another data i put into mysql. I think it still empty in the dialup admin, but actually ,theres a lot user in mysql data bases regards, Hilman - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Little problem with default.vars in Dialup Admin
On Mon, 2003-07-07 at 14:08, Kostas Kalevras wrote: On Mon, 7 Jul 2003, Nickitas wrote: Hi , I am having a little problem setting a default value in default.vals . I want the default value for Callback-Number to be lcp:callback-dialstring= . The problem is the : symbol . Since it is a seperator it ignores what follows it . Is there any way to bypass this one ? Thanx in advance . If you are using the latest dialup admin it should work just fine. It doesn't work for me :( Still having the same problem ... -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Little problem with default.vars in Dialup Admin
Hi , I am having a little problem setting a default value in default.vals . I want the default value for Callback-Number to be lcp:callback-dialstring= . The problem is the : symbol . Since it is a seperator it ignores what follows it . Is there any way to bypass this one ? Thanx in advance . -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Little problem with default.vars in Dialup Admin
On Mon, 7 Jul 2003, Nickitas wrote: Hi , I am having a little problem setting a default value in default.vals . I want the default value for Callback-Number to be lcp:callback-dialstring= . The problem is the : symbol . Since it is a seperator it ignores what follows it . Is there any way to bypass this one ? Thanx in advance . If you are using the latest dialup admin it should work just fine. -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Little problem with default.vars in Dialup Admin
I am using the one included in the latest freeradius (0.8-1) . Thanx :) On Mon, 2003-07-07 at 14:08, Kostas Kalevras wrote: On Mon, 7 Jul 2003, Nickitas wrote: Hi , I am having a little problem setting a default value in default.vals . I want the default value for Callback-Number to be lcp:callback-dialstring= . The problem is the : symbol . Since it is a seperator it ignores what follows it . Is there any way to bypass this one ? Thanx in advance . If you are using the latest dialup admin it should work just fine. -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius + Mysql + Dialup Admin problem
Hello everyone and sorry cause this is gonna be a little bit long , I am having a problem making Freeradius , Dialup Admin and Mysql work correctly . I am using Freeradius v 0.8.1 and mysql verion 3.23.49 in a RedHat 7.3 Linux . I had no problem setting up radius to work authenticating from users file , and from mysql using a very good tutorial from http://www.frontios.com/freeradius.html; . After I installed and start using Dialup Admin I can't get it to work. The passwords stored in mysql are encrypted in a strange way . For example using crypt encryption the password stored in the database is this :$1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 After learning a little bit about crypt and md5 encryption I can say that this doesn't look correct to me . I run the following little script for the same password and using st as salt for the encryption . perl -e 'print crypt( asd123, st),\n;' stn/LmaCw8SMU I changed a little bit the ./lib/crypt/crypt.php3 in order to give me the correct encrypted password but it still doesn't work . I use the radtest program to check the authentication . Here is the log I get when running radiusd -X : ---RadiusLog-- rad_recv: Access-Request packet from host 127.0.0.1:1033, id=211, length=56 User-Name = szax User-Password = asd123 NAS-IP-Address = 255.255.255.255 NAS-Port = 11 modcall: entering group authorize modcall[authorize]: module preprocess returns ok rlm_realm: No '@' in User-Name = szax, looking up realm NULL rlm_realm: No such realm NULL modcall[authorize]: module suffix returns noop radius_xlat: 'szax' rlm_sql (sql): sql_set_user escaped user -- 'szax' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'szax' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'szax' ORDER BY id radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql_mysql: query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'szax' ORDER BY id' rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'szax' ORDER BY id radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id rlm_sql (sql): Pairs do not match for user [szax] rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module sql returns notfound modcall: group authorize returns ok auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user auth: Failed to validate the user. Delaying request 0 for 1 seconds Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Sending Access-Reject of id 211 to 127.0.0.1:1033 Waking up in 4 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 211 with timestamp 3efaa83e Nothing to do. Sleeping until we see a request. --Radius Log- I think that the problem is in this line : rlm_sql (sql): Pairs do not match for user [szax] If however I edit the Value field in radcheck table and replace it with a plain text password it works ok . If anyone understand what is going wrong and could give me a hint , I would very much appreciate it cause I am running out of time for this project ... Thanx in advance . -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius + Mysql + Dialup Admin problem
On Thu, Jun 26, 2003 at 11:21:58AM +0300, Nickitas wrote: The passwords stored in mysql are encrypted in a strange way . For example using crypt encryption the password stored in the database is this :$1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 this is an md5 password created with glibc crypt. its ok. After learning a little bit about crypt and md5 encryption I can say that this doesn't look correct to me . I run the following little script for the same password and using st as salt for the encryption . perl -e 'print crypt( asd123, st),\n;' stn/LmaCw8SMU you are not using the seed of the abouve md5ed password. try: [10:[EMAIL PROTECTED]:radiusd perl -e 'print crypt( asd123, \$1\$JLBPzLpM),\n;' $1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 looks fine. I changed a little bit the ./lib/crypt/crypt.php3 in order to give me the correct encrypted password but it still doesn't work . man crypt gives you more hints about what crypt can do. I think that the problem is in this line : rlm_sql (sql): Pairs do not match for user [szax] What are the check pairs for this user? Auth-Type := Crypt-Local, Crypt-Password == $1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 should work as check pairs. Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius + Mysql + Dialup Admin problem
It works ok , thank you very much :) On Thu, 2003-06-26 at 11:30, Oliver Graf wrote: On Thu, Jun 26, 2003 at 11:21:58AM +0300, Nickitas wrote: The passwords stored in mysql are encrypted in a strange way . For example using crypt encryption the password stored in the database is this :$1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 this is an md5 password created with glibc crypt. its ok. After learning a little bit about crypt and md5 encryption I can say that this doesn't look correct to me . I run the following little script for the same password and using st as salt for the encryption . perl -e 'print crypt( asd123, st),\n;' stn/LmaCw8SMU you are not using the seed of the abouve md5ed password. try: [10:[EMAIL PROTECTED]:radiusd perl -e 'print crypt( asd123, \$1\$JLBPzLpM),\n;' $1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 looks fine. I changed a little bit the ./lib/crypt/crypt.php3 in order to give me the correct encrypted password but it still doesn't work . man crypt gives you more hints about what crypt can do. I think that the problem is in this line : rlm_sql (sql): Pairs do not match for user [szax] What are the check pairs for this user? Auth-Type := Crypt-Local, Crypt-Password == $1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0 should work as check pairs. Oliver. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Nickitas [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
op type in dialup-admin
I use the == as op type in my radcheck table. When I'm opening new user account through dialup-admin, it puts by default the := op type. And I need manualy correct this in MySQL. Question: How can I change default op type in dialup-admin to ==? Thanks in advance! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin
Hello, I have such problem with Dialup admin: When i run it in my browser the left frame (buttons) is stay unloaded showa the content of buttons.html.php3 file. I use php-4.3.0 apache 1.3.27 all off my other php-applications works perfectly except Dialup admin :( Have somebody any ideas about it? Thanks in advance!!! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin
Try to change file_uploads=On in the php.ini file Selon Eric [EMAIL PROTECTED]: Hello, I have such problem with Dialup admin: When i run it in my browser the left frame (buttons) is stay unloaded showa the content of buttons.html.php3 file. I use php-4.3.0 apache 1.3.27 all off my other php-applications works perfectly except Dialup admin :( Have somebody any ideas about it? Thanks in advance!!! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - This mail sent through IMP: http://horde.org/imp/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin
It is already turned to On On Saturday 01 March 2003 16:38, [EMAIL PROTECTED] wrote: Try to change file_uploads=On in the php.ini file Selon Eric [EMAIL PROTECTED]: Hello, I have such problem with Dialup admin: When i run it in my browser the left frame (buttons) is stay unloaded showa the content of buttons.html.php3 file. I use php-4.3.0 apache 1.3.27 all off my other php-applications works perfectly except Dialup admin :( Have somebody any ideas about it? Thanks in advance!!! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - This mail sent through IMP: http://horde.org/imp/ - 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
do you have any other .php3 files working? maybe you should set in your apache conf file that not only .php files should be treated as php files but also .php3 fiels On Sat, 1 Mar 2003, Eric wrote: Hello, I have such problem with Dialup admin: When i run it in my browser the left frame (buttons) is stay unloaded showa the content of buttons.html.php3 file. I use php-4.3.0 apache 1.3.27 all off my other php-applications works perfectly except Dialup admin :( Have somebody any ideas about it? Thanks in advance!!! - 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 problems
I have free radius runing but can not get the interface to work I don't get any errors but when I attempt to add a user using the interface it does not do a thing. Regards, Peter Rahnev - http://kulinar.GBG.bg - ÐÅÖÅÏÒÈ | ÏÎÄÏÐÀÂÊÈ | ÏÐÎÄÓÊÒÈ | ÃÎÒÂÀÐÑÊÈ ÒÅÕÍÈÊÈ | ÊÓËÈÍÀÐÅÍ ÊÀËÅÍÄÀÐ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin problems
I have similar problem with dialup admin, but enabling safe mode = On and variables_order = EGPCS in php.ini solve problem. Also interface didnt work with Konqueror browser. Natscape is fine . I have free radius runing but can not get the interface to work I don't get any errors but when I attempt to add a user using the interface it does not do a thing. Regards, Peter Rahnev - http://kulinar.GBG.bg - ÐÅÖÅÏÒÈ | ÏÎÄÏÐÀÂÊÈ | ÏÐÎÄÓÊÒÈ | ÃÎÒÂÀÐÑÊÈ ÒÅÕÍÈÊÈ | ÊÓËÈÍÀÐÅÍ ÊÀËÅÍÄÀÐ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Best Regards, Nachko Halachev - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup-Admin
On Tue, 7 Jan 2003, Mike Paneth wrote: Kostas wrote I have just started to use version 1.61 and I have the following questions. When I select Statistics (and select sessions, uploads and downloads, the results are all zero, even though the radacct table has entries. Do you press the Refresh button and you still don't get results? Yes, refresh does nothing Strange, do you have the right start and stop time set in the statistics page? When I select a user, how do I change the allowed session time? My users are volume based not time based. You can change the Session Timeout from the EDIT page if I understand you correctly. Edit only allows the following to be changes Protocol, Ip Address, Ip netmask, MTU, Compression used, Session timeout, Idle timeout, Port limit, Lock message Edit the user_edit.attrs file to match your needs. The session timeout only affects the per-session timeout. No daily or weekly limits can be set from here. Also the account status is all zeros. The Account Status is only for the last 7 days. Do you have sessions for that user for the last 7 days? The Accounting report generator gave the following Client IP Address Download Login Time Logout Time NAS IP Address NAS Port Session Time Upload User Name - 2.10 MBs 2003-01-06 10:40:29 2003-01-06 10:57:35 192.168.1.1 0 0 seconds 146.48 KBs fred - 0.62 MBs 2003-01-07 12:13:20 2003-01-07 12:14:55 192.168.1.100 0 0 seconds 120.56 KBs fred When I edit user fred, I get the following in the Account status for the last 7 days section Connections 0 Online time 0 seconds Failed Logins 0 Upload 0.00 KBs Download 0.00 KBs Average Time 0 seconds Average Upload 0.00 KBs Average Download 0.00 KBs That's really strange, what does the user accounting page give you? -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup-Admin
On Mon, 6 Jan 2003, Mike Paneth wrote: I have just started to use version 1.61 and I have the following questions. When I select Statistics (and select sessions, uploads and downloads, the results are all zero, even though the radacct table has entries. Do you press the Refresh button and you still don't get results? When I select a user, how do I change the allowed session time? My users are volume based not time based. You can change the Session Timeout from the EDIT page if I understand you correctly. Also the account status is all zeros. The Account Status is only for the last 7 days. Do you have sessions for that user for the last 7 days? Is it possible to convert the html to shtml so I can pass this securely over the network? use https ? Is it possible to have login security, so only valid users can access these pages? Use apache http authentication. Sorry, but I am not a programmer and don't fully understand these issues, or how to solve them. Mike Paneth Melbourne Australia -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup-Admin
Obviously you are not using FreeRadius, so you are on the wrong list. FreeRadius is currently on version .8 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike PanethSent: Monday, January 06, 2003 12:06 AMTo: [EMAIL PROTECTED]Subject: Dialup-Admin I have just started to use version 1.61 and I have the following questions. When I select "Statistics" (and select "sessions", "uploads" and "downloads", the results are all zero, even though the radacct table has entries. When I select a user, how do I change the "allowed session" time? My users are volume based not time based. Also the account status is all zeros. Is it possible to convert the html to shtml so I can pass this securely over the network? Is it possible to have login security, so only valid users can access these pages? Sorry, but I am not a programmer and don't fully understand these issues, or how to solve them. Mike Paneth Melbourne Australia
RE: Dialup-Admin
no, he is on the right list I think, freeradius version is 0.81 but dialupadmin version is about 1.61 if I am not mistaken? On Mon, 6 Jan 2003, Tim D. McCracken wrote: Obviously you are not using FreeRadius, so you are on the wrong list. FreeRadius is currently on version .8 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Paneth Sent: Monday, January 06, 2003 12:06 AM To: [EMAIL PROTECTED] Subject: Dialup-Admin I have just started to use version 1.61 and I have the following questions. When I select Statistics (and select sessions, uploads and downloads, the results are all zero, even though the radacct table has entries. When I select a user, how do I change the allowed session time? My users are volume based not time based. Also the account status is all zeros. Is it possible to convert the html to shtml so I can pass this securely over the network? Is it possible to have login security, so only valid users can access these pages? Sorry, but I am not a programmer and don't fully understand these issues, or how to solve them. Mike Paneth Melbourne Australia - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup-Admin
About the questions, I put SSL server so I am using dialup_admin with ssl and you can use any kind of security the apache or your web server software supports for accessing the pages. I put a simple username/password which was enough for me. Evren On Mon, 6 Jan 2003, Evren Yurtesen wrote: no, he is on the right list I think, freeradius version is 0.81 but dialupadmin version is about 1.61 if I am not mistaken? On Mon, 6 Jan 2003, Tim D. McCracken wrote: Obviously you are not using FreeRadius, so you are on the wrong list. FreeRadius is currently on version .8 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Paneth Sent: Monday, January 06, 2003 12:06 AM To: [EMAIL PROTECTED] Subject: Dialup-Admin I have just started to use version 1.61 and I have the following questions. When I select Statistics (and select sessions, uploads and downloads, the results are all zero, even though the radacct table has entries. When I select a user, how do I change the allowed session time? My users are volume based not time based. Also the account status is all zeros. Is it possible to convert the html to shtml so I can pass this securely over the network? Is it possible to have login security, so only valid users can access these pages? Sorry, but I am not a programmer and don't fully understand these issues, or how to solve them. Mike Paneth Melbourne Australia - 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
Kostas wrote
I have just started to use version 1.61 and I have the following
questions.
When I select Statistics (and select sessions, uploads and
downloads,
the results are all zero, even though the radacct table has entries.
Do you press the Refresh button and you still don't get results?
Yes, refresh does nothing
When I select a user, how do I change the allowed session time? My
users
are volume based not time based.
You can change the Session Timeout from the EDIT page if I understand you
correctly.
Edit only allows the following to be changes
Protocol, Ip Address, Ip netmask, MTU, Compression used, Session timeout,
Idle timeout, Port limit, Lock message
The session timeout only affects the per-session timeout. No daily or
weekly limits can be set from here.
Also the account status is all zeros.
The Account Status is only for the last 7 days. Do you have sessions for
that
user for the last 7 days?
The Accounting report generator gave the following
Client IP Address Download Login Time Logout Time NAS IP Address NAS Port
Session Time Upload User Name
- 2.10 MBs 2003-01-06 10:40:29 2003-01-06 10:57:35 192.168.1.1 0 0
seconds 146.48 KBs fred
- 0.62 MBs 2003-01-07 12:13:20 2003-01-07 12:14:55 192.168.1.100 0 0
seconds 120.56 KBs fred
When I edit user fred, I get the following in the Account status for the
last 7 days section
Connections 0
Online time 0 seconds
Failed Logins 0
Upload 0.00 KBs
Download 0.00 KBs
Average Time 0 seconds
Average Upload 0.00 KBs
Average Download 0.00 KBs
Mike Paneth
Melbourne Australia
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf
The config file is as follows
#
# Main Configuration File
#
# it can be default or whatever language. Only greek are supported
# from non latin alphabet languages
# These attribute only apply for ldap not for sql
#
general_prefered_lang: el
general_prefered_lang_name: Greek
#
# Uncomment this if normal attributes (not the ;lang-xx ones) in ldap
# are utf8 encoded.
#
#general_decode_normal_attributes: yes
#
#general_base_dir: /usr/local/dialup_admin
#general_radiusd_base_dir: /usr/local/radiusd
#general_domain: company.com
general_base_dir: /data/dialup_admin
general_radiusd_base_dir: /usr/local
general_domain: marinett.com
#
# Set it to yes to use sessions and cache the various mappings
# You can also set use_session = 1 in config.php3 to also cache
# the admin.conf
#
# IMPORTANT -- IMPORTANT -- IMPORTANT
#Remember to use the 'Clear Cache' page if you use sessions and do any
changes
#in any of the configuration files.
#
general_use_session: no
#
# This is used by the failed logins page. It states the default back time
# in minutes.
#
general_most_recent_fl: 30
#
# Realm setup
#
# Set general_strip_realms to yes in order to stip realms from usernames.
# By default realms are not striped
#general_strip_realms : yes
#
# The delimiter used in realms. Default is @
#
general_realm_delimiter: @
#
# The format of the realms. Can be either suffix (realm is after the
username)
# or prefix (realm is before the username). Default is suffix
#
general_realm_format: suffix
#
general_ldap_attrmap: %{general_radiusd_base_dir}/etc/raddb/ldap.attrmap
general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap
general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap
#
# it can be either ldap or sql
#
general_lib_type: sql
general_user_edit_attrs_file: %{general_base_dir}/conf/user_edit.attrs
general_sql_attrs_file: %{general_base_dir}/conf/sql.attrs
general_default_file: %{general_base_dir}/conf/default.vals
#general_ld_library_path: /usr/local/snmpd/lib
#
# can be 'snmp' (for snmpfinger) or empty to query the radacct table without
first
# querying the nas
#
general_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
general_test_account_password: testing123
#
# These are used as default values for the user test page
#
general_radius_server: localhost
general_radius_server_port: 1812
#
# sorry, single valued for now. Should become something like
# password[server-name]: x
#
general_radius_server_secret: XX
general_auth_request_file: %{general_base_dir}/conf/auth.request
#
# can be one of crypt,md5,clear#
#general_encryption_method: crypt
general_encryption_method: clear
#
# can be either asc (older dates first) or desc (recent dates first)
#
general_accounting_info_order: desc
nas1_name: Firewall.%{general_domain}
nas1_model: Mikes firewall (192.168.1.1)
nas1_ip: 192.168.1.1
nas1_port_num: 100
nas1_community: public
nas2_name: M.%{general_domain}
nas2_model: M Wireless system (192.168.1.100)
nas2_ip: 192.168.1.100
nas2_port_num: 100
nas2_community: public
dialup admin
I'm getting a strange behaviour from the dialup admin code where the $login value does not get set when I put in the user name and click show user in the user_admin.php3. Its strange because I can see the value that I inserted in the field because it shows up in my URL, but in the code itself the $login value is ''. I am running the page on the Apache 1.3.27 web server and PHP 4.2.3 with the Netscape web browser. Has anyone else seen this behaviour. I need to get this working so that I can test the Oracle support that I added. Thanks. Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeRADIUS dialup admin
On Wed, 30 Oct 2002 [EMAIL PROTECTED] wrote: Hello, I was wondering if there was an oracle driver for the dialup admin. Thanks. Adam Joncas No there isn't. Patches are welcome though. It is quite easy, just create a corresponding lib/sql/drivers/oracle/functions.php3 file just like the corresponding mysql and postgresql ones. -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeRADIUS dialup admin
Hello, I was wondering if there was an oracle driver for the dialup admin. Thanks. Adam Joncas - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin - Help!
it just says user not found. doesnt find any user on any page. yet to finger_user.php works fine. i can see whos dialed in. What do you mean by cannot edit current users? Does it find a current user or itjust says that the user was not found? Does the Accounting or Find Userpages work ok? Enable mysql logging and check the sql queries executed bydialup_admin. If you run them by hand do they produce any results?--Kostas Kalevras Network Operations Center[EMAIL PROTECTED] National Technical University of Athens, GreeceWork Phone: +30 210 7721861'Go back to the shadow' Gandalf
Re: Dialup Admin - Help!
On Sun, 6 Oct 2002, Andrew Hardman wrote: it just says user not found. doesnt find any user on any page. yet to finger_user.php works fine. i can see whos dialed in. What happens if you try to add a new user? Do you do user authentication/authorization from mysql? Can you do a show tables in mysql for the radius database? Does it contain all the tables? If you do a SELECT * FROM radcheck WHERE UserName='something' and SELECT * FROM radreply WHERE UserName = 'something' where something is a valid username in mysql what do you get back? -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin - Help!
This is pretty much a follow up to a previous listing. http://lists.cistron.nl/pipermail/freeradius-users/2002-June/008022.html I have the same problem. I can see the users online but cannot create or administer current users in the database. sql_type: mysqlsql_server: localhost sql_port: 3306sql_username: radiussql_password: xxsql_database: radiussql_accounting_table: radacctsql_badusers_table: baduserssql_check_table: radchecksql_reply_table: radreply sql_user_info_table: userinfosql_groupcheck_table: radgroupchecksql_groupreply_table: radgroupreplysql_usergroup_table: usergroup Where am i going wrong. It seems to read from mysql but cannot create. When i check online users it tells me the name of the person next to the username ok. As I entered userinfo via webmin. Any Ideas? Andrew HardmanEmail: [EMAIL PROTECTED]
Re: Dialup Admin - Help!
Have you checked the permissions of your radius MySQL user? -AW On October 3, 2002 04:14 am, Andrew Hardman wrote: This is pretty much a follow up to a previous listing. http://lists.cistron.nl/pipermail/freeradius-users/2002-June/008022.html I have the same problem. I can see the users online but cannot create or administer current users in the database. sql_type: mysql sql_server: localhost sql_port: 3306 sql_username: radius sql_password: xx sql_database: radius sql_accounting_table: radacct sql_badusers_table: badusers sql_check_table: radcheck sql_reply_table: radreply sql_user_info_table: userinfo sql_groupcheck_table: radgroupcheck sql_groupreply_table: radgroupreply sql_usergroup_table: usergroup Where am i going wrong. It seems to read from mysql but cannot create. When i check online users it tells me the name of the person next to the username ok. As I entered userinfo via webmin. Any Ideas? Andrew Hardman Email: [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin - Help!
Yeh I have, radius has full rights to add edit and delete etc. Its strange cause I can see whos logged in but cannot edit current or even add users. Although if i change any of the settings it tells me connect connect to sql database Andrew Have you checked the permissions of your radius MySQL user? -AW On October 3, 2002 04:14 am, Andrew Hardman wrote: This is pretty much a follow up to a previous listing. http://lists.cistron.nl/pipermail/freeradius-users/2002-June/008022.html I have the same problem. I can see the users online but cannot create or administer current users in the database. sql_type: mysql sql_server: localhost sql_port: 3306 sql_username: radius sql_password: xx sql_database: radius sql_accounting_table: radacct sql_badusers_table: badusers sql_check_table: radcheck sql_reply_table: radreply sql_user_info_table: userinfo sql_groupcheck_table: radgroupcheck sql_groupreply_table: radgroupreply sql_usergroup_table: usergroup Where am i going wrong. It seems to read from mysql but cannot create. When i check online users it tells me the name of the person next to the username ok. As I entered userinfo via webmin. Any Ideas? Andrew Hardman Email: [EMAIL PROTECTED] Andrew Hardman Email: [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Webmin Module? - DialUp Admin
I get the following errors when trying to edit a user: Warning: file(/etc/raddb/etc/raddb/ldap.attrmap) - No such file or directory in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 3 Warning: Invalid argument supplied for foreach() in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 4 Warning: file(/etc/raddb/etc/raddb/ldap.attrmap) - No such file or directory in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 3 Warning: Invalid argument supplied for foreach() in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 4 Could not connect to the LDAP server I am not running an LDAP server. And using the previous version of dialup_admin works fine. Thanks, Sheldon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kostas Kalevras Sent: Tuesday, September 03, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: RE: Webmin Module? On Tue, 3 Sep 2002, Sheldon Fougere wrote: Thanksusing the dialup_admin 1.55 I'm getting ldap errors. I have changed the general_lib_type to sql but it still tells me that I have ldap errors. Can you point me in the right direction? Thanks, Sheldon What errors, where, when? -- 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
RE: Webmin Module? - DialUp Admin
I found my problem...I hadn't changed the config.php3 file to point to the right admin.conf file. I'm going to learn to read the manual someday. Thanks, Sheldon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sheldon Fougere Sent: Tuesday, September 03, 2002 3:39 PM To: [EMAIL PROTECTED] Subject: RE: Webmin Module? - DialUp Admin I get the following errors when trying to edit a user: Warning: file(/etc/raddb/etc/raddb/ldap.attrmap) - No such file or directory in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 3 Warning: Invalid argument supplied for foreach() in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 4 Warning: file(/etc/raddb/etc/raddb/ldap.attrmap) - No such file or directory in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 3 Warning: Invalid argument supplied for foreach() in /var/www/html/radadmin/lib/ldap/attrmap.php3 on line 4 Could not connect to the LDAP server I am not running an LDAP server. And using the previous version of dialup_admin works fine. Thanks, Sheldon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kostas Kalevras Sent: Tuesday, September 03, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: RE: Webmin Module? On Tue, 3 Sep 2002, Sheldon Fougere wrote: Thanksusing the dialup_admin 1.55 I'm getting ldap errors. I have changed the general_lib_type to sql but it still tells me that I have ldap errors. Can you point me in the right direction? Thanks, Sheldon What errors, where, when? -- 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 - 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
Re: Dialup admin FATAL error in apache repost
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
Re: Dialup admin FATAL error in apache repost
Hi thank you for the answer, well...
I Use mysql. I have imported the users with a perl script from an old
/etc/shadow System.
I get the same error in every page i have to get some result from the
database.
I'm able to create users with the interface but if i try to get
information of the user created i get the error.
The page of the online users is running, i think becouse it use only the
snmpfinger on the NAS.
The statistic page is working properly.
I have a little more question: How may i have the group to insert the
user in shown in the new user page and let the dialup_admin to insert
the user in the group i specified?
This are my tables:
mysql show tables;
+--+
| Tables_in_radius |
+--+
| badusers |
| radacct |
| radcheck |
| radgroupcheck|
| radgroupreply|
| radreply |
| usergroup|
| userinfo |
+--+
8 rows in set (0.01 sec)
This is an account that trigger the error, but all the accounts trigger
the problem.
mysql select * from radcheck where username='pipperino';
++---+++--+
| id | UserName | Attribute | Value |
op |
++---+++--+
| 1 | pipperino | Crypt-Password | $1$/EhFx4aw$.jqrX7F5RwKB5ExUINRYH0
| |
++---+++--+
1 row in set (0.01 sec)
mysql select * from usergroup where username='pipperino';
++---+---+
| id | UserName | GroupName |
++---+---+
| 1 | pipperino | DEFAULT |
++---+---+
1 row in set (0.09 sec)
This is my admin.cong file:
# it can be el (greek) or default
#
general_prefered_lang: el
general_prefered_lang_name: Greek
#
general_base_dir: /usr/local/dialup_admin
general_radiusd_base_dir: /usr/local
general_domain: domain.com
#
general_ldap_attrmap: %{general_radiusd_base_dir}/etc/raddb/ldap.attrmap
general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap
general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap
#
# it can be either ldap or sql
#
general_lib_type: sql
general_user_edit_attrs_file: %{general_base_dir}/conf/user_edit.attrs
general_sql_attrs_file: %{general_base_dir}/conf/sql.attrs
general_default_file: %{general_base_dir}/conf/default.vals
#general_ld_library_path: /usr/local/snmpd/lib
#
# can be 'snmp' (for snmpfinger) or empty to query the radacct table
without first
# querying the nas
#
general_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
general_test_account_password: testpass
#
# These are used as default values for the user test page
#
general_radius_server: localhost
general_radius_server_port: 1645
#
# sorry, single valued for now. Should become something like
# password[server-name]: x
#
general_radius_server_secret: secret
general_auth_request_file: %{general_base_dir}/conf/auth.request
#
# can be one of crypt,md5,clear
#
general_encryption_method: crypt
#
# can be either asc (older dates first) or desc (recent dates first)
#
general_accounting_info_order: desc
nas1_name: as5300.%{general_domain}
nas1_model: Cisco AS5300 access server
nas1_ip: xxx.xxx.xxx.xxx
nas1_port_num: 60
nas1_community: public
nas2_name: nas2.%{general_domain}
nas2_model: Cisco 2511 access server
nas2_ip: 147.122.122.123
nas2_port_num: 16
nas2_community: public
nas3_name: nas3.%{general_domain}
nas3_model: Cisco 5300 access server
nas3_ip: 147.122.122.124
nas3_port_num: 210
nas3_community: public
ldap_server: ldap.%{general_domain}
ldap_base: dc=company,dc=com
ldap_binddn: cn=Directory Manager
ldap_bindpw: XXX
ldap_default_new_entry_suffix: ou=dialup,ou=guests,%{ldap_base}
ldap_default_dn: uid=default-dialup,%{ldap_base}
ldap_regular_profile_attr: dialupregularprofile
#
# can be one of mysql,pg where:
# mysq: MySQL database (port 3306)
# pg: PostgreSQL database (port 5432)
#
sql_type: mysql
sql_server: localhost
sql_port: 3306
sql_username: username
sql_password: password
sql_database: radius
sql_accounting_table: radacct
sql_badusers_table: badusers
sql_check_table: radcheck
sql_reply_table: radreply
sql_user_info_table: userinfo
#
# true or false
#
#sql_use_user_info_table: true
#sql_use_operators: true
sql_use_user_info_table: false
sql_use_operators: false
#
#
sql_password_attribute: Crypt-Password
sql_date_format: Y-m-d
sql_full_date_format: Y-m-d H:i:s
#
# Used in the accounting report generator so that we
# don't return too many results
#
sql_row_limit: 40
counter_default_daily: 14400
counter_default_weekly: 72000
counter_default_monthly: none
**
Kostas Kalevras wrote:
On Wed, 3 Jul
Dialup admin - a small change which helps me a lot.
On dialup admin, adding the following line to htdocs/user_finger.php3 META HTTP-EQUIV=Refresh CONTENT=30 below the head line will make the online users page reload twice a minute, so I don't need to get reloading the page every time. Hope this interest someone. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin - a small change which helps me a lot.
On Wed, 3 Jul 2002, Alexandre Strube wrote: On dialup admin, adding the following line to htdocs/user_finger.php3 META HTTP-EQUIV=Refresh CONTENT=30 below the head line will make the online users page reload twice a minute, so I don't need to get reloading the page every time. Hope this interest someone. Added, thanks. It will just refresh every 50 secs instead of 30 secs since the page can take a few seconds to load when fingering a Cisco 5800 :-) -- 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
Re: Dialup Admin again
On Mon, 10 Jun 2002, Alexandre Strube wrote: When set to clear text password on admin.conf the user_admin.php3 file can check the password correctly! But I could never get this to work when using crypt on general_encryption_method line... It always says NO It is wrong, even when the password is correct... What OS are you using? The crypt function can get very tricky some times. Another thing worth of mention: when the line above is set to clear, it still set the password value on Crypt-Password record from radcheck table, which stops radius from authenticating the user ... It tries to find a crypted password, but what it finds is a cleartext one... Of course when I changed this, I changed the password on radcheck table so the user is always authenticating correctly... There is an sql_password_attribute configuration directive in conf/admin.conf. You could just change that. -- 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
Dialup admin
Hello, a little question when using dialup admin On conf/admin.conf there's a line with the encryption method, called general_encryption_method: crypt When I change to clear, what I was expecting is that the dialup admin interface could work with clear text password, stored at radcheck table as attribute password, instead of crypt-password... Am I wrong? Anyway, if this is the expected behaviour, it's not happening... Even when I change this on admin.conf file it keeps on working with crypted-passwords... And I would like to work on this really nice interface with cleartext passwords.. Am I doing something wrong ? Thanks in advance, As opiniões formuladas neste e-mail são de caráter exclusivamente pessoal. Minha opinião não necessariamente representa a opinião do meu Moto Grupo nem da empresa onde trabalho. Mene Sakkhet ur-seveh Alexandre Ganso - Diretor Steel Goose Moto Group 6, 7 e 8 de setembro - Aniversario 10 anos Steel Goose - Ouro Branco - MG 500 Four Vermelha [EMAIL PROTECTED] ICQ# 3778773 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin again
When set to clear text password on admin.conf the user_admin.php3 file can check the password correctly! But I could never get this to work when using crypt on general_encryption_method line... It always says NO It is wrong, even when the password is correct... Another thing worth of mention: when the line above is set to clear, it still set the password value on Crypt-Password record from radcheck table, which stops radius from authenticating the user ... It tries to find a crypted password, but what it finds is a cleartext one... Of course when I changed this, I changed the password on radcheck table so the user is always authenticating correctly... As opiniões formuladas neste e-mail são de caráter exclusivamente pessoal. Minha opinião não necessariamente representa a opinião do meu Moto Grupo nem da empresa onde trabalho. Mene Sakkhet ur-seveh Alexandre Ganso - Diretor Steel Goose Moto Group 6, 7 e 8 de setembro - Aniversario 10 anos Steel Goose - Ouro Branco - MG 500 Four Vermelha [EMAIL PROTECTED] ICQ# 3778773 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup Admin question
On Mon, 3 Jun 2002, Deramus, Chris wrote: Does it print out any messages? If you try adding a new user what happens? Do you have problem seeing the accounting information or everything? If you try to administer an active account, does it report that it didn't find it or does it show the user administration page ok? The page to load fine. I click the Edit Users section on the left frame and it says user not found. I do a search for user 'TestRad' (which does exist cause I'm currently logged in as him on my laptop) and it says User does not exist. The accounting page shows my attributes and gives me the selection to choose from, but when I hit the submit button it just resets the values and doesn't display anything (including error messages). When I had enter new user information on the Add User section, and then hit the enter button the information disappears and that entry isn't added to the database. So it takes the column information from the database but doesn't find anything in the accounting table. That seems strange. If you do a 'SELECT UserName FROM radacct LIMIT 10' will it give you any results? Could you send the sql_* config directives from the admin.conf (apart from the sql password of course). It doesn't display any active accounts even though I'm currently logged on right now. If you do a 'SELECT UserName from radacct WHERE AcctStartTime = '0'' what does it show when you are loged in? The admin.conf allows you to do a finger to the nas (that only works for cisco access servers currently) or just use the information provided from the accounting database. Which of the two have you enabled? Thanks, Chris DeRamus HQ VPN Administrator Verizon 301-903-2093 -- 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
Dialup Admin question
I know this service is mainly for Free Radius questions but I figured since this product was written for FreeRadius that someone on here has had experience using it. I have FreeRadius successfully working with MySQL for Authorization and PAP for authentication. The system works great and I'm very happy. I'm now trying to bring a web front online for added administration convenience. I have Dialup Admin installed and it seems to be working fine, however it's not pulling any information from the MySQL database and tables. I've looked over the admin.conf file many a times and short of the basic configuration changes are there any major changes that any of you had to make before this would begin to work. Thanks, Chris DeRamus HQ VPN Administrator Verizon 301-903-2093
Re: Dialup Admin question
On Mon, 3 Jun 2002, Deramus, Chris wrote: I know this service is mainly for Free Radius questions but I figured since this product was written for FreeRadius that someone on here has had experience using it. I have FreeRadius successfully working with MySQL for Authorization and PAP for authentication. The system works great and I'm very happy. I'm now trying to bring a web front online for added administration convenience. I have Dialup Admin installed and it seems to be working fine, however it's not pulling any information from the MySQL database and tables. I've looked over the admin.conf file many a times and short of the basic configuration changes are there any major changes that any of you had to make before this would begin to work. Thanks, Chris DeRamus HQ VPN Administrator Verizon 301-903-2093 Does it print out any messages? If you try adding a new user what happens? Do you have problem seeing the accounting information or everything? If you try to administer an active account, does it report that it didn't find it or does it show the user administration page ok? -- 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
RE: Dialup Admin question
Title: RE: Dialup Admin question Does it print out any messages? If you try adding a new user what happens? Do you have problem seeing the accounting information or everything? If you try to administer an active account, does it report that it didn't find it or does it show the user administration page ok? The page to load fine. I click the Edit Users section on the left frame and it says user not found. I do a search for user 'TestRad' (which does exist cause I'm currently logged in as him on my laptop) and it says User does not exist. The accounting page shows my attributes and gives me the selection to choose from, but when I hit the submit button it just resets the values and doesn't display anything (including error messages). When I had enter new user information on the Add User section, and then hit the enter button the information disappears and that entry isn't added to the database. It doesn't display any active accounts even though I'm currently logged on right now. Thanks, Chris DeRamus HQ VPN Administrator Verizon 301-903-2093
Dialup-Admin
When Apache was initially set up during the Caldera OpenLinux installation the default php extension was set to just php rather than php3. So I renamed all of the dialup-admin files to have a php extension and I edited them all replacing php3 with php. Everything appears to be working for the most part; radiusd, MySQL, and Apache are all running. But when I try to use the Dialup_Admin I ran into some problems: When I click on: Accounting: cannot connect to sql databse Problem line appears to be $link = da_sql_pconnect($config) or die... Obviously the script is unable to open a persistent connection to the MySQL db. Any ideas? Edit User: Could not connect to database. New User: Could not connect to database. Check Server: Could not connect to database. I have changed the sql_username and sql_password in admin.conf. Can MySQL usernames have an underscore in them? The MySQL user that I set up for radius was dialup_admin, could this be the problem? Clearly I'm missing something big (not unusual). Are these problems related to my tinkering around with the file extensions? Thanks much. ~ Jason - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup-Admin
When Apache was initially set up during the Caldera OpenLinux installation the default php extension was set to just php rather than php3. So I renamed all of the dialup-admin files to have a php extension and I edited them all replacing php3 with php. Everything appears to be working for the why did you not just edit the httpd.conf file and add '.php3' after the .php include?? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup-Admin
When I change the following line in accounting.php: $link = @da_sql_pconnect($config) or die... to $link = mysql_pconnect(localhost, username,password) or die... I can connect to the db and the accounting page works just fine. A problem with my config file? A problem with this @da_sql_pconnect function? (I can't seem to find it referenced at php.net so I'm assuming it's a function somewhere in the dialup-admin stuff but I can't find it. I'm just looking for some suggestions folks. Thanks. ~ Jason - Original Message - From: Jason M. Weber [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: April 02, 2002 9:14 AM Subject: Dialup-Admin When Apache was initially set up during the Caldera OpenLinux installation the default php extension was set to just php rather than php3. So I renamed all of the dialup-admin files to have a php extension and I edited them all replacing php3 with php. Everything appears to be working for the most part; radiusd, MySQL, and Apache are all running. But when I try to use the Dialup_Admin I ran into some problems: When I click on: Accounting: cannot connect to sql databse Problem line appears to be $link = @da_sql_pconnect($config) or die... Obviously the script is unable to open a persistent connection to the MySQL db. Any ideas? Edit User: Could not connect to database. New User: Could not connect to database. Check Server: Could not connect to database. I have changed the sql_username and sql_password in admin.conf. Can MySQL usernames have an underscore in them? The MySQL user that I set up for radius was dialup_admin, could this be the problem? Clearly I'm missing something big (not unusual). Are these problems related to my tinkering around with the file extensions? Thanks much. ~ Jason - 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 ... error in delete_user.php3, line 18
On Sat, 9 Mar 2002, Peter Santiago wrote:
code fragment reads
if ($res){
if ($config[sql_use_user_info_table] == 'true'){
$res = @da_sql_query($config[sql_database], - error.. this
will return false
DELETE FROM $config[sql_user_info_table] WHERE UserName
= '$login';);
if ($res)
echo bUser $login deleted
successfully/bbr\n;
else
echo bError deleting user $login from user
info table/bbr\n;
}
Isn't that line supposed to read
$res = @da_sql_query($link,$config, DELETE FROM
$config[sql_user_info_table] WHERE UserName = '$login';);
???
Peter
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Yes you 're right. Bug fixed in cvs
--
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
dialup-admin
the following commands does not execute properly...
1. Check server doesn't return any results...
2. Edit users on the left side menu doesn't retrieve userinfo, when the
input box is filled the username. One has to enter the user name again in
the main window then click on show user, before the userinfo comes out
Peter
===
admin.conf
#
# it can be el (greek) or default
#
general_prefered_lang: default
general_prefered_lang_name: English
#
general_base_dir: /var/www/html/dialup_admin
general_radiusd_base_dir: /usr/sbin/radiusd
general_domain: psinergybbs.com
#
general_ldap_attrmap: %{general_radiusd_base_dir}/etc/raddb/ldap.attrmap
general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap
general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap
#
# it can be either ldap or sql
#
general_lib_type: sql
general_user_edit_attrs_file: %{general_base_dir}/conf/user_edit.attrs
general_sql_attrs_file: %{general_base_dir}/conf/sql.attrs
general_default_file: %{general_base_dir}/conf/default.vals
#general_ld_library_path: /usr/local/snmpd/lib
#
# can be 'snmp' (for snmpfinger) or empty to query the radacct table without
first
# querying the nas
#
general_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
general_test_account_password: test
#
# These are used as default values for the user test page
#
general_radius_server: localhost
general_radius_server_port: 1812
#
# sorry, single valued for now. Should become something like
# password[server-name]: x
#
general_radius_server_secret: weraef
general_auth_request_file: %{general_base_dir}/conf/auth.request
#
# can be one of crypt,md5,clear
#
general_encryption_method: crypt
#
# can be either asc (older dates first) or desc (recent dates first)
#
general_accounting_info_order: desc
nas1_name: nas1.%{general_domain}
nas1_model: Portslave
nas1_ip: 10.0.0.1
nas1_port_num: 1
nas1_community: public
#nas2_name: nas2.%{general_domain}
#nas2_model: Cisco 2511 access server
#nas2_ip: 147.122.122.123
#nas2_port_num: 16
#nas2_community: public
#nas3_name: nas3.%{general_domain}
#nas3_model: Cisco 5300 access server
#nas3_ip: 147.122.122.124
#nas3_port_num: 210
#nas3_community: public
ldap_server: ldap.%{general_domain}
ldap_base: dc=company,dc=com
ldap_binddn: cn=Directory Manager
ldap_bindpw: XXX
ldap_default_new_entry_suffix: ou=dialup,ou=guests,%{ldap_base}
ldap_default_dn: uid=default-dialup,%{ldap_base}
ldap_regular_profile_attr: dialupregularprofile
#
# can be one of mysql,pg where:
# mysq: MySQL database (port 3306)
# pg: PostgreSQL database (port 5432)
#
sql_type: mysql
sql_server: localhost
sql_port: 3306
sql_username: root
sql_password:
sql_database: radius
sql_accounting_table: radacct
sql_badusers_table: badusers
sql_check_table: radcheck
sql_reply_table: radreply
sql_user_info_table: userinfo
#
# true or false
#
sql_use_user_info_table: true
sql_use_operators: true
#
#
sql_password_attribute: Crypt-Password
sql_date_format: Y-m-d
sql_full_date_format: Y-m-d H:i:s
#
# Used in the accounting report generator so that we
# don't return too many results
#
sql_row_limit: 40
counter_default_daily: 14400
counter_default_weekly: 72000
counter_default_monthly: none
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: dialup-admin--- sorry.. my mistake...
problem just solved itself... I must be brain-dead... Kostas, you did a very wonderful job... peter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin
On Sat, 9 Mar 2002, Peter Santiago wrote:
the following commands does not execute properly...
1. Check server doesn't return any results...
general_radiusd_base_dir should contain the base directory of the freeradius
installation *not* the radiusd binary. The way you 've edited admin.conf will
make the radclient path look like this:
/usr/sbin/radiusd/bin/radclient which does not seem correct. Only if
dialup_admin can access radclient can the 'check server' and 'test user' pages
work properly.
2. Edit users on the left side menu doesn't retrieve userinfo, when the
input box is filled the username. One has to enter the user name again in
the main window then click on show user, before the userinfo comes out
Just put the username in the input box and press enter. :-)
general_base_dir: /var/www/html/dialup_admin
general_radiusd_base_dir: /usr/sbin/radiusd
general_domain: psinergybbs.com
#
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
--
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
dialup-admin ... error in delete_user.php3, line 18
code fragment reads
if ($res){
if ($config[sql_use_user_info_table] == 'true'){
$res = da_sql_query($config[sql_database], - error.. this
will return false
DELETE FROM $config[sql_user_info_table] WHERE UserName
= '$login';);
if ($res)
echo bUser $login deleted
successfully/bbr\n;
else
echo bError deleting user $login from user
info table/bbr\n;
}
Isn't that line supposed to read
$res = da_sql_query($link,$config, DELETE FROM
$config[sql_user_info_table] WHERE UserName = '$login';);
???
Peter
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: dialup-admin
Thanks Kostas I must be getting senile, to miss such an obvious error
:(
Peter
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kostas
Kalevras
Sent: 09 March 2002 23:31
To: Freeradius-Users@Lists. Cistron. Nl
Subject: Re: dialup-admin
On Sat, 9 Mar 2002, Peter Santiago wrote:
the following commands does not execute properly...
1. Check server doesn't return any results...
general_radiusd_base_dir should contain the base directory of the freeradius
installation *not* the radiusd binary. The way you 've edited admin.conf
will
make the radclient path look like this:
/usr/sbin/radiusd/bin/radclient which does not seem correct. Only if
dialup_admin can access radclient can the 'check server' and 'test user'
pages
work properly.
2. Edit users on the left side menu doesn't retrieve userinfo, when the
input box is filled the username. One has to enter the user name again in
the main window then click on show user, before the userinfo comes out
Just put the username in the input box and press enter. :-)
general_base_dir: /var/www/html/dialup_admin
general_radiusd_base_dir: /usr/sbin/radiusd
general_domain: psinergybbs.com
#
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
--
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
