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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
