Got a problem - mysql and radius table

2005-04-02 Thread Blake
I am new to this list so perhaps this has been brought up already but: Using freeradius 1.0.1 with mysql. I insert the tables from db_mysql.sql into the radius database and i get an error on id default for the nas table. I simply delete the default entry for that row and everything goes well.

Re: Got a problem - mysql and radius table

2005-04-02 Thread Scott Edwards
On Apr 2, 2005 11:05 AM, Blake [EMAIL PROTECTED] wrote: I am new to this list so perhaps this has been brought up already but: Using freeradius 1.0.1 with mysql. I insert the tables from db_mysql.sql into the radius database and i get an error on id default for the nas table. I simply delete

Re: Got a problem - mysql and radius table

2005-04-02 Thread Blake
Scott Edwards wrote: and just sits there trying to start I look at the mysql process table and it shows that the user has logged in and is reading from net TCP or Unix socket, it's still a network connection. humm... maybe try switching to TCP? hm? Radiusd never gets started.

Re: Got a problem - mysql and radius table

2005-04-02 Thread Scott Edwards
On Apr 2, 2005 11:33 AM, Blake [EMAIL PROTECTED] wrote: Scott Edwards wrote: and just sits there trying to start I look at the mysql process table and it shows that the user has logged in and is reading from net TCP or Unix socket, it's still a network connection. humm... maybe try

Re: Got a problem - mysql and radius table

2005-04-02 Thread Blake
Scott Edwards wrote: On Apr 2, 2005 11:33 AM, Blake [EMAIL PROTECTED] wrote: Scott Edwards wrote: and just sits there trying to start I look at the mysql process table and it shows that the user has logged in and is reading from net TCP or Unix socket, it's still a network

Re: Got a problem - mysql and radius table

2005-04-02 Thread Blake
My guess is that it has something to do with the error when importing the tables from the db_mysql.sql file. The error was on the nas table. Like I said I ended up having to omit the entry for default '0' on the id row. No matter how I worded the default. I would get a syntax error everytime.

Re: Got a problem - mysql and radius table

2005-04-02 Thread Blake
Blake wrote: My guess is that it has something to do with the error when importing the tables from the db_mysql.sql file. The error was on the nas table. Like I said I ended up having to omit the entry for default '0' on the id row. No matter how I worded the default. I would get a syntax

Re: Got a problem - mysql and radius table - more output from debuging mode

2005-04-02 Thread Blake
Here is the last few lines from radiusd -X output: sql: accounting_stop_query_alt = INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop,

Re: Got a problem - mysql and radius table

2005-04-02 Thread Scott Edwards
On Apr 2, 2005 11:50 AM, Blake [EMAIL PROTECTED] wrote: [snip] I don't see the option in sql.conf. Here is what I do have sql { driver = rlm_sql_mysql server = localhost login = sqladmin password = *** radius_db = radius [snip] Here's your

Re: Got a problem - mysql and radius table - more output from debuging mode

2005-04-02 Thread Scott Edwards
On Apr 2, 2005 4:27 PM, Blake [EMAIL PROTECTED] wrote: Here is the last few lines from radiusd -X output: AcctStopTime = 0 sql: postauth_table = radpostauth sql: postauth_query = INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}',