(RADIATOR) Problems upgrading

Hugh Irvine hugh at open.com.au
Thu Jul 17 06:06:59 CDT 2003 

Hello Bogdan -

We don't have any information about the "MySQL has gone away problem" - 
perhaps someone else on the list knows something? You may have to check 
the MySQL web site and/or the DBI/DBD web sites and possibly try 
different versions until you find a combination that works correctly.

If you (or anyone else) finds the solution please let us know.

regards

Hugh


On Thursday, Jul 17, 2003, at 18:28 Australia/Melbourne, Bogdan TARU 
wrote:

>
> 	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.
>>
>
>
>
>

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.

More information about the radiator mailing list