I made a mistake.
I posted an output that had problems
Here's the output with the mistakes:
rad_recv: Access-Request packet from host 192.168.226.13:36704, id=189, length=206
User-Name = "[EMAIL PROTECTED]
Digest-Attributes = 0x0a0761646d696e
Digest-Attributes = 0x01103139322e3136382e3232362e3133
Digest-Attributes = 0x022a34353031386134373232653237643866613166333663303539343262393938666166333531666263
Digest-Attributes = 0x04147369703a3139322e3136382e3232362e3133
Digest-Attributes = 0x030a5245474953544552
Digest-Response = "19f6c96bf5fe597d0cc2a1fc9a390917"
Service-Type = Sip-Session
Sip-Uri-User = "admin"
NAS-Port = 5060
NAS-IP-Address = xxx.xxx.xxx.xxx
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module "preprocess" returns ok for request 0
modcall[authorize]: module "chap" returns noop for request 0
modcall[authorize]: module "mschap" returns noop for request 0
rlm_digest: Converting Digest-Attributes to something sane...
Digest-User-Name = "admin"
Digest-Realm = "xxx.xxx.xxx.xxx"
Digest-Nonce = "45018a4722e27d8fa1f36c05942b998faf351fbc"
Digest-URI = "sip:xxx.xxx.xxx"
Digest-Method = "REGISTER"
rlm_digest: Adding Auth-Type = DIGEST
modcall[authorize]: module "digest" returns ok for request 0
rlm_realm: Looking up realm "xxx.xxx.xxx.xxx" for User-Name = "[EMAIL PROTECTED]"
rlm_realm: No such realm "xxx.xxx.xxx.xxx"
modcall[authorize]: module "suffix" returns noop for request 0
rlm_eap: No EAP-Message, not doing EAP
modcall[authorize]: module "eap" returns noop for request 0
users: Matched entry DEFAULT at line 152
modcall[authorize]: module "files" returns ok for request 0
radius_xlat: 'admin'
rlm_sql (sql): sql_set_user escaped user --> 'admin'
radius_xlat: 'SELECT phplib_id, username, password FROM subscriber WHERE LOWER(username) = LOWER('admin') ORDER BY phplib_id'
rlm_sql (sql): Reserving sql socket id: 4
Segmentation fault
On 9/8/06, Roberto Lopes <[EMAIL PROTECTED]
> wrote:
Hello!
I'm having some problems when wanting the database of SER to be the one FreeRADIUS will be checking on, instead of the radius database.
Like that I changed the file /etc/raddb/sql.conf
At the end is the output of the problems.
Hope somebody can help,
Thanks in advance
Roberto
#----------------------------------------------------------------------------------------------------------------------------------------------#
#SQL.conf
sql {
driver = "rlm_sql_mysql"
server = "localhost"
login = "root"
password = "**********"
# Database table configuration
radius_db = "ser"
# Allow for storing data after authentication
postauth_table = "authenticate"
authcheck_table = "subscriber"
authreply_table = "subscriber2"
### postauth_table = "radpostauth"
### authcheck_table = "radcheck"
### authreply_table = "radreply"
### groupcheck_table = "radgroupcheck"
### groupreply_table = "radgroupreply"
### usergroup_table = "usergroup"
# Table to keep radius client info
### nas_table = "nas"
authorize_check_query = "SELECT phplib_id, username, password\
FROM ${authcheck_table} \
WHERE LOWER(username) = LOWER('%{SQL-User-Name}') \
ORDER BY phplib_id"
authorize_reply_query = "SELECT phplib_id, username, password\
FROM ${authreply_table} \
WHERE LOWER(username) = LOWER('%{SQL-User-Name}') \
ORDER BY phplib_id"
authorize_check_query = "SELECT phplib_id, username, password\
FROM ${authcheck_table} \
WHERE username = '%{SQL-User-Name}' \
ORDER BY phplib_id"
authorize_reply_query = "SELECT phplib_id, username, password\
FROM ${authreply_table} \
WHERE username = '%{SQL-User-Name}' \
ORDER BY phplib_id"
postauth_query = "INSERT into ${postauth_table} (phplib_id, user, pass, reply, date) values ('', '%{User-Name}',
'%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())"
#SQL.conf
#----------------------------------------------------------------------------------------------------------------------------------------------#
I thought that i neede to create some more tables so here they are
Subscriber2 will act like- authcheck_table
Authenticate will actlike - postauth_table
#----------------------------------------------------------------------------------------------------------------------------------------------#
#Tables created in databaseSER
CREATE TABLE authenticate (
phplib_id varchar(32) not null default '',
user varchar(64) not null default '',
pass varchar(25) not null default '',
reply varchar(25) not null default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY phplib_id(phplib_id));
table subsciber had exactly the same structure of subscriber2
CREATE TABLE subscriber2 (
phplib_id varchar(32) NOT NULL default '',
$USERCOL varchar(64) NOT NULL default '',
domain varchar(128) NOT NULL default '',
password varchar(25) NOT NULL default '',
first_name varchar(25) NOT NULL default '',
last_name varchar(45) NOT NULL default '',
phone varchar(15) NOT NULL default '',
email_address varchar(50) NOT NULL default '',
datetime_created datetime NOT NULL default '0000-00-00 00:00:00',
datetime_modified datetime NOT NULL default '0000-00-00 00:00:00',
confirmation varchar(64) NOT NULL default '',
flag char(1) NOT NULL default 'o',
sendnotification varchar(50) NOT NULL default '',
greeting varchar(50) NOT NULL default '',
ha1 varchar(128) NOT NULL default '',
ha1b varchar(128) NOT NULL default '',
allow_find char(1) NOT NULL default '0',
timezone varchar(128) default NULL,
rpid varchar(128) default NULL,
domn int(10) default NULL,
uuid varchar(64) default NULL,
UNIQUE KEY phplib_id (phplib_id),
PRIMARY KEY ($USERCOL, domain),
KEY user_2 ($USERCOL)
) ;
#Tables created in databaseSER
#----------------------------------------------------------------------------------------------------------------------------------------------#
Output Problems
reread_config: reading radiusd.conf
Config: including file: /etc/raddb/proxy.conf
Config: including file: /etc/raddb/clients.conf
Config: including file: /etc/raddb/snmp.conf
Config: including file: /etc/raddb/eap.conf
Config: including file: /etc/raddb/sql.conf
/etc/raddb/sql.conf[243]: Line is not in 'attribute = value' format
Errors reading radiusd.conf
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
