OpenForum RSS: Freeradius � Mysql ��

Freeradius � Mysql �� (kolyaniust)

Tue, 26 Jun 2012 12:48:15 GMT

> ��

� �� , �� !!!!

Freeradius � Mysql �� (tetst)

Wed, 06 Jul 2011 13:21:59 GMT

��

Freeradius � Mysql �� (tetst)

Wed, 06 Jul 2011 08:02:26 GMT

� �� [code]server = "77.*.*.53"[/code] � ��
[code]server = "localhost"[/code]

�� [code]rlm_sql (sql) in sql_postauth: Database query error - Unknown column 'username' in 'field list'
[/code]

��
[code]
select * from radcheck;
+----+----------+--------------------+----+---------+
| id | UserName | Attribute | op | Value |
+----+----------+--------------------+----+---------+
| 2 | testsql2 | Cleartext-Password | := | test123 |
+----+----------+--------------------+----+---------+

select * from radreply;
+----+----------+-------------------+----+---------------+
| id | UserName | Attribute | op | Value |
+----+----------+-------------------+----+---------------+
| 2 | testsql2 | Framed-IP-Address | = | 172.16.1.135 |
| 3 | testsql2 &#

Freeradius � Mysql �� (Aquarius)

Tue, 05 Jul 2011 15:03:50 GMT

> sql.conf
> [code]# Connection info:
> <------>server = "77.*.*.53"
> <------>port = 3306
> <------>login = "radius"
> <------>password = "radpass"
> <------># Database table configuration for everything except Oracle
> <------>radius_db = "radius"
> [/code]

� ��, ��, ��:
� telnet'�� ?

Freeradius � Mysql �� (tetst)

Tue, 05 Jul 2011 08:38:35 GMT

sql.conf
[code]# Connection info:
<------>server = "77.*.*.53"
<------>port = 3306
<------>login = "radius"
<------>password = "radpass"

<------># Database table configuration for everything except Oracle
<------>radius_db = "radius"
[/code]

Freeradius � Mysql �� (Aquarius)

Tue, 05 Jul 2011 08:09:54 GMT

> ��
> � ��?

�� , ��, �� MySQL'�� , � �� radius'��?

Freeradius � Mysql �� (tetst)

Tue, 05 Jul 2011 07:04:53 GMT

�� ?

Freeradius � Mysql �� (Aquarius)

Tue, 05 Jul 2011 06:54:29 GMT

> �� FreeBSD 7.3, Freeradius 2.1.0 MySQL 5.5.7
> �� , �� 691,
> � ��
> [code]rlm_sql_mysql: Starting connect to MySQL server for #4

� �� radius �� MySQL �� radius'�� ?
>[�� ]
> rlm_sql (sql): Failed to connect DB handle #4
> rlm_sql (sql): Ignoring unconnected handle 4..
> rlm_sql (sql): Ignoring unconnected handle 3..
> rlm_sql (sql): Ignoring unconnected handle 2..
> rlm_sql (sql): Ignoring unconnected handle 1..
> rlm_sql (sql): Ignoring unconnected handle 0..
> rlm_sql (sql): There are no DB handles to use! skipped 5, tried
> to connect 1
> ++[sql] returns fail
> [/code]

Freeradius � Mysql �� (tetst)

Tue, 05 Jul 2011 06:28:49 GMT

telnet 77.*.*.53 1812???
�� [code] #sockstat
USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN ADDRESS
freeradius radiusd 77623 6 udp4 77.241.240.53:1812 *:*
freeradius radiusd 77623 7 udp4 *:1813 *:*
freeradius radiusd 77623 8 stream /var/run/radiusd/radiusd.sock
freeradius radiusd 77623 9 udp4 127.0.0.1:18120 *:*
freeradius radiusd 77623 10 udp4 77.241.240.53:1814 *:*
[/code]

OpenForum RSS: Freeradius � Mysql ��������

Freeradius � Mysql �������� (kolyaniust)

Freeradius � Mysql �������� (tetst)

Freeradius � Mysql �������� (tetst)

Freeradius � Mysql �������� (Aquarius)

Freeradius � Mysql �������� (tetst)

Freeradius � Mysql �������� (Aquarius)

Freeradius � Mysql �������� (tetst)

Freeradius � Mysql �������� (Aquarius)

Freeradius � Mysql �������� (tetst)

OpenForum RSS: Freeradius � Mysql ��

Freeradius � Mysql �� (kolyaniust)

Freeradius � Mysql �� (tetst)

Freeradius � Mysql �� (tetst)

Freeradius � Mysql �� (Aquarius)

Freeradius � Mysql �� (tetst)

Freeradius � Mysql �� (Aquarius)

Freeradius � Mysql �� (tetst)

Freeradius � Mysql �� (Aquarius)

Freeradius � Mysql �� (tetst)