[RADIATOR] Can't Insert into database - fresh radiator install

[Christian Kratzer]

Hi,

On Fri, 10 Dec 2010, Ricardo Freitas wrote:

> Hello everyone.
>
> I just installed Radiator 4.7. Have perl 5.12 and Mysql 5.1.8x.
>
> I had a running configuration of Radiator 2.19 that worked fine and upon
> any call, it would register the info on my database.
>
> Currently, I'm trying to "authenticate" some calls using "radpwtsd" but
> despite the fact I'm able to authenticate and account for each call,
> those calls aren't inserted into the database - bear in mind that they
> are logged and saved into the radius log directory.

as you quoted "authenticate" above are you aware that accounting is a separate process and if you have given -noacct or similar options to radpwtst it will not generate any accounting.

> I would also like to know how I can configure such logs since I'm trying
> to log different perl files (so I can find out what is happening with
> some variables) but I'm unable to do so. Thought a simple printf would
> suffice if I was running the --config-file with debug on.


For starters raise the loglevel to 4 and make sure you have specified a logfile file using the LogFile directive.

Alternatively just start radiator from the command line using -log_stdout -trace 4 -foreground options.

You should watch for mysql connection errors and for errors from perl in case it cannot load modules such as DBI or DBD::mysql.

You of course need to install DBI and DBD::mysql for mysql connections to work from any perl application.

> I can't manage to get the calls into the database and on the mysql logs
> I haven't got any error (error log and general query log). I've tried to
> access and insert a record into the database using the mysql/radius user
> file and was able to.
>
> Can you guys give me some tips on where to start looking for problems? I
> mean from 2.19 to 4.7 is an huge leap.

For more detailed help you might want to post your config file stripped of all secrets.

Greetings
Chrsitian

-- 
Christian Kratzer                      CK Software GmbH
Email:   ck at cksoft.de                  Wildberger Weg 24/2
Phone:   +49 7032 893 997 - 0          D-71126 Gaeufelden
Fax:     +49 7032 893 997 - 9          HRB 245288, Amtsgericht Stuttgart
Web:     http://www.cksoft.de/         Geschaeftsfuehrer: Christian Kratzer