Man this is a stumper,
Same question as before. Here is exactly what I have done up to this point. From mysql admin created database radius. Input all tables from src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql with this command:
mysql -u chilli -p radius < ~/freeradius-1.0.2/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
There is only one syntax error in that file - the id row on the "nas" table. I had to get rid of the default entry. An auto_increment row can't have a default value. I compiled freeradius-1.0.2 and make && make install. All went well. The end of my radius.conf file looks like this
authorize {
preprocess
chap
mschap
#counter
#attr_filter
#eap
suffix sql
#files
#etc_smbpasswd
}
authenticate {
authtype PAP {
pap
}
authtype CHAP {
chap
}
authtype MS-CHAP{
mschap
}
#pam
#unix
#authtype LDAP {
# ldap
#}
}preacct { preprocess
suffix
#files
}
accounting {
acct_unique
detail
#counter
unix
sql
radutmp
#sradutmp
}session {
radutmp
}The rest of the file is untouched from the default.
sql.conf is default accept for the username and password to the database. I know for sure that I can login with that username and password. I have checked to make sure that I can read all the tables from database 'radius' with that username and password.
Now having said all that.... I finally run /usr/local/sbin/radiusd -X and find out that no matter what I do it comes back with this:
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 (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 Segmentation fault
That of course is just the last few lines from the output. I am using fedora core 3. Now when I use files instead of sql everything works
fine - so it has to be the database. The acctual database. Do I need to populate it in a certian way? When I drop the radius database and
start radiusd - IT WORKS. That error doesn't come up. It is able to connect to the sql server and retreive data. It just says that the database 'radius' doesn't exist.
Anyone out there have something that I could try. Maybe some database inserts script for testing data. Known data that works in the tables?
Thanks for your time, Blake
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
