At Mon, 15 Dec 2003 12:57:24 +0000,
James Green wrote:
>
> ZORBADELOS KONSTANTINOS wrote:
>
You said you used radiusd -x and not radiusd -X (case is important).
Please send the output you receive from radiusd -X. See the rlm_sql
and radius_xlat messages. Perhaps something is wrong with the
configuration of queries.
> >At Mon, 15 Dec 2003 10:25:36 +0000,
> >James Green wrote:
> >
> >
> >Use radiusd -X and see what happens with the requests. You should see
> >the sql queries that the server tries to execute.
> >
> >
>
> Zorbadelos,
>
> This has been done. That is how I know it connects to the database, but
> doesn't perform any SQL queries.
>
> I can get it to look up the user in the database even, it just refuses
> to log the result in the database.
>
> Its driving me up the wall :-(
>
> James
>
> >
> >
> >>Good morning all,
> >>
> >>We have a server with a really old copy of FreeRADIUS logging accounting
> >>data to mysql 3.xx. We are now in the process of upgrading to the latest
> >>stable of mysql 4 and freeradius.
> >>
> >>We've built the system on a separate machine and it works during
> >>testing, except it doesn't log anything to mysql. We have authorisation
> >>checks using flat files, but use mysql for logging.
> >>
> >>radtest works fine, nothing in mysql. radiusd -x shows it connects fine
> >>to the mysql server, and mysqld shows it has connected.
> >>
> >>Yet there is no sqltrace.sql file either.
> >>
> >>We have confirmed the username/password details can log in, and the
> >>table names are correct. The accounting{} part is as default, with 'sql'
> >>right above 'unix'.
> >>
> >>Some help would be appreciated. We are at a loss!
> >>
> >>Thanks,
> >>
> >>James Green
> >>
> >>
> >>
> >>-
> >>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >>
> >>
> >======================================================
> > Kostas Zorbadelos
> > Currently at: Otenet IT Department
> > mailto: [EMAIL PROTECTED]
> >
> > Out there in the darkness, out there in the night
> > out there in the starlight, one soul burns brighter
> > than a thousand suns.
> >
> >
> >-
> >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
> >
> >
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
======================================================
Kostas Zorbadelos
Currently at: Otenet IT Department
mailto: [EMAIL PROTECTED]
Out there in the darkness, out there in the night
out there in the starlight, one soul burns brighter
than a thousand suns.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
