Re: MySQL and FreeRADIUS environment

[Arran Cudbard-Bell]

On 6 Oct 2011, at 10:19, Alan DeKok wrote:

> Arran Cudbard-Bell wrote:
>> raddb/sites-available/buffered-sql
> 
>  He's already been told MULTIPLE times where to look.
> 
>  I can only conclude he's lazy, or he's trying to be rude.

Ah, was in auto-help mode. Blame it on the iGrief.

Arran Cudbard-Bell
a.cudba...@freeradius.org

Betelwiki, Betelwiki, Betelwiki http://wiki.freeradius.org/ !

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment

[tonimanel]

Sorry did not mean to cause this series of comments to me. I just found
something missing, I think, by the discrepancy between files with respect to
the installation I have done and what you say here. Once again I apologize.

Thanks.

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4875626.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: MySQL and FreeRADIUS environment

[Alan DeKok]

Arran Cudbard-Bell wrote:
> raddb/sites-available/buffered-sql

  He's already been told MULTIPLE times where to look.

  I can only conclude he's lazy, or he's trying to be rude.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment

[Arran Cudbard-Bell]

On 6 Oct 2011, at 09:59, tonimanel wrote:

> Sorry, can you tell me where are "detail file readers for examples"?
> 
> Thank you for your help. We apologize for any inconvenience caused

raddb/sites-available/buffered-sql

-Arran

Arran Cudbard-Bell
a.cudba...@freeradius.org

Betelwiki, Betelwiki, Betelwiki http://wiki.freeradius.org/ !

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment

[tonimanel]

Sorry, can you tell me where are "detail file readers for examples"?

Thank you for your help. We apologize for any inconvenience caused

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4875532.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: MySQL and FreeRADIUS environment

[Alan DeKok]

tonimanel wrote:
> I have readed the "sites-available/example" file that contains an example of
> how to define a client and a server.

  i.e. you didn't do what you were told to do.

>  I should to define a client and a
> server in both machines (serverA's client is server B AND serverB's client
> is server A). Do you understand me? 

  I have no idea.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment

[tonimanel]

I have readed the "sites-available/example" file that contains an example of
how to define a client and a server. I should to define a client and a
server in both machines (serverA's client is server B AND serverB's client
is server A). Do you understand me? 

Thanks again.

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872439.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: MySQL and FreeRADIUS environment

[Alan DeKok]

tonimanel wrote:
> I have readed the example file. I have some doubts. 
> 
> Do I get with this example file? I don't have a radrelay.conf example (or is
> this?) 

  Yes, you do.  See the raddb/ directory.

> ... I have readed in Internet that in radiusd.conf I should to define
> a detail block information like detail detail-name {some information} to get
> two binary files with my main server data (then the other server should to
> use to replicate data), it is true?

  You could try reading the examples that come with the server.  The
examples you were told to read.

  Why search the internet when you have the answers in front of you?

> And then I should create radrelay.conf
> file (because not exists in /etc/freeradius) with what information? I think
> that with listen block of copy-acct-to-home-server file, it is true?

  The server comes with a sample radrelay.conf.  See the "tar" file on
the web site.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MySQL and FreeRADIUS environment

[tonimanel]

I have readed the example file. I have some doubts. 

Do I get with this example file? I don't have a radrelay.conf example (or is
this?) ... I have readed in Internet that in radiusd.conf I should to define
a detail block information like detail detail-name {some information} to get
two binary files with my main server data (then the other server should to
use to replicate data), it is true? And then I should create radrelay.conf
file (because not exists in /etc/freeradius) with what information? I think
that with listen block of copy-acct-to-home-server file, it is true?

Then, when I have got radrelay.conf file with listen block information from
"copy-acct-to-home-server" file, where I should to define the second server?
I think that in some place I should to define the second server for make the
replica...

Can you help me? Can you tell me about that?

Thank you.

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872393.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: MySQL and FreeRADIUS environment

[tonimanel]

I'm going to read this example file. I don't know if I will understand it but
I will try it.

Thanks,

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872336.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: MySQL and FreeRADIUS environment

[Fajar A. Nugraha]

On Wed, Oct 5, 2011 at 4:57 PM, tonimanel
 wrote:
> Hi again,
>
> How can I do freeradius replication with radrelay? Do you know any tutorial
> or howto?

Have you READ the suggested documentation? For example, Alan said
"Also, raddb/sites-available/copy-acct-to-home-server"

I also wrote earlier rerarding FR-managed replication: "In this setup
the user data needs to be synced manually though."

-- 
Fajar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment

[tonimanel]

My FreeRADIU version is 2.1.10 on Debian. Suggest me update? Or is a valid
verstion to work and implement freeradius replication with radrelay?

Thanks,

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872269.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: MySQL and FreeRADIUS environment

[tonimanel]

Hi again,

How can I do freeradius replication with radrelay? Do you know any tutorial
or howto?

I have a basic freeradius service installed and function!!!

Thanks!

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872147.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: MySQL and FreeRADIUS environment

[Alan DeKok]

tonimanel wrote:
> Is possible to make the data replica with TCP protocol with FreeRADIUS? Do
> you prefer FreeRADIUS replica or mysql replica? What is the best solution to
> make the replica?

  The best solution is to use RADIUS replication.  FreeRADIUS knows how
to do conflict resolution in the database.  MySQL does not.

  See "raddb/radrelay.conf", and the detail file readers for examples.
Also, raddb/sites-available/copy-acct-to-home-server

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment

[tonimanel]

Hi again, 
I have a doubt, what happen if in my company we want to have two servers,
both with freeradius service and mysql service and this two servers could be
actives with mysql data replicated? We would like to have two servers as
actives with the ability to be both functional. I think that is more
difficult than the other solution but this is best. 

Is possible to make the data replica with TCP protocol with FreeRADIUS? Do
you prefer FreeRADIUS replica or mysql replica? What is the best solution to
make the replica?


Thank you very much!!! I hope your answers!!

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4868964.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: MySQL and FreeRADIUS environment

[Fajar A. Nugraha]

On Fri, Sep 30, 2011 at 9:19 PM, tonimanel
 wrote:
> Hi, thank you for your answer.
>
> We are thinking in two servers: First server with one freeradius and mysql
> service, both services as actives. Second server, another freeradius service
> with mysql service running also. Two servers must to have data replicated.
>

Like I said, eaerlier there are many possible configuration with
varying degrees of cost and
complexity, depending on how much you can tolerate a single point of
failure.

If you have a somewhat experienced MySQL admin you could create a
master-master replication. It's not really a cluster, but should be
enough for simple purposes:
http://www.google.co.id/search?q=mysql+master+master+replication

On the other hand, if you have more experience in freeradius, you
could create two independent instances and have FR replicate
accounting data to each other (or have each FR instance write to two
db, possibly with buffered sql) to maintain sync. In this setup the
user data needs to be synced manually though.


> I think that this is the best solution for my company, it's possible with
> mysql and freeradius in Debian?

It's not really a matter of which distro, but rather expertise. If you
use a distro with recent-enough version of freeradius, or willing to
compile from source, it should work.

-- 
Fajar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySQL and FreeRADIUS environment.

[tonimanel]

Hi, thank you for your answer. 

I think the same.

We are thinking in two servers: First server with one freeradius and mysql
service, both services as actives. Second server, another freeradius service
with mysql service running also. Two servers must to have data replicated. 

I think that this is the best solution for my company, it's possible with
mysql and freeradius in Debian? Do you know how we have to make the
configuration to replicate data for mysql and freeradius? 

Thanks 



--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/Fwd-MySQL-and-FreeRADIUS-environment-tp4846037p4857295.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: MySQL and FreeRADIUS environment

[tonimanel]

Hi, thank you for your answer. 

We are thinking in two servers: First server with one freeradius and mysql
service, both services as actives. Second server, another freeradius service
with mysql service running also. Two servers must to have data replicated. 

I think that this is the best solution for my company, it's possible with
mysql and freeradius in Debian?

Thanks

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4857276.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: MySQL and FreeRADIUS environment

[Fajar A. Nugraha]

On Tue, Sep 27, 2011 at 11:32 PM, tonimanel
 wrote:
> Hi everybody,
>
> In my company we are thinking to implement a FreeRADIUS server with MySQL on
> Linux. We need to duplicate FreeRADIUS service because we think that this is
> a critical service for us but the authentication process only could be done
> with the master server(FreeRADIUS and MySQL service, both in only one
> server). For the other hand, if we want to replicate the data base servers,
> we would have to synchronize two database servers but we would not know wich
> would be the best solution, cluster or synchronize. Maybe we will not to
> need a MySQL cluster service and we will need two servers only. First with
> master FreeRADIUS service and master MySQL service and the second with slave
> FreeRADIUS service and slave MySQL service.
>
> What do you think about the best solution to implement this environment?

Hire someone who have implement a similar setup.

There are many possible configuration with varying degrees of cost and
complexity, depending on how much you can tolerate a single point of
failure.

The easiest way would be to have two or more servers running FR with
one mysql master and many mysql slaves (FR and mysql can use the same
server), with distributed sql reads (i.e. SELECT) and writes only to
the master. In the event of failure, you need to manually (for maximum
consistency) promote one slave to be master.

The most complex way would be to setup a full mysql cluster, possibly
with each server acting as FR, data node, and sql node.

-- 
Fajar
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment.

[Alexander Clouter]

Alan Buxey  wrote:
> 
> Master/slave, or replication and remote accounting, if you want one 
> true source let radius deal with the sql rather than trying anything 
> with sql. Final advice would be to use postgresql rather than mysql, 
> our performance increase was a magnitude better when we ditched mysql
> 
Our experience has been that using MySQL pretty much guarantees you 
*will* be burnt...especially with the replication.

Cheers

-- 
Alexander Clouter
.sigmonster says: I'm having a MID-WEEK CRISIS!

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySQL and FreeRADIUS environment.

[Tim Sylvester]

I would recommend two servers using MySQL Replication.

 

1.   Master Server with FreeRADIUS and MySQL Master; write accounting
packets to MySQL

2.   Replica Server with FreeRADIUS and MySQL Replica; forward
accounting packets to Master for writing to MySQL

 

As for performance, my record is 3,000 authentications/sec on a server using
MySQL. That’s over 10 million authentications per hour and a ¼ billion per
day. That should be enough to start with.

 

Tim

 

 

From:
freeradius-users-bounces+tim.sylvester=networkradius@lists.freeradius.or
g
[mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freer
adius.org] On Behalf Of Antonio Fernández Pérez
Sent: Tuesday, September 27, 2011 9:33 AM
To: freeradius-users@lists.freeradius.org
Subject: Fwd: MySQL and FreeRADIUS environment.

 

Hi everybody,

 

In my company we are thinking to implement a FreeRADIUS server with MySQL on
Linux. We need to duplicate FreeRADIUS service because we think that this is
a critical service for us but the authentication process only could be done
with the master server(FreeRADIUS and MySQL service, both in only one
server). For the other hand, if we want to replicate the data base servers,
we would have to synchronize two database servers but we would not know wich
would be the best solution, cluster or synchronize. Maybe we will not to
need a MySQL cluster service and we will need two servers only. First with
master FreeRADIUS service and master MySQL service and the second with slave
FreeRADIUS service and slave MySQL service.

 

What do you think about the best solution to implement this environment?

 

I hope your answer. Thank you very much.

 

Regards, 

 

-- 


Antonio Manuel Fernández Pérez

Ingeniero Técnico Informático

Dpto. Informático Fabergames S.L.

TLF:96626 / FAX:966551801

 <http://www.fabergames.com/> www.fabergames.com
Fabergames respeta su privacidad
<http://www.fabergames.com/index.php/component/content/article/57/1-politica
-de-privacidad> 

* * * ADVERTENCIA LEGAL * * *

Le informamos, como destinatario de este mensaje, que el correo electrónico
y las comunicaciones por medio de Internet no permiten asegurar ni
garantizar la confidencialidad de los mensajes transmitidos, así como
tampoco su integridad o su correcta recepción, por lo que FABERGAMES S.L. no
asume responsabilidad alguna por tales circunstancias. Si no consintiese en
la utilización del correo electrónico o de las comunicaciones vía Internet
le rogamos nos lo comunique y ponga en nuestro conocimiento de manera
inmediata. Este mensaje va dirigido, de manera exclusiva, a su destinatario
y contiene información confidencial y sujeta al secreto profesional, cuya
divulgación no está permitida por la ley. En caso de haber recibido este
mensaje por error, le rogamos que, de forma inmediata, nos lo comunique
mediante correo electrónico remitido a nuestra atención o a través del
teléfono (+ 34) 966 26 11 11 y proceda a su eliminación, así como a la de
cualquier documento adjunto al mismo. Asimismo, le comunicamos que la
distribución, copia o utilización de este mensaje, o de cualquier documento
adjunto al mismo, cualquiera que fuera su finalidad, están prohibidas por la
ley.

 

 

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRADIUS environment.

[Alan Buxey]

Master/slave, or replication and remote accounting, if you want one true source 
let radius deal with the sql rather than trying anything with sql. Final advice 
would be to use postgresql rather than mysql, our performance increase was a 
magnitude better when we ditched mysql

alan

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Fwd: MySQL and FreeRADIUS environment.

[Antonio Fernández Pérez]

Hi everybody,

In my company we are thinking to implement a FreeRADIUS server with MySQL on
Linux. We need to duplicate FreeRADIUS service because we think that this is
a critical service for us but the authentication process only could be done
with the master server(FreeRADIUS and MySQL service, both in only one
server). For the other hand, if we want to replicate the data base servers,
we would have to synchronize two database servers but we would not know wich
would be the best solution, cluster or synchronize. Maybe we will not to
need a MySQL cluster service and we will need two servers only. First with
master FreeRADIUS service and master MySQL service and the second with slave
FreeRADIUS service and slave MySQL service.

What do you think about the best solution to implement this environment?

I hope your answer. Thank you very much.

Regards,

-- 

*Antonio Manuel Fernández Pérez*

Ingeniero Técnico Informático

Dpto. Informático Fabergames S.L.

TLF:96626 / FAX:966551801

www.fabergames.com
Fabergames respeta su
privacidad

* * * ADVERTENCIA LEGAL * * *

Le informamos, como destinatario de este mensaje, que el correo electrónico
y las comunicaciones por medio de Internet no permiten asegurar ni
garantizar la confidencialidad de los mensajes transmitidos, así como
tampoco su integridad o su correcta recepción, por lo que FABERGAMES S.L. no
asume responsabilidad alguna por tales circunstancias. Si no consintiese en
la utilización del correo electrónico o de las comunicaciones vía Internet
le rogamos nos lo comunique y ponga en nuestro conocimiento de manera
inmediata. Este mensaje va dirigido, de manera exclusiva, a su destinatario
y contiene información confidencial y sujeta al secreto profesional, cuya
divulgación no está permitida por la ley. En caso de haber recibido este
mensaje por error, le rogamos que, de forma inmediata, nos lo comunique
mediante correo electrónico remitido a nuestra atención o a través del
teléfono (+ 34) 966 26 11 11 y proceda a su eliminación, así como a la de
cualquier documento adjunto al mismo. Asimismo, le comunicamos que la
distribución, copia o utilización de este mensaje, o de cualquier documento
adjunto al mismo, cualquiera que fuera su finalidad, están prohibidas por la
ley.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MySQL and FreeRADIUS environment

[tonimanel]

Hi everybody,

In my company we are thinking to implement a FreeRADIUS server with MySQL on
Linux. We need to duplicate FreeRADIUS service because we think that this is
a critical service for us but the authentication process only could be done
with the master server(FreeRADIUS and MySQL service, both in only one
server). For the other hand, if we want to replicate the data base servers,
we would have to synchronize two database servers but we would not know wich
would be the best solution, cluster or synchronize. Maybe we will not to
need a MySQL cluster service and we will need two servers only. First with
master FreeRADIUS service and master MySQL service and the second with slave
FreeRADIUS service and slave MySQL service.

What do you think about the best solution to implement this environment?

I hope your answer. Thank you very much.

Regards, 

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4845985.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: about simultaneous when using mysql and freeradius

[Alan DeKok]

Spacelee wrote:
> my nas client is pptp and ppp, how can i set pptp to send updates every
> 5 minutes?

  See the PPTP documentation.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: about simultaneous when using mysql and freeradius

[Spacelee]

my nas client is pptp and ppp, how can i set pptp to send updates every 5
minutes?

On Tue, Jun 1, 2010 at 7:13 PM, Marinko Tarlac  wrote:

> Here we go again
>
> 1. add datetime column at the end of radacct table (name it for example
> last_update_column)
> 2. edit queries in dialup.conf (for 2.x FR) or sql.conf (for 1.x FR) so
> every update will update this column to (for example update radacct set
> , last_update_column = NOW() ).
>
> Now you will have the correct time when was the last update for specific
> session.
>
> 3. write php, perl, shell or any other script which you can start with cron
> and check if there is any active sessions (acctstoptime = null or
> acctstoptime = 0) which last update was X minutes ago.
>
> For example, X can be 11 minutes and you can set up your NAS to send
> updates every 5 minutes. This means that you can have at least 2 updates
> before you close session with cron script.
> This is not the only way to solve this problem but it works with all FR
> version, and it doesn't depend on your NAS(es). Also, this isn't ideal
> solution because if your NAS goes off and on again before you received stop
> packets, all users will need to wait X minutes before they can connect
> again. (there are no updates so last_update_column will be unchanged and the
> cron script will close all sessions after X minutes)
>
>
> Spacelee wrote:
>
>> sorry, does the radcheck.pl  included in freeradius
>> now? does you mean /usr/sbin/checkrad ?
>>
>>
>>
>> and i search the keywords "Simultaneous mysql radius down" , but found no
>> results i need.
>>
>> 2010/6/1 Anton mailto:w...@stack.ru>>
>>
>>
>>It should be done by NAS. For example PPPoE and PPTP have lcp
>>packets, If no response for some time from
>>client to NAS then NAS decides that session is down and sends
>>acct-stop packet to radius server. Radius
>>server sets the corresponding record to SQL session table.
>>
>>Or there is another method: depending on NAS type radiusd can
>>connect to NAS and check activity of user
>>session directly on NAS - this is more reliable source of
>>information. See radcheck.pl .
>>
>>
>>
>>On Tue, 1 Jun 2010 16:24:54 +0700
>>Spacelee mailto:fjct...@gmail.com>> wrote:
>>
>>>
>>> i want to limit user's behavior, such as a username can login
>>only once at the same time...
>>>
>>> 1、modifiy default and inner-tunnel in
>>>
>>> #  Session database, used for checking Simultaneous-Use. Either
>>the radutmp
>>> #  or rlm_sql module can handle this.
>>> #  The rlm_sql module is *much* faster
>>> session {
>>> #radutmp
>>>
>>> #  See "Simultaneous Use Checking Querie" in sql.conf
>>> sql
>>>
>>> }
>>> 2、modify dialup.conf in etc/raddb/sql/mysql
>>>
>>> # Uncomment simul_count_query to enable simultaneous use checking
>>>
>>> simul_count_query = "SELECT COUNT(*) \
>>> FROM ${acct_table1} \
>>> WHERE username = '%{SQL-User-Name}' \
>>>  AND acctstoptime IS NULL"
>>>
>>> 3、add a entry to the table radgorucheck
>>> INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` ,
>>`op` , `Value` )
>>> VALUES (
>>> NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
>>> );
>>>
>>> 4. update the user "test"  to the group "user"
>>>
>>>
>>> i finally tried successfully, but if , i say if the radius
>>server was down suddenly or the user logout
>>> improperly(such as he poweroff the computer directly). then the
>>record will still be record in the table as
>>> he was still online ...so we need to modify the record, but how
>>to ? can freeradius judge it by itself, or
>>> how to judge the user if offline ?
>>>
>>> --
>>> Spacelee
>>>
>>>
>>>
>>> --
>>> Spacelee
>>
>>
>>--
>>Anton [WARM-RIPE]
>>Stack ltd division head
>>tel. 8 (3822) 555-797
>>
>>
>>-
>>List info/subscribe/unsubscribe? See
>>http://www.freeradius.org/list/users.html
>>
>>
>>
>>
>> --
>> Spacelee
>> 
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>



-- 
Spacelee
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: about simultaneous when using mysql and freeradius

[Marinko Tarlac]

Here we go again

1. add datetime column at the end of radacct table (name it for example 
last_update_column)
2. edit queries in dialup.conf (for 2.x FR) or sql.conf (for 1.x FR) so 
every update will update this column to (for example update radacct set 
, last_update_column = NOW() ).


Now you will have the correct time when was the last update for specific 
session.


3. write php, perl, shell or any other script which you can start with 
cron and check if there is any active sessions (acctstoptime = null or 
acctstoptime = 0) which last update was X minutes ago.


For example, X can be 11 minutes and you can set up your NAS to send 
updates every 5 minutes. This means that you can have at least 2 updates 
before you close session with cron script. 

This is not the only way to solve this problem but it works with all FR 
version, and it doesn't depend on your NAS(es). Also, this isn't ideal 
solution because if your NAS goes off and on again before you received 
stop packets, all users will need to wait X minutes before they can 
connect again. (there are no updates so last_update_column will be 
unchanged and the cron script will close all sessions after X minutes)



Spacelee wrote:
sorry, does the radcheck.pl  included in 
freeradius now? does you mean /usr/sbin/checkrad ?



and i search the keywords "Simultaneous mysql radius down" , but found 
no results i need.


2010/6/1 Anton mailto:w...@stack.ru>>

It should be done by NAS. For example PPPoE and PPTP have lcp
packets, If no response for some time from
client to NAS then NAS decides that session is down and sends
acct-stop packet to radius server. Radius
server sets the corresponding record to SQL session table.

Or there is another method: depending on NAS type radiusd can
connect to NAS and check activity of user
session directly on NAS - this is more reliable source of
information. See radcheck.pl .


On Tue, 1 Jun 2010 16:24:54 +0700
Spacelee mailto:fjct...@gmail.com>> wrote:

>
> i want to limit user's behavior, such as a username can login
only once at the same time...
>
> 1、modifiy default and inner-tunnel in
>
> #  Session database, used for checking Simultaneous-Use. Either
the radutmp
> #  or rlm_sql module can handle this.
> #  The rlm_sql module is *much* faster
> session {
> #radutmp
>
> #  See "Simultaneous Use Checking Querie" in sql.conf
> sql
>
> }
> 2、modify dialup.conf in etc/raddb/sql/mysql
>
> # Uncomment simul_count_query to enable simultaneous use checking
>
> simul_count_query = "SELECT COUNT(*) \
> FROM ${acct_table1} \
> WHERE username = '%{SQL-User-Name}' \
>  AND acctstoptime IS NULL"
>
> 3、add a entry to the table radgorucheck
> INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` ,
`op` , `Value` )
> VALUES (
> NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
> );
>
> 4. update the user "test"  to the group "user"
>
>
> i finally tried successfully, but if , i say if the radius
server was down suddenly or the user logout
> improperly(such as he poweroff the computer directly). then the
record will still be record in the table as
> he was still online ...so we need to modify the record, but how
to ? can freeradius judge it by itself, or
> how to judge the user if offline ?
>
> --
> Spacelee
>
>
>
> --
> Spacelee


--
Anton [WARM-RIPE]
Stack ltd division head
tel. 8 (3822) 555-797


-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html




--
Spacelee


-
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: about simultaneous when using mysql and freeradius

[Anton]

Yes, this is /usr/sbin/checkrad. Sorry for mistake.

You should read this script ...

Radiusd can be down or unrichable or packet can be loss. If You have NAS one of 
this type You can specify
this type in clients.conf (nastype = cisco). After than radiusd should use 
/usr/sbin/checkrad to check
simultaneous logins.

But if You have a situation when NAS has opened working session and radiusd has 
no records about it in
session table You can get double login. AFAIK in this case radiusd will not do 
simultaneous check at all.
But it should not happen -- when radiusd goes down suddenly the records in SQL 
session table should be stay
like opened sessions. And after radiusd starts again it thinks that that 
sessions are active :-), in this case
radiusd will use checkrad if nastype is configured to check his SQL records.

Moreover if You will connect simultaneously very fast (faster then Your SQL can 
handle queries) and without
using checkrad then You will get simultaneous logins too. This is because there 
is no any transaction is SQL
schema or no other method to make single unique login attempt in a time for SQL 
can see them like separate
tries.


On Tue, 1 Jun 2010 17:21:26 +0700
Spacelee  wrote:

> sorry, does the radcheck.pl included in freeradius now? does you mean 
> /usr/sbin/checkrad ?
> 
> 
> and i search the keywords "Simultaneous mysql radius down" , but found no 
> results i need.
> 
> 2010/6/1 Anton mailto:w...@stack.ru>>
> It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no 
> response for some time from
> client to NAS then NAS decides that session is down and sends acct-stop 
> packet to radius server. Radius
> server sets the corresponding record to SQL session table.
> 
> Or there is another method: depending on NAS type radiusd can connect to NAS 
> and check activity of user
> session directly on NAS - this is more reliable source of information. See 
> radcheck.pl.
> 
> 
> On Tue, 1 Jun 2010 16:24:54 +0700
> Spacelee mailto:fjct...@gmail.com>> wrote:
> 
> >
> > i want to limit user's behavior, such as a username can login only once at 
> > the same time...
> >
> > 1、modifiy default and inner-tunnel in
> >
> > #  Session database, used for checking Simultaneous-Use. Either the radutmp
> > #  or rlm_sql module can handle this.
> > #  The rlm_sql module is *much* faster
> > session {
> > #radutmp
> >
> > #  See "Simultaneous Use Checking Querie" in sql.conf
> > sql
> >
> > }
> > 2、modify dialup.conf in etc/raddb/sql/mysql
> >
> > # Uncomment simul_count_query to enable simultaneous use checking
> >
> > simul_count_query = "SELECT COUNT(*) \
> > FROM ${acct_table1} \
> > WHERE username = '%{SQL-User-Name}' \
> >  AND acctstoptime IS NULL"
> >
> > 3、add a entry to the table radgorucheck
> > INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , 
> > `Value` )
> > VALUES (
> > NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
> > );
> >
> > 4. update the user "test"  to the group "user"
> >
> >
> > i finally tried successfully, but if , i say if the radius server was down 
> > suddenly or the user logout
> > improperly(such as he poweroff the computer directly). then the record will 
> > still be record in the table
> > as he was still online ...so we need to modify the record, but how to ? can 
> > freeradius judge it by
> > itself, or how to judge the user if offline ?
> >
> > --
> > Spacelee
> >
> >
> >
> > --
> > Spacelee
> 
> 
> --
> Anton [WARM-RIPE]
> Stack ltd division head
> tel. 8 (3822) 555-797
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> 
> 
> --
> Spacelee


-- 
Anton [WARM-RIPE]
Stack ltd division head
tel. 8 (3822) 555-797


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: about simultaneous when using mysql and freeradius

[Spacelee]

sorry, does the radcheck.pl included in freeradius now? does you mean
/usr/sbin/checkrad ?


and i search the keywords "Simultaneous mysql radius down" , but found no
results i need.

2010/6/1 Anton 

> It should be done by NAS. For example PPPoE and PPTP have lcp packets, If
> no response for some time from
> client to NAS then NAS decides that session is down and sends acct-stop
> packet to radius server. Radius
> server sets the corresponding record to SQL session table.
>
> Or there is another method: depending on NAS type radiusd can connect to
> NAS and check activity of user
> session directly on NAS - this is more reliable source of information. See
> radcheck.pl.
>
>
> On Tue, 1 Jun 2010 16:24:54 +0700
> Spacelee  wrote:
>
> >
> > i want to limit user's behavior, such as a username can login only once
> at the same time...
> >
> > 1、modifiy default and inner-tunnel in
> >
> > #  Session database, used for checking Simultaneous-Use. Either the
> radutmp
> > #  or rlm_sql module can handle this.
> > #  The rlm_sql module is *much* faster
> > session {
> > #radutmp
> >
> > #  See "Simultaneous Use Checking Querie" in sql.conf
> > sql
> >
> > }
> > 2、modify dialup.conf in etc/raddb/sql/mysql
> >
> > # Uncomment simul_count_query to enable simultaneous use checking
> >
> > simul_count_query = "SELECT COUNT(*) \
> > FROM ${acct_table1} \
> > WHERE username = '%{SQL-User-Name}' \
> >  AND acctstoptime IS NULL"
> >
> > 3、add a entry to the table radgorucheck
> > INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` ,
> `Value` )
> > VALUES (
> > NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
> > );
> >
> > 4. update the user "test"  to the group "user"
> >
> >
> > i finally tried successfully, but if , i say if the radius server was
> down suddenly or the user logout
> > improperly(such as he poweroff the computer directly). then the record
> will still be record in the table as
> > he was still online ...so we need to modify the record, but how to ? can
> freeradius judge it by itself, or
> > how to judge the user if offline ?
> >
> > --
> > Spacelee
> >
> >
> >
> > --
> > Spacelee
>
>
> --
> Anton [WARM-RIPE]
> Stack ltd division head
> tel. 8 (3822) 555-797
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>



-- 
Spacelee
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: about simultaneous when using mysql and freeradius

[Anton]

It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no 
response for some time from
client to NAS then NAS decides that session is down and sends acct-stop packet 
to radius server. Radius
server sets the corresponding record to SQL session table.

Or there is another method: depending on NAS type radiusd can connect to NAS 
and check activity of user
session directly on NAS - this is more reliable source of information. See 
radcheck.pl.
  

On Tue, 1 Jun 2010 16:24:54 +0700
Spacelee  wrote:

> 
> i want to limit user's behavior, such as a username can login only once at 
> the same time...
> 
> 1、modifiy default and inner-tunnel in
> 
> #  Session database, used for checking Simultaneous-Use. Either the radutmp
> #  or rlm_sql module can handle this.
> #  The rlm_sql module is *much* faster
> session {
> #radutmp
> 
> #  See "Simultaneous Use Checking Querie" in sql.conf
> sql
> 
> }
> 2、modify dialup.conf in etc/raddb/sql/mysql
> 
> # Uncomment simul_count_query to enable simultaneous use checking
> 
> simul_count_query = "SELECT COUNT(*) \
> FROM ${acct_table1} \
> WHERE username = '%{SQL-User-Name}' \
>  AND acctstoptime IS NULL"
> 
> 3、add a entry to the table radgorucheck
> INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , 
> `Value` )
> VALUES (
> NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
> );
> 
> 4. update the user "test"  to the group "user"
> 
> 
> i finally tried successfully, but if , i say if the radius server was down 
> suddenly or the user logout
> improperly(such as he poweroff the computer directly). then the record will 
> still be record in the table as
> he was still online ...so we need to modify the record, but how to ? can 
> freeradius judge it by itself, or
> how to judge the user if offline ?
> 
> --
> Spacelee
> 
> 
> 
> --
> Spacelee


-- 
Anton [WARM-RIPE]
Stack ltd division head
tel. 8 (3822) 555-797


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: about simultaneous when using mysql and freeradius

[Marinko Tarlac]

I already wrote about this problem on this list. Please search before 
asking...




Spacelee wrote:


i want to limit user's behavior, such as a username can login only 
once at the same time...


1、modifiy default and inner-tunnel in

#  Session database, used for checking Simultaneous-Use. Either the 
radutmp 
#  or rlm_sql module can handle this.

#  The rlm_sql module is *much* faster
session {
#radutmp

#  See "Simultaneous Use Checking Querie" in sql.conf
sql

}
2、modify dialup.conf in etc/raddb/sql/mysql

# Uncomment simul_count_query to enable simultaneous use checking
 
simul_count_query = "SELECT COUNT(*) \

FROM ${acct_table1} \
WHERE username = '%{SQL-User-Name}' \
 AND acctstoptime IS NULL"
   
3、add a entry to the table radgorucheck 
INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` 
, `Value` ) 
VALUES ( 
NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’

);

4. update the user "test"  to the group "user"


i finally tried successfully, but if , i say if the radius server was 
down suddenly or the user logout improperly(such as he poweroff the 
computer directly). then the record will still be record in the table 
as he was still online ...so we need to modify the record, but how to 
? can freeradius judge it by itself, or how to judge the user if offline ?


--
Spacelee



--
Spacelee


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

about simultaneous when using mysql and freeradius

[Spacelee]

i want to limit user's behavior, such as a username can login only once at
the same time...

1、modifiy default and inner-tunnel in

#  Session database, used for checking Simultaneous-Use. Either the radutmp
#  or rlm_sql module can handle this.
#  The rlm_sql module is *much* faster
session {
#radutmp

#  See "Simultaneous Use Checking Querie" in sql.conf
sql

}
2、modify dialup.conf in etc/raddb/sql/mysql

# Uncomment simul_count_query to enable simultaneous use checking

simul_count_query = "SELECT COUNT(*) \
FROM ${acct_table1} \
WHERE username = '%{SQL-User-Name}' \
 AND acctstoptime IS NULL"

3、add a entry to the table radgorucheck
INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` ,
`Value` )
VALUES (
NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’
);

4. update the user "test"  to the group "user"


i finally tried successfully, but if , i say if the radius server was down
suddenly or the user logout improperly(such as he poweroff the computer
directly). then the record will still be record in the table as he was still
online ...so we need to modify the record, but how to ? can freeradius judge
it by itself, or how to judge the user if offline ?

-- 
Spacelee



-- 
Spacelee
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

problems with queries and user database in mysql and freeradius

[VU VAN HUNG]

Hi all,
I'm trying to manage the users in freeradius with mysql. Users can log 
in wireless network successfully but I get 2 problems.
1. Only post-authenticate query's implemented to insert information to  
radpostauth table in radius database. Accouting queries for accounting 
table in database're not implemented.
2. When I only use sql to manage users, I totally dont configure in 
users file of freeradius, users cant login to network.

I hope someones will help me solve these problems.
Here my out put from radiusd -X command:

rad_recv: Access-Request packet from host 192.168.0.2 port 1024, id=141, 
length=145

   User-Name = "hung"
   NAS-IP-Address = 192.168.0.2
   NAS-Port = 0
   Called-Station-Id = "00-1E-E5-9B-9A-FE:LCK"
   Calling-Station-Id = "00-17-C4-8C-2C-C8"
   Framed-MTU = 1400
   NAS-Port-Type = Wireless-802.11
   Connect-Info = "CONNECT 11Mbps 802.11b"
   EAP-Message = 0x02090168756e67
   Message-Authenticator = 0x92a2c1dd019f55542bef82c3b6b122b9
+- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
[eap] EAP packet type response id 0 length 9
[eap] No EAP Start, assuming it's an on-going EAP conversation
++[eap] returns updated
++[unix] returns notfound
[files] users: Matched entry hung at line 91
++[files] returns ok
[sql] expand: %{Stripped-User-Name} ->
[sql] expand: %{User-Name} -> hung
[sql] expand: %{%{User-Name}:-DEFAULT} -> hung
[sql] expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> hung
[sql] sql_set_user escaped user --> 'hung'
rlm_sql (sql): Reserving sql socket id: 4
[sql] expand: SELECT id, username, attribute, op, value   
FROM radcheck   WHERE username = '%{SQL-User-Name}'ORDER 
BY id -> SELECT id, username, attribute, op, value   FROM 
radcheck   WHERE username = 'hung'ORDER BY id
[sql] expand: SELECT groupname   FROM usergroup   
WHERE username = '%{SQL-User-Name}'   ORDER BY priority -> 
SELECT groupname   FROM usergroup   WHERE username = 
'hung'   ORDER BY priority
[sql] expand: SELECT id, groupname, attribute,op, 
Value   FROM radgroupcheck   WHERE groupname = 
'%{Sql-Group}'   ORDER BY id -> SELECT id, groupname, 
attribute,op, Value   FROM radgroupcheck   
WHERE groupname = 'WLANgroup'   ORDER BY id

[sql] User found in group WLANgroup
[sql] expand: SELECT id, groupname, attribute,op, 
Value   FROM radgroupreply   WHERE groupname = 
'%{Sql-Group}'   ORDER BY id -> SELECT id, groupname, 
attribute,op, Value   FROM radgroupreply   
WHERE groupname = 'WLANgroup'   ORDER BY id

rlm_sql (sql): Released sql socket id: 4
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
[pap] Found existing Auth-Type, not changing it.
++[pap] returns noop
Found Auth-Type = EAP
+- entering group authenticate {...}
[eap] EAP Identity
[eap] processing type tls
[tls] Initiate
[tls] Start returned 1
++[eap] returns handled
Sending Access-Challenge of id 141 to 192.168.0.2 port 1024
   EAP-Message = 0x010100061520
   Message-Authenticator = 0x
   State = 0x09945ffc09954a3c3aef342532c8f473
Finished request 0.
Going to the next request
Waking up in 4.9 seconds.
rad_recv: Access-Request packet from host 192.168.0.2 port 1024, id=141, 
length=145

Sending duplicate reply to client localhost port 1024 - ID: 141
Sending Access-Challenge of id 141 to 192.168.0.2 port 1024
Waking up in 4.9 seconds.
rad_recv: Access-Request packet from host 192.168.0.2 port 1024, id=142, 
length=160

   User-Name = "hung"
   NAS-IP-Address = 192.168.0.2
   NAS-Port = 0
   Called-Station-Id = "00-1E-E5-9B-9A-FE:LCK"
   Calling-Station-Id = "00-17-C4-8C-2C-C8"
   Framed-MTU = 1400
   NAS-Port-Type = Wireless-802.11
   Connect-Info = "CONNECT 11Mbps 802.11b"
   EAP-Message = 0x020100060319
   State = 0x09945ffc09954a3c3aef342532c8f473
   Message-Authenticator = 0x560713ad902723d908cff078aab76337
+- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
[eap] EAP packet type response id 1 length 6
[eap] No EAP Start, assuming it's an on-going EAP conversation
++[eap] returns updated
++[unix] returns notfound
[files] users: Matched entry hung at line 91
++[files] returns ok
[sql] expand: %{Stripped-User-Name} ->
[sql] expand: %{User-Name} -> hung
[sql] expand: %{%{User-Name}:-DEFAULT} -> hung
[sql] expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> hung
[sql] sql_set_user escaped user --> 'hung'
rlm_sql (sql): Reserving sql socket id: 3
[sql] expand: SELECT id, username, attribute, op, value   
FROM radcheck   WHERE username = '%{SQL-User-Name}'ORDER 
BY id -> SELECT id, username, attribute, op, value   FROM 
radcheck 

Re: Freeradius-mysql and freeradius 1.1.5

[K. Hoercher]

On 3/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i have installed freeradius 1.1.5 on debian machine now how i can install
> freeradius-mysql package?

>   freeradius-mysql Depends: freeradius(= 1.0.2-4sarge3) but 1.1.3 is to be
> installed
> E: Broken packages

That is a distribution-specific problem of debian not a general
freeradius one. So just as few hints:

Current version in stable is 1.0.2-4sarge3. So wherever you got 1.1.5
from, would be the place to search for the pertinent freeradius-mysql
(it would/should stem from the same source package).

Under normal circumstances you cannot/should not mix interdependent
packages from different sources. That leads to conflicting
dependencies as you are told by apt-get. Those are there for a reason.

hth
K. Hoercher
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Freeradius-mysql and freeradius 1.1.5

[[EMAIL PROTECTED]]

Hi,

i have installed freeradius 1.1.5 on debian machine now how i can install 
freeradius-mysql package?

When i try 'apt-get install freeradius-mysql' this is the error:

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
  freeradius-mysql Depends: freeradius(= 1.0.2-4sarge3) but 1.1.3 is to be 
installed
E: Broken packages

Help i can't use mysql 5 database with freeradius in this situation. i need 
freeradius-mysql.

Andrea


--
Leggi GRATIS le tue mail con il telefonino i-mode™ di Wind
http://i-mode.wind.it



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Problems with mysql and freeradius

[Marilene Lima]

Hi,

I am starting the freeradius with my mysql server and I noticed this
erro: rlm_sql_mysql: Mysql error 'Host 'mysql1.wireless.intranet' is
not allowed to connect to this MySQL server'

But I already give the privileges to my user radius and add the server
mysql1.wireless.intranet to my list of hosts knowed.

I use linux Debian and mysql 5.0.33 and the both are in the same
machine, but they have different ip adress. In the freeradius/sql.conf
file I configured this:
sql {

   # Database type
   # Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
   # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds
   driver = "rlm_sql_mysql"

   # Connect info
   server = "mysql1.wireless.intranet"
   # server = localhost
   login = "radius"
   password = "radius_password"
   #login = "root"
   # password = "mysql_password"

   # Database table configuration
   radius_db = "radius"

   # If you want both stop and start records logged to the
   # same SQL table, leave this as is.  If you want them in
   # different tables, put the start table in acct_table1
   # and stop table in acct_table2
   acct_table1 = "radacct"
   acct_table2 = "radacct"



Someone can help me?

Thanks a lot,
Marilene


This the result of freeradius:

 freeradius -x
Starting - reading configuration files ...
Using deprecated naslist file.  Support for this will go away soon.
Module: Loaded exec
rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Module: Instantiated exec (exec)
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded System
Module: Instantiated unix (unix)
Module: Loaded eap
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
rlm_eap: Loaded and initialized type gtc
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Module: Loaded preprocess
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
Module: Instantiated realm (suffix)
Module: Loaded files
Module: Instantiated files (files)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
rlm_sql_mysql: Couldn't connect socket to MySQL server
[EMAIL PROTECTED]:radius
rlm_sql_mysql: Mysql error 'Host 'mysql1.wireless.intranet' is not
allowed to connect to this MySQL server'
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.
Module: Instantiated sql (sql)
Module: Loaded Acct-Unique-Session-Id
Module: Instantiated acct_unique (acct_unique)
Module: Loaded detail
Module: Instantiated detail (detail)
Module: Loaded radutmp
Module: Instantiated radutmp (radutmp)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Listening on proxy *:1814
Ready to process requests.
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MYSQL and FreeRadius

[Seferovic Edvin]

Maybe a firewall script at startup?

Regards,

Edvin


From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
g] On Behalf Of Diniz Da Rocha
Sent: Samstag, 25. Februar 2006 06:51
To: freeradius-users@lists.freeradius.org
Subject: MYSQL and FreeRadius

Hi I have currently setup FreeRadius 1.0.4 with ldap authentication and
authorization as well as mysql authorization and its all working fine. The
problem exists when I restart the server, freeradius starts on boot but it
fails in connecting to the MYSQL server. If I then shutdown the service and
start it again it works fine. I have move the boot order to be S99 but it
still fails. The MYSQL server is on a seperate server, so I am wondering
whether the ports are blocked until startup is complete, if this is the case
How can I get round this??? I am using Fedora Core 4... Has anyone else had
this problem??? 
 
thanks 
 
diniz


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MYSQL and FreeRadius

[Diniz Da Rocha]

Hi I have currently setup FreeRadius 1.0.4 with ldap authentication and authorization as well as mysql authorization and its all working fine. The problem exists when I restart the server, freeradius starts on boot but it fails in connecting to the MYSQL server. If I then shutdown the service and start it again it works fine. I have move the boot order to be S99 but it still fails. The MYSQL server is on a seperate server, so I am wondering whether the ports are blocked until startup is complete, if this is the case How can I get round this??? I am using Fedora Core 4... Has anyone else had this problem???

 
thanks 
 
diniz
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MYSQL and Freeradius

[Diniz Da Rocha]

Hi ,
 
 
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Mysql and freeradius

[Joseph Abadi]

Hello,

Probably you had this question asked a bunch of times before, but here
we go again I installed freeradius1.0.2 configured with openssl. I
am using peap for authentication and everything was working fine while
using files to store user password.
I then installed Mysql server so that i could use the database for
storing that info. I  felt lazy so i just "apt-got" Mysql instead of
building it from source (running Ubuntu 2.6.8-1). I configured the
radiusd.conf and sql.conf files but when I run the server it gives me
segmentation fault just before loading the rlm_sql drivers (last
thing radiusd -X shows me is "sql: safe-characters
="@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"" Segmentation fault).

Here goes the question: how can I check if the rlm_sql_mysql driver is
being linked properly? should I rebuild freeradius? If so, with what
options? (debian mysql packages has some weird locations for
libraries, etc.. does someone know where they are?)

Thanks for your help

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRadius

[D.J. Wood]

Don, 

If you are in the directory where you unpacked freeradius it would be in:
src/modules/rlm_sql/drivers/rlm_sql_mysql/

Hope that helps.

D.J.


On Mon, 17 Jan 2005 10:26:09 -0600, don <[EMAIL PROTECTED]> wrote:
> Hello  list,
> 
> I am running freeradius and mysql on Gentoo Linux.
> 
> I have installed mysql, but can't seem to find the file, db_mysql.sql, so
> that I can create the radius database using the command:
> 
> mysql -uroot -prootpass radius < db_mysql.sql
> 
> Does anyone out there have a clue where db_mysql.sql is hiding?
> 
> Thanks,
> 
> Don James
> Henderson, Texas USA
> 
> -
> 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: MySQL and FreeRadius

[Mike-Olumide, Johnson]

Thanks!

Please could you help with any guide to be able to
install MySQL development
package? Have done some googling! Pls help.

- Original Message -
From: Neil Craig
To: freeradius-users@lists.freeradius.org
Sent: Monday, January 17, 2005 5:58 PM
Subject: Re: MySQL and FreeRadius


I think you need MySQl development package installed

>>> [EMAIL PROTECTED] 17/01/2005 16:52:48 >>>


--- Alan DeKok <[EMAIL PROTECTED]> wrote:

> "Mike-Olumide, Johnson" <[EMAIL PROTECTED]>
> wrote:
> > rlm_sql (sql): Could not link driver
> rlm_sql_mysql:
> > file not found
> > rlm_sql (sql): Make sure it (and all its dependent
> > libraries!) are in the search
> >  path of your system's ld.
> > radiusd.conf[14]: sql: Module instantiation
> failed.
> >
> > How can I correct this pls?
>
>   Please read the FAQ.
>
>   Alan DeKok.

I have read the FAQ and chose to make & make install
from source, but it returned with plenty errors as
below. The other options with lib path and linker are
strange as i couldn't figure out what to do. Will
appreciate any help on this!


ibraries have been installed in:
   /usr/local/lib

If you ever happen to want to link against installed
libraries
in a given directory, LIBDIR, you must either use
libtool, and
specify the full pathname of the library, or use the
`-LLIBDIR'
flag during linking and do at least one of the
following:
   - add LIBDIR to the `LD_LIBRARY_PATH' environment
variable
 during execution
   - add LIBDIR to the `LD_RUN_PATH' environment
variable
 during linking
   - use the `-Wl,--rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to
`/etc/ld.so.conf'

See any operating system documentation about shared
libraries for
more information, such as the ld(1) and ld.so(8)
manual pages.
--
gmake[6]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_realm'
Making install in rlm_sql...
gmake[6]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
if [ "xrlm_sql" != "x" ]; then \
/root/freeradius-1.0.1/libtool --mode=install
/root/freeradius-1.0.1/install
-sh -c -c \
rlm_sql.la /usr/local/lib/rlm_sql.la; \
rm -f /usr/local/lib/rlm_sql-1.0.1.la; \
ln -s rlm_sql.la /usr/local/lib/rlm_sql-1.0.1.la;
\
fi
libtool: install: `rlm_sql.la' is not a valid libtool
archive
Try `libtool --help --mode=install' for more
information.
gmake[7]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[8]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
Making install in drivers...
gmake[9]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
'
/usr/bin/gmake -w WHAT_TO_MAKE=install common
gmake[10]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/driver
s'
Making install in rlm_sql_iodbc...
gmake[11]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/driver
s/rlm_sql_iodbc'
[ "x" = "x" ] || /root/freeradius-1.0.1/libtool
--mode=install /root/freeradius-
1.0.1/install-sh -c -c .la /usr/local/lib/.la
gmake[11]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
/rlm_sql_iodbc'
Making install in rlm_sql_mysql...
gmake[11]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/driver
s/rlm_sql_mysql'
[ "xrlm_sql_mysql" = "x" ] ||
/root/freeradius-1.0.1/libtool --mode=install /roo
t/freeradius-1.0.1/install-sh -c -c rlm_sql_mysql.la
/usr/local/lib/rlm_sql_mysq
l.la
libtool: install: `rlm_sql_mysql.la' is not a valid
libtool archive
Try `libtool --help --mode=install' for more
information.
gmake[11]: *** [install] Error 1
gmake[11]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
/rlm_sql_mysql'
gmake[10]: *** [common] Error 1
gmake[10]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
'
gmake[9]: *** [install] Error 2
gmake[9]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'
gmake[8]: *** [common] Error 1
gmake[8]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[7]: *** [install-drivers] Error 2
gmake[7]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[6]: *** [install] Error 2
gmake[6]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[5]: *** [common] Error 1
gmake[5]: Leaving directory
`/root/freeradius-1.0.1/src/modules'
gmake[4]: *** [install] Error 2
gmake[4]: Leaving directory
`/root/freeradius-1.0.1/src/modules'
gmake[3]: *** [common] Error 1
gmake[3]: Leaving directory
`/root/freeradius-1.0.1/src'
gmake[2]: *** [install] Error 2
gmake[2]: Leaving directory
`/root/freeradius

Re: MySQL and FreeRadius

[Neil Craig]

I think you need MySQl 
development package installed>>> [EMAIL PROTECTED] 
17/01/2005 16:52:48 >>>
--- Alan DeKok <[EMAIL PROTECTED]> wrote:> "Mike-Olumide, 
Johnson" <[EMAIL PROTECTED]>> wrote:> > rlm_sql 
(sql): Could not link driver> rlm_sql_mysql:> > file not 
found> > rlm_sql (sql): Make sure it (and all its dependent> 
> libraries!) are in the search> >  path of your system's 
ld.> > radiusd.conf[14]: sql: Module instantiation> 
failed.> > > > How can I correct this pls?> 
>   Please read the FAQ.> >   Alan 
DeKok.I have read the FAQ and chose to make & make installfrom 
source, but it returned with plenty errors asbelow. The other options with 
lib path and linker arestrange as i couldn't figure out what to do. 
Willappreciate any help on this!ibraries have been installed 
in:   /usr/local/libIf you ever happen to want to link 
against installedlibrariesin a given directory, LIBDIR, you must either 
uselibtool, andspecify the full pathname of the library, or use 
the`-LLIBDIR'flag during linking and do at least one of 
thefollowing:   - add LIBDIR to the `LD_LIBRARY_PATH' 
environmentvariable during 
execution   - add LIBDIR to the `LD_RUN_PATH' 
environmentvariable during 
linking   - use the `-Wl,--rpath -Wl,LIBDIR' linker 
flag   - have your system administrator add LIBDIR 
to`/etc/ld.so.conf'See any operating system documentation about 
sharedlibraries formore information, such as the ld(1) and 
ld.so(8)manual 
pages.--gmake[6]: 
Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_realm'Making 
install in rlm_sql...gmake[6]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql'if [ "xrlm_sql" != 
"x" ]; then \    /root/freeradius-1.0.1/libtool 
--mode=install/root/freeradius-1.0.1/install-sh -c -c 
\    rlm_sql.la 
/usr/local/lib/rlm_sql.la; \    rm -f 
/usr/local/lib/rlm_sql-1.0.1.la; \    ln -s rlm_sql.la 
/usr/local/lib/rlm_sql-1.0.1.la;\filibtool: install: `rlm_sql.la' is 
not a valid libtoolarchiveTry `libtool --help --mode=install' for 
moreinformation.gmake[7]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[8]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql'Making install in 
drivers...gmake[9]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'/usr/bin/gmake 
-w WHAT_TO_MAKE=install commongmake[10]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'Making 
install in rlm_sql_iodbc...gmake[11]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_iodbc'[ 
"x" = "x" ] || /root/freeradius-1.0.1/libtool--mode=install 
/root/freeradius-1.0.1/install-sh -c -c .la /usr/local/lib/.lagmake[11]: 
Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_iodbc'Making 
install in rlm_sql_mysql...gmake[11]: Entering 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_mysql'[ 
"xrlm_sql_mysql" = "x" ] ||/root/freeradius-1.0.1/libtool --mode=install 
/root/freeradius-1.0.1/install-sh -c -c 
rlm_sql_mysql.la/usr/local/lib/rlm_sql_mysql.lalibtool: install: 
`rlm_sql_mysql.la' is not a validlibtool archiveTry `libtool --help 
--mode=install' for moreinformation.gmake[11]: *** [install] Error 
1gmake[11]: Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_mysql'gmake[10]: 
*** [common] Error 1gmake[10]: Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'gmake[9]: 
*** [install] Error 2gmake[9]: Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'gmake[8]: 
*** [common] Error 1gmake[8]: Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[7]: *** 
[install-drivers] Error 2gmake[7]: Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[6]: *** 
[install] Error 2gmake[6]: Leaving 
directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[5]: *** 
[common] Error 1gmake[5]: Leaving 
directory`/root/freeradius-1.0.1/src/modules'gmake[4]: *** [install] 
Error 2gmake[4]: Leaving 
directory`/root/freeradius-1.0.1/src/modules'gmake[3]: *** [common] 
Error 1gmake[3]: Leaving 
directory`/root/freeradius-1.0.1/src'gmake[2]: *** [install] Error 
2gmake[2]: Leaving directory`/root/freeradius-1.0.1/src'gmake[1]: 
*** [common] Error 1gmake[1]: Leaving directory 
`/root/freeradius-1.0.1'make: *** [install] Error 2> - > 
List info/subscribe/unsubscribe? See> http://www.freeradius.org/list/users.html> 
Thanks for your help.Mike=Michael-Olumide Johnson 
B.Sc.(Phy), PG.D(Fin.Mgt), MCP, 
CCNA08033133324        
__ Do you Yahoo!? Yahoo! Mail - 
250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRadius

[Mike-Olumide, Johnson]

--- Alan DeKok <[EMAIL PROTECTED]> wrote:

> "Mike-Olumide, Johnson" <[EMAIL PROTECTED]>
> wrote:
> > rlm_sql (sql): Could not link driver
> rlm_sql_mysql:
> > file not found
> > rlm_sql (sql): Make sure it (and all its dependent
> > libraries!) are in the search
> >  path of your system's ld.
> > radiusd.conf[14]: sql: Module instantiation
> failed.
> > 
> > How can I correct this pls?
> 
>   Please read the FAQ.
> 
>   Alan DeKok.

I have read the FAQ and chose to make & make install
from source, but it returned with plenty errors as
below. The other options with lib path and linker are
strange as i couldn't figure out what to do. Will
appreciate any help on this!


ibraries have been installed in:
   /usr/local/lib
 
If you ever happen to want to link against installed
libraries
in a given directory, LIBDIR, you must either use
libtool, and
specify the full pathname of the library, or use the
`-LLIBDIR'
flag during linking and do at least one of the
following:
   - add LIBDIR to the `LD_LIBRARY_PATH' environment
variable
 during execution
   - add LIBDIR to the `LD_RUN_PATH' environment
variable
 during linking
   - use the `-Wl,--rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to
`/etc/ld.so.conf'
 
See any operating system documentation about shared
libraries for
more information, such as the ld(1) and ld.so(8)
manual pages.
--
gmake[6]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_realm'
Making install in rlm_sql...
gmake[6]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
if [ "xrlm_sql" != "x" ]; then \
/root/freeradius-1.0.1/libtool --mode=install
/root/freeradius-1.0.1/install
-sh -c -c \
rlm_sql.la /usr/local/lib/rlm_sql.la; \
rm -f /usr/local/lib/rlm_sql-1.0.1.la; \
ln -s rlm_sql.la /usr/local/lib/rlm_sql-1.0.1.la;
\
fi
libtool: install: `rlm_sql.la' is not a valid libtool
archive
Try `libtool --help --mode=install' for more
information.
gmake[7]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[8]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
Making install in drivers...
gmake[9]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
'
/usr/bin/gmake -w WHAT_TO_MAKE=install common
gmake[10]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/driver
s'
Making install in rlm_sql_iodbc...
gmake[11]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/driver
s/rlm_sql_iodbc'
[ "x" = "x" ] || /root/freeradius-1.0.1/libtool
--mode=install /root/freeradius-
1.0.1/install-sh -c -c .la /usr/local/lib/.la
gmake[11]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
/rlm_sql_iodbc'
Making install in rlm_sql_mysql...
gmake[11]: Entering directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/driver
s/rlm_sql_mysql'
[ "xrlm_sql_mysql" = "x" ] ||
/root/freeradius-1.0.1/libtool --mode=install /roo
t/freeradius-1.0.1/install-sh -c -c rlm_sql_mysql.la
/usr/local/lib/rlm_sql_mysq
l.la
libtool: install: `rlm_sql_mysql.la' is not a valid
libtool archive
Try `libtool --help --mode=install' for more
information.
gmake[11]: *** [install] Error 1
gmake[11]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
/rlm_sql_mysql'
gmake[10]: *** [common] Error 1
gmake[10]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers
'
gmake[9]: *** [install] Error 2
gmake[9]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'
gmake[8]: *** [common] Error 1
gmake[8]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[7]: *** [install-drivers] Error 2
gmake[7]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[6]: *** [install] Error 2
gmake[6]: Leaving directory
`/root/freeradius-1.0.1/src/modules/rlm_sql'
gmake[5]: *** [common] Error 1
gmake[5]: Leaving directory
`/root/freeradius-1.0.1/src/modules'
gmake[4]: *** [install] Error 2
gmake[4]: Leaving directory
`/root/freeradius-1.0.1/src/modules'
gmake[3]: *** [common] Error 1
gmake[3]: Leaving directory
`/root/freeradius-1.0.1/src'
gmake[2]: *** [install] Error 2
gmake[2]: Leaving directory
`/root/freeradius-1.0.1/src'
gmake[1]: *** [common] Error 1
gmake[1]: Leaving directory `/root/freeradius-1.0.1'
make: *** [install] Error 2

> - 
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> 

Thanks for your help.
Mike

=
Michael-Olumide Johnson B.Sc.(Phy), PG.D(Fin.Mgt), MCP, CCNA
08033133324




__ 
Do you Yahoo!? 
Yahoo! Mail - 250MB free storage. Do more. Manage less. 
http://info.mail.yahoo.com/mail_250

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySQL and FreeRadius

[Alan DeKok]

"Mike-Olumide, Johnson" <[EMAIL PROTECTED]> wrote:
> rlm_sql (sql): Could not link driver rlm_sql_mysql:
> file not found
> rlm_sql (sql): Make sure it (and all its dependent
> libraries!) are in the search
>  path of your system's ld.
> radiusd.conf[14]: sql: Module instantiation failed.
> 
> How can I correct this pls?

  Please read the FAQ.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MySQL and FreeRadius

[don]

Hello  list, 

I am running freeradius and mysql on Gentoo Linux.

I have installed mysql, but can't seem to find the file, db_mysql.sql, so
that I can create the radius database using the command:

mysql -uroot -prootpass radius < db_mysql.sql 

Does anyone out there have a clue where db_mysql.sql is hiding?

Thanks,

Don James
Henderson, Texas USA


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: AW: MySQL and FreeRadius

[Neil Craig]

As mentioned before - you 
can install the RPM or get Freeradius source and compile the module from 
there>>> [EMAIL PROTECTED] 17/01/2005 15:48:43 
>>>
Hello yes you canUnder Debian you must install the Packet  
freeradius-mysql for your Linux idon't know it> 
-Ursprüngliche Nachricht-> Von: 
[EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 
Im > Auftrag von Mike-Olumide, Johnson> Gesendet: Montag, 17. 
Januar 2005 16:10> An: freeradius-users@lists.freeradius.org> 
Betreff: MySQL and FreeRadius> > Hi All,> > 
Freeradius1.0.1 was installed on RH9.0 linux and it ran ok.> 
>  Afterwards downloaded the standard version> 4.0.23 of 
MySQL and installed. Radisud.conf was also edited > to authenticate and 
authorize via MySQL. Debug output is as below.> > Is there a way 
forward from here? Please help!> > [EMAIL PROTECTED] raddb]# radiusd 
-X> Starting - reading configuration files ...> 
reread_config:  reading radiusd.conf> Config:   including 
file:> /usr/local/etc/raddb/proxy.conf> Config:   
including file:> /usr/local/etc/raddb/clients.conf> 
Config:   including file:> 
/usr/local/etc/raddb/snmp.conf> Config:   including 
file:> /usr/local/etc/raddb/eap.conf> Config:   
including file:> /usr/local/etc/raddb/sql.conf>  main: prefix 
= "/usr/local">  main: localstatedir = 
"/usr/local/var">  main: logdir = 
"/usr/local/var/log/radius">  main: libdir = 
"/usr/local/lib">  main: radacctdir => 
"/usr/local/var/log/radius/radacct">  main: hostname_lookups = 
no>  main: max_request_time = 30>  main: cleanup_delay = 
5>  main: max_requests = 1024>  main: 
delete_blocked_requests = 0>  main: port = 0>  main: 
allow_core_dumps = no>  main: log_stripped_names = no>  
main: log_file => "/usr/local/var/log/radius/radius.log">  
main: log_auth = yes>  main: log_auth_badpass = no>  
main: log_auth_goodpass = no>  main: pidfile => 
"/usr/local/var/run/radiusd/radiusd.pid">  main: user = 
"(null)">  main: group = "(null)">  main: usercollide = 
no>  main: lower_user = "no">  main: lower_pass = 
"no">  main: nospace_user = "no">  main: nospace_pass = 
"no">  main: checkrad = "/usr/local/sbin/checkrad">  
main: proxy_requests = yes>  proxy: retry_delay = 5>  
proxy: retry_count = 3>  proxy: synchronous = no>  
proxy: default_fallback = yes>  proxy: dead_time = 120>  
proxy: post_proxy_authorize = yes>  proxy: wake_all_if_all_dead = 
no>  security: max_attributes = 200>  security: 
reject_delay = 1>  security: status_server = no>  main: 
debug_level = 0> read_config_files:  reading dictionary> 
read_config_files:  reading naslist> Using deprecated naslist 
file.  Support for this will go away soon.> read_config_files:  
reading clients> read_config_files:  reading realms> 
radiusd:  entering modules setup> Module: Library search path is 
/usr/local/lib> Module: Loaded exec>  exec: wait = 
yes>  exec: program = "(null)">  exec: input_pairs = 
"request">  exec: output_pairs = "(null)">  exec: 
packet_type = "(null)"> rlm_exec: Wait=yes but no output defined. Did you 
mean output=none?> Module: Instantiated exec (exec)> Module: 
Loaded expr> Module: Instantiated expr (expr)> Module: Loaded 
PAP>  pap: encryption_scheme = "crypt"> Module: Instantiated 
pap (pap)> Module: Loaded CHAP> Module: Instantiated chap 
(chap)> Module: Loaded MS-CHAP>  mschap: use_mppe = 
yes>  mschap: require_encryption = no>  mschap: 
require_strong = no>  mschap: with_ntdomain_hack = no>  
mschap: passwd = "(null)"> mschap: authtype = "MS-CHAP">  
mschap: ntlm_auth = "(null)"> Module: Instantiated mschap 
(mschap)> Module: Loaded eap>  eap: default_eap_type = 
"md5">  eap: timer_expire = 60>  eap: 
ignore_unknown_eap_types = no>  eap: cisco_accounting_username_bug = 
no> rlm_eap: Loaded and initialized type md5> rlm_eap: Loaded and 
initialized type leap>  gtc: challenge = "Password: ">  
gtc: auth_type = "PAP"> rlm_eap: Loaded and initialized type 
gtc>  mschapv2: with_ntdomain_hack = no> rlm_eap: Loaded and 
initialized type mschapv2> Module: Instantiated eap (eap)> Module: 
Loaded preprocess>  preprocess: huntgroups => 
"/usr/local/etc/raddb/huntgroups">  preprocess: hints = 
"/usr/local/etc/raddb/hints">  preprocess: with_ascend_hack = 
no>  preprocess: ascend_channels_per_line = 23>  
preprocess: with_ntdomain_hack = no>  preprocess: 
with_specialix_jetstream_hack = no>  preproce

AW: MySQL and FreeRadius

[Drießen]

Hello yes you can

Under Debian you must install the Packet  freeradius-mysql for your Linux i
don't know it

> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] Im 
> Auftrag von Mike-Olumide, Johnson
> Gesendet: Montag, 17. Januar 2005 16:10
> An: freeradius-users@lists.freeradius.org
> Betreff: MySQL and FreeRadius
> 
> Hi All,
> 
> Freeradius1.0.1 was installed on RH9.0 linux and it ran ok.
> 
>  Afterwards downloaded the standard version
> 4.0.23 of MySQL and installed. Radisud.conf was also edited 
> to authenticate and authorize via MySQL. Debug output is as below.
> 
> Is there a way forward from here? Please help!
> 
> [EMAIL PROTECTED] raddb]# radiusd -X
> Starting - reading configuration files ...
> reread_config:  reading radiusd.conf
> Config:   including file:
> /usr/local/etc/raddb/proxy.conf
> Config:   including file:
> /usr/local/etc/raddb/clients.conf
> Config:   including file:
> /usr/local/etc/raddb/snmp.conf
> Config:   including file:
> /usr/local/etc/raddb/eap.conf
> Config:   including file:
> /usr/local/etc/raddb/sql.conf
>  main: prefix = "/usr/local"
>  main: localstatedir = "/usr/local/var"
>  main: logdir = "/usr/local/var/log/radius"
>  main: libdir = "/usr/local/lib"
>  main: radacctdir =
> "/usr/local/var/log/radius/radacct"
>  main: hostname_lookups = no
>  main: max_request_time = 30
>  main: cleanup_delay = 5
>  main: max_requests = 1024
>  main: delete_blocked_requests = 0
>  main: port = 0
>  main: allow_core_dumps = no
>  main: log_stripped_names = no
>  main: log_file =
> "/usr/local/var/log/radius/radius.log"
>  main: log_auth = yes
>  main: log_auth_badpass = no
>  main: log_auth_goodpass = no
>  main: pidfile =
> "/usr/local/var/run/radiusd/radiusd.pid"
>  main: user = "(null)"
>  main: group = "(null)"
>  main: usercollide = no
>  main: lower_user = "no"
>  main: lower_pass = "no"
>  main: nospace_user = "no"
>  main: nospace_pass = "no"
>  main: checkrad = "/usr/local/sbin/checkrad"
>  main: proxy_requests = yes
>  proxy: retry_delay = 5
>  proxy: retry_count = 3
>  proxy: synchronous = no
>  proxy: default_fallback = yes
>  proxy: dead_time = 120
>  proxy: post_proxy_authorize = yes
>  proxy: wake_all_if_all_dead = no
>  security: max_attributes = 200
>  security: reject_delay = 1
>  security: status_server = no
>  main: debug_level = 0
> read_config_files:  reading dictionary
> read_config_files:  reading naslist
> Using deprecated naslist file.  Support for this will go away soon.
> read_config_files:  reading clients
> read_config_files:  reading realms
> radiusd:  entering modules setup
> Module: Library search path is /usr/local/lib
> Module: Loaded exec
>  exec: wait = yes
>  exec: program = "(null)"
>  exec: input_pairs = "request"
>  exec: output_pairs = "(null)"
>  exec: packet_type = "(null)"
> rlm_exec: Wait=yes but no output defined. Did you mean output=none?
> Module: Instantiated exec (exec)
> Module: Loaded expr
> Module: Instantiated expr (expr)
> Module: Loaded PAP
>  pap: encryption_scheme = "crypt"
> Module: Instantiated pap (pap)
> Module: Loaded CHAP
> Module: Instantiated chap (chap)
> Module: Loaded MS-CHAP
>  mschap: use_mppe = yes
>  mschap: require_encryption = no
>  mschap: require_strong = no
>  mschap: with_ntdomain_hack = no
>  mschap: passwd = "(null)"
> mschap: authtype = "MS-CHAP"
>  mschap: ntlm_auth = "(null)"
> Module: Instantiated mschap (mschap)
> Module: Loaded eap
>  eap: default_eap_type = "md5"
>  eap: timer_expire = 60
>  eap: ignore_unknown_eap_types = no
>  eap: cisco_accounting_username_bug = no
> rlm_eap: Loaded and initialized type md5
> rlm_eap: Loaded and initialized type leap
>  gtc: challenge = "Password: "
>  gtc: auth_type = "PAP"
> rlm_eap: Loaded and initialized type gtc
>  mschapv2: with_ntdomain_hack = no
> rlm_eap: Loaded and initialized type mschapv2
> Module: Instantiated eap (eap)
> Module: Loaded preprocess
>  preprocess: huntgroups =
> "/usr/local/etc/raddb/huntgroups"
>  preprocess: hints = "/usr/local/etc/raddb/hints"
>  preprocess: with_ascend_hack = no
>  preprocess: ascend_channels_per_line = 23
>  preprocess: with_ntdomain_hack = no
>  preprocess: with_specialix_jetstream_hack = no
>  preprocess: with_cisco_vsa_hack = no
> Module: Instantiated preprocess (preprocess)
> Module: Loaded realm
>  realm: forma

MySQL and FreeRadius

[Mike-Olumide, Johnson]

Hi All,

Freeradius1.0.1 was installed on RH9.0 linux and it
ran ok.

 Afterwards downloaded the standard version
4.0.23 of MySQL and installed. Radisud.conf was also
edited to authenticate and authorize via MySQL. Debug
output is as below.

Is there a way forward from here? Please help!

[EMAIL PROTECTED] raddb]# radiusd -X
Starting - reading configuration files ...
reread_config:  reading radiusd.conf
Config:   including file:
/usr/local/etc/raddb/proxy.conf
Config:   including file:
/usr/local/etc/raddb/clients.conf
Config:   including file:
/usr/local/etc/raddb/snmp.conf
Config:   including file:
/usr/local/etc/raddb/eap.conf
Config:   including file:
/usr/local/etc/raddb/sql.conf
 main: prefix = "/usr/local"
 main: localstatedir = "/usr/local/var"
 main: logdir = "/usr/local/var/log/radius"
 main: libdir = "/usr/local/lib"
 main: radacctdir =
"/usr/local/var/log/radius/radacct"
 main: hostname_lookups = no
 main: max_request_time = 30
 main: cleanup_delay = 5
 main: max_requests = 1024
 main: delete_blocked_requests = 0
 main: port = 0
 main: allow_core_dumps = no
 main: log_stripped_names = no
 main: log_file =
"/usr/local/var/log/radius/radius.log"
 main: log_auth = yes
 main: log_auth_badpass = no
 main: log_auth_goodpass = no
 main: pidfile =
"/usr/local/var/run/radiusd/radiusd.pid"
 main: user = "(null)"
 main: group = "(null)"
 main: usercollide = no
 main: lower_user = "no"
 main: lower_pass = "no"
 main: nospace_user = "no"
 main: nospace_pass = "no"
 main: checkrad = "/usr/local/sbin/checkrad"
 main: proxy_requests = yes
 proxy: retry_delay = 5
 proxy: retry_count = 3
 proxy: synchronous = no
 proxy: default_fallback = yes
 proxy: dead_time = 120
 proxy: post_proxy_authorize = yes
 proxy: wake_all_if_all_dead = no
 security: max_attributes = 200
 security: reject_delay = 1
 security: status_server = no
 main: debug_level = 0
read_config_files:  reading dictionary
read_config_files:  reading naslist
Using deprecated naslist file.  Support for this will
go away soon.
read_config_files:  reading clients
read_config_files:  reading realms
radiusd:  entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded exec
 exec: wait = yes
 exec: program = "(null)"
 exec: input_pairs = "request"
 exec: output_pairs = "(null)"
 exec: packet_type = "(null)"
rlm_exec: Wait=yes but no output defined. Did you mean
output=none?
Module: Instantiated exec (exec)
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
 pap: encryption_scheme = "crypt"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
 mschap: use_mppe = yes
 mschap: require_encryption = no
 mschap: require_strong = no
 mschap: with_ntdomain_hack = no
 mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
 mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded eap
 eap: default_eap_type = "md5"
 eap: timer_expire = 60
 eap: ignore_unknown_eap_types = no
 eap: cisco_accounting_username_bug = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
 gtc: challenge = "Password: "
 gtc: auth_type = "PAP"
rlm_eap: Loaded and initialized type gtc
 mschapv2: with_ntdomain_hack = no
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Module: Loaded preprocess
 preprocess: huntgroups =
"/usr/local/etc/raddb/huntgroups"
 preprocess: hints = "/usr/local/etc/raddb/hints"
 preprocess: with_ascend_hack = no
 preprocess: ascend_channels_per_line = 23
 preprocess: with_ntdomain_hack = no
 preprocess: with_specialix_jetstream_hack = no
 preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
 realm: format = "suffix"
 realm: delimiter = "@"
 realm: ignore_default = no
 realm: ignore_null = no
Module: Instantiated realm (suffix)
Module: Loaded SQL
 sql: driver = "rlm_sql_mysql"
 sql: server = "localhost"
 sql: port = ""
 sql: login = "root"
 sql: password = "rootpass"
 sql: radius_db = "radius"
 sql: acct_table = "radacct"
 sql: acct_table2 = "radacct"
 sql: authcheck_table = "radcheck"
 sql: authreply_table = "radreply"
 sql: groupcheck_table = "radgroupcheck"
 sql: groupreply_table = "radgroupreply"
 sql: usergroup_table = "usergroup"
 sql: nas_table = "nas"
 sql: dict_table = "dictionary"
 sql: sqltrace = no
 sql: sqltracefile =
"/usr/local/var/log/radius/sqltrace.sql"
 sql: readclients = no
 sql: deletestalesessions = yes
 sql: num_sql_socks = 5
 sql: sql_user_name = "%{User-Name}"
 sql: default_user_profile = ""
 sql: query_on_not_found = no
 sql: authorize_check_query = "SELECT
id,UserName,Attribute,Value,op FROM radche
ck WHERE Username = '%{SQL-User-Name}' ORDER BY id"
 sql: authorize_reply_query = "SELECT
id,UserName,Attribute,Value,op FROM radrep ly WHERE
Username =
'%{SQL-User-Name}' ORDER BY id"
 sql: authorize_group_check_query = "SELECT
radgroupcheck.id,radgroupcheck.Group
Name,radgroupcheck.Attribute,radgroupcheck.Value,radgroupche

Re: mysql and freeradius

[Kostas Kalevras]

On Wed, 21 Jul 2004, wadih jalad wrote:

> hi all
>
> i make a freeradius with mysql on redhat 9.
>
> i have two problems:
>
> i notice that the symbol " # " is written as " =23 ", is there any way to
> fix this? i will appreciate.

Open sql.conf, look for safe-characters.

>
> second, i want to make the authentication only on the NAS Ip, is there any
> way to do this.

What do you mean by that exactly? In any case check out the users file and the
checkval module for that (if i understand you correctly).

>
> any help will be appreciate.
>
> thanks
>
> _
> Take charge with a pop-up guard built on patented Microsoft? SmartScreen
> Technology.
> http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
>   Start enjoying all the benefits of MSN? Premium right now and get the
> first two months FREE*.
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]   National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

mysql and freeradius

[wadih jalad]

hi all
i make a freeradius with mysql on redhat 9.
i have two problems:
i notice that the symbol " # " is written as " =23 ", is there any way to 
fix this? i will appreciate.

second, i want to make the authentication only on the NAS Ip, is there any 
way to do this.

any help will be appreciate.
thanks
_
Take charge with a pop-up guard built on patented Microsoft® SmartScreen 
Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
 Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySql and freeRadius

[Andreas Fink]

use mysql 4.0 not 4.1alpha or 5.0alpha. They have a bug in 
authentication of mysql which might get you into troubles.

On 24.03.2004, at 23:30, Kirti S. Bajwa wrote:
Hello List:
I want to make sure I am installing freeRADIUS & MySQL correctly. I
installed (test installation) freeRADIUS (0.9.3) and MySQL 5.0.0 (?) 
from
binaries on a RH9 machine. It tested fine. In the next couple of days, 
I am
going to do a final installation of freeRADIUS & MySQL (with InnoDB).

Questions:
==
(1) with the above setup, what version of MySQL (binaries or rpm) 
should I
use?
(2) Do I still need a develoment package of MySQL to work with 
freeRADIUS?
If YES, what version of MySQL?

I am new to MySQL!!
Kirti
-Original Message-
From: Keith Yoder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 2:36 PM
To: [EMAIL PROTECTED]
Subject: Re: MySql and freeRadius
John Que escreveu:
As I understand , I must install the sources of MySql if I want to use
rlm_sql in freeRadius
(and not install the rpm for mySql Server and client).
Actually, you can install the -devel rpms and that will allow you to
compile the rlm_sql_mysql module.  This will make sure all the 
libraries
and header files get to the right places.

-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html


Andreas Fink
Global Networks Switzerland AG
--
Tel: +41-61-330  Fax: +41-61-334   Mobile: +41-79-2457333
Global Networks, Inc. Clarastrasse 3, 4058 Basel, Switzerland
Web: http://www.global-networks.ch/  [EMAIL PROTECTED]
--
PGP Fingerprint: B982 00B7 FFB5 0B33 BFF8  0F77 1E23 F3CA B4A3 D0B8
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius--WORKING FINE

[Alan DeKok]

"Linda Pagillo" <[EMAIL PROTECTED]> wrote:
> I just wanted to let you know that i did exatly what you said to do.

That's what I like to hear.

> I installed the Mysql Development package and i now have freeradius
> up and running using mysql with no problems at all. Everything is
> beautiful thanks to your help. I just wanted to show you my
> appreciation. Thank you, sir.

  You're welcome.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius--WORKING FINE

[Milver S. Nisay]

> Hi Mr. DeKok
>
> I just wanted to let you know that i did exatly what you said to do. I
> installed the Mysql Development package and i now have freeradius up and
> running using mysql with no problems at all. Everything is beautiful
thanks
> to your help. I just wanted to show you my appreciation. Thank you, sir.

well done.



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius--WORKING FINE

[Linda Pagillo]

Hi Mr. DeKok

I just wanted to let you know that i did exatly what you said to do. I
installed the Mysql Development package and i now have freeradius up and
running using mysql with no problems at all. Everything is beautiful thanks
to your help. I just wanted to show you my appreciation. Thank you, sir.
- Original Message - 
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 3:01 PM
Subject: Re: Mysql and Freeradius


> "Linda Pagillo" <[EMAIL PROTECTED]> wrote:
> > Your previous post said "Normally, you don't have to do anything.
> > FreeRADIUS will find MySQL, and automatically build the rlm_sql_mysql
> > driver."
>
>   FreeRADIUS will find it: IF MYSQL EXISTS ON YOUR SYSTEM.
>
>   It is very clear that the MySQL development package DOES NOT exist
> on your system.  No amount of playing games with FreeRADIUS is going
> to install the MySQL development package.  Stop playing with
> FreeRADIUS, it's not the problem.
>
>   Install the MySQL development RPM.
>
>   Now.
>
> > So what you're telling me is that i should have an actual file called
> > rlm_sql_mysql, is that correct?
>
>   No.  I never said that.  I have no idea how you got that conclusion
> from my posts.
>
>   Stop trying to interpret my responses.  Because you're unfamiliar
> with the system, your interpretations are wrong.  Take my responses at
> face value, believe them, and do what they say.
>
> > Also, Mr.DeKok, please forgive me for asking questions that may seem
simple
> > to most people. I'm very new at this and Linux in general. I realize
that
> > you are a very intelligent man and being a programmer, you probably
don't
> > have the time to deal with newbies like me. Just know that your time is
> > appreciated by me. Thank you again.
>
>   I don't mind that you're unfamiliar with the process.  I do mind
> that you seem to have trouble following instructions.
>
>   Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius

[Milver S. Nisay]

>
>   FreeRADIUS will find it: IF MYSQL EXISTS ON YOUR SYSTEM.
I agree.

>
>   It is very clear that the MySQL development package DOES NOT exist
> on your system.  No amount of playing games with FreeRADIUS is going
> to install the MySQL development package.  Stop playing with
> FreeRADIUS, it's not the problem.

my guess is not on freeradius, MySQL mailling list to the rescue?

>   Install the MySQL development RPM.
>
>   Now.
>
> > So what you're telling me is that i should have an actual file called
> > rlm_sql_mysql, is that correct?
>
if you are going to implement MySQL, ofcourse you do not need Oracle SQL or
something

>
> > Also, Mr.DeKok, please forgive me for asking questions that may seem
simple
> > to most people. I'm very new at this and Linux in general. I realize
that
> > you are a very intelligent man and being a programmer, you probably
don't
> > have the time to deal with newbies like me. Just know that your time is
> > appreciated by me. Thank you again.
>
google will lead you to lots of linux mailing list.



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius

[Alan DeKok]

"Linda Pagillo" <[EMAIL PROTECTED]> wrote:
> Your previous post said "Normally, you don't have to do anything.
> FreeRADIUS will find MySQL, and automatically build the rlm_sql_mysql
> driver."

  FreeRADIUS will find it: IF MYSQL EXISTS ON YOUR SYSTEM.

  It is very clear that the MySQL development package DOES NOT exist
on your system.  No amount of playing games with FreeRADIUS is going
to install the MySQL development package.  Stop playing with
FreeRADIUS, it's not the problem.

  Install the MySQL development RPM.

  Now.

> So what you're telling me is that i should have an actual file called
> rlm_sql_mysql, is that correct? 

  No.  I never said that.  I have no idea how you got that conclusion
from my posts.

  Stop trying to interpret my responses.  Because you're unfamiliar
with the system, your interpretations are wrong.  Take my responses at
face value, believe them, and do what they say.

> Also, Mr.DeKok, please forgive me for asking questions that may seem simple
> to most people. I'm very new at this and Linux in general. I realize that
> you are a very intelligent man and being a programmer, you probably don't
> have the time to deal with newbies like me. Just know that your time is
> appreciated by me. Thank you again.

  I don't mind that you're unfamiliar with the process.  I do mind
that you seem to have trouble following instructions.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius

[Linda Pagillo]

Hi Mr.DeKok,

Your previous post said "Normally, you don't have to do anything.
FreeRADIUS will find MySQL, and automatically build the rlm_sql_mysql
driver."

When i configured freeradius the first time, i didn't do anything special. I
just did the basic ./configure and that was it.

As i posted previously, i ended up with a rlm_sql_mysql directory, not an
actual file. Inside the directory showed files such as "configure" and
"MakeFile". This made me wonder if i had to do something with it.

So what you're telling me is that i should have an actual file called
rlm_sql_mysql, is that correct? If yes, where would i find that file? i have
looked everywhere so that i could link it correctly, but it's not on my
system.

Also, Mr.DeKok, please forgive me for asking questions that may seem simple
to most people. I'm very new at this and Linux in general. I realize that
you are a very intelligent man and being a programmer, you probably don't
have the time to deal with newbies like me. Just know that your time is
appreciated by me. Thank you again.

- Original Message - 
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 12:59 PM
Subject: Re: Mysql and Freeradius


> "Linda Pagillo" <[EMAIL PROTECTED]> wrote:
> ...
>
>   Please edit your text so it's not all one run-on sentence.
> Arranging text neatly not only looks pretty, it ensures that the ideas
> are communicated clearly.
>
> > When i edited my sql.conf and radiusd.conf files to use the Mysql, i
> > received this error... Could not link driver rlm_sql_mysql: file not
> > found as i stated previously in my last post.
>
>   And there was a reply with a solution for you to implement.
>
> >  I researched this error
> > and tried every solution given to me from other users, etc... it came to
> > the point where i just uninstalled Freeradius completely and
> > reconfigured it like this ./configure --disable-shared. then i tried to
> > get it running in text file authentication mode once again. It installed
> > correctly, and i edited my radiusd.conf, clients.conf and users files
> > how i wanted them and then when i ran radiusd -x i kept getting errors
> > for almost every module saying that entries were missing for all of
> > these modules.. so i went through my radiusd.conf file and i commented
> > out everytihng that had to do with these errors..
>
>   Which was a complete and total waste of your time.  You should be
> configuring the server to use MySQL, not deleting everything else from
> the server.
>
> >  So then i went in and decided that i was going to try to setup the
> > Mysql and see what happens. Well, i put an "sql" entry in the
> > radiusd.conf file where i needed them and i edited my sql.conf file
> > accordingly, but i got an error about the sql module entries being
> > missing.
>
>   It helps if you post the *actual* error message.  We can't read your
> mind, and we can't read your terminal remotely.
>
> >  I could not find a way around this, so i went ahead and completely
> > uninstalled Freeradius again.
>
>   Which is again a complete and total waste of your time.  It's not a
> Windows program, you don't need to re-install it if it hiccups.
>
> > Now, this is where i'm at. Surely there are many people out there
> > that have freeradius running with Mysql flawlessly. Can anyone give
> > me exact directions on how i need to ./configure freeradius so that
> > mysql works?
>
>   My previous reply explains what you have to do to get FreeRADIUS
> to know about MySQL.  Work on that stage first.
>
>   Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius

[Dave Mason]

Hi,
I've seen your posts and you have my sympathy.  The best I can say is 
that everything magically works if it's set up right.  I think you've 
already seen the web site with the config notes?

My suggestions would be to rebuild with a fresh dump from the tar file, 
in case you made some changes that arent working.  Alan mentioned that 
you might not have the MySQL development package installed, which sounds 
like a good guess to me.  On my system that's mysql-devel-3.23.58-1, but 
the version number should match what's on your machine.  When you run 
configure, make sure you get some lines that look like this:
checking for mysql/mysql.h... yes
checking for mysql_init in -lmysqlclient... yes
If youre missing the devel package these probably say no.

There is also a faq about link problems.  I dont think that applies to 
your case, but it's a common problem so you might check it out.

Dave

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius

[Alan DeKok]

"Linda Pagillo" <[EMAIL PROTECTED]> wrote:
...

  Please edit your text so it's not all one run-on sentence.
Arranging text neatly not only looks pretty, it ensures that the ideas
are communicated clearly.

> When i edited my sql.conf and radiusd.conf files to use the Mysql, i
> received this error... Could not link driver rlm_sql_mysql: file not
> found as i stated previously in my last post.

  And there was a reply with a solution for you to implement.

>  I researched this error
> and tried every solution given to me from other users, etc... it came to
> the point where i just uninstalled Freeradius completely and
> reconfigured it like this ./configure --disable-shared. then i tried to
> get it running in text file authentication mode once again. It installed
> correctly, and i edited my radiusd.conf, clients.conf and users files
> how i wanted them and then when i ran radiusd -x i kept getting errors
> for almost every module saying that entries were missing for all of
> these modules.. so i went through my radiusd.conf file and i commented
> out everytihng that had to do with these errors..

  Which was a complete and total waste of your time.  You should be
configuring the server to use MySQL, not deleting everything else from
the server.

>  So then i went in and decided that i was going to try to setup the
> Mysql and see what happens. Well, i put an "sql" entry in the
> radiusd.conf file where i needed them and i edited my sql.conf file
> accordingly, but i got an error about the sql module entries being
> missing.

  It helps if you post the *actual* error message.  We can't read your
mind, and we can't read your terminal remotely.

>  I could not find a way around this, so i went ahead and completely
> uninstalled Freeradius again.

  Which is again a complete and total waste of your time.  It's not a
Windows program, you don't need to re-install it if it hiccups.

> Now, this is where i'm at. Surely there are many people out there
> that have freeradius running with Mysql flawlessly. Can anyone give
> me exact directions on how i need to ./configure freeradius so that
> mysql works?

  My previous reply explains what you have to do to get FreeRADIUS
to know about MySQL.  Work on that stage first.

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql and Freeradius (OFF THE LIST)

[Milver S. Nisay]

it should work, one box that i have is 
the exact platform, RH9, MySQL 3.23+freeradius 0.9.3 and it's still working, 
it's not a
bug, there must be something wrong with your 
config.
 
by the way, i can offer my service to you, setting 
up freeradius+mysql, (administration is optional) not for money, but 
only for a book, not that i cannot buy a book, just a simple token from simple accomplishments.
 
let me know your thoughts.
//milver

  - Original Message - 
  From: 
  Linda Pagillo 
  
  To: [EMAIL PROTECTED] 
  
  Sent: Friday, April 30, 2004 5:58 
PM
  Subject: Mysql and Freeradius
  
  Hello again:
   
  I've been trying for days to get freeradius 
  working with Mysql. I'm using Linux Redhat 9, Mysql 3.23 and Freeradius-0.9.3 
  At first i configured freeradius without any options.. i was able to get it 
  working perfectly using text file authentication. Then i started to configure 
  the Mysql part of it. I made a mysql DB and populated it with test data. When 
  i edited my sql.conf and radiusd.conf files to use the Mysql, i received this 
  error... Could not link driver rlm_sql_mysql: file not found as i stated 
  previously in my last post. I researched this error and tried every solution 
  given to me from other users, etc... it came to the point where i just 
  uninstalled Freeradius completely and reconfigured it like this ./configure 
  --disable-shared. then i tried to get it running in text file authentication 
  mode once again. It installed correctly, and i edited my radiusd.conf, 
  clients.conf and users files how i wanted them and then when i ran radiusd -x 
  i kept getting errors for almost every module saying that entries were missing 
  for all of these modules.. so i went through my radiusd.conf file and i 
  commented out everytihng that had to do with these errors.. i got it up and 
  running so i thought because it said i was "ready to recevie requests", but 
  when i did a radtest, it refused me. So then i went in and decided that i was 
  going to try to setup the Mysql and see what happens. Well, i put an "sql" 
  entry in the radiusd.conf file where i needed them and i edited my sql.conf 
  file accordingly, but i got an error about the sql module entries being 
  missing. I could not find a way around this, so i went ahead and completely 
  uninstalled Freeradius again. Now, this is where i'm at. Surely there are many 
  people out there that have freeradius running with Mysql flawlessly. Can 
  anyone give me exact directions on how i need to ./configure freeradius 
  so that mysql works? I'm sorry about the long post, but i know you guys 
  like for people to explain in detail the problems that they are having. Thank 
  you.
   
  Linda PagilloDirector of Technical 
  ServicesN2 The Net

Re: Mysql and Freeradius

[Milver S. Nisay]

 

  Hello again:
   
  I've been trying for days to get freeradius 
  working with Mysql. I'm using Linux Redhat 9, Mysql 3.23 and Freeradius-0.9.3 
  At first i configured freeradius without any options.. i was able to get it 
  working perfectly using text file authentication. Then i started to configure 
  the Mysql part of it. I made a mysql DB and populated it with test data. When 
  i edited my sql.conf and radiusd.conf files to use the Mysql, i received this 
  error... Could not link driver rlm_sql_mysql: file not found as i stated 
  previously in my last post. I researched this error and tried every solution 
  given to me from other users, etc... it came to the point where i just 
  uninstalled Freeradius completely and reconfigured it like this ./configure 
  --disable-shared. then i tried to get it running in text file authentication 
  mode once again. It installed correctly, and i edited my radiusd.conf, 
  clients.conf and users files how i wanted them and then when i ran radiusd -x 
  i kept getting errors for almost every module saying that entries were missing 
  for all of these modules.. so i went through my radiusd.conf file and i 
  commented out everytihng that had to do with these errors.. i got it up and 
  running so i thought because it said i was "ready to recevie requests", but 
  when i did a radtest, it refused me. So then i went in and decided that i was 
  going to try to setup the Mysql and see what happens. Well, i put an "sql" 
  entry in the radiusd.conf file where i needed them and i edited my sql.conf 
  file accordingly, but i got an error about the sql module entries being 
  missing. I could not find a way around this, so i went ahead and completely 
  uninstalled Freeradius again. Now, this is where i'm at. Surely there are many 
  people out there that have freeradius running with Mysql flawlessly. Can 
  anyone give me exact directions on how i need to ./configure freeradius 
  so that mysql works? I'm sorry about the long post, but i know you guys 
  like for people to explain in detail the problems that they are having. Thank 
  you.
   
   
beside from mysql package, make sure you also 
 have  mysql-server package. see to it that your configure commands 
includes
compiling freeradius with rlm_sqlcounter support. 
sql.conf and sqlcounter.conf files must also exists and be included with 
radiusd.conf.
it seems that freeradius cannot find some 
sql  files from your system. radiusd -X would give you a hint.
if this is not the first time you install 
freeradius, removing all the commnets from radiusd.conf would help on easing 
tension on reading and
modifying it. more 
to browse with freeradius list also helps, and 
more to google. good luck then.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Mysql and Freeradius

[Linda Pagillo]

Hello again:
 
I've been trying for days to get freeradius working 
with Mysql. I'm using Linux Redhat 9, Mysql 3.23 and Freeradius-0.9.3 At first i 
configured freeradius without any options.. i was able to get it working 
perfectly using text file authentication. Then i started to configure the Mysql 
part of it. I made a mysql DB and populated it with test data. When i edited my 
sql.conf and radiusd.conf files to use the Mysql, i received this error... Could 
not link driver rlm_sql_mysql: file not found as i stated previously in my last 
post. I researched this error and tried every solution given to me from other 
users, etc... it came to the point where i just uninstalled Freeradius 
completely and reconfigured it like this ./configure --disable-shared. then i 
tried to get it running in text file authentication mode once again. It 
installed correctly, and i edited my radiusd.conf, clients.conf and users files 
how i wanted them and then when i ran radiusd -x i kept getting errors for 
almost every module saying that entries were missing for all of these modules.. 
so i went through my radiusd.conf file and i commented out everytihng that had 
to do with these errors.. i got it up and running so i thought because it said i 
was "ready to recevie requests", but when i did a radtest, it refused me. So 
then i went in and decided that i was going to try to setup the Mysql and see 
what happens. Well, i put an "sql" entry in the radiusd.conf file where i needed 
them and i edited my sql.conf file accordingly, but i got an error about the sql 
module entries being missing. I could not find a way around this, so i went 
ahead and completely uninstalled Freeradius again. Now, this is where i'm at. 
Surely there are many people out there that have freeradius running with Mysql 
flawlessly. Can anyone give me exact directions on how i need to 
./configure freeradius so that mysql works? I'm sorry about the long 
post, but i know you guys like for people to explain in detail the problems that 
they are having. Thank you.
 
Linda PagilloDirector of Technical 
ServicesN2 The Net

RE: MySql and freeRadius

[Jeremy Davis]

> Can you send link to RPMS and will this work on redhat 9 ?
>
> Thanks !

I use apt for rpm at apt.freshrpms.net  50 Radius installs later and not a
hiccup.

Jeremy


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySql and freeRadius

[Juan Pablo Fava]

> Can you send link to RPMS and will this work on redhat 9 ?
I dont know but i supose yes, i use fedora core 1

Mysql and freeradius from the oroginal distribution:

and sqlcounter from here:
http://rpm.pbone.net/index.php3/stat/4/idpl/1061499/com/freeradius-sqlcounter-0.9.3-alt3.i586.rpm.html

freeradius-mysql you can get it here:

ALTLinux

ftp.altlinux.ru/pub/distributions/ALTLinux/Sisyphus/files/i586/RPMS/freeradius-mysql-0.9.3-alt3.i586.rpm

Mandrake Other

carroll.cac.psu.edu/pub/linux/distributions/mandrake-devel/contrib/i586/freeradius-mysql-0.9.2-3mdk.i586.rpm

Fedora Core 1

download.fedora.redhat.com/pub/fedora/linux/core/1/i386/os/Fedora/RPMS/freeradius-mysql-0.9.1-1.i386.rpm

Fedora Other

download.fedora.redhat.com/pub/fedora/linux/core/development/i386/Fedora/RPMS/freeradius-mysql-0.9.1-1.i386.rpm

Mandrake 9.X

carroll.cac.psu.edu/pub/linux/distributions/mandrake/9.1/contrib/i586/freeradius-mysql-0.8.1-1mdk.i586.rpm

Juan


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySql and freeRadius

[John Overman]

Can you send link to RPMS and will this work on redhat 9 ?

Thanks ! 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Juan Pablo
Fava
Sent: Wednesday, March 24, 2004 3:48 PM
To: [EMAIL PROTECTED]
Subject: Re: MySql and freeRadius

I have a working instalation all with binary rpm, i didnt compile anything.
all from freshrpms.

freeradius, mysql, freeradius-mysql (i think this is the name i cant check
now) and freerdius-sqlcounter (not for red hat, but i moved the files to the
right place and it works)

juan.

Keith Yoder dijo:
> John Que escreveu:
>
>> As I understand , I must install the sources of MySql if I want to 
>> use rlm_sql in freeRadius (and not install the rpm for mySql Server 
>> and client).
>
> Actually, you can install the -devel rpms and that will allow you to 
> compile the rlm_sql_mysql module.  This will make sure all the 
> libraries and header files get to the right places.
>
> -
> 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: MySql and freeRadius

[Juan Pablo Fava]

I have a working instalation all with binary rpm, i didnt compile
anything. all from freshrpms.

freeradius, mysql, freeradius-mysql (i think this is the name i cant check
now) and freerdius-sqlcounter (not for red hat, but i moved the files to
the right place and it works)

juan.

Keith Yoder dijo:
> John Que escreveu:
>
>> As I understand , I must install the sources of MySql if I want to use
>> rlm_sql in freeRadius
>> (and not install the rpm for mySql Server and client).
>
> Actually, you can install the -devel rpms and that will allow you to
> compile the rlm_sql_mysql module.  This will make sure all the libraries
> and header files get to the right places.
>
> -
> 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[3]: MySql and freeRadius

[Humberto Diogenes]

Wednesday, March 24, 2004, 6:19:51 PM, John escreveu:

JQ> I made a search in "rpmfind.net" for mysql ; then , i searched the
JQ> results for "devel" and there was not  one result.


Search for "mysql-devel".

You  said  you're using Red Hat 9, so you'll be much better if you use
apt-get to search/download/install packets: http://apt.freshrpms.net

When  recompiling  again,  pay  close attention to the warnings on the
"make" output.










--
Humberto Diógenes
Administração de Redes
--
Internet é Diginet
http://www.digi.com.br


-- 
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySql and freeRadius

[Kirti S. Bajwa]

Hello List:

I want to make sure I am installing freeRADIUS & MySQL correctly. I
installed (test installation) freeRADIUS (0.9.3) and MySQL 5.0.0 (?) from
binaries on a RH9 machine. It tested fine. In the next couple of days, I am
going to do a final installation of freeRADIUS & MySQL (with InnoDB). 

Questions:
==
(1) with the above setup, what version of MySQL (binaries or rpm) should I
use?
(2) Do I still need a develoment package of MySQL to work with freeRADIUS?
If YES, what version of MySQL?

I am new to MySQL!!


Kirti


-Original Message-
From: Keith Yoder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 2:36 PM
To: [EMAIL PROTECTED]
Subject: Re: MySql and freeRadius


John Que escreveu:

> As I understand , I must install the sources of MySql if I want to use 
> rlm_sql in freeRadius
> (and not install the rpm for mySql Server and client).

Actually, you can install the -devel rpms and that will allow you to 
compile the rlm_sql_mysql module.  This will make sure all the libraries 
and header files get to the right places.

- 
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: MySql and freeRadius

[John Kiehnle]

Now I might be popping off cause I don't know with 
certainty... but have a look at these things. Make sure 
you added the proper lines in /etc/ld.so.conf and run 
ldconfig to update your libraries after you install MySQL. 

Also many applications will require the addition of 
./configure --with-mysql=/usr/local/mysql or wherever your 
mysql was installed. 

Just a few thoughts. good luck...

JK

On Wed, 24 Mar 2004 22:27:42 +0300
 "John Que" <[EMAIL PROTECTED]> wrote:
*This message was transferred with a trial version of 
CommuniGate(tm) Pro*
Hello,
I want to use MySql with freeRadius.
I want to use rlm_sql_mysql

I am developing on RedHat Linux 9.

As I understand , I must install the sources of MySql if 
I want to use rlm_sql in freeRadius
(and not install the rpm for mySql Server and client).

Now, I had done so. And I had used the ordinary chain;
./configure
make
make install
both for MySql and afterwards for freeRadius.

Now , I had prepared and configured sql tables to be used 
by freeRadius.
when I try to run ./freeRadius -X I get the
following error

rlm_sql: Could not link driver rlm_sql_mysql: file not 
found

I had seen the 4.14 section of the FAQ of freeradius and 
I do not know what I
did wrong.

I have 2  questiions:

1) Is it ok to use the usual chain
./configure
make
make install
when we want to use MySql with freeRadius ?

or should I had some attribute to the configure ?

(the thing is that I sea, in freeRadius tree,
src\modules\rlm_sql\drivers\rlm_sql_mysql, in config.log 
,
an error that it does not find mysql.h ;
Any idea what can cause it?)



2) This error : rlm_sql: Could not link driver 
rlm_sql_mysql: file not found

should the make of freeRadius create a  file 
rlm_sql_mysql.so
or lm_sql_mysql.o or lm_sql_mysql.a
or something like it?

Any help will be appreciated.

regards,
sting
_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

- 
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: Re: MySql and freeRadius

[John Que]

Hello,
first,thnks , Keith Yoder .
second;
you said:
"Actually, you can install the -devel rpms and that will allow you to
compile the rlm_sql_mysql module".
I assume you are talking about the sql . Am i right?

which devel rpms do you mean and where can they be found ?

I made a search in "rpmfind.net" for mysql ; then , i searched the
results for "devel" and there was not  one result.
regards,
john
_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: MySql and freeRadius

[Keith Yoder]

John Que escreveu:

As I understand , I must install the sources of MySql if I want to use 
rlm_sql in freeRadius
(and not install the rpm for mySql Server and client).
Actually, you can install the -devel rpms and that will allow you to 
compile the rlm_sql_mysql module.  This will make sure all the libraries 
and header files get to the right places.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

MySql and freeRadius

[John Que]

Hello,
I want to use MySql with freeRadius.
I want to use rlm_sql_mysql
I am developing on RedHat Linux 9.

As I understand , I must install the sources of MySql if I want to use 
rlm_sql in freeRadius
(and not install the rpm for mySql Server and client).

Now, I had done so. And I had used the ordinary chain;
./configure
make
make install
both for MySql and afterwards for freeRadius.

Now , I had prepared and configured sql tables to be used by freeRadius.
when I try to run ./freeRadius -X I get the
following error
rlm_sql: Could not link driver rlm_sql_mysql: file not found

I had seen the 4.14 section of the FAQ of freeradius and I do not know what 
I
did wrong.

I have 2  questiions:

1) Is it ok to use the usual chain
./configure
make
make install
when we want to use MySql with freeRadius ?

or should I had some attribute to the configure ?

(the thing is that I sea, in freeRadius tree,
src\modules\rlm_sql\drivers\rlm_sql_mysql, in config.log ,
an error that it does not find mysql.h ;
Any idea what can cause it?)


2) This error : rlm_sql: Could not link driver rlm_sql_mysql: file not found

should the make of freeRadius create a  file rlm_sql_mysql.so
or lm_sql_mysql.o or lm_sql_mysql.a
or something like it?
Any help will be appreciated.

regards,
sting
_
Protect your PC - get McAfee.com VirusScan Online 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html