OpenForum RSS: MySQL & RadiusD

MySQL & RadiusD (.)

Wed, 08 Apr 2009 06:15:08 GMT

>��!
>radius �� mysql_query.
>mysql_query �� .

��. Update �� .

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...]
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]

MySQL & RadiusD (linspb)

Wed, 20 Jul 2005 13:16:43 GMT

�� :

--- src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c.orig Wed Jul 20 17:08:15 2005
+++ src/modules/rlm_sql/drivers/rlm_sql_mysql/sql_mysql.c Wed Jul 20 17:07:44 2005
@@ -145,9 +145,14 @@
*
* Purpose: Issue a query to the database
*
+ * Patched by linspb@gmail.com
+ * for many SQL QUERY
*************************************************************************/
static int sql_query(SQLSOCK * sqlsocket, SQL_CONFIG *config, char *querystr)
{
+ char *r;
+ char *str;
+
rlm_sql_mysql_sock *mysql_sock = sqlsocket->conn;

if (config->sqltrace)
@@ -156,8 +161,13 @@
radlog(L_ERR, "rlm_sql_mysql: Socket not connected");
return SQL_DOWN;
}
-
- mysql_query(mysql_sock->sock, querystr);
+
+ r=strdup(querystr);
+ while (str=strsep(&r,";")) {
+ radlog(L_DBG,"rlm_sql_mysql: mysql_query (%s)",str);
+ mysql_query(mysql_sock->sock,str);
+

MySQL & RadiusD (linspb)

Wed, 20 Jul 2005 09:36:27 GMT

��!
radius �� mysql_query.
mysql_query �� .

�� mysql, �� ; � �� .

�� sql_mysql.c
static int sql_query(SQLSOCK * sqlsocket, SQL_CONFIG *config, char *querystr)
{
<...skip...>
mysql_query(mysql_sock->sock, querystr);
return sql_check_error(mysql_errno(mysql_sock->sock));
}

�� .

MySQL & RadiusD (linspb)

Wed, 20 Jul 2005 09:15:48 GMT

>>�� ?
>
>�� =) �� ; � ��

��
... WHERE AcctSessionId = '%{Acct-Session-Id}' \
AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}'; SELECT '1'"
��:
rlm_sql (sql): Couldn't update SQL accounting ALIVE record - You have an error i
syntax; check the manual that corresponds to your MySQL server version for the r
to use near '; SELECT '1'' at line 1

��
... WHERE AcctSessionId = '%{Acct-Session-Id}' \
AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}' \
SELECT '1'"
��:
rlm_sql (sql): Couldn't update SQL accounting ALIVE record - You have an error i
syntax; check the manual that corresponds to your MySQL server version for the r
to use near 'SELECT '1'' at line 1

��, �� ...

MySQL & RadiusD (Simps)

Tue, 19 Jul 2005 12:44:42 GMT

>�� ?

�� =) �� ; � ��

MySQL & RadiusD (linspb)

Tue, 19 Jul 2005 12:25:30 GMT

�� ?

MySQL & RadiusD (linspb)

Mon, 18 Jul 2005 12:27:46 GMT

>�� ? � �� ?

��, �� .

�� ,
�� .

MySQL & RadiusD (Simps)

Mon, 18 Jul 2005 12:07:11 GMT

>�� All,
>
>�� ,
>�� FreeBSD, MPD, Radius, Mysql. �ӣ ��, �� .
>� radius � sql.conf
>��
>accounting_update_query = "UPDATE ${acct_table1} \
> SET FramedIPAddress =
>'%{Framed-IP-Address}', \
> AcctSessionTime = '%{Acct-Session-Time}',
>\
> AcctInputOctets = '%{Acct-Input-Octets}',
>\
> AcctOutputOctets = '%{Acct-Output-Octets}'
>\
> WHERE AcctSessionId =
>'%{Acct-Session-Id}' \
> AND UserName =
>'%{SQL-User-Name}' \
> AND NASIPAddress= '%{NAS-IP-Address}'"
>
>� �� , ��! �� 2 �� 3,4 sql ��
>�� accounting_update_query.
>�� :
>accounting_update_query = "UPDATE ${acct_table1} \
> SET FramedIPAddress =
>'%{Framed-IP-Address}', \
> AcctSessionTime = '%{Acct-Session-Time}',
>\
> AcctInputOctets = '%{Acct-Input-Octets}',
>\
> AcctOutputOctets = '%{Acct-Output-Octets}'
>\
>