Re: Mysql Error Message and Postgresql Question

[Guy Fraser]

Ugur GUNCER wrote:

Hi 

Im my radius server gives "Mysql check_error : 1054 received "message after
user authorization procc.
What is it mean 

My usergroup table is  empty !!!

modcall: entering group authorize
 modcall[authorize]: module "preprocess" returns ok
radius_xlat:  'dark'
rlm_sql (sql): sql_set_user escaped user --> 'dark'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'dark' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat:  'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'dark' ORDER BY id'
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
rlm_sql (sql): Released sql socket id: 4


And my second question is 

im exporting detail to mysql
But i want to export detail to postgresql 

At same time with mysql 

i edit my
Radius.conf . Like this
# Include another file that has the SQL-related configuration.
       # This is another file solely because it tends to be big.
       #
       #  The following configuration file is for use with MySQL.
       #
       # For Postgresql, use:          ${confdir}/postgresql.conf
       # For MS-SQL, use:              ${confdir}/mssql.conf
       #
       $INCLUDE  ${confdir}/sql.conf
The line above should be commented out or removed.

       $INCLUDE  /usr/local/radiusd/etc/raddb/postgresql.conf
       # Write a 'utmp' style log file, of which users are currently
       # logged in, and where they've logged in from.
       #
And postgresql.conf  like this 

# Connect info
       server = "localhost"
       login = "puser"
       password = "ppass"
       # Database table configuration
       radius_db = "pdata_db"
But in postgres radacct table is empty 

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

 

--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html