HI joe
Well can u check out with u 1st table
mysql> select * from radcheck;
+----+----------------+----------------+------------------+------+
| id | UserName | Attribute | Value | Op |
+----+----------------+----------------+------------------+------+
| 1 | fredf | Password | wilma | == |
| 2 | barney | Password | betty | == |
| 2 | dialrouter | Password | dialup | == |
+----+----------------+----------------+------------------+------+
your table does not have Attribute value or Password it shoulde not value...
Also u can check Using radtest wht will be result...n one more
thing..When u will ask question write up in details not like i want
to configure pppoe server +mysql+radius server
do u tell where u configured PPPOE SERVER n what is tht i
guess ( MikroTIK) Ha.ha.a.a.a.a.a.a.
try to write query
select * from radcheck Where USERNAME='joe'
give this query in your mysql n will get result or not tell me ...
Hope u get...something !!!!!!!!!!!!!
On 01 Nov 2004 16:28:45 +0530, Joel n.solanki <[EMAIL PROTECTED]> wrote:
> Dear all,
>
> I have configured pppoe+ mysql with free-radius.
> Now i have used the sql file camed along with free-radius source.
> this is the file
> freeradius-0.9.2/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
>
> Now i made the database according to told by this document
>
> http://www.frontios.com/freeradius.html
>
> So now my mysql look like this.
> But by doing this configuration i cant connect to the pppoe server.
>
> I am starting my radius in debug mode with this command: radiusd -X
>
> when connecting from client machine i m getting this error ...radius
> tell me like this.
>
> rad_recv: Access-Request packet from host 127.0.0.1:32768, id=237,
> length=68
> Service-Type = Framed-User
> Framed-Protocol = PPP
> User-Name = "joel"
> User-Password = "joel123"
> NAS-IP-Address = 127.0.0.1
> NAS-Port = 1
> modcall: entering group authorize for request 1
> modcall[authorize]: module "preprocess" returns ok for request 1
> modcall[authorize]: module "chap" returns noop for request 1
> rlm_realm: No '@' in User-Name = "joel", looking up realm NULL
> rlm_realm: No such realm "NULL"
> modcall[authorize]: module "suffix" returns noop for request 1
> radius_xlat: 'joel'
> rlm_sql (sql): sql_set_user escaped user --> 'joel'
> radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
> Username = 'joel' ORDER BY id'
> rlm_sql (sql): Reserving sql socket id: 3
> rlm_sql: unknown attribute joel123
> rlm_sql (sql): Error getting data from database
> rlm_sql (sql): SQL query error; rejecting user
> rlm_sql (sql): Released sql socket id: 3
> modcall[authorize]: module "sql" returns fail for request 1
> modcall: group authorize returns fail for request 1
> Finished request 1
>
> Here it is telling me that SQL querry error; rejecting use ...something
> related to sql query...
> What will be the problem ????
> How can i solve this problem ???
> What i have done wrong ????
>
> mysql> select * from radacct;
> Empty set (0.00 sec)
>
> mysql> select * from radcheck;
> +----+----------+-----------+----+------------+
> | id | UserName | Attribute | op | Value |
> +----+----------+-----------+----+------------+
> | 1 | d2v | d2v123 | == | d2vdy |
> | 2 | joel | joel123 | == | joelbhai |
> | 3 | dhaval | dhaval123 | == | dhavalbhai |
> +----+----------+-----------+----+------------+
> 3 rows in set (0.00 sec)
>
> mysql> select * from radgroupcheck;
> +----+-----------+-----------+----+-------+
> | id | GroupName | Attribute | op | Value |
> +----+-----------+-----------+----+-------+
> | 1 | dynamic | Auth-Type | := | Local |
> | 2 | static | Auth-Type | := | Local |
> +----+-----------+-----------+----+-------+
> 2 rows in set (0.00 sec)
>
> mysql> select * from radgroupreply;
> +----+-----------+--------------------+----+---------------------+------+
> | id | GroupName | Attribute | op | Value | prio
> |
> +----+-----------+--------------------+----+---------------------+------+
> | 1 | dynamic | Framed-Compresion | := | Van-Jacobsen-TCP-IP | 1
> |
> | 2 | dynamic | Framed-Protocol | := | PPP | 1
> |
> | 3 | dynamic | Service-Type | := | Framed-User | 1
> |
> | 4 | dynamic | Framed-MTU | := | 1500 | 1
> |
> | 5 | static | Framed-Protocol | := | PPP | 2
> |
> | 6 | static | Service-Type | := | Framed-User | 2
> |
> | 7 | static | Framed-Compression | := | Van-Jacobsen-TCP-IP | 2
> |
> +----+-----------+--------------------+----+---------------------+------+
> 7 rows in set (0.00 sec)
>
> mysql> select * from radreply;
> +----+----------+-------------------+----+--------------+
> | id | UserName | Attribute | op | Value |
> +----+----------+-------------------+----+--------------+
> | 1 | joel | Framed-IP-Address | := | 192.168.0.25 |
> | 2 | dhaval | Framed-IP-Address | := | 192.168.0.30 |
> +----+----------+-------------------+----+--------------+
> 2 rows in set (0.00 sec)
>
> mysql> select * from usergroup;
> +----+----------+-----------+
> | id | UserName | GroupName |
> +----+----------+-----------+
> | 1 | d2v | dynamic |
> | 2 | joel | static |
> | 3 | dhaval | static |
> +----+----------+-----------+
> 3 rows in set (0.00 sec)
>
> --
> Joel N.Solanki
> Systems Administrator
> Mobile: 91-9426353268
> Phone No: 0265-550001/2/3/4/5 Ext: 211/212
> Digtial 2 Virtual Internet Service Provider.
> http://www.packetraptor.com/
> http://www.d2visp.com/
> Gujarat (India)
> --
> Joel N.Solanki
> Network Administrator
> Mobile: 91-9426353268
> Phone No: 0265-550001/2/3/4/5 Ext: 211/212
> Digtial 2 Virtual Internet Service Provider.
> http://www.packetraptor.com/
> http://www.d2visp.com/
> Gujarat (India)
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
--
Regards
Vipul Ramani
[EMAIL PROTECTED]
[EMAIL PROTECTED]
~~~~~We Know HoW NeTWoRkS !!!!~~~
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
