Re: mysql configuration for version 2.1.8

2010-02-25 Thread Pratik Shrestha
Thanks...I have already configured. Pratik On Thu, Feb 25, 2010 at 3:53 PM, Alan DeKok wrote: > Pratik Shrestha wrote: > > Thanks. But is the database schema has changed from previous version? In > > previous version there used to be mysql.sql or db_mysql.sql. In this > > version I found rad.sql

Re: mysql configuration for version 2.1.8

2010-02-25 Thread Fajar A. Nugraha
On Thu, Feb 25, 2010 at 3:47 PM, Pratik Shrestha wrote: > Thanks. But is the database schema has changed from previous version? In > previous version there used to be mysql.sql or db_mysql.sql. In this version > I found rad.sql, cui.sql and so on. where did you find rad.sql? >From /etc/raddb/sql.

Re: mysql configuration for version 2.1.8

2010-02-25 Thread Alan DeKok
Pratik Shrestha wrote: > Thanks. But is the database schema has changed from previous version? In > previous version there used to be mysql.sql or db_mysql.sql. In this > version I found rad.sql, cui.sql and so on. Have you bothered reading the documentation and config files that come with the s

Re: mysql configuration for version 2.1.8

2010-02-25 Thread Pratik Shrestha
Thanks. But is the database schema has changed from previous version? In previous version there used to be mysql.sql or db_mysql.sql. In this version I found rad.sql, cui.sql and so on. And do you know any site that describes the configuration for 2.1.8 with mysql? Pratik On Thu, Feb 25, 2010 at

Re: mysql configuration for version 2.1.8

2010-02-25 Thread Fajar A. Nugraha
On Thu, Feb 25, 2010 at 2:22 PM, Pratik Shrestha wrote: > Hello to all, > I am using the latest version 2.1.8 and I am newbie. I was trying to > configure sql (mysql) for this version, but I did not find any configuration > help from any source. Where did you look? See doc/rlm_sql Or (if you inst

mysql configuration for version 2.1.8

2010-02-24 Thread Pratik Shrestha
Hello to all, I am using the latest version 2.1.8 and I am newbie. I was trying to configure sql (mysql) for this version, but I did not find any configuration help from any source. I cannot find the sql files that used to be in older version. So, can anyone locate these files for me or please tell

Re: freeradius mysql configuration problem

2009-06-09 Thread Ivan Kalik
> grep mysql_config" still remains as follows: > > > configure: WARNING: silently not building rlm_sql_iodbc. > configure: WARNING: FAILURE: rlm_sql_iodbc requires: libiodbc isql.h. > checking for mysql_config... no > configure: WARNING: silently not building rlm_sql_postgresql. > configu

Re: freeradius mysql configuration problem

2009-06-08 Thread EasyHorpak.com
yZone PPPoE Billing 2.5, EasyZone Hotspot Billing 2.7, EasyZone VPN Billing 1.0, EasyZone File Server - Original Message - From: "kalesameer" To: Sent: Tuesday, June 09, 2009 1:31 AM Subject: freeradius mysql configuration problem hi, I am not able to configure fr

Re: freeradius mysql configuration problem

2009-06-08 Thread Marinko Tarlac
You just need to read through log file you posted. kalesameer wrote: hi, I am not able to configure freeradius to use mysql.The output of radiusd -X command is shown below. Can anyone tell me what my mistake is?? Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object

Re: freeradius mysql configuration problem

2009-06-08 Thread Alan DeKok
kalesameer wrote: > hi, > I am not able to configure freeradius to use mysql.The output of radiusd -X > command is shown below. > Can anyone tell me what my mistake is?? Read the FAQ. > Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared > object file: No such file or dire

freeradius mysql configuration problem

2009-06-08 Thread kalesameer
#x27;, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" connect_failure_retry_delay = 60 simul_count_query = "" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocolFROM radacct WHERE username = '%{SQL-User-Name}'AND acctstoptime IS NULL" postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql" /usr/local/etc/raddb/sites-enabled/default[152]: Failed to find module "sql". /usr/local/etc/raddb/sites-enabled/default[62]: Errors parsing authorize section. } Errors initializing modules [r...@localhost mysql]# -- View this message in context: http://www.nabble.com/freeradius-mysql-configuration-problem-tp23929645p23929645.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 configuration

2008-08-25 Thread Ivan Kalik
Read instructions at the end of radiusd.conf. It tels you where are those sections in 2.0.5. Ivan Kalik Kalik Infoprmatika ISP Dana 25/8/2008, "Ahmet DÜLGAR" <[EMAIL PROTECTED]> piše: > >hi everyone >i use fedora 9 and freeraidus 2.0.5 >i want to use mysql database for user lists and i want to

Re: mysql configuration

2008-08-25 Thread Alan DeKok
Ahmet DÜLGAR wrote: > hi everyone > i use fedora 9 and freeraidus 2.0.5 > i want to use mysql database for user lists and i want to limit time > users login for example 3 hour or 3 days > i looked documents for howto wpa Or... just read the examples that come with the server? > but i only cant

mysql configuration

2008-08-25 Thread Ahmet DÜLGAR
hi everyone i use fedora 9 and freeraidus 2.0.5 i want to use mysql database for user lists and i want to limit time users login for example 3 hour or 3 days i looked documents for howto wpa i create the radius db by db_mysql.sql configure the sql.conf by writein login mysql password and include

Re: rlm_sql, mysql configuration

2006-12-04 Thread Stefan Winter
Hi, > see there is a "nas" table that was not around before (at least on > our system), but as far as I can see we still need to use > clients.conf as nas has no field for allowed ip addresses of clients. > Am I missing something? I see no mention of the nas table in the > rlm_sql docs. Thank

rlm_sql, mysql configuration

2006-12-04 Thread Andrew Long
Setting up 1.1.2 with mysql and mschap. Our existing 0.9 setup uses clients.conf file and the rest via the mysql tables. Now, in 1.2, I see there is a "nas" table that was not around before (at least on our system), but as far as I can see we still need to use clients.conf as nas has no field

Freeradius 0.93 with MySQL configuration

2004-01-06 Thread Peter Morgan
I'm trying to setup the MySQL functionality with freeradius version 0.93, but i do not understand what i should put in the 'radreply' or 'radgroupreply' tables. I honestly do not understand what I need to in order to do this, but the tutorial that i followed ( http://www.frontios.com/freeradius.ht