(RADIATOR) Problems upgrading

[Bogdan TARU]

	Hi Hugh & all,

 Yes, indeed, I shuold have passed -dictionary argument to radpwtst (now
it works). As about the "MySQL has gone away problem", here are the infos:

FreeBSD 4.8-REL on x86
Perl v5.6.1 (built from ports)
DBD::mysql v2.9002
DBI v1.37
MySQL 3.23.55

 Thanks,
 bogdan


On Thu, 17 Jul 2003, Hugh Irvine wrote:

>
> Hello Bogdan -
>
> The first problem is because radpwtst cannot find the dictionary file.
>
> You should specify where to find it with "radpwtst -dictionary ....
> -secret ....".
>
> Here is the help from radpwtst:
>
> bash-2.05a$ perl radpwtst -h
> usage: radpwtst [-h] [-time] [-iterations n]
>            [-trace [level]] [-s server] [-secret secret]
>            [-noauth] [-noacct][-nostart] [-nostop] [-status]
>            [-chap] [-mschap] [-mschapv2] [-eapmd5]
>            [-accton] [-acctoff] [-framed_ip_address address]
>            [-auth_port port] [-acct_port port] [-identifier n]
>            [-user username] [-password password] [-nas_ip_address
> address]
>            [-nas_port port] [-nas_port_type type] [-service_type service]
>            [-calling_station_id string] [-called_station_id string]
>            [-session_id string] [-interactive]
>            [-delay_time n] [-session_time n] [-input_octets n]
>            [-output_octets n] [-timeout n] [-dictionary file,file]
>            [-gui] [-class string] [-useoldascendpasswords]
>            [-code requestcode] [-raw data] [-rawfile filename]
>            [attribute=value]...
>
> For the second issue, it sounds like a problem with DBI and/or DBD.
>
> What hardware/software platform are you using? And what versions of
> Perl, DBI, DBD, etc.?
>
> regards
>
> Hugh
>
>
> On Wednesday, Jul 16, 2003, at 21:19 Australia/Melbourne, Bogdan TARU
> wrote:
>
> >
> >
> > 	Hi Hugh & all,
> >
> >  I have installed Radiator 3.6 (with patches), and when trying to test
> > with radpwtst (/usr/local/radius/bin/radpwtst -secret foobar -user pp
> > -password bleh -auth_port 1812 -acct_port 1813 -nas_ip_address
> > 192.168.0.9 -nas_port_type=2), not only do I get a lot of messages
> > like:
> >
> > Attribute number 1 is not defined in your dictionary
> > Attribute number 6 is not defined in your dictionary
> > Attribute number 4 is not defined in your dictionary
> > Attribute number 5 is not defined in your dictionary
> > Attribute number 30 is not defined in your dictionary
> > Attribute number 31 is not defined in your dictionary
> > Attribute number 61 is not defined in your dictionary
> > Attribute number 2 is not defined in your dictionary
> > No such attribute Unknown
> > No such attribute Unknown
> > No such attribute Unknown
> > No such attribute Unknown
> > No such attribute Unknown
> > No such attribute Unknown
> > No such attribute Unknown
> > No such attribute Unknown
> >
> >  But I also get the old (ERR: do failed for 'delete from online where
> > NASID='127.0.0.1' and NASPort=0': MySQL server has gone away) in the
> > radius' logfile.
> >
> >  Any ideas why the dictionary makes problems (yes, I am using the new
> > dictionary shipped with Radiator 3.6 file -- I even specify the file on
> > the radiusd's command line), and also what could be wrong with the
> > MySQL
> > connection? Again, only the first test results in this "mysql has
> > gone away" error, the following tests are allright.
> >
> >  Thank you,
> >  bogdan
> >
> >
> > On Wed, 16 Jul 2003, Hugh Irvine wrote:
> >
> >>
> >> Hello Bogdan -
> >>
> >> I suggest you upgrade to the latest version - Radiator 3.6 (plus
> >> patches).
> >>
> >> There have been many improvements to the SQL code since 2.19.
> >>
> >> regards
> >>
> >> Hugh
> >>
> >>
> >> On Tuesday, Jul 15, 2003, at 20:44 Australia/Melbourne, Bogdan TARU
> >> wrote:
> >>
> >>>
> >>> 	Hi everyone,
> >>>
> >>>  I have some problems when trying to install Radiator-2.19 with MySQL
> >>> 3.23.55 and Perl 5.6.1. Radiator starts ok, but when I try to make a
> >>> test
> >>> I get the following message:
> >>>
> >>> DBD::mysql::db do failed: MySQL server has gone away at
> >>> /usr/local/lib/perl5/site_perl/5.6.1/Radius/SqlDb.pm line 232
> >>>
> >>>  It seems that I get this message only when trying a first test,
> >>> afterwards everything works smoothly. Any ideas what could cause
> >>> this?
> >>> I
> >>> have googled around, but found nothing interesting. The mysql daemon
> >>> doesn't die (checked the logs), so this is NOT the problem.
> >>>
> >>>  Thank you for your support,
> >>>  bogdan
> >>>
> >>> ===
> >>> Archive at http://www.open.com.au/archives/radiator/
> >>> Announcements on radiator-announce at open.com.au
> >>> To unsubscribe, email 'majordomo at open.com.au' with
> >>> 'unsubscribe radiator' in the body of the message.
> >>>
> >>>
> >>
> >> NB: have you included a copy of your configuration file (no secrets),
> >> together with a trace 4 debug showing what is happening?
> >>
> >> --
> >> Radiator: the most portable, flexible and configurable RADIUS server
> >> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> >> -
> >> Nets: internetwork inventory and management - graphical, extensible,
> >> flexible with hardware, software, platform and database independence.
> >>
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>



===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.