Re: Dialup Admin
>> Hi Guys, >> >> Could I please get a response to this? > > > Have you considered the possibility that no-one knows? > > dialupadmin is largely abandonware; it's been removed from the GIT repo in > master as no-one maintains it, or wants to. So, expertise on it is minimal, > and interest in it even less so. Check out DaloRadius which is maintained and very good. http://sourceforge.net/projects/daloradius/ Regards Wayne - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin
On 02/12/2013 09:52 PM, Shawky Skaff wrote: Hi Guys, Could I please get a response to this? Have you considered the possibility that no-one knows? dialupadmin is largely abandonware; it's been removed from the GIT repo in master as no-one maintains it, or wants to. So, expertise on it is minimal, and interest in it even less so. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup Admin
Hi Guys, Could I please get a response to this? From: freeradius-users-bounces+shawkys=ivox.com...@lists.freeradius.org [mailto:freeradius-users-bounces+shawkys=ivox.com...@lists.freeradius.org] On Behalf Of Shawky Skaff Sent: Tuesday, 29 January 2013 12:45 PM To: freeradius-users@lists.freeradius.org Subject: Dialup Admin In dialup admin if a select accounting and run an accounting query, I can see accounting data listed in the tables, uptime, downloads, uploads, etc, however if I edit the user, the connection status has no information and the open session shows no sessions. Doesn't the data for all locations come from the same place? Is there anything that I need to do? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin
In dialup admin if a select accounting and run an accounting query, I can see accounting data listed in the tables, uptime, downloads, uploads, etc, however if I edit the user, the connection status has no information and the open session shows no sessions. Doesn't the data for all locations come from the same place? Is there anything that I need to do? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup Admin
Furthermore to do this. In dialup admin if a select accounting and run an accounting query, I can see accounting data listed in the tables, uptime, downloads, uploads, etc, however if I edit the user, the connection status has no information and the open session shows no sessions. Doesn't the data for all locations come from the same place? Is there anything that I need to do? -Original Message- From: freeradius-users-bounces+shawkys=ivox.com...@lists.freeradius.org [mailto:freeradius-users-bounces+shawkys=ivox.com...@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, 27 June 2012 11:43 PM To: FreeRadius users mailing list Subject: Re: Dialup Admin Shawky Skaff wrote: > - When I view a session of a user, it says user “bla” has 0 > open session, which it weird because the user is connected. Where does > radius get this info from? Is there anything that I need to change to > fix it? It comes from the DB. The information in the DB comes from RADIUS accounting packets sent by the NAS. To "fix it", make sure that the NAS sends accounting packets. > - Is radkill still used? Is there anywhere I can obtain this > from, the ftp link in the wiki times out after a while I guess it's gone. 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
Dialup admin lingering sessions
Hello, I'm having an issue from time to time where a PPPoE session will drop and relogin which is fine but the "Online Users" doesn't seem to clear the old session. I check on the NAS and there is only the 1 session active. Not sure how to properly clear stale sessions. Serge. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin and PPPoE
Am 04.10.2012 04:09, schrieb Serge Paquin: > The NAS I have is a Cisco 7204VXR with an NPE-G2 so I assume (hope) it > supports Accounting Interim-Update. Cisco 7204VXR definitely supports interim accounting (period >= 5min). Look for: aaa accounting ... aaa accounting update newinfo periodic 5 Regards, Peter. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup Admin and PPPoE
Thanks I'll give that a try. The NAS I have is a Cisco 7204VXR with an NPE-G2 so I assume (hope) it supports Accounting Interim-Update. Thanks for the suggestion. Serge. -Original Message- From: freeradius-users-bounces+serge=skycomp...@lists.freeradius.org [mailto:freeradius-users-bounces+serge=skycomp...@lists.freeradius.org] On Behalf Of Fajar A. Nugraha Sent: Wednesday, October 03, 2012 10:05 PM To: FreeRadius users mailing list Subject: Re: Dialup Admin and PPPoE On Thu, Oct 4, 2012 at 8:35 AM, Serge Paquin wrote: > Thank you. > > I believe our NAS supports this and is working. If I go into the user it > will show they've been connected for days and shows and upload/download value. That's not an indication of the nas suppoting Accounting Interim-Update. However, since even chillispot and openvpn supports Accounting Interim-Update, I don't see why whatever-NAS-you-re-using wouldn't support it. It would be just silly :P > > The catch is the reporting. This data doesn't get updated into the > statistics until the user logs off. > > I'm sure it's something specific with Dialup Admin since it's built from the > premise of a dialup ISP which will have typical log offs. > > I was just curious if there is a config or change to make to Dialup Admin > that would update statistics while an account is still logged on but not > duplicate data. Probably nothing. Try adding reply item "Acct-Interim-Interval := 300" to a test user (in radreply table, if you're using database backend), login, do stuff that uses bandwidth for 6 minutes or so, and check: - whether the NAS sends acct interim update (easiest if you can run FR in debug mode) - whether the acct entry is updated - whether dialup admin correctly displays the updated acct record -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin and PPPoE
On Thu, Oct 4, 2012 at 8:35 AM, Serge Paquin wrote: > Thank you. > > I believe our NAS supports this and is working. If I go into the user it > will show they've been connected for days and shows and upload/download value. That's not an indication of the nas suppoting Accounting Interim-Update. However, since even chillispot and openvpn supports Accounting Interim-Update, I don't see why whatever-NAS-you-re-using wouldn't support it. It would be just silly :P > > The catch is the reporting. This data doesn't get updated into the > statistics until the user logs off. > > I'm sure it's something specific with Dialup Admin since it's built from the > premise of a dialup ISP which will have typical log offs. > > I was just curious if there is a config or change to make to Dialup Admin > that would update statistics while an account is still logged on but not > duplicate data. Probably nothing. Try adding reply item "Acct-Interim-Interval := 300" to a test user (in radreply table, if you're using database backend), login, do stuff that uses bandwidth for 6 minutes or so, and check: - whether the NAS sends acct interim update (easiest if you can run FR in debug mode) - whether the acct entry is updated - whether dialup admin correctly displays the updated acct record -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup Admin and PPPoE
Thank you. I believe our NAS supports this and is working. If I go into the user it will show they've been connected for days and shows and upload/download value. The catch is the reporting. This data doesn't get updated into the statistics until the user logs off. I'm sure it's something specific with Dialup Admin since it's built from the premise of a dialup ISP which will have typical log offs. I was just curious if there is a config or change to make to Dialup Admin that would update statistics while an account is still logged on but not duplicate data. Serge. -Original Message- From: freeradius-users-bounces+serge=skycomp...@lists.freeradius.org [mailto:freeradius-users-bounces+serge=skycomp...@lists.freeradius.org] On Behalf Of Blake Covarrubias Sent: Wednesday, October 03, 2012 9:27 PM To: FreeRadius users mailing list Subject: Re: Dialup Admin and PPPoE On Oct 3, 2012, at 18:13, "Serge Paquin" wrote: > One item I haven't been able to figure out is how to have the Upload and > Download statistics updated on a regular basis What you're looking for is Accounting Interim-Update. This functionality must be implemented by your NAS. Check with your NAS vendor regarding support for this feature. -- Blake Covarrubias - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin and PPPoE
On Oct 3, 2012, at 18:13, "Serge Paquin" wrote: > One item I haven't been able to figure out is how to have the Upload and > Download statistics updated on a regular basis What you're looking for is Accounting Interim-Update. This functionality must be implemented by your NAS. Check with your NAS vendor regarding support for this feature. -- Blake Covarrubias - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin and PPPoE
Hello, I've setup FreeRadius and Dialup Admin to manage it. One item I haven't been able to figure out is how to have the Upload and Download statistics updated on a regular basis. With PPPoE my users stay always on. Looking at the code it seems that transfer statistics are only updated if there is a complete session with a log off. Ideally I'd like something we could run every day or 12 hours or something that would update the transfer statistics even if the user is still online. I've done a lot of searching and read all the documents so if I've missed something I apologize. If somebody has some insight and can point me in the right direction it would be much appreciated. Thanks, Serge. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin
Shawky Skaff wrote: > - When I view a session of a user, it says user “bla” has 0 > open session, which it weird because the user is connected. Where does > radius get this info from? Is there anything that I need to change to > fix it? It comes from the DB. The information in the DB comes from RADIUS accounting packets sent by the NAS. To "fix it", make sure that the NAS sends accounting packets. > - Is radkill still used? Is there anywhere I can obtain this > from, the ftp link in the wiki times out after a while I guess it's gone. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin
I was wondering if you can point me in the right direction for a couple of issues that I'm having - When I view a session of a user, it says user "bla" has 0 open session, which it weird because the user is connected. Where does radius get this info from? Is there anything that I need to change to fix it? - Is radkill still used? Is there anywhere I can obtain this from, the ftp link in the wiki times out after a while - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Php error with Dialup Admin and FreeBSD
Hi, > $auth_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"]; > if ($auth_user){ > if (is_file("../html/buttons/$auth_user/buttons.html.php3")) > include("../html/buttons/$auth_user/buttons.html.php3"); > else{ > if (is_file("../html/buttons/default/buttons.html.php3")) > include("../html/buttons/default/buttons.html.php3"); > } > } > else{ > if (is_file("../html/buttons/default/buttons.html.php3")) > include("../html/buttons/default/buttons.html.php3"); > } > ?> files are .php3 extensionssee what happens if you tell apache config that that means they are PHP files (edit the relevant php module config in apache) alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Php error with Dialup Admin and FreeBSD
Hi, > Dialup Admin works perfectly on Ubuntu 10.04 64 bit with php 5.3 > except for some minor errors. > > No alteration is needed. Indeed. I updated the code to 5.3 compliance a long while ago, and it's running on several of our servers (halfways-recent openSUSE). The file extensions remained, but will be changed to .php in the future. There is NO php3-only code in these files. Greetings, Stefan Winter - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Php error with Dialup Admin and FreeBSD
On 2012-06-01 11:58 PM, Kaya Saman wrote: Hi, I'm trying to test FreeRADIUS on FreeBSD which is the easy part however, I need a web ui and so Dialup Admin directly comes with the port on FreeBSD. Trying to get it running I am having difficulty with php it seems?? I get a green screen saying "Dialup Admin" and that's it. On the left hand side of the screen I have this: I went through the install guide here: http://wiki.freeradius.org/Dialup-admin#Apache+Configuration However, I am using Php5.4 which gets installed by default on FreeBSD unless using a "Legacy" port. Could anyone help me getting this to work or is the web-ui simply too old to be able to work with the latest FreeBSD variant? Regards, Kaya Dialup Admin works perfectly on Ubuntu 10.04 64 bit with php 5.3 except for some minor errors. No alteration is needed. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Php error with Dialup Admin and FreeBSD
On Fri, Jun 01, 2012 at 04:58:20PM +0100, Kaya Saman wrote: > Hi, > > I'm trying to test FreeRADIUS on FreeBSD which is the easy part > however, I need a web ui and so Dialup Admin directly comes with the > port on FreeBSD. > > Trying to get it running I am having difficulty with php it seems?? > > I get a green screen saying "Dialup Admin" and that's it. On the left > hand side of the screen I have this: > > $auth_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"]; > if ($auth_user){ > if (is_file("../html/buttons/$auth_user/buttons.html.php3")) > include("../html/buttons/$auth_user/buttons.html.php3"); > else{ > if (is_file("../html/buttons/default/buttons.html.php3")) > include("../html/buttons/default/buttons.html.php3"); > } > } > else{ > if (is_file("../html/buttons/default/buttons.html.php3")) > include("../html/buttons/default/buttons.html.php3"); > } > ?> > > I went through the install guide here: > > http://wiki.freeradius.org/Dialup-admin#Apache+Configuration > > However, I am using Php5.4 which gets installed by default on FreeBSD > unless using a "Legacy" port. > I left php4 on the machine running Dialup Admin. I think I first tried 5.x but the Dialup Admin code is old and hasn't been updated for deprecated and removed features, IIRC. We originally installed it in a jail on FreeBSD 6.x. The machine is now running FreeBSD 8.3. However, we've left the installed Apache/PHP ports alone. It's firewalled off from public access. Are you sure you spelled the AddType rule correctly in httpd.conf to tell it that .php3 files are php applications? AddType application/x-httpd-php .php3 That's my first guess for why you are seeing php code output in the page rather than executed. If I had it to do over again, I would probably use the DaloRADIUS web interface instead of Dialup Admin. We populate the DB with scripts from our billing/provisioning system and just use Dialup Admin for read-only access to call logs for the occasional tech support calls. -- Scott LambertKC5MLE Unix SysAdmin lamb...@lambertfam.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Php error with Dialup Admin and FreeBSD
Hi, I'm trying to test FreeRADIUS on FreeBSD which is the easy part however, I need a web ui and so Dialup Admin directly comes with the port on FreeBSD. Trying to get it running I am having difficulty with php it seems?? I get a green screen saying "Dialup Admin" and that's it. On the left hand side of the screen I have this: I went through the install guide here: http://wiki.freeradius.org/Dialup-admin#Apache+Configuration However, I am using Php5.4 which gets installed by default on FreeBSD unless using a "Legacy" port. Could anyone help me getting this to work or is the web-ui simply too old to be able to work with the latest FreeBSD variant? Regards, Kaya - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_perl, aaa, dialup admin
Hi... I have a lot of problems configuring freeRadius. First I have a web service and a perl client to obtain users and password from an external database. I used with rlm_perl with an script perl in the authetication func and it works... but i need to implement dialup admin (or daloradius) to account... but i read that dialup admin works with a mysql database so... what i need to use to works dialup admin? and what archives i need to edit (users, radiusd.conf, etc) to authentication with rlm_perl and authorize and accounting with mysql? -- Fabricio A. Flores G. Egresado en Ingeniería en Sistemas MSN: fabri_flor...@hotmail.com Google: fabriflor...@gmail.com Twitter: fabricioflores Skype: fabriciofloresgallardo Blog Personal <http://fabricioflores.wordpress.com/> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin
Hi, radiusd -X is of no use in debugging dialup admin. It's a PHP tool running on a web server, whereas FreeRADIUS' radiusd is a stand-alone process doing RADIUS. Their only interface is that FreeRADIUS writes into a DB, and dialup admin reads data from that same DB; the two sides of it use a common schema. You need to configure both sides regarding database hostname, username, password. Setting it in raddb/* is NOT doing any good. So, if your dialup admin throws an error - look at the web server's error log. It will help you much more. Greetings, Stefan Winter Am 19.09.2011 05:14, schrieb shawky skaff: > Hi, > > I am having issues viewing content on the dialup screen, I can see the > html links, when I select one of them say acconuting I just receive a > error saying DEBUG(SQL,MYSQL DRIVER): Connect: User=root,Password=* > > *I have allowed all sql options in site-enabled default file. > > Running radiusd -X gives me the following output > > [root@radius conf]# radiusd -X > FreeRADIUS Version 2.1.7, for host i686-redhat-linux-gnu, built on Mar > 31 2010 at 00:25:31 > Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. > There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A > PARTICULAR PURPOSE. > You may redistribute copies of FreeRADIUS under the terms of the > GNU General Public License v2. > Starting - reading configuration files ... > including configuration file /etc/raddb/radiusd.conf > including configuration file /etc/raddb/proxy.conf > including configuration file /etc/raddb/clients.conf > including files in directory /etc/raddb/modules/ > including configuration file /etc/raddb/modules/counter > including configuration file /etc/raddb/modules/etc_group > including configuration file /etc/raddb/modules/attr_rewrite > including configuration file /etc/raddb/modules/smbpasswd > including configuration file /etc/raddb/modules/mschap > including configuration file /etc/raddb/modules/logintime > including configuration file /etc/raddb/modules/always > including configuration file /etc/raddb/modules/ippool > including configuration file /etc/raddb/modules/sql_log > including configuration file /etc/raddb/modules/detail.log > including configuration file /etc/raddb/modules/expiration > including configuration file /etc/raddb/modules/echo > including configuration file /etc/raddb/modules/checkval > including configuration file /etc/raddb/modules/acct_unique > including configuration file /etc/raddb/modules/sradutmp > including configuration file /etc/raddb/modules/unix > including configuration file /etc/raddb/modules/exec > including configuration file /etc/raddb/modules/attr_filter > including configuration file /etc/raddb/modules/wimax > including configuration file /etc/raddb/modules/sqlcounter_expire_on_login > including configuration file /etc/raddb/modules/perl > including configuration file /etc/raddb/modules/preprocess > including configuration file /etc/raddb/modules/pam > including configuration file /etc/raddb/modules/files > including configuration file /etc/raddb/modules/linelog > including configuration file /etc/raddb/modules/expr > including configuration file /etc/raddb/modules/otp > including configuration file /etc/raddb/modules/inner-eap > including configuration file /etc/raddb/modules/detail.example.com > including configuration file /etc/raddb/modules/digest > including configuration file /etc/raddb/modules/mac2ip > including configuration file /etc/raddb/modules/realm > including configuration file /etc/raddb/modules/radutmp > including configuration file /etc/raddb/modules/detail > including configuration file /etc/raddb/modules/cui > including configuration file /etc/raddb/modules/smsotp > including configuration file /etc/raddb/modules/mac2vlan > including configuration file /etc/raddb/modules/chap > including configuration file /etc/raddb/modules/passwd > including configuration file /etc/raddb/modules/policy > including configuration file /etc/raddb/modules/pap > including configuration file /etc/raddb/eap.conf > including configuration file /etc/raddb/sql.conf > including configuration file /etc/raddb/sql/mysql/dialup.conf > including configuration file /etc/raddb/policy.conf > including files in directory /etc/raddb/sites-enabled/ > including configuration file /etc/raddb/sites-enabled/inner-tunnel > including configuration file /etc/raddb/sites-enabled/control-socket > including configuration file /etc/raddb/sites-enabled/default > group = radiusd > user = radiusd > including dictionary file /etc/raddb/dictionary > main { > prefix = "/usr" > localstatedir = "/var" > logdir = "/var/log/radius" > libdir = "/us
Re: Dialup Admin
Configure dialupadmin to use the correct mysql username / password. freeradius is working well.. On Mon, Sep 19, 2011 at 8:44 AM, shawky skaff wrote: > Hi, > > I am having issues viewing content on the dialup screen, I can see the html > links, when I select one of them say acconuting I just receive a error > saying DEBUG(SQL,MYSQL DRIVER): Connect: User=root,Password=* > > *I have allowed all sql options in site-enabled default file. > > Running radiusd -X gives me the following output > > [root@radius conf]# radiusd -X > FreeRADIUS Version 2.1.7, for host i686-redhat-linux-gnu, built on Mar 31 > 2010 at 00:25:31 > Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. > There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A > PARTICULAR PURPOSE. > You may redistribute copies of FreeRADIUS under the terms of the > GNU General Public License v2. > Starting - reading configuration files ... > including configuration file /etc/raddb/radiusd.conf > including configuration file /etc/raddb/proxy.conf > including configuration file /etc/raddb/clients.conf > including files in directory /etc/raddb/modules/ > including configuration file /etc/raddb/modules/counter > including configuration file /etc/raddb/modules/etc_group > including configuration file /etc/raddb/modules/attr_rewrite > including configuration file /etc/raddb/modules/smbpasswd > including configuration file /etc/raddb/modules/mschap > including configuration file /etc/raddb/modules/logintime > including configuration file /etc/raddb/modules/always > including configuration file /etc/raddb/modules/ippool > including configuration file /etc/raddb/modules/sql_log > including configuration file /etc/raddb/modules/detail.log > including configuration file /etc/raddb/modules/expiration > including configuration file /etc/raddb/modules/echo > including configuration file /etc/raddb/modules/checkval > including configuration file /etc/raddb/modules/acct_unique > including configuration file /etc/raddb/modules/sradutmp > including configuration file /etc/raddb/modules/unix > including configuration file /etc/raddb/modules/exec > including configuration file /etc/raddb/modules/attr_filter > including configuration file /etc/raddb/modules/wimax > including configuration file /etc/raddb/modules/sqlcounter_expire_on_login > including configuration file /etc/raddb/modules/perl > including configuration file /etc/raddb/modules/preprocess > including configuration file /etc/raddb/modules/pam > including configuration file /etc/raddb/modules/files > including configuration file /etc/raddb/modules/linelog > including configuration file /etc/raddb/modules/expr > including configuration file /etc/raddb/modules/otp > including configuration file /etc/raddb/modules/inner-eap > including configuration file /etc/raddb/modules/detail.example.com > including configuration file /etc/raddb/modules/digest > including configuration file /etc/raddb/modules/mac2ip > including configuration file /etc/raddb/modules/realm > including configuration file /etc/raddb/modules/radutmp > including configuration file /etc/raddb/modules/detail > including configuration file /etc/raddb/modules/cui > including configuration file /etc/raddb/modules/smsotp > including configuration file /etc/raddb/modules/mac2vlan > including configuration file /etc/raddb/modules/chap > including configuration file /etc/raddb/modules/passwd > including configuration file /etc/raddb/modules/policy > including configuration file /etc/raddb/modules/pap > including configuration file /etc/raddb/eap.conf > including configuration file /etc/raddb/sql.conf > including configuration file /etc/raddb/sql/mysql/dialup.conf > including configuration file /etc/raddb/policy.conf > including files in directory /etc/raddb/sites-enabled/ > including configuration file /etc/raddb/sites-enabled/inner-tunnel > including configuration file /etc/raddb/sites-enabled/control-socket > including configuration file /etc/raddb/sites-enabled/default > group = radiusd > user = radiusd > including dictionary file /etc/raddb/dictionary > main { > prefix = "/usr" > localstatedir = "/var" > logdir = "/var/log/radius" > libdir = "/usr/lib/freeradius" > radacctdir = "/var/log/radius/radacct" > hostname_lookups = no > max_request_time = 30 > cleanup_delay = 5 > max_requests = 1024 > allow_core_dumps = no > pidfile = "/var/run/radiusd/radiusd.pid" > checkrad = "/usr/sbin/checkrad" > debug_level = 0 > proxy_requests = yes > log { > stripped_names = no > auth = no > auth_badpass = no > auth_goodpass = no > } > security { > max_attributes = 200 > reject_delay = 1 > status_server = yes > } > } > radiusd: Loading Realms and Home Servers > proxy server { > retry_delay = 5 > retry_count = 3 > default_fallback = no >
Re: Dialup Admin and HTTP Authentication
OK, so to get this working I modified the Dialup Admin functions.php3 file to use $_SERVER instead of $HTTP_SERVER_VARS and to use "REMOTE_USER" instead of "PHP_AUTH_USER". PHP_AUTH_USER wasn't being populated, but REMOTE_USER was so I just used that. Not sure if that's good, bad or indifferent, but it does work. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Dialup-Admin-and-HTTP-Authentication-tp3285681p3286362.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin and HTTP Authentication
Hi, I'm trying to setup Dialup Admin to use HTTP authentication credentials to connect to a mysql database. The HTTP authentication works, but the PHP_AUTH_USER and PHP_AUTH_PW don't seem to be getting set, when trying to connect to the DB I get "DEBUG(SQL,MYSQL DRIVER): Connect: User=,Password= Could not connect to SQL database" (with SQL Debug enabled for Dialup Admin and after setting "sql_use_http_credentials = yes" in my admin.conf). This is with Apache2 2.2 and mod_php5 5.33. The mysql/functions.php3 file is using the $HTTP_SERVER_VARS array, is that going to work with php5? Or is there something else that I need to configure? Thanks in advance! -- View this message in context: http://freeradius.1045715.n5.nabble.com/Dialup-Admin-and-HTTP-Authentication-tp3285681p3285681.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Automatically Generating "Expiration" - Freeradius 2.1.9 / mysql 5.1 / dialup admin
On Wed, Nov 24, 2010 at 7:50 AM, mikal wrote: > > What I'm trying to do is enable a non-technical person to create temporary, > "guest like" accounts using the dialup admin interface. The accounts will > be created as needed, they need to expire within a predetermined time > frame(s) and I'm trying to avoid asking the person creating the accounts to > be entering "Expiration". > > So how would I approach having the "Expiration" field auto populated based > on the account creation date/time and a predetermined account lifetime? For > instance, creation date/time + 12-hours, or date + 1-day. > > Thanks in advance for any guidance. Why don't you simply write some kind of small webif in php to do this? It's easy to predefine values and just add them to the database when a non-technical person presses a button or something like it. (you could even add multiple timeframes in a dropdownbox or so) With a little coding you could even integrate such a page in the existing dialup admin if this is desired. I would not use expiration also, but some no-resetting sql counter. You will also need to find a way to auto-delete expired accounts. Just my 2cents. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Automatically Generating "Expiration" - Freeradius 2.1.9 / mysql 5.1 / dialup admin
I don't know of a way to do that in dialup_admin, but you could potentially look at using a trigger on insert in MySQL. That might be problematic however if you have some users that you don't want to automatically assign this Expiration to. Otherwise if the services assigned are simple it might be easier to create a pared down account creation script either as an extension of dialup_admin or as a standalone app. Ben > -Original Message- > From: freeradius-users- > bounces+wiechman.lists=gmail@lists.freeradius.org > [mailto:freeradius-users- > bounces+wiechman.lists=gmail@lists.freeradius.org] On Behalf Of > mikal > Sent: Wednesday, November 24, 2010 12:51 AM > To: freeradius-users@lists.freeradius.org > Subject: Automatically Generating "Expiration" - Freeradius 2.1.9 / > mysql 5.1 / dialup admin > > > What I'm trying to do is enable a non-technical person to create > temporary, > "guest like" accounts using the dialup admin interface. The accounts > will > be created as needed, they need to expire within a predetermined time > frame(s) and I'm trying to avoid asking the person creating the > accounts to > be entering "Expiration". > > So how would I approach having the "Expiration" field auto populated > based > on the account creation date/time and a predetermined account lifetime? > For > instance, creation date/time + 12-hours, or date + 1-day. > > Thanks in advance for any guidance. > -- > View this message in context: > http://freeradius.1045715.n5.nabble.com/Automatically-Generating- > Expiration-Freeradius-2-1-9-mysql-5-1-dialup-admin- > tp3277961p3277961.html > Sent from the FreeRadius - User mailing list archive at Nabble.com. > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Automatically Generating "Expiration" - Freeradius 2.1.9 / mysql 5.1 / dialup admin
What I'm trying to do is enable a non-technical person to create temporary, "guest like" accounts using the dialup admin interface. The accounts will be created as needed, they need to expire within a predetermined time frame(s) and I'm trying to avoid asking the person creating the accounts to be entering "Expiration". So how would I approach having the "Expiration" field auto populated based on the account creation date/time and a predetermined account lifetime? For instance, creation date/time + 12-hours, or date + 1-day. Thanks in advance for any guidance. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Automatically-Generating-Expiration-Freeradius-2-1-9-mysql-5-1-dialup-admin-tp3277961p3277961.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FR 2.1.8 + dialup admin: Online users
Dear all, I am having troubles with user_finger.php3 because "Online users" do not show up. Problem is that there are no entries in radacct with 'AcctStopTime'. Entries show up in my radacct table when the user session ends and a AcctStopTime gets logged. But then the user is not online anymore ;-) Any ideas? Cheers, Alexander - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Dialup admin error
radiusd: FreeRADIUS Version 1.1.8, for host i686-pc-linux-gnu, built on Mar 3 2010 at 18:01:19 here is the exact error I am getting Warning: import_request_variables() [function.import-request-variables]: Numeric key detected - possible security hazard. in /usr/local/dialup_admin/conf/config.php3 on line 8 here is the code from dialup admin (config.php3) = $testVer ) import_request_variables('GPC'); # If using sessions set use_session to 1 to also cache the config file # $use_session = 0; if ($use_session){ // Start session @session_start(); } if (!isset($config)){ unset($nas_list); $ARR=file("../conf/admin.conf"); $EXTRA_ARR = array(); foreach($ARR as $val) { $val=chop($val); if (ereg('^[[:space:]]*#',$val) || ereg('^[[:space:]]*$',$val)) continue; There are no errors in the error_log file in apache As far as the procedure I was doing I was attempting to change a user password through the edit user screen. Thank you for choosing -- Michael J Humphries Penstar Office Center, Suite 101 1431 N. 26th Street Escanaba, MI 49829 Phone: 906.786.3583 ext. 139 Fax: 906.786.4300 E-Mail: mhumphr...@dstech.us www.dstech.us -Original Message- From: Steve Bertrand [mailto:st...@ibctech.ca] Sent: Tuesday, March 02, 2010 8:36 PM To: FreeRadius users mailing list Cc: Michael J Humphries Subject: Re: Dialup admin error On 2010.03.02 15:38, Michael J Humphries wrote: > We had to reboot the Radius server and ever since then I am getting the > following error when I try to edit someones account in Dialup admin > > *Warning*: import_request_variables() [function.import-request-variables > <http://69.54.213.8/dialup_admin/htdocs/function.import-request-variables>]: > Numeric key detected - possible security hazard. in > */usr/local/dialup_admin/conf/config.php3* on line *8* > > *Any ideas* What version of FreeRADIUS? I don't know if the dialup_admin code has been changed in recent versions of FreeRADIUS or not, but you might want to paste the code in question (five lines previous, and five lines following) in the offending file. Also, posting what you attempted to enter, and what your web server log file states would also be relevant. This isn't a FreeRADIUS problem fwiw. It is a problem with your setup. I'm not trying to be ignorant, I'm just attempting to get that out of the way. This is third party code you are having an issue with. Post what I asked for. Someone here will be able to guide you to an appropriate resource if they can't help directly. Steve - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin error
On 2010.03.02 15:38, Michael J Humphries wrote: > We had to reboot the Radius server and ever since then I am getting the > following error when I try to edit someones account in Dialup admin > > *Warning*: import_request_variables() [function.import-request-variables > <http://69.54.213.8/dialup_admin/htdocs/function.import-request-variables>]: > Numeric key detected - possible security hazard. in > */usr/local/dialup_admin/conf/config.php3* on line *8* > > *Any ideas* What version of FreeRADIUS? I don't know if the dialup_admin code has been changed in recent versions of FreeRADIUS or not, but you might want to paste the code in question (five lines previous, and five lines following) in the offending file. Also, posting what you attempted to enter, and what your web server log file states would also be relevant. This isn't a FreeRADIUS problem fwiw. It is a problem with your setup. I'm not trying to be ignorant, I'm just attempting to get that out of the way. This is third party code you are having an issue with. Post what I asked for. Someone here will be able to guide you to an appropriate resource if they can't help directly. Steve - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin error
We had to reboot the Radius server and ever since then I am getting the following error when I try to edit someones account in Dialup admin Warning: import_request_variables() [function.import-request-variables]: Numeric key detected - possible security hazard. in /usr/local/dialup_admin/conf/config.php3 on line 8 Any ideas Thank you for choosing -- Michael J Humphries Penstar Office Center, Suite 101 1431 N. 26th Street Escanaba, MI 49829 Phone: 906.786.3583 ext. 139 Fax: 906.786.4300 E-Mail: mhumphr...@dstech.us www.dstech.us <>- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin problem
There is also daloRADIUS available which is a web platform to manage freeradius based on mysql. On Mon, Sep 21, 2009 at 5:16 PM, Franz X. Maier wrote: > I have the same problem: installed freeradius on Suse Linux 11.2 and got > the dialupadmin partially working, but the web-interface only shows the > dialup-admin Page with no main menu on the left side – only white. I get no > errors in the logs, but I also had to remove the two lines > > > > >> # Scott Added for freeradius dialup-admin > > >>#LoadModule php4_module libexec/libphp4.so > > >>#AddModule mod_php4.c > > > > or it didn’t work at all. > > > > Any help? > > > > Franz X. Maier > > IT-Berater > > Promenadegasse 11-13/2/1 > > 1170 Wien > > Tel.: 01-8904222 > > Mobil: 0664-1004513 > > eMail: franz.x.ma...@inode.at > > Mobile eMail: franzxma...@mobileemail.vodafone.at > > > > - > 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 problem
I have the same problem: installed freeradius on Suse Linux 11.2 and got the dialupadmin partially working, but the web-interface only shows the dialup-admin Page with no main menu on the left side - only white. I get no errors in the logs, but I also had to remove the two lines >># Scott Added for freeradius dialup-admin >>#LoadModule php4_module libexec/libphp4.so >>#AddModule mod_php4.c or it didn't work at all. Any help? Franz X. Maier IT-Berater Promenadegasse 11-13/2/1 1170 Wien Tel.: 01-8904222 Mobil: 0664-1004513 eMail: franz.x.ma...@inode.at Mobile eMail: franzxma...@mobileemail.vodafone.at - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin config
Hi users i have installed diualup admin i like it! I am traying to configure but my problem are that not list online users conected ,failed loging , and etc. I have been installed the net-snmp. I could create an user an conect but not the other thing like i said in the up lines. what is wrong ?? I read a lot of articles but not explain very good for newbie people. Someone have a How to ?? or a webpage ?? thz _ Permanece actualizado con MSN Noticias. Clic aquí http://noticias.cl.msn.com/- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: AW: Dialup admin questions
To fix your warning about mktime(), edit the file function.php3, go to line 95 and the function should look like this. function date2time($date) { list($day,$time)=explode(' ',$date); $day = explode('-',$day); $time = explode(':',$time); #$timest = mktime($time[0],$time[1],$time[2],$day[1],$day[2],$day[0]); $timest = mktime(0,0,0,$day[1],$day[2],$day[0]); return $timest; } I had the same problem and that was the fix for me. Good luck.. [EMAIL PROTECTED] wrote: 1. Can I see the statistics or aren't they passed, too? They will come up once you connect to the accounting. 2. Is there an alternative with which I can edit the configuration files etc via webinterface? You can use things like OpenOffice if it is installed and you connect via KVM or VNC. Normally you connect with ssh (putty) and use joe or such text editors. Chap from daloRadius used to post here some time ago. You can try that and see. 3. How can I fix this warning message: Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 That's something to do with php. That extension is .php3 so it probably wasn't updated for quite some time. Ivan Kalik Kalik Informatika ISP - 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: AW: Dialup admin questions
>1. Can I see the statistics or aren't they passed, too? They will come up once you connect to the accounting. >2. Is there an alternative with which I can edit the configuration files etc >via webinterface? You can use things like OpenOffice if it is installed and you connect via KVM or VNC. Normally you connect with ssh (putty) and use joe or such text editors. Chap from daloRadius used to post here some time ago. You can try that and see. >3. How can I fix this warning message: >Warning: mktime() expects parameter 1 to be long, string given in >/usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 That's something to do with php. That extension is .php3 so it probably wasn't updated for quite some time. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AW: Dialup admin questions
OK. 1. Can I see the statistics or aren't they passed, too? I mean can I use it for information or is it completely useless in my environment? 2. Is there an alternative with which I can edit the configuration files etc. via webinterface? 3. How can I fix this warning message: Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 Thanks F. Niedernolte -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von [EMAIL PROTECTED] Gesendet: Freitag, 10. Oktober 2008 13:01 An: FreeRadius users mailing list Betreff: Re: Dialup admin questions >Does it make it sense to use dialup admin for administration if the >freeRADIUS server uses the active directory for authentification? > Not a lot. You won't be able to do any user administration (add users, change passwords,...) >Because I have the following errors in the interface: > > > >Warning: asort() expects parameter 1 to be array, null given in >/usr/share/freeradius-dialupadmin/htdocs/accounting.php3 on line 47 > > > >Warning: mktime() expects parameter 1 to be long, string given in >/usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 > >Warning: mktime() expects parameter 1 to be long, string given in >/usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 > > > >DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS >res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM >radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-11 >00:00:00' AND acctstoptime <= '2008-10-11 23:59:59' ; >Database query failed: Table 'radius.radacct' doesn't exist >DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS >res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM >radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-03 >00:00:00' AND acctstoptime <= '2008-10-03 23:59:59' ; >Database query failed: Table 'radius.radacct' doesn't exist > > > >How should I fix them? It's looking for the accounting database. Check your sql.conf settings. Ivan Kalik Kalik Informatika ISP - 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 questions
>Does it make it sense to use dialup admin for administration if the >freeRADIUS server uses the active directory for authentification? > Not a lot. You won't be able to do any user administration (add users, change passwords,...) >Because I have the following errors in the interface: > > > >Warning: asort() expects parameter 1 to be array, null given in >/usr/share/freeradius-dialupadmin/htdocs/accounting.php3 on line 47 > > > >Warning: mktime() expects parameter 1 to be long, string given in >/usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 > >Warning: mktime() expects parameter 1 to be long, string given in >/usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 > > > >DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS >res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM >radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-11 >00:00:00' AND acctstoptime <= '2008-10-11 23:59:59' ; >Database query failed: Table 'radius.radacct' doesn't exist >DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS >res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM >radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-03 >00:00:00' AND acctstoptime <= '2008-10-03 23:59:59' ; >Database query failed: Table 'radius.radacct' doesn't exist > > > >How should I fix them? It's looking for the accounting database. Check your sql.conf settings. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin questions
Does it make it sense to use dialup admin for administration if the freeRADIUS server uses the active directory for authentification? Because I have the following errors in the interface: Warning: asort() expects parameter 1 to be array, null given in /usr/share/freeradius-dialupadmin/htdocs/accounting.php3 on line 47 Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-11 00:00:00' AND acctstoptime <= '2008-10-11 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist DEBUG(SQL,MYSQL DRIVER): Query: SELECT COUNT(radacctid) AS res_1,sum(acctsessiontime) AS res_2,sum(acctoutputoctets) AS res_3 FROM radacct WHERE username LIKE '%' AND acctstoptime >= '2008-10-03 00:00:00' AND acctstoptime <= '2008-10-03 23:59:59' ; Database query failed: Table 'radius.radacct' doesn't exist How should I fix them? Thanks. F. Niedernolte - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin httpd/error_log
Hello Fedora 5 httpd 2.2.2 ( Release: 1.3) php 5.1.6 ( Release : 1.6) /var/log/httpd/error_log PHP Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup_admin/conf/config.php3 on line 8, PHP Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup_admin/conf/config.php3 PHP Notice: Undefined index: ua in /usr/local/dialup_admin/lib/attrshow.php3 Use of undefined constant sql_use_user_info_table - assumed 'sql_use_user_info_table' in /usr/local/dialup_admin/lib/sql/functions.php3 180도 달라진 야후! 메일 - 여러 개의 메시지를 동시에 확인? 새로운 야후! 메일의 탭으로 가능해집니다. http://kr.content.mail.yahoo.com/cgland - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup-Admin Alternatives?
Hey Jaxx, I believe you may find daloRADIUS very productive. It's actively developed, rather stable and provides efficient and vast management control over a FreeRADIUS deployment. Quoting the Sourceforge description: "daloRADIUS is an advanced RADIUS web management application aimed at managing hotspots and general-purpose ISP deployments. It features user management, graphical reporting, accounting, a billing engine and integrates with GoogleMaps for geo-locating." References: Web: http://sourceforge.net/projects/daloradius/ Wiki: http://daloradius.wiki.sourceforge.net/ Demo: http://daloradius.xdsl.by/ (login with administrator/radius by default) Regards, Liran Tal. On Tue, Apr 22, 2008 at 3:21 AM, JaxxMaxx the Elder Druid <[EMAIL PROTECTED]> wrote: > Greetings folks! > > I'm wondering if there is something else that other folks are using to > allow GUI administrative access to FreeRadius w/MySQL-stored user > databases. > I'm noticing that the Dialup-Admin web interface is leaving a LOT to be > desired, and doesn't appear to be keeping up with the rest of the FreeRadius > updates. I had to modify some of the .sql schemas, and I'm still getting > PHP errors on some of the interface pages. > ** Warning: mktime() expects parameter 1 to be long, string given in > /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 ** > > Does anyone still use this interface with the current 2.0.3 ? > What other methods do you use to allow non-SQL savvy administrative folks > to add and remove valid usernames for authentication? > > Basically, this web interface is the last thing standing in my way of > fully implementing the newer version of FreeRadius (needed to move to > different hardware, supporting a captive portal device on a Wifi network) > > > - > 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 Alternatives?
Greetings folks! I'm wondering if there is something else that other folks are using to allow GUI administrative access to FreeRadius w/MySQL-stored user databases. I'm noticing that the Dialup-Admin web interface is leaving a LOT to be desired, and doesn't appear to be keeping up with the rest of the FreeRadius updates. I had to modify some of the .sql schemas, and I'm still getting PHP errors on some of the interface pages. ** Warning: mktime() expects parameter 1 to be long, string given in /usr/share/freeradius-dialupadmin/lib/functions.php3 on line 95 ** Does anyone still use this interface with the current 2.0.3 ? What other methods do you use to allow non-SQL savvy administrative folks to add and remove valid usernames for authentication? Basically, this web interface is the last thing standing in my way of fully implementing the newer version of FreeRadius (needed to move to different hardware, supporting a captive portal device on a Wifi network) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin sql table creation error
rgreiner wrote: > I was making some tests with the freeradius 2 install, and found that > the creation schema for the "badusers" table for dialupadmin (in the > /dialup_admin/sql/mysql folder) has 2 problems: > > [...] Fixed in CVS. Thanks for the report. -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin sql table creation error
(pt-BR) Olá Marcos,Eu tinha me deparado com este mesmo problema a um tempo atrás, eu retirei o default e mudei de Date para IncidentDate, isso resolveu.(en-US) Hi, Marcos,I saw this problem a time ago, I delete the default in ID and replace Date to IncidentDate, appers to work fine. I was making some tests with the freeradius 2 install, and found that the creation schema for the "badusers" table for dialupadmin (in the /dialup_admin/sql/mysql folder) has 2 problems: # # Table structure for table 'badusers' # CREATE TABLE badusers ( id int(10) DEFAULT '0' NOT NULL auto_increment, UserName varchar(30), IncidentDate datetime DEFAULT '-00-00 00:00:00' NOT NULL, Reason varchar(200), Admin varchar(30) DEFAULT '-', PRIMARY KEY (id), KEY UserName (UserName), KEY Date (Date) ); The first is in the 'id' creation line. Starting with version 4.11 (I think its this version), MySQL does not accept having a default value when you use auto_increment. So, "id int(10) NOT NULL auto_increment" would be the correct entry. The second problem is in the last line. There is a reference to 'Date' beeing used as key, but the 'Date' was not created. There is no reference creating it. Checking version 1.1.7, the line was " Date datetime DEFAULT '-00-00 00:00:00' NOT NULL,". Now, was it removed because it's no longer used, or was it removed by accident, ir should it be renamed to the "IncidentDate" field? I guess it would be the last option Thanks, Roberto --- Marcos Roberto Greiner Os otimistas acham que estamos no melhor dos mundos Os pessimistas tem medo de que isto seja verdade Murphy - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Acelerador POP Acelere a sua conexão discada em até 19 x. Use o Acelerador POP. É grátis, pegue já o seu. http://www.pop.com.br/acelerador - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup-admin sql table creation error
I was making some tests with the freeradius 2 install, and found that the creation schema for the "badusers" table for dialupadmin (in the /dialup_admin/sql/mysql folder) has 2 problems: # # Table structure for table 'badusers' # CREATE TABLE badusers ( id int(10) DEFAULT '0' NOT NULL auto_increment, UserName varchar(30), IncidentDate datetime DEFAULT '-00-00 00:00:00' NOT NULL, Reason varchar(200), Admin varchar(30) DEFAULT '-', PRIMARY KEY (id), KEY UserName (UserName), KEY Date (Date) ); The first is in the 'id' creation line. Starting with version 4.11 (I think its this version), MySQL does not accept having a default value when you use auto_increment. So, "id int(10) NOT NULL auto_increment" would be the correct entry. The second problem is in the last line. There is a reference to 'Date' beeing used as key, but the 'Date' was not created. There is no reference creating it. Checking version 1.1.7, the line was " Date datetime DEFAULT '-00-00 00:00:00' NOT NULL,". Now, was it removed because it's no longer used, or was it removed by accident, ir should it be renamed to the "IncidentDate" field? I guess it would be the last option Thanks, Roberto -- - Marcos Roberto Greiner Os otimistas acham que estamos no melhor dos mundos Os pessimistas tem medo de que isto seja verdade Murphy - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup Admin
When I run these commands I get. mysql -uradius -p radius < badusers.sql ERROR 1067 (42000) at line 4: Invalid default value for 'id' mysql -uradius -p radius < userinfo.sql ERROR 1067 (42000) at line 4: Invalid default value for 'id' -- Scott Rodgers - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin online user page & real online user different
O/H hyunok έγραψε: Hello, I have a freeradius 1.1.7 server setup with ppp and pptp using a mysql DB for user authentication. dialup admin web Online Users page ==> 5 online real online pptp user ===> 7 online Why different? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Dialupadmin will only show you what the database is telling it (unless you have a nas supporting the aaa-session-mib in which case it can first query the nas for the online users list). You can enable sql debug to see the sql queries run. -- Kostas Kalevras - Network Operations Center National Technical University of Athens http://kkalev.wordpress.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin online user page & real online user different
Hello, I have a freeradius 1.1.7 server setup with ppp and pptp using a mysql DB for user authentication. dialup admin web Online Users page ==> 5 online real online pptp user ===> 7 online Why different? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin - no clear_opensessions.php3
Currenty i am working on new freeradius Admin interface i will soon launch this package in mailling list David Antognini <[EMAIL PROTECTED]> wrote: Hi Guys, I have an older version of dialupadmin and I upgraded to the latest on sourceforge and now I don't see the clear_opensessions.php3 file and there is no way to do it in the gui.. Any thoughts? Dave - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html $ cat ~/satish/url.txt http://www.linuxbug.org _ - Unlimited freedom, unlimited storage. Get it now- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup-admin - no clear_opensessions.php3
Hi Guys, I have an older version of dialupadmin and I upgraded to the latest on sourceforge and now I don't see the clear_opensessions.php3 file and there is no way to do it in the gui.. Any thoughts? Dave - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: customise dialup admin
Hey Kostas, It's been a while since we talked... in the meanwhile I've done much progress with daloRADIUS<http://www.sourceforge.net/projects/daloradius>and it's pretty mature and stable. Can we discuss further development? Regards, Liran. On 8/22/07, Kostas Kalevras <[EMAIL PROTECTED]> wrote: > > O/H Carl aniams έγραψε: > > > > Hi > > i'm presently using dialup admin for client connexion to the net. > > but my handicap is the time counter > Which time counter, there are plenty of them > > > . i would like to know if it would be possible > > to set graphical time counter for a customer > What do you mean exactly? > > > . also is it possible to increase the time limit > > for a customer that may require an hour more. > You can increase the time limit by one hour (3600 seconds). See the > documentation for the counter module as well as the dialupadmin > configuration files in the config catalog > > > if yes how please. > > thanks > > -- > > -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ > > > > ANIAMBOSSOU Carl > > NIAMS TECHNOLOGIES > > tel: +229 90 04 08 58 +229 97 48 01 33 > > COTONOU > > REPUBLIC OF BENIN > > WEST AFRICA > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > -- > Kostas Kalevras - Network Operations Center > National Technical University of Athens > http://kkalev.wordpress.com > > - > 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: customise dialup admin
O/H Carl aniams έγραψε: Hi i'm presently using dialup admin for client connexion to the net. but my handicap is the time counter Which time counter, there are plenty of them . i would like to know if it would be possible to set graphical time counter for a customer What do you mean exactly? . also is it possible to increase the time limit for a customer that may require an hour more. You can increase the time limit by one hour (3600 seconds). See the documentation for the counter module as well as the dialupadmin configuration files in the config catalog if yes how please. thanks -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ ANIAMBOSSOU Carl NIAMS TECHNOLOGIES tel: +229 90 04 08 58 +229 97 48 01 33 COTONOU REPUBLIC OF BENIN WEST AFRICA - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras - Network Operations Center National Technical University of Athens http://kkalev.wordpress.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: customise dialup admin + daloRADIUS Web Management
Hey Carl, I'm extensively working on a web management for RADIUS which you can use as a replacement for dialup admin. The project is called daloRADIUS and is much more comprehensive than dialup admin with support for accounting, reports, visual graphs, and even hotspots management integrated already into it. I hope you find it useful and you can feel free to always contact me at [EMAIL PROTECTED] Website: http://sourceforge.net/projects/daloradius/ Yours, Liran Tal. On 8/21/07, Carl aniams <[EMAIL PROTECTED]> wrote: > > > Hi > > i'm presently using dialup admin for client connexion to the net. > but my handicap is the time counter. i would like to know if it would be > possible > to set graphical time counter for a customer . also is it possible to > increase the time limit > for a customer that may require an hour more. > if yes how please. > thanks > -- > -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ > > ANIAMBOSSOU Carl > NIAMS TECHNOLOGIES > tel: +229 90 04 08 58 +229 97 48 01 33 > COTONOU > REPUBLIC OF BENIN > WEST AFRICA > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
customise dialup admin
Hi i'm presently using dialup admin for client connexion to the net. but my handicap is the time counter. i would like to know if it would be possible to set graphical time counter for a customer . also is it possible to increase the time limit for a customer that may require an hour more. if yes how please. thanks -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ ANIAMBOSSOU Carl NIAMS TECHNOLOGIES tel: +229 90 04 08 58 +229 97 48 01 33 COTONOU REPUBLIC OF BENIN WEST AFRICA - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
problem with dialup admin, php
hi all, i'm using dialup admin on a freeradius server. i updated the folowing packages: php4 to php5, mysql4 to my sql5 with the corresponding php-mysql 5 when i browse my dialup admin interface the menu buttons do not appear and am rather asked to download the php file(eg buttons.php3) looking in the http error_access.log i have for the dialup admin page the message: undefined variable at /buttons.php3 Also all other other software installed containing php scripts and databases(index.php) do not open at all or open partially. i have in my httpd.conf *application*/x-httpd-php .php3 i'm using fedora core 4, freeradius1.1.6 -- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ ANIAMBOSSOU Carl NIAMS TECHNOLOGIES tel: +229 90 04 08 58 +229 97 48 01 33 COTONOU REPUBLIC OF BENIN WEST AFRICA - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: LDAP errror in dialup admin page
Apache is running as www and it can open and read file. But still I am getting the same error. On 7/29/2007, "Kostas Kalevras" <[EMAIL PROTECTED]> wrote: >O/H Bishal ÎγÏαÏε: >> I am trying to use freeradius 1.1.7 in Freebsd 6.2 with openldap 2.3.37 >> for authentication and mysql for accounting. >> >> While creating new user I get following error in dialup admin page: >> >> Warning: file(/usr/local/etc/raddb/ldap.attrmap) [function.file]: failed >> to open stream: Permission denied in >> /usr/local/www/apache22/data/dialupadmin/lib/ldap/attrmap.php3 on line 4 >> >I think the problem is exactly what is written. Check the persmissions >to the /usr/local/etc/raddb/ldap.attrmap file. Especially check that the >apache process (usually runs as nobody) can open the file. >> Warning: Invalid argument supplied for foreach() in >> /usr/local/www/apache22/data/dialupadmin/lib/ldap/attrmap.php3 on line 5 >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > >-- >Kostas Kalevras - Network Operations Center >National Technical University of Athens >http://kkalev.wordpress.com > >- >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: LDAP errror in dialup admin page
O/H Bishal έγραψε: > I am trying to use freeradius 1.1.7 in Freebsd 6.2 with openldap 2.3.37 > for authentication and mysql for accounting. > > While creating new user I get following error in dialup admin page: > > Warning: file(/usr/local/etc/raddb/ldap.attrmap) [function.file]: failed > to open stream: Permission denied in > /usr/local/www/apache22/data/dialupadmin/lib/ldap/attrmap.php3 on line 4 > I think the problem is exactly what is written. Check the persmissions to the /usr/local/etc/raddb/ldap.attrmap file. Especially check that the apache process (usually runs as nobody) can open the file. > Warning: Invalid argument supplied for foreach() in > /usr/local/www/apache22/data/dialupadmin/lib/ldap/attrmap.php3 on line 5 > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras - Network Operations Center National Technical University of Athens http://kkalev.wordpress.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
LDAP errror in dialup admin page
I am trying to use freeradius 1.1.7 in Freebsd 6.2 with openldap 2.3.37 for authentication and mysql for accounting. While creating new user I get following error in dialup admin page: Warning: file(/usr/local/etc/raddb/ldap.attrmap) [function.file]: failed to open stream: Permission denied in /usr/local/www/apache22/data/dialupadmin/lib/ldap/attrmap.php3 on line 4 Warning: Invalid argument supplied for foreach() in /usr/local/www/apache22/data/dialupadmin/lib/ldap/attrmap.php3 on line 5 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin accounting revers order
Have a suggestion to make a checkbox on accounting page which will enable reverse listing order. It is more convenient (imho) to see it last-like. --- /usr/share/webapps/freeradius-dialupadmin/1.70.3/htdocs/accounting.php 2007-03-01 11:58:34.0 +0200 +++ /var/www/adm/htdocs/du/accounting.php 2007-04-28 10:46:54.0 +0300 @@ -147,7 +147,7 @@ Max results returned: - + Reverse @@ -219,7 +219,8 @@ ' AND ' . ${"item_of_w$i"} . ' ' . ${"operator_of_w$i"} . " '" . ${"value_of_w$i"} . "'" ; $i++; } - +#phpinfo(); +$reverse = ($_REQUEST["revers"] != 'on') ? "ASC" : "DESC" ; $order = ($order_by != '') ? "$order_by" : 'username'; foreach ($accounting_show_attrs as $val) @@ -228,7 +229,7 @@ $sql_extra_query = ''; if ($config[sql_accounting_extra_query] != '') $sql_extra_query = sql_xlat($config[sql_accounting_extra_query],$login,$config); -$query="SELECT $query_view FROM $config[sql_accounting_table] $where $sql_extra_query ORDER BY $order LIMIT $maxresults;"; +$query="SELECT $query_view FROM $config[sql_accounting_table] $where $sql_extra_query ORDER BY $order $reverse LIMIT $maxresults;"; echo << -- Olimp, System Administrator IT Dept. Looking forward to reading yours. RUFF-RIPE DI76-GANDI RUFF-6BONE Ruslan N. Marchenko - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: failed login accounting with dialup admin
update to my fault because not RTFM first. I add another sql to the sql.conf sql sql_failed_reject { driver = "rlm_sql_mysql" server = "localhost" login = "xxx" password = "xxx" radius_db = "radius" postauth_table = "radpostauth" authcheck_table = "radcheck" authreply_table = "radreply" groupcheck_table = "radgroupcheck" groupreply_table = "radgroupreply" usergroup_table = "usergroup" nas_table = "nas" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" acct_table1 = "radacct" num_sql_socks = 3 connect_failure_retry_delay = 60 postauth_query = "INSERT into ${acct_table1} (radacctid, username, nasipaddress, nasportid, acctterminatecause, acctstarttime, acctstoptime, callingstationid, servicetype, framedprotocol, framedipaddress,acctauthentic) values ('', '%{User-Name}', '%{NAS-IP- Address}', '%{NAS-PORT}', '%{reply:Packet-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '% S', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '% {Framed-IP-Address}', '%{Acct-Authentic}')" } then I put sql_failed_reject to the postauth section in radiusd.conf post-auth { # Get an address from the IP Pool. # main_pool reply_log sql # sql_log # ldap Post-Auth-Type REJECT { #insert-module-name-here #sql sql_failed_reject } } modify dialup admin failed login page to check for Access Reject. that's it, now I can see failed user in dialup admin thanks for freeradius === On Wed, 2007-01-31 at 19:42 +0700, kemas wrote: > I have a small accounting problem with freeradius and dialup admin which > I can't find a way to solve it. > > I've set freeradius to authenticate EAP-TLS, I want to log people who > failed to authenticate to mysql with rlm_sql, which will show in dialup > admin failed login page. > > I put in radiusd.con post-auth section the sql module: > Post-Auth-Type REJECT { > #insert-module-name-here > sql > } > > the post-auth query in sql.conf: > postauth_query = "INSERT into ${postauth_table} (id, user, pass, > reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap- > Password}', '%{reply:Packet-Type}', NOW())" > > > the sql query runs well, it put the failed login to the radpostauth > table but the dialup admin failed login page is searching to the radacct > table for the failed user which will never find it. > > am I doing the right way to put the sql module inside the post-auth? or > should I put it in other section? > > I don't want to change the postauth_query but is there any way to add > another query to put the data to radacct table? > > 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
failed login accounting with dialup admin
I have a small accounting problem with freeradius and dialup admin which I can't find a way to solve it. I've set freeradius to authenticate EAP-TLS, I want to log people who failed to authenticate to mysql with rlm_sql, which will show in dialup admin failed login page. I put in radiusd.con post-auth section the sql module: Post-Auth-Type REJECT { #insert-module-name-here sql } the post-auth query in sql.conf: postauth_query = "INSERT into ${postauth_table} (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap- Password}', '%{reply:Packet-Type}', NOW())" the sql query runs well, it put the failed login to the radpostauth table but the dialup admin failed login page is searching to the radacct table for the failed user which will never find it. am I doing the right way to put the sql module inside the post-auth? or should I put it in other section? I don't want to change the postauth_query but is there any way to add another query to put the data to radacct table? thanks in advance - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin NAS List
Cory Robson wrote: Whilst this is a good example it still doesn't suit my purpose. It requires someone to constantly update the list for it to be effective. This is not to be confused with the clients. I have multiple roaming numbers, therefore if a customer is travelling around and dials in at different locations I will receive a diff NASIP from that local POP. As this information is provided in the account start/stop and update packets then why enter them manually. Just drill through the existing radacct table filtering on no stop time to see a list of active NAS's and display them as I wanted. No further updating the separate table. So edit lib/sql/nas_list.php3 to read the radacct table instead and set the nas type/port num variables to some default value. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kostas Kalevras Sent: Tuesday, 16 January 2007 6:53 PM To: FreeRadius users mailing list Subject: Re: Dialup Admin NAS List Cory Robson wrote: I'm hoping someone may be able to assist in modifying the user_finger.php script to retrieve the list of NAS's for the online users from radacct table. Why not just use the nas table. In the cvs version of dialupadmin there's a file called lib/sql/nas_list.php3 It will read the nas table and get the nas list. You could try changing that one if it suits your needs. Basically instead of reading the text file and cycling through them to add the breakdown of NAS's I want to use something like select DISTINCT NASIPAddress from radacct add them to an array and use the php gethostbyaddr() function to retrieve the true hostname to sort them by I don't need any of the snmp or NAS type or number of lines left as my upstream does not allow me to connect to verify the information anyway . This should just be a quick change for someone more talented than I to remove the existing loop and replace it with the relevant sql loop instead. Anyone ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1981 (20070116) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com - 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 NAS List
Whilst this is a good example it still doesn't suit my purpose. It requires someone to constantly update the list for it to be effective. This is not to be confused with the clients. I have multiple roaming numbers, therefore if a customer is travelling around and dials in at different locations I will receive a diff NASIP from that local POP. As this information is provided in the account start/stop and update packets then why enter them manually. Just drill through the existing radacct table filtering on no stop time to see a list of active NAS's and display them as I wanted. No further updating the separate table. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kostas Kalevras Sent: Tuesday, 16 January 2007 6:53 PM To: FreeRadius users mailing list Subject: Re: Dialup Admin NAS List Cory Robson wrote: > >I'm hoping someone may be able to assist in modifying the user_finger.php >script to retrieve the list of NAS's for the online users from radacct >table. > > Why not just use the nas table. In the cvs version of dialupadmin there's a file called lib/sql/nas_list.php3 It will read the nas table and get the nas list. You could try changing that one if it suits your needs. >Basically instead of reading the text file and cycling through them to add >the breakdown of NAS's I want to use something like > >select DISTINCT NASIPAddress >from radacct > >add them to an array and use the php gethostbyaddr() function to retrieve >the true hostname to sort them by > >I don't need any of the snmp or NAS type or number of lines left as my >upstream does not allow me to connect to verify the information anyway . > >This should just be a quick change for someone more talented than I to >remove the existing loop and replace it with the relevant sql loop instead. > >Anyone ? > > > > > > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1981 (20070116) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin NAS List
Cory Robson wrote: I'm hoping someone may be able to assist in modifying the user_finger.php script to retrieve the list of NAS's for the online users from radacct table. Why not just use the nas table. In the cvs version of dialupadmin there's a file called lib/sql/nas_list.php3 It will read the nas table and get the nas list. You could try changing that one if it suits your needs. Basically instead of reading the text file and cycling through them to add the breakdown of NAS's I want to use something like select DISTINCT NASIPAddress from radacct add them to an array and use the php gethostbyaddr() function to retrieve the true hostname to sort them by I don't need any of the snmp or NAS type or number of lines left as my upstream does not allow me to connect to verify the information anyway . This should just be a quick change for someone more talented than I to remove the existing loop and replace it with the relevant sql loop instead. Anyone ? - 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 NAS List
I'm hoping someone may be able to assist in modifying the user_finger.php script to retrieve the list of NAS's for the online users from radacct table. Basically instead of reading the text file and cycling through them to add the breakdown of NAS's I want to use something like select DISTINCT NASIPAddress from radacct add them to an array and use the php gethostbyaddr() function to retrieve the true hostname to sort them by I don't need any of the snmp or NAS type or number of lines left as my upstream does not allow me to connect to verify the information anyway . This should just be a quick change for someone more talented than I to remove the existing loop and replace it with the relevant sql loop instead. Anyone ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Daylight savings dialup admin
Since no one responded here is the additional code snippet to remedy the situation. $ts = date("U"); //gets current server date as a timestamp $tsgmt = date("Z"); //gets current server timestamp offset from GMT if ($tsgmt == "32400"){ //is current server timestamp offset equal to "32400" (9 hours) $hourdiff = "0"; //if 8 hours then $timediff = 0 hours }else{ $hourdiff = "1"; //if not 9 hours then $timediff = 1 hours (Daylight Saving) } $timeadjust = ($hourdiff * 3600); $perthdate = date("l, d F Y H:i:s T",time() + $timeadjust); $date = $perthdate; I'm having several problems still with the php scripting not display my current date time correctly. The system time is correct and mysql timestamps are correct both the console and mysql show the correct time and date showing the true daylight savings adjustment however the user_admin and user_finger page does not show this counters show the customer online time incorrect by an hour Any coders know how I can get php to show the correct time adjustment automatically? Thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1951 (20070101) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin help
I am using php4, works fine. I am using debian so all I had to do was 'apt-get install freeradius-dialupadmin' -- Don Schultz http://www.airdial.net > Does it work with PHP4 or should I install 3? > > > On 1/8/07 1:07 PM, "Greg Hartung" <[EMAIL PROTECTED]> wrote: > >> Any ideas where to begin? Is this an apache, php or mysql problem? >> >> >> On 1/5/07 9:14 PM, "Don Schultz" <[EMAIL PROTECTED]> wrote: >> >>> I'm still not completely done with my setup of dialupadmin but when I >>> first set things up I found that groups only display on the group page >>> if there are users in them. >>> >>> Second, a white screen suggests a problem. sql_debug does output to the >>> browser window, provided php and all that are working correctly. >>> >>> -- >>> Don Schultz >>> >>> Airdial Technologies >>> http://www.airdial.net >>> >>> >>> Greg Hartung wrote: >>>>I have had FreeRadius and Mysql have been authenticating users for >>>> months >>>> but now I am trying to get dialup admin working for the first time. >>>> The >>>> main page loads fine. "Find User" does load a search page but won't >>>> return >>>> any users and "Show Groups" loads a header with no groups. The rest >>>> of the >>>> menu items are either a blank white or blank green screen. >>>> >>>>I am using Mysql and I have configured user,pwd, dbname, etc. in >>>> admin.conf and I have run the 4 "create table" scripts. >>>> >>>>Does it log anywhere? >>>>How do I tell if it's hitting the db? >>>>Or what should I try next? >>>> >>>> Thanks! >>>> Greg >>>> >>>> - >>>> 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 > > - > 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 help
Does it work with PHP4 or should I install 3? On 1/8/07 1:07 PM, "Greg Hartung" <[EMAIL PROTECTED]> wrote: > Any ideas where to begin? Is this an apache, php or mysql problem? > > > On 1/5/07 9:14 PM, "Don Schultz" <[EMAIL PROTECTED]> wrote: > >> I'm still not completely done with my setup of dialupadmin but when I >> first set things up I found that groups only display on the group page >> if there are users in them. >> >> Second, a white screen suggests a problem. sql_debug does output to the >> browser window, provided php and all that are working correctly. >> >> -- >> Don Schultz >> >> Airdial Technologies >> http://www.airdial.net >> >> >> Greg Hartung wrote: >>>I have had FreeRadius and Mysql have been authenticating users for months >>> but now I am trying to get dialup admin working for the first time. The >>> main page loads fine. "Find User" does load a search page but won't return >>> any users and "Show Groups" loads a header with no groups. The rest of the >>> menu items are either a blank white or blank green screen. >>> >>>I am using Mysql and I have configured user,pwd, dbname, etc. in >>> admin.conf and I have run the 4 "create table" scripts. >>> >>>Does it log anywhere? >>>How do I tell if it's hitting the db? >>>Or what should I try next? >>> >>> Thanks! >>> Greg >>> >>> - >>> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin help
Any ideas where to begin? Is this an apache, php or mysql problem? On 1/5/07 9:14 PM, "Don Schultz" <[EMAIL PROTECTED]> wrote: > I'm still not completely done with my setup of dialupadmin but when I > first set things up I found that groups only display on the group page > if there are users in them. > > Second, a white screen suggests a problem. sql_debug does output to the > browser window, provided php and all that are working correctly. > > -- > Don Schultz > > Airdial Technologies > http://www.airdial.net > > > Greg Hartung wrote: >>I have had FreeRadius and Mysql have been authenticating users for months >> but now I am trying to get dialup admin working for the first time. The >> main page loads fine. "Find User" does load a search page but won't return >> any users and "Show Groups" loads a header with no groups. The rest of the >> menu items are either a blank white or blank green screen. >> >>I am using Mysql and I have configured user,pwd, dbname, etc. in >> admin.conf and I have run the 4 "create table" scripts. >> >>Does it log anywhere? >>How do I tell if it's hitting the db? >>Or what should I try next? >> >> Thanks! >> Greg >> >> - >> 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
Re: Dialup admin help
I'm still not completely done with my setup of dialupadmin but when I first set things up I found that groups only display on the group page if there are users in them. Second, a white screen suggests a problem. sql_debug does output to the browser window, provided php and all that are working correctly. -- Don Schultz Airdial Technologies http://www.airdial.net Greg Hartung wrote: I have had FreeRadius and Mysql have been authenticating users for months but now I am trying to get dialup admin working for the first time. The main page loads fine. "Find User" does load a search page but won't return any users and "Show Groups" loads a header with no groups. The rest of the menu items are either a blank white or blank green screen. I am using Mysql and I have configured user,pwd, dbname, etc. in admin.conf and I have run the 4 "create table" scripts. Does it log anywhere? How do I tell if it's hitting the db? Or what should I try next? Thanks! Greg - 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 help
The default for sql_debug is true and I left it that way but it's not at all clear where the output goes. I was thinking it was supposed to go to a log file which is why I was asking where to look, but now I wonder if it isn't supposed to go to the browser...? If so, I'm not getting anything but a white screen when I click on add user, so I can't enter one to see if it makes it into the db tables. The menu bar on the left is still there, but the entire right frame is just white. Ideas? On 1/5/07 4:50 PM, "Ali Jawad" <[EMAIL PROTECTED]> wrote: > Try setting sql_debug..or debug_sql to on in the main config file of > dialup admin and see if it yields any errors..to check if it is > workin..just create a users using dialup admin..and then check the > existance of the user in the mysql tables using phpmyadmin..the > created user should be there... > > On 1/6/07, Greg Hartung <[EMAIL PROTECTED]> wrote: >>I have had FreeRadius and Mysql have been authenticating users for months >> but now I am trying to get dialup admin working for the first time. The >> main page loads fine. "Find User" does load a search page but won't return >> any users and "Show Groups" loads a header with no groups. The rest of the >> menu items are either a blank white or blank green screen. >> >>I am using Mysql and I have configured user,pwd, dbname, etc. in >> admin.conf and I have run the 4 "create table" scripts. >> >>Does it log anywhere? >>How do I tell if it's hitting the db? >>Or what should I try next? >> >> Thanks! >> Greg >> >> - >> 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 help
Try setting sql_debug..or debug_sql to on in the main config file of dialup admin and see if it yields any errors..to check if it is workin..just create a users using dialup admin..and then check the existance of the user in the mysql tables using phpmyadmin..the created user should be there... On 1/6/07, Greg Hartung <[EMAIL PROTECTED]> wrote: I have had FreeRadius and Mysql have been authenticating users for months but now I am trying to get dialup admin working for the first time. The main page loads fine. "Find User" does load a search page but won't return any users and "Show Groups" loads a header with no groups. The rest of the menu items are either a blank white or blank green screen. I am using Mysql and I have configured user,pwd, dbname, etc. in admin.conf and I have run the 4 "create table" scripts. Does it log anywhere? How do I tell if it's hitting the db? Or what should I try next? Thanks! Greg - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- With Regards Ali Jawad - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin help
I have had FreeRadius and Mysql have been authenticating users for months but now I am trying to get dialup admin working for the first time. The main page loads fine. "Find User" does load a search page but won't return any users and "Show Groups" loads a header with no groups. The rest of the menu items are either a blank white or blank green screen. I am using Mysql and I have configured user,pwd, dbname, etc. in admin.conf and I have run the 4 "create table" scripts. Does it log anywhere? How do I tell if it's hitting the db? Or what should I try next? Thanks! Greg - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Daylight savings dialup admin
I'm having several problems still with the php scripting not display my current date time correctly. The system time is correct and mysql timestamps are correct both the console and mysql show the correct time and date showing the true daylight savings adjustment however the user_admin and user_finger page does not show this counters show the customer online time incorrect by an hour Any coders know how I can get php to show the correct time adjustment automatically? Thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin coding - help required
On 12/21/06, Cory Robson <[EMAIL PROTECTED]> wrote: Anyway this is my code for my failed login page, my sql query does parse all information into the array ok but I just cannot seem to get it to output on screen. Any way here is what I have so far anyone able to assist in showing me where I'm going wrong. First, see Owen's reply (which I haven't quoted). I believe he's nailed the issue and his code would most likely work, though I would do it like this: [snip code] *// Here is my screen output, obviously I need to loop through the array and output the lines but just can't figure it out. *// [snip code] Both Owen's code and mine should have the same effect, however I've found that the above is sometimes easier to read and "keep track of". And I like to keep my HTML and PHP "blocks" separate as much as possible. -j -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin coding - help required
I don't have an environment to test this, and, I'm no PHP expert, but, I've got some similar stuff working, and, I suspect that the changes below might work for you... You can't include PHP variables in HTML text outside of the tags and expect them to be interpolated. Generally, it's just easier to use PHP echo statements for things that require variables to be interpolated. Below is an example of your code with this resolved. No guarantees, but, hopefully it points you in the right direction. In case you don't know, pretty good documentation with examples for PHP can be found at www.php.net. Owen Failed logins link="black" alink="black"> Could not include SQL library functions. Aborting EOM; exit(); } $now = time(); $start = $now - ($last*60); $now_str = date($config[sql_full_date_format],$now); $prev_str = date($config[sql_full_date_format],$start); ?> Failed Logins link="black" alink="black"> Failed Logins #loginPasswordTimeTerminate causeCaller ID *// Here is my screen output, obviously I need to loop through the array and output the lines but just can't figure it out. *// echo "\n" echo " $num\n" echo " $acct_login echo " $acct_password echo " $acct_time echo " $acct_terminate_cause echo " $acct_callingid echo " } ?> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ users.html smime.p7s Description: S/MIME cryptographic signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin coding - help required
Ok I have tried and tried to get this to work how I want but obviously need more sleep, not being a code genius and trying to learn this mix and mash is confusing enough. Anyway this is my code for my failed login page, my sql query does parse all information into the array ok but I just cannot seem to get it to output on screen. Any way here is what I have so far anyone able to assist in showing me where I'm going wrong. Failed logins Could not include SQL library functions. Aborting EOM; exit(); } $now = time(); $start = $now - ($last*60); $now_str = date($config[sql_full_date_format],$now); $prev_str = date($config[sql_full_date_format],$start); ?> Failed Logins Failed Logins #loginPasswordTimeTerminate causeCaller ID *// Here is my screen output, obviously I need to loop through the array and output the lines but just can't figure it out. *// $num $acct_login $acct_password $acct_time $acct_terminate_cause $acct_callingid - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
huntgroups, sql and dialup admin
hi, i configured freeradius using configuration files( user, huntgroups, clients, ...). it works great. now i 'd like to be able to manage my radius server with the web GUI dailup admin. my issue is that i don't see how i can put a nas ip in a huntgroup with this GUI. Can i have my nasip list / huntgroup in an sql DB to be able to manage it with dialup admin or can i only use the huntroups file ? with more than 400 nas it it could be usefull. thank you for your help, regards, jey- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup admin Display users online (suggestion)
Cory Robson wrote: I am slowly getting around this interface and notice many things that could be improved upon but I'm lacking in the coding department. For example the user_finger.php page, this does a nice job once you have manually entered all of the pops into the separate naslist file but can become a royal pain to maintain. If someone could rewrite the code to extract the users online from the raddact table and simply group them by the independent nas's this would be a far simpler method. As you added additional pops to your range nothing to add/remove in the code, it simply regenerates as people log in from that pool. If you are using sql to keep radius client info then you don't need to do any extra work, since you already have your clients added in the table for freeradius to function correctly. What you are suggesting isn't a lot of work. The idea was to have more information than just the ip of the nas server though (like description, ports available). In any case it could be added as a configuration option I have done a very similar thing with the failed logins page. Have the sql query dumping failed logins into the postauth table from the radius process and then have dialup admin failed logins script running an sql query against that table instead. Alas my coding is not that good so I'm not getting all records just the last one. Again help would be needed for me to finish this. It's a nice thought. Anyone up to the task to assist in this matter Regards Cory Robson - 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 Display users online (suggestion)
On 12/21/06, Cory Robson <[EMAIL PROTECTED]> wrote: I am slowly getting around this interface and notice many things that could be improved upon but I'm lacking in the coding department. [snip] Anyone up to the task to assist in this matter Looks like commercial support is available for FreeRADIUS[1]. I'm sure you could find someone willing to make these modifications for you at a small fee (including me). Otherwise, you're basically stuck until such time as someone gets around to it on their own. -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Dialup admin Display users online (suggestion)
I am slowly getting around this interface and notice many things that could be improved upon but I'm lacking in the coding department. For example the user_finger.php page, this does a nice job once you have manually entered all of the pops into the separate naslist file but can become a royal pain to maintain. If someone could rewrite the code to extract the users online from the raddact table and simply group them by the independent nas's this would be a far simpler method. As you added additional pops to your range nothing to add/remove in the code, it simply regenerates as people log in from that pool. I have done a very similar thing with the failed logins page. Have the sql query dumping failed logins into the postauth table from the radius process and then have dialup admin failed logins script running an sql query against that table instead. Alas my coding is not that good so I'm not getting all records just the last one. Again help would be needed for me to finish this. Anyone up to the task to assist in this matter Regards Cory Robson - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup Admin
I'm really new to the whole radius thing, however, I think you need to have snmp to your nas properly setup for this to work. On 5/15/06, Jeremy ohara <[EMAIL PROTECTED]> wrote: Wondering if anyone can help me with Dialup Admin. what the current problem is. when i look at online users. it shows the nas server but saying noone is online. and when i go to view the user who is online it says they are not online can anyone help me here. if you need more info plz tell me Jeremy This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. - 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
Wondering if anyone can help me with Dialup Admin. what the current problem is. when i look at online users. it shows the nas server but saying noone is online. and when i go to view the user who is online it says they are not online can anyone help me here. if you need more info plz tell me Jeremy This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
Am Donnerstag, den 06.04.2006, 16:58 +0300 schrieb Peter Nixon: > We have developed a new sqlippool module which exclusively uses SQL (Tested > with Postgresql) and doesn't require configuration in radiusd.conf (at least > no more than the existing sql module) Great Peter. It must have been telepathy :) > > We are currently load testing this for stability and will be rolling it into > production tomorrow if all goes well. At that point we will also commit it to > FR cvs. That sounds good. I've just had a look into the snapshot from 9th of april - it's not there. I'm anxious to see it running on my machine. > > I suggest you wait a few days before you do too much more coding :-) Ok, good idea :) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
We have developed a new sqlippool module which exclusively uses SQL (Tested with Postgresql) and doesn't require configuration in radiusd.conf (at least no more than the existing sql module) We are currently load testing this for stability and will be rolling it into production tomorrow if all goes well. At that point we will also commit it to FR cvs. I suggest you wait a few days before you do too much more coding :-) Cheers Peter On Wed 29 Mar 2006 12:28, Olaf Schäfer wrote: > > the sqlippool module in cvs does this.. > > This module sounds interesting - something I haven't take into my > considerations keeping the dynamic ippool data in the sql-db, too. And > it's obvious to do it this way using a primary and a backup server. > > But the configuration information like "range-start" etc. is still > stored in the radiusd.conf. My idea was to put these configuration > information for each ippool into the mysql-db. > > Some background information for better understanding :) My task is to > migrate from MS-IAS to freeradius. Thus people are used to do > administration tasks with a GUI. :) At least normal production > administration tasks should be integrated within a GUI. Putting > configuration information into a db would save the parsing and editing > the radius.conf by dialup-admin scripts. > > best regards, > Olaf > > - > 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 pgpZU1V4Zaem7.pgp Description: PGP signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
Laker Netman <[EMAIL PROTECTED]> wrote: > Has there been any consideration to using an XML > config file? Yes. It won't be happening. Ever. XML config files are a complete waste of time. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
Has there been any consideration to using an XML config file? Laker --- Olaf Sch�fer <[EMAIL PROTECTED]> wrote: > > > > > > But the configuration information like > "range-start" etc. is still > > > stored in the radiusd.conf. My idea was to put > these configuration > > > information for each ippool into the mysql-db. > > > > That may be harder to do. But if you can create > a patch, it will be > > welcome. > > I'm afraid this exceeds my abilities :( > > Thus I resigned to the fact and have started to > parse the radiusd.conf > via PHP. > > Olaf Schaefer > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
On Fri, 2006-31-03 at 10:37 +0200, Olaf Schäfer wrote: > > > > > > But the configuration information like "range-start" etc. is still > > > stored in the radiusd.conf. My idea was to put these configuration > > > information for each ippool into the mysql-db. > > > > That may be harder to do. But if you can create a patch, it will be > > welcome. > > I'm afraid this exceeds my abilities :( > > Thus I resigned to the fact and have started to parse the radiusd.conf > via PHP. > I have written a recursive function for reading radiusd.conf and all included files. I finally spent some time and built a simple site to host the current files for the FreeRadius Admin stuff I am working on. You can check it out at : http://sphinx.incentre.net/radius.html -- Guy Fraser Network Administrator The Internet Centre 1-888-450-6787 (780)450-6787 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
> > > > But the configuration information like "range-start" etc. is still > > stored in the radiusd.conf. My idea was to put these configuration > > information for each ippool into the mysql-db. > > That may be harder to do. But if you can create a patch, it will be > welcome. I'm afraid this exceeds my abilities :( Thus I resigned to the fact and have started to parse the radiusd.conf via PHP. Olaf Schaefer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
Olaf =?ISO-8859-1?Q?Sch=E4fer?= <[EMAIL PROTECTED]> wrote: > This module sounds interesting - something I haven't take into my > considerations keeping the dynamic ippool data in the sql-db, too. And > it's obvious to do it this way using a primary and a backup server. > > But the configuration information like "range-start" etc. is still > stored in the radiusd.conf. My idea was to put these configuration > information for each ippool into the mysql-db. That may be harder to do. But if you can create a patch, it will be welcome. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
> the sqlippool module in cvs does this.. This module sounds interesting - something I haven't take into my considerations keeping the dynamic ippool data in the sql-db, too. And it's obvious to do it this way using a primary and a backup server. But the configuration information like "range-start" etc. is still stored in the radiusd.conf. My idea was to put these configuration information for each ippool into the mysql-db. Some background information for better understanding :) My task is to migrate from MS-IAS to freeradius. Thus people are used to do administration tasks with a GUI. :) At least normal production administration tasks should be integrated within a GUI. Putting configuration information into a db would save the parsing and editing the radius.conf by dialup-admin scripts. best regards, Olaf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup admin & ippool administraton
On Tue 28 Mar 2006 14:23, [EMAIL PROTECTED] wrote: > Hi, > > I need a GUI for administration of the ippool-feature. Currently I'm using > freeradius 1.1.1 with dialup admin 1.8 from CVS. The ippool-feature works > fine, my aim is to add/edit/delete ip-pools within the dialup-admin. > > I know, I have to parse the radiusd.conf and write an approperiate > php-script. > My questions: > - Has anybody done this before? Any suggestions? > - Is it possible to put the ippool-information into a table of the > radius-db (like the nas list) and let freeradius use the information in > this table instead of the radiusd.conf? the sqlippool module in cvs does this.. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc pgpsZm5UNOvhS.pgp Description: PGP signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
dialup admin & ippool administraton
Hi, I need a GUI for administration of the ippool-feature. Currently I'm using freeradius 1.1.1 with dialup admin 1.8 from CVS. The ippool-feature works fine, my aim is to add/edit/delete ip-pools within the dialup-admin. I know, I have to parse the radiusd.conf and write an approperiate php-script. My questions: - Has anybody done this before? Any suggestions? - Is it possible to put the ippool-information into a table of the radius-db (like the nas list) and let freeradius use the information in this table instead of the radiusd.conf? - Are there security issues, letting dialup-admin write into the radiusd.conf file? with best regards, olaf -- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
sqlcounter and dialup admin issue
hello list, i'm using freeradius 1.1.0 with mysql 5.0.x and dialup_admin i want to use the monthly counter function of the sqlcounter module. I've added "checkItem MaxMonthlySession MaxMonthlySession" to sql.attrmap also added: MaxMonthlySession to user_edit.attrs in the radiusd.conf added "monthlycounter" in the authorize section. freeradius loading the module: http://pastebin.com/542929 I add a user from dialup_admin with a maxmonthlysession = 14400 for example and when the user tries to log in radius says: " 1. Tue Feb 7 10:47:14 2006 : Info: rlm_sql (sql): No matching entry in the database for request from user [het] 2. Tue Feb 7 10:47:14 2006 : Auth: Login incorrect: [het/het] (from client pppoe-as port 0 cli 00:0A:EB:40:9F:FD) " if i don't specify maxmonthlysession the user logs fine. any idea? -- regards, Georgi Alexandrov Key Server = http://pgp.mit.edu/ :: KeyID = 37B4B3EE Key Fingerprint = E429 BF93 FA67 44E9 B7D4 F89E F990 01C1 37B4 B3EE signature.asc Description: OpenPGP digital signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin problem
Hi, > OK - I think I figured out my problem, although not sure exactly which > correction I did fixed it. However, I am still getting the MySQL Debug > output and was wondering how to get rid of it: > > DEBUG(SQL,MYSQL DRIVER): Query: SELECT groupname FROM usergroup WHERE > username = 'srmiller'; > DEBUG(SQL,MYSQL DRIVER): Query Result: um, debugging is enabled by default. it helps fix things for the new installers. to 'shut it up' you simply edit the admin.conf in the conf/ directorylook for the obvious line: sql_debug: true and comment it out alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup-admin problem
OK - I think I figured out my problem, although not sure exactly which correction I did fixed it. However, I am still getting the MySQL Debug output and was wondering how to get rid of it: DEBUG(SQL,MYSQL DRIVER): Query: SELECT groupname FROM usergroup WHERE username = 'srmiller'; DEBUG(SQL,MYSQL DRIVER): Query Result: Thanks, Scott Miller - Original Message - From: "Scott Miller" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, February 06, 2006 10:45 AM Subject: Re: dialup-admin problem Thanks for all the help. I verified that "error_reporting" is set to E_ALL, and have changed "display_errors" to On. Now, when I go to dialup-admin I get the first page fine, but when I click a link, here's the errors it displays: (above link window) Notice: Undefined variable: HTTP_SERVER_VARS in /usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 22 - (inside link window - above links) Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup-admin/conf/config.php3 on line 8 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line 61 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 66 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 69 Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined index: general_username_mappings_file in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 91 - (Right side when I click on "Find User" (all others have alot more "notice" statements:) Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup-admin/conf/config.php3 on line 8 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line 61 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 66 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 69 Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined index: general_username_mappings_file in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined variable: search_IN in /usr/local/dialup-admin/htdocs/find.php3 on line 3 Notice: Undefined variable: radius_attr in /usr/local/dialup-admin/htdocs/find.php3 on line 4 Notice: Undefined variable: max_results in /usr/local/dialup-admin/htdocs/find.php3 on line 5 I was getting permissions errors, but then changed group ownership to "apache" and set the entire directory to "755" Any help with these errors would be appriciated. Thanks, Scott Miller - Original Message ----- From: "Rich Marriner" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Tuesday, January 24, 2006 10:05 AM Subject: Re: dialup-admin problem FreeBSD 6.0 Apache 2.2.0 PHP 5.1.1 FreeRadius 1.0.5 Dialup_admin works fine for me. It does appear to be a PHP problem. Look at your apache logs and see what errors you are getting if any. You might want to check the "error_reporting" setting in your php.ini, make sure it is set to E_ALL so you can see what errors are occuring. If this is not a production box you might even want to change "display_errors" to On. This should give you a couple more "hints" on where to go next. Rich Scott Miller wrote: I've found that my problem might be with Apache 2 and PHP 5 - does anyone else have dialup-admin running properly on Apache 2 and PHP 5? I'd hate to think I'd have to downgrade. Thanks, Scott - Original Message - From: "Scott Miller" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, January 23, 2006 1:03 PM Subject: dialup-admin problem I've installed freeradius 1.1.0, went through all the tests and everything (the tests) seems to be working fine there. My platform is: Fedora Core 4 Sendmail 8.13.4 Apache 2.0.54 MySQL 4.1.16 PHP 5.0.5-2.1 Freeradius 1.1.0 I've also followed the instructions for the dialup-admin, and have run into a problem. When I view servername.com/dialup-admin, I can see the fi
Re: dialup-admin problem
OK - I've figured out my own problem (I think) but not sure exactly what I did - BUT it seems to be working fine. However, how do I get rid of the MySQL Debug output such as: - Original Message - From: "Scott Miller" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, February 06, 2006 10:45 AM Subject: Re: dialup-admin problem Thanks for all the help. I verified that "error_reporting" is set to E_ALL, and have changed "display_errors" to On. Now, when I go to dialup-admin I get the first page fine, but when I click a link, here's the errors it displays: (above link window) Notice: Undefined variable: HTTP_SERVER_VARS in /usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 22 - (inside link window - above links) Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup-admin/conf/config.php3 on line 8 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line 61 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 66 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 69 Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined index: general_username_mappings_file in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 91 - (Right side when I click on "Find User" (all others have alot more "notice" statements:) Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup-admin/conf/config.php3 on line 8 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line 61 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 66 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 69 Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined index: general_username_mappings_file in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined variable: search_IN in /usr/local/dialup-admin/htdocs/find.php3 on line 3 Notice: Undefined variable: radius_attr in /usr/local/dialup-admin/htdocs/find.php3 on line 4 Notice: Undefined variable: max_results in /usr/local/dialup-admin/htdocs/find.php3 on line 5 I was getting permissions errors, but then changed group ownership to "apache" and set the entire directory to "755" Any help with these errors would be appriciated. Thanks, Scott Miller - Original Message ----- From: "Rich Marriner" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Tuesday, January 24, 2006 10:05 AM Subject: Re: dialup-admin problem FreeBSD 6.0 Apache 2.2.0 PHP 5.1.1 FreeRadius 1.0.5 Dialup_admin works fine for me. It does appear to be a PHP problem. Look at your apache logs and see what errors you are getting if any. You might want to check the "error_reporting" setting in your php.ini, make sure it is set to E_ALL so you can see what errors are occuring. If this is not a production box you might even want to change "display_errors" to On. This should give you a couple more "hints" on where to go next. Rich Scott Miller wrote: I've found that my problem might be with Apache 2 and PHP 5 - does anyone else have dialup-admin running properly on Apache 2 and PHP 5? I'd hate to think I'd have to downgrade. Thanks, Scott - Original Message - From: "Scott Miller" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, January 23, 2006 1:03 PM Subject: dialup-admin problem I've installed freeradius 1.1.0, went through all the tests and everything (the tests) seems to be working fine there. My platform is: Fedora Core 4 Sendmail 8.13.4 Apache 2.0.54 MySQL 4.1.16 PHP 5.0.5-2.1 Freeradius 1.1.0 I've also followed the instructions for the dialup-admin, and have run into a problem. When I view servername.com/dialup-admin, I can see the first page just fine, but when I click on any link on the left, the right side just turns white - nothing displays. The "home" link brings me back to the "A web
Re: dialup-admin problem
Thanks for all the help. I verified that "error_reporting" is set to E_ALL, and have changed "display_errors" to On. Now, when I go to dialup-admin I get the first page fine, but when I click a link, here's the errors it displays: (above link window) Notice: Undefined variable: HTTP_SERVER_VARS in /usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 22 - (inside link window - above links) Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup-admin/conf/config.php3 on line 8 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line 61 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 66 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 69 Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined index: general_username_mappings_file in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 91 - (Right side when I click on "Find User" (all others have alot more "notice" statements:) Notice: import_request_variables() [function.import-request-variables]: No prefix specified - possible security hazard in /usr/local/dialup-admin/conf/config.php3 on line 8 Notice: Use of undefined constant general_use_session - assumed 'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line 61 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 66 Notice: Undefined variable: login in /usr/local/dialup-admin/conf/config.php3 on line 69 Notice: Use of undefined constant general_username_mappings_file - assumed 'general_username_mappings_file' in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined index: general_username_mappings_file in /usr/local/dialup-admin/conf/config.php3 on line 76 Notice: Undefined variable: search_IN in /usr/local/dialup-admin/htdocs/find.php3 on line 3 Notice: Undefined variable: radius_attr in /usr/local/dialup-admin/htdocs/find.php3 on line 4 Notice: Undefined variable: max_results in /usr/local/dialup-admin/htdocs/find.php3 on line 5 I was getting permissions errors, but then changed group ownership to "apache" and set the entire directory to "755" Any help with these errors would be appriciated. Thanks, Scott Miller - Original Message - From: "Rich Marriner" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Tuesday, January 24, 2006 10:05 AM Subject: Re: dialup-admin problem FreeBSD 6.0 Apache 2.2.0 PHP 5.1.1 FreeRadius 1.0.5 Dialup_admin works fine for me. It does appear to be a PHP problem. Look at your apache logs and see what errors you are getting if any. You might want to check the "error_reporting" setting in your php.ini, make sure it is set to E_ALL so you can see what errors are occuring. If this is not a production box you might even want to change "display_errors" to On. This should give you a couple more "hints" on where to go next. Rich Scott Miller wrote: I've found that my problem might be with Apache 2 and PHP 5 - does anyone else have dialup-admin running properly on Apache 2 and PHP 5? I'd hate to think I'd have to downgrade. Thanks, Scott - Original Message - From: "Scott Miller" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, January 23, 2006 1:03 PM Subject: dialup-admin problem I've installed freeradius 1.1.0, went through all the tests and everything (the tests) seems to be working fine there. My platform is: Fedora Core 4 Sendmail 8.13.4 Apache 2.0.54 MySQL 4.1.16 PHP 5.0.5-2.1 Freeradius 1.1.0 I've also followed the instructions for the dialup-admin, and have run into a problem. When I view servername.com/dialup-admin, I can see the first page just fine, but when I click on any link on the left, the right side just turns white - nothing displays. The "home" link brings me back to the "A web based administration interface for the freeradius radius server " page, but no other links seem to bring anyting up. Here's what I did: 1. Copied the directory dialup-admin to the /user/local/ directory 2. In /var/www/html I created a simlink /user/local/dialup-admin/htdocs named dialup-admin ln -s /usr/local/dialup-admin/htdocs /var/www/html/dialup-admin 3. Edited httpd.co
Re: dialup-admin problem
Mine too is FreeBSD 6.0 with Apache2.2.0 and php5.1 Dialup admin works fine only one dialup menu option i.e "Statistics" when I click on it, gives the error as follows; Warning: mktime() expects parameter 1 to be long, string given in /usr/home/httpd/baayu.com/dialbaayu/lib/functions.php3 on line 83 Warning: mktime() expects parameter 1 to be long, string given in /usr/home/httpd/baayu.com/dialbaayu/lib/functions.php3 on line 83 == On 1/24/2006, "Scott Miller" <[EMAIL PROTECTED]> wrote: >I've found that my problem might be with Apache 2 and PHP 5 - does anyone >else have dialup-admin running properly on Apache 2 and PHP 5? I'd hate to >think I'd have to downgrade. > >Thanks, >Scott > > >- Original Message - >From: "Scott Miller" <[EMAIL PROTECTED]> >To: "FreeRadius users mailing list" >Sent: Monday, January 23, 2006 1:03 PM >Subject: dialup-admin problem > > >> I've installed freeradius 1.1.0, went through all the tests and everything >> (the tests) seems to be working fine there. My platform is: >> >> Fedora Core 4 >> Sendmail 8.13.4 >> Apache 2.0.54 >> MySQL 4.1.16 >> PHP 5.0.5-2.1 >> Freeradius 1.1.0 >> >> I've also followed the instructions for the dialup-admin, and have run >> into a problem. When I view servername.com/dialup-admin, I can see the >> first page just fine, but when I click on any link on the left, the right >> side just turns white - nothing displays. The "home" link brings me back >> to the "A web based administration interface for the freeradius radius >> server " page, but no other links seem to bring anyting up. >> >> Here's what I did: >> >> 1. Copied the directory dialup-admin to the /user/local/ directory >> 2. In /var/www/html I created a simlink /user/local/dialup-admin/htdocs >> named dialup-admin >> ln -s /usr/local/dialup-admin/htdocs /var/www/html/dialup-admin >> 3. Edited httpd.conf to the following >> >># Scott Added for freeradius dialup-admin >>#LoadModule php4_module libexec/libphp4.so >>#AddModule mod_php4.c >>AddType application/x-httpd-php .php >>AddType application/x-httpd-php .php3 >> >> I had to comment out the fist two lines, because httpd kept failing and >> producing the error: Apache 1.3 configuration directives found please read >> /usr/share/doc/httpd-2.0.54/migration.html >> >> 4. I did not do: [1.3.2.2] Creating a more secure web interface. - >> wanting to make it work first, then will start securing it. >> 5. Created the 4 additional MySQL Databases according to the instructions >> and all look fine. >> 6. I then went through the general configuraiton options. I commented >> out all LDAP options, and fixed the following: >> >> >> general_prefered_lang: en >> general_prefered_lang_name: English >> general_charset: iso-8859-1 >> #general_decode_normal_attributes: yes >> general_base_dir: /usr/local/dialup-admin >> general_radiusd_base_dir: /usr/local/radiusd >> general_use_session: no >> general_most_recent_fl: 30 >> #general_strip_realms : yes >> general_realm_delimiter: @ >> general_realm_format: suffix >> general_show_user_password: yes >> general_raddb_dir: %{general_radiusd_base_dir}/etc/raddb >> general_ldap_attrmap: %{general_raddb_dir}/ldap.attrmap >> #general_clients_conf: %{general_raddb_dir}/clients.conf >> general_clients_conf: /usr/local/etc/raddb/clients.conf >> general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap >> general_accounting_attrs_file: %{general_base_dir}/conf/accounting.attrs >> general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap >> 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 >> general_finger_type: snmp >> general_nas_type: cisco >> general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger >> general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient >> general_test_account_login: test >> general_test_account_password: testpass >> general_radius_server: localhost >> general_radius_server_port: 1812 >> general_radius_server_auth_proto: pap >> general_radius_server_secret: commented-out >> ge
Re: dialup-admin problem
FreeBSD 6.0 Apache 2.2.0 PHP 5.1.1 FreeRadius 1.0.5 Dialup_admin works fine for me. It does appear to be a PHP problem. Look at your apache logs and see what errors you are getting if any. You might want to check the "error_reporting" setting in your php.ini, make sure it is set to E_ALL so you can see what errors are occuring. If this is not a production box you might even want to change "display_errors" to On. This should give you a couple more "hints" on where to go next. Rich Scott Miller wrote: I've found that my problem might be with Apache 2 and PHP 5 - does anyone else have dialup-admin running properly on Apache 2 and PHP 5? I'd hate to think I'd have to downgrade. Thanks, Scott - Original Message - From: "Scott Miller" <[EMAIL PROTECTED]> To: "FreeRadius users mailing list" Sent: Monday, January 23, 2006 1:03 PM Subject: dialup-admin problem I've installed freeradius 1.1.0, went through all the tests and everything (the tests) seems to be working fine there. My platform is: Fedora Core 4 Sendmail 8.13.4 Apache 2.0.54 MySQL 4.1.16 PHP 5.0.5-2.1 Freeradius 1.1.0 I've also followed the instructions for the dialup-admin, and have run into a problem. When I view servername.com/dialup-admin, I can see the first page just fine, but when I click on any link on the left, the right side just turns white - nothing displays. The "home" link brings me back to the "A web based administration interface for the freeradius radius server " page, but no other links seem to bring anyting up. Here's what I did: 1. Copied the directory dialup-admin to the /user/local/ directory 2. In /var/www/html I created a simlink /user/local/dialup-admin/htdocs named dialup-admin ln -s /usr/local/dialup-admin/htdocs /var/www/html/dialup-admin 3. Edited httpd.conf to the following # Scott Added for freeradius dialup-admin #LoadModule php4_module libexec/libphp4.so #AddModule mod_php4.c AddType application/x-httpd-php .php AddType application/x-httpd-php .php3 I had to comment out the fist two lines, because httpd kept failing and producing the error: Apache 1.3 configuration directives found please read /usr/share/doc/httpd-2.0.54/migration.html 4. I did not do: [1.3.2.2] Creating a more secure web interface. - wanting to make it work first, then will start securing it. 5. Created the 4 additional MySQL Databases according to the instructions and all look fine. 6. I then went through the general configuraiton options. I commented out all LDAP options, and fixed the following: general_prefered_lang: en general_prefered_lang_name: English general_charset: iso-8859-1 #general_decode_normal_attributes: yes general_base_dir: /usr/local/dialup-admin general_radiusd_base_dir: /usr/local/radiusd general_use_session: no general_most_recent_fl: 30 #general_strip_realms : yes general_realm_delimiter: @ general_realm_format: suffix general_show_user_password: yes general_raddb_dir: %{general_radiusd_base_dir}/etc/raddb general_ldap_attrmap: %{general_raddb_dir}/ldap.attrmap #general_clients_conf: %{general_raddb_dir}/clients.conf general_clients_conf: /usr/local/etc/raddb/clients.conf general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap general_accounting_attrs_file: %{general_base_dir}/conf/accounting.attrs general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap 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 general_finger_type: snmp general_nas_type: cisco general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient general_test_account_login: test general_test_account_password: testpass general_radius_server: localhost general_radius_server_port: 1812 general_radius_server_auth_proto: pap general_radius_server_secret: commented-out general_auth_request_file: %{general_base_dir}/conf/auth.request general_encryption_method: crypt general_accounting_info_order: desc general_stats_use_totacct: no general_restrict_badusers_access: no INCLUDE: %{general_base_dir}/conf/naslist.conf INCLUDE: %{general_base_dir}/conf/captions.conf #ldap_server: ldap.%{general_domain} #ldap_write_server: master.%{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 #ldap_use_http_credentials: yes #ldap_directory_manager: cn=Directory Manager #ldap_map_to_directory_manager: admin #ldap_debug: true # Allow for defining the ldap filter used when sea