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