Hi all,
I'm using postgresql and dialup_admin for
freeradius 0.9
with dialup_admin, if I let it in orginal source
code, it does not work correct. because case-sensitive. I must try to convert to
lower_case and it work well.
Because when I import radius tables, it is in
lowercase and postgres work well with free-radius. SOme problems will accour
when I try to create tables that has fields in uppercase , such as: "Username",
"AcctStartTime" instead of "username", "acctstoptime"
so that in dialup_admin, I have to let all field in
row[] in lowercase:
$link = @da_sql_pconnect($config);if
($link){
$search =
@da_sql_query($link,$config,
"SELECT * FROM $config[sql_badusers_table]
WHERE UserName
$usercheck AND
Date <= '$now_str'
AND Date >=
'$prev_str'
ORDER BY Date ASC $limit;");
if ($search){
while( $row = @da_sql_fetch_array($search,$config) ){
$num++;
$user =
"$row[username]";
$date =
"$row[date]";
$reason =
"$row[reason]";
$admin =
"$row[admin]";
if ($admin == '')
$admin =
'-';
if ($reason == '')
$reason =
'-';
echo <<<EOM
<tr align=center>
<td>$num</td>
<td><a
href="" title="Edit user $user">$user</a></td>
<td>$date</td>
<td>$admin</td>
<td>$reason</td>
</tr>EOM;
}
}
This code segment is work OK.
Any suggestion for me?
Thank you for all who are developing dialup_admin
and free-radius.
I had to rewrite dialup_admin because if I
extracted the source code and lease it in orginal, it can't work well because
case sensitive, and in the old version, I added to it some new features, but I
didn't post to list. I'm sory because I don't think it would usefull for
another.
I found that in new version, free-radius and
dialup_admin are added some new features that I did in my old version. I
think I will send my own new update version to mailling list.
Thanks and best Regards,
******************************************************* EIS Service, Inc. |