[RADIATOR] Radiator - MySQL HA solution with low cost and easy configuration
hi team,any of you can recommend some low cost HA solution for mysql? continuent m/cluster is bit too costly. prefer some stable while not difficult to configure. our OS is Suse Linux. thanks! ___ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator
Re: (RADIATOR) Radiator+MySQL problem
Hello Romain, thanks for telling us about this. It is cause by a debug print message accidentally left in AuthLog SQL. I have attached a new version of AuthLogSQL.pm that should fix that problem. Cheers. On Mon, 3 Jun 2002 18:56, Romain Vergniol wrote: > I've upgraded to Radiator 3.1 and the problem is fixed. > > > After the upgrade, when I start radiusd from the console, lots of messages > apear as said in a previous mail > (http://www.open.com.au/archives/radiator/2002-05/msg00214.html). > Ex: > AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 > Radius::Radius=HASH(0x87691d4) > AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 > Radius::Radius=HASH(0x878052c) > AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 > Radius::Radius=HASH(0x8788be8) > AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 > Radius::Radius=HASH(0x8780660) > ... > > Is there a way to avoid this ? > > Thanks again. > > Romain > > > - Original Message - > From: "Mike McCauley" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; "Romain Vergniol" <[EMAIL PROTECTED]> > Cc: "Charles Delorme" <[EMAIL PROTECTED]>; "Mailing-List Radiator" > <[EMAIL PROTECTED]> > Sent: Saturday, June 01, 2002 1:52 AM > Subject: Re: (RADIATOR) Radiator+MySQL problem > > > Hello Romain, > > > > this is almost certainly the SQL Trace 4 infinite recursion problem that > > was > > > fixed in version 3.1. > > > > Cheers. > > > > On Sat, 1 Jun 2002 08:44, Hugh Irvine wrote: > > > Salut Romain - > > > > > > Quel plaisir de pouvoir regarder le tennis a Roland-Garros en ce > > > moment! > > > > > > :-) > > > > > > (ayant vecu a deux pas du stade ) > > > > > > I have copied Mike on this mail, but have you tested the same scenario > > with > > > > Radiator 3.1? I know there has been some work done in this area. > > > > > > Please let me know if 3.1 fixes the problem. > > > > > > If not, please send me the config and trace 4 again for the new > > > version. > > > > > > A+ > > > > > > Hugues > > > > > > On Fri, 31 May 2002 20:58, Romain Vergniol wrote: > > > > Hello Hugh, Mike, everyone, > > > > > > > > I use Radiator 3.0 together with MySQL on Slackware 8.0 servers. > > > > I noticed that Radiator badly manages the loss of MySQL server ; in > > > > certain cases, > > > > Radiator consumes all available memory then crashes down. > > > > > > > > I set up a test server and it was easy to reproduce the problem, here > > is > > > > > the scenario : > > > > > > > > - start MySQL server > > > > - start Radiator > > > > - start radpwtst with thousands iterations to have the time to do > > our > > > > > tests > > > > - shutdown MySQL server > > > > > > > > At this moment, Radiator starts to consume all available memory until > > it > > > > > crashes (restarting Mysql server doesn't change anything...). > > > > I tried to increase or reduce 'FailureBackoffTime' but it doesn't > > > > seem > > to > > > > > change anything. > > > > > > > > Shutting down MySQL when no radius request is sent doesn't reproduce > > the > > > > > problem. > > > > > > > > Is my config file OK ? > > > > > > > > Here is a trace 4 debug with the config file > > > > > > > > > > > > Romain Vergniol > > > > CEGEDIM > > > > France > > > > > > > > PS : Radiator is a great product !:) > > > > > > > > > > > > = > > > >= > > > > > > > > Trace 4 debug: > > > > > > > > *** Received from 172.xxx port 1074 > > > > Code: Access-Request > > > > Identifier: 219 > > > > Authentic: 1234567890123456 > > > > Attributes: > > > > User-Name = "[EMAIL PROTECTED]" > > > > Service-Type = Framed > > > > NAS-IP-Address = 172.xx > > > > NAS-Port = 1234 > > > > Called-Station-Id = "" > > > > Calling-Station-Id = &quo
Re: (RADIATOR) Radiator+MySQL problem
I've upgraded to Radiator 3.1 and the problem is fixed. After the upgrade, when I start radiusd from the console, lots of messages apear as said in a previous mail (http://www.open.com.au/archives/radiator/2002-05/msg00214.html). Ex: AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 Radius::Radius=HASH(0x87691d4) AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 Radius::Radius=HASH(0x878052c) AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 Radius::Radius=HASH(0x8788be8) AuthLogSQL log Radius::AuthLogSQL=HASH(0x84982e0) 0 Radius::Radius=HASH(0x8780660) ... Is there a way to avoid this ? Thanks again. Romain - Original Message - From: "Mike McCauley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Romain Vergniol" <[EMAIL PROTECTED]> Cc: "Charles Delorme" <[EMAIL PROTECTED]>; "Mailing-List Radiator" <[EMAIL PROTECTED]> Sent: Saturday, June 01, 2002 1:52 AM Subject: Re: (RADIATOR) Radiator+MySQL problem > Hello Romain, > > this is almost certainly the SQL Trace 4 infinite recursion problem that was > fixed in version 3.1. > > Cheers. > > On Sat, 1 Jun 2002 08:44, Hugh Irvine wrote: > > Salut Romain - > > > > Quel plaisir de pouvoir regarder le tennis a Roland-Garros en ce moment! > > > > :-) > > > > (ayant vecu a deux pas du stade ) > > > > I have copied Mike on this mail, but have you tested the same scenario with > > Radiator 3.1? I know there has been some work done in this area. > > > > Please let me know if 3.1 fixes the problem. > > > > If not, please send me the config and trace 4 again for the new version. > > > > A+ > > > > Hugues > > > > On Fri, 31 May 2002 20:58, Romain Vergniol wrote: > > > Hello Hugh, Mike, everyone, > > > > > > I use Radiator 3.0 together with MySQL on Slackware 8.0 servers. > > > I noticed that Radiator badly manages the loss of MySQL server ; in > > > certain cases, > > > Radiator consumes all available memory then crashes down. > > > > > > I set up a test server and it was easy to reproduce the problem, here is > > > the scenario : > > > > > > - start MySQL server > > > - start Radiator > > > - start radpwtst with thousands iterations to have the time to do our > > > tests > > > - shutdown MySQL server > > > > > > At this moment, Radiator starts to consume all available memory until it > > > crashes (restarting Mysql server doesn't change anything...). > > > I tried to increase or reduce 'FailureBackoffTime' but it doesn't seem to > > > change anything. > > > > > > Shutting down MySQL when no radius request is sent doesn't reproduce the > > > problem. > > > > > > Is my config file OK ? > > > > > > Here is a trace 4 debug with the config file > > > > > > > > > Romain Vergniol > > > CEGEDIM > > > France > > > > > > PS : Radiator is a great product !:) > > > > > > > > > == > > > > > > Trace 4 debug: > > > > > > *** Received from 172.xxx port 1074 > > > Code: Access-Request > > > Identifier: 219 > > > Authentic: 1234567890123456 > > > Attributes: > > > User-Name = "[EMAIL PROTECTED]" > > > Service-Type = Framed > > > NAS-IP-Address = 172.xx > > > NAS-Port = 1234 > > > Called-Station-Id = "" > > > Calling-Station-Id = "987654321" > > > NAS-Port-Type = Async > > > Framed-IP-Address = 172.xxx > > > User-Password = > > > "<170>n<243>=<28><251><161><238>4<31><131>"B<18><249><132>" > > > > > > Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler > > > 'Request-Type=Access-Request' > > > Fri May 31 11:50:46 2002: DEBUG: Deleting session for > > > [EMAIL PROTECTED], 172.xx, 1234 > > > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthGROUP > > > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL > > > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL: > > > Fri May 31 11:50:46 2002: DEBUG: Query is: select S.PASSWORD, > > > S.CHECKATTR, S.REPLYATTR from SUBSCRIBERS as S, REL_PROFC
Re: (RADIATOR) Radiator+MySQL problem
Hello Romain, this is almost certainly the SQL Trace 4 infinite recursion problem that was fixed in version 3.1. Cheers. On Sat, 1 Jun 2002 08:44, Hugh Irvine wrote: > Salut Romain - > > Quel plaisir de pouvoir regarder le tennis a Roland-Garros en ce moment! > > :-) > > (ayant vecu a deux pas du stade ) > > I have copied Mike on this mail, but have you tested the same scenario with > Radiator 3.1? I know there has been some work done in this area. > > Please let me know if 3.1 fixes the problem. > > If not, please send me the config and trace 4 again for the new version. > > A+ > > Hugues > > On Fri, 31 May 2002 20:58, Romain Vergniol wrote: > > Hello Hugh, Mike, everyone, > > > > I use Radiator 3.0 together with MySQL on Slackware 8.0 servers. > > I noticed that Radiator badly manages the loss of MySQL server ; in > > certain cases, > > Radiator consumes all available memory then crashes down. > > > > I set up a test server and it was easy to reproduce the problem, here is > > the scenario : > > > > - start MySQL server > > - start Radiator > > - start radpwtst with thousands iterations to have the time to do our > > tests > > - shutdown MySQL server > > > > At this moment, Radiator starts to consume all available memory until it > > crashes (restarting Mysql server doesn't change anything...). > > I tried to increase or reduce 'FailureBackoffTime' but it doesn't seem to > > change anything. > > > > Shutting down MySQL when no radius request is sent doesn't reproduce the > > problem. > > > > Is my config file OK ? > > > > Here is a trace 4 debug with the config file > > > > > > Romain Vergniol > > CEGEDIM > > France > > > > PS : Radiator is a great product !:) > > > > > > == > > > > Trace 4 debug: > > > > *** Received from 172.xxx port 1074 > > Code: Access-Request > > Identifier: 219 > > Authentic: 1234567890123456 > > Attributes: > > User-Name = "[EMAIL PROTECTED]" > > Service-Type = Framed > > NAS-IP-Address = 172.xx > > NAS-Port = 1234 > > Called-Station-Id = "" > > Calling-Station-Id = "987654321" > > NAS-Port-Type = Async > > Framed-IP-Address = 172.xxx > > User-Password = > > "<170>n<243>=<28><251><161><238>4<31><131>"B<18><249><132>" > > > > Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler > > 'Request-Type=Access-Request' > > Fri May 31 11:50:46 2002: DEBUG: Deleting session for > > [EMAIL PROTECTED], 172.xx, 1234 > > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthGROUP > > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL > > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL: > > Fri May 31 11:50:46 2002: DEBUG: Query is: select S.PASSWORD, > > S.CHECKATTR, S.REPLYATTR from SUBSCRIBERS as S, REL_PROFCOM as P where > > S.USERNAME='[EMAIL PROTECTED]' and S.NASIDENTIFIER='172.xx' > > and S.PROFCOM=P.ID and P.NUM='' > > > > Fri May 31 11:50:46 2002: DEBUG: Radius::AuthSQL looks for match with > > [EMAIL PROTECTED] > > Fri May 31 11:50:46 2002: DEBUG: Expiration date converted to: 1798758000 > > Fri May 31 11:50:46 2002: DEBUG: Radius::AuthSQL ACCEPT: > > Fri May 31 11:50:46 2002: DEBUG: Access accepted for > > [EMAIL PROTECTED] > > Fri May 31 11:50:46 2002: DEBUG: Packet dump: > > *** Sending to 172.port 1074 > > Code: Access-Accept > > Identifier: 219 > > Authentic: 1234567890123456 > > Attributes: > > Framed-IP-Address = 172.x > > Service-Type = Framed > > cisco-avpair = "ip:dns-servers=xxx yy" > > cisco-avpair = "ip:inacl#1=permit ip any 172.x/16" > > cisco-avpair = "ip:inacl#2=permit ip any host " > > cisco-avpair = "ip:inacl#3=permit ip any host " > > cisco-avpair = "ip:inacl#4=deny all any any" > > Framed-Protocol = PPP > > > > Fri May 31 11:50:46 2002: DEBUG: Packet dump: > > > > # > > # Up to here, everything is OK > > # MySQL shuts down now > > # > > > > > > *** Received from 172.x port 1074 > > Code: Accounting-Request > > Identifier: 220 > > Authentic: > > <212><29><155>$\<246><202><193><141><206><12><148><15><138><210>Q > > Attributes: > > User-Name = "[EMAIL PROTECTED]" > > Service-Type = Framed > > NAS-IP-Address = 172.xxx > > NAS-Port = 1234 > > NAS-Port-Type = Async > > Acct-Session-Id = "1400" > > Acct-Status-Type = Start > > Called-Station-Id = "" > > Calling-Station-Id = "987654321" > > Framed-IP-Address = 172xxx > > Acct-Delay-Time = 0 > > > > Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler > > 'Request-Type=Accounting-Request' > > Fri May 31 11:50:
Re: (RADIATOR) Radiator+MySQL problem
Salut Romain - Quel plaisir de pouvoir regarder le tennis a Roland-Garros en ce moment! :-) (ayant vecu a deux pas du stade ) I have copied Mike on this mail, but have you tested the same scenario with Radiator 3.1? I know there has been some work done in this area. Please let me know if 3.1 fixes the problem. If not, please send me the config and trace 4 again for the new version. A+ Hugues On Fri, 31 May 2002 20:58, Romain Vergniol wrote: > Hello Hugh, Mike, everyone, > > I use Radiator 3.0 together with MySQL on Slackware 8.0 servers. > I noticed that Radiator badly manages the loss of MySQL server ; in certain > cases, > Radiator consumes all available memory then crashes down. > > I set up a test server and it was easy to reproduce the problem, here is > the scenario : > > - start MySQL server > - start Radiator > - start radpwtst with thousands iterations to have the time to do our > tests > - shutdown MySQL server > > At this moment, Radiator starts to consume all available memory until it > crashes (restarting Mysql server doesn't change anything...). > I tried to increase or reduce 'FailureBackoffTime' but it doesn't seem to > change anything. > > Shutting down MySQL when no radius request is sent doesn't reproduce the > problem. > > Is my config file OK ? > > Here is a trace 4 debug with the config file > > > Romain Vergniol > CEGEDIM > France > > PS : Radiator is a great product !:) > > > == > > Trace 4 debug: > > *** Received from 172.xxx port 1074 > Code: Access-Request > Identifier: 219 > Authentic: 1234567890123456 > Attributes: > User-Name = "[EMAIL PROTECTED]" > Service-Type = Framed > NAS-IP-Address = 172.xx > NAS-Port = 1234 > Called-Station-Id = "" > Calling-Station-Id = "987654321" > NAS-Port-Type = Async > Framed-IP-Address = 172.xxx > User-Password = > "<170>n<243>=<28><251><161><238>4<31><131>"B<18><249><132>" > > Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler > 'Request-Type=Access-Request' > Fri May 31 11:50:46 2002: DEBUG: Deleting session for > [EMAIL PROTECTED], 172.xx, 1234 > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthGROUP > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL: > Fri May 31 11:50:46 2002: DEBUG: Query is: select S.PASSWORD, S.CHECKATTR, > S.REPLYATTR from SUBSCRIBERS as S, REL_PROFCOM as P where > S.USERNAME='[EMAIL PROTECTED]' and S.NASIDENTIFIER='172.xx' > and S.PROFCOM=P.ID and P.NUM='' > > Fri May 31 11:50:46 2002: DEBUG: Radius::AuthSQL looks for match with > [EMAIL PROTECTED] > Fri May 31 11:50:46 2002: DEBUG: Expiration date converted to: 1798758000 > Fri May 31 11:50:46 2002: DEBUG: Radius::AuthSQL ACCEPT: > Fri May 31 11:50:46 2002: DEBUG: Access accepted for > [EMAIL PROTECTED] > Fri May 31 11:50:46 2002: DEBUG: Packet dump: > *** Sending to 172.port 1074 > Code: Access-Accept > Identifier: 219 > Authentic: 1234567890123456 > Attributes: > Framed-IP-Address = 172.x > Service-Type = Framed > cisco-avpair = "ip:dns-servers=xxx yy" > cisco-avpair = "ip:inacl#1=permit ip any 172.x/16" > cisco-avpair = "ip:inacl#2=permit ip any host " > cisco-avpair = "ip:inacl#3=permit ip any host " > cisco-avpair = "ip:inacl#4=deny all any any" > Framed-Protocol = PPP > > Fri May 31 11:50:46 2002: DEBUG: Packet dump: > > # > # Up to here, everything is OK > # MySQL shuts down now > # > > > *** Received from 172.x port 1074 > Code: Accounting-Request > Identifier: 220 > Authentic: > <212><29><155>$\<246><202><193><141><206><12><148><15><138><210>Q > Attributes: > User-Name = "[EMAIL PROTECTED]" > Service-Type = Framed > NAS-IP-Address = 172.xxx > NAS-Port = 1234 > NAS-Port-Type = Async > Acct-Session-Id = "1400" > Acct-Status-Type = Start > Called-Station-Id = "" > Calling-Station-Id = "987654321" > Framed-IP-Address = 172xxx > Acct-Delay-Time = 0 > > Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler > 'Request-Type=Accounting-Request' > Fri May 31 11:50:46 2002: DEBUG: Adding session for > [EMAIL PROTECTED], 172.xx, 1234 > Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL > Fri May 31 11:50:46 2002: DEBUG: Handling accounting with Radius::AuthSQL > Fri May 31 11:50:46 2002: DEBUG: do query is: insert into ACCOUNTING > (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, > ACCTSESSIONID, NASIDENTIFIER, FRAMEDIPADDRESS, ASCEND_CALLED_STATION_ID, >
(RADIATOR) Radiator+MySQL problem
Hello Hugh, Mike, everyone,
I use Radiator 3.0 together with MySQL on Slackware 8.0 servers.
I noticed that Radiator badly manages the loss of MySQL server ; in certain
cases,
Radiator consumes all available memory then crashes down.
I set up a test server and it was easy to reproduce the problem, here is the
scenario :
- start MySQL server
- start Radiator
- start radpwtst with thousands iterations to have the time to do our
tests
- shutdown MySQL server
At this moment, Radiator starts to consume all available memory until it
crashes (restarting Mysql server doesn't change anything...).
I tried to increase or reduce 'FailureBackoffTime' but it doesn't seem to
change anything.
Shutting down MySQL when no radius request is sent doesn't reproduce the
problem.
Is my config file OK ?
Here is a trace 4 debug with the config file
Romain Vergniol
CEGEDIM
France
PS : Radiator is a great product !:)
==
Trace 4 debug:
*** Received from 172.xxx port 1074
Code: Access-Request
Identifier: 219
Authentic: 1234567890123456
Attributes:
User-Name = "[EMAIL PROTECTED]"
Service-Type = Framed
NAS-IP-Address = 172.xx
NAS-Port = 1234
Called-Station-Id = ""
Calling-Station-Id = "987654321"
NAS-Port-Type = Async
Framed-IP-Address = 172.xxx
User-Password =
"<170>n<243>=<28><251><161><238>4<31><131>"B<18><249><132>"
Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler
'Request-Type=Access-Request'
Fri May 31 11:50:46 2002: DEBUG: Deleting session for
[EMAIL PROTECTED], 172.xx, 1234
Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthGROUP
Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL
Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL:
Fri May 31 11:50:46 2002: DEBUG: Query is: select S.PASSWORD, S.CHECKATTR,
S.REPLYATTR from SUBSCRIBERS as S, REL_PROFCOM as P where
S.USERNAME='[EMAIL PROTECTED]' and S.NASIDENTIFIER='172.xx' and
S.PROFCOM=P.ID and P.NUM=''
Fri May 31 11:50:46 2002: DEBUG: Radius::AuthSQL looks for match with
[EMAIL PROTECTED]
Fri May 31 11:50:46 2002: DEBUG: Expiration date converted to: 1798758000
Fri May 31 11:50:46 2002: DEBUG: Radius::AuthSQL ACCEPT:
Fri May 31 11:50:46 2002: DEBUG: Access accepted for
[EMAIL PROTECTED]
Fri May 31 11:50:46 2002: DEBUG: Packet dump:
*** Sending to 172.port 1074
Code: Access-Accept
Identifier: 219
Authentic: 1234567890123456
Attributes:
Framed-IP-Address = 172.x
Service-Type = Framed
cisco-avpair = "ip:dns-servers=xxx yy"
cisco-avpair = "ip:inacl#1=permit ip any 172.x/16"
cisco-avpair = "ip:inacl#2=permit ip any host "
cisco-avpair = "ip:inacl#3=permit ip any host "
cisco-avpair = "ip:inacl#4=deny all any any"
Framed-Protocol = PPP
Fri May 31 11:50:46 2002: DEBUG: Packet dump:
#
# Up to here, everything is OK
# MySQL shuts down now
#
*** Received from 172.x port 1074
Code: Accounting-Request
Identifier: 220
Authentic:
<212><29><155>$\<246><202><193><141><206><12><148><15><138><210>Q
Attributes:
User-Name = "[EMAIL PROTECTED]"
Service-Type = Framed
NAS-IP-Address = 172.xxx
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "1400"
Acct-Status-Type = Start
Called-Station-Id = ""
Calling-Station-Id = "987654321"
Framed-IP-Address = 172xxx
Acct-Delay-Time = 0
Fri May 31 11:50:46 2002: DEBUG: Handling request with Handler
'Request-Type=Accounting-Request'
Fri May 31 11:50:46 2002: DEBUG: Adding session for
[EMAIL PROTECTED], 172.xx, 1234
Fri May 31 11:50:46 2002: DEBUG: Handling with Radius::AuthSQL
Fri May 31 11:50:46 2002: DEBUG: Handling accounting with Radius::AuthSQL
Fri May 31 11:50:46 2002: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTSESSIONID, NASIDENTIFIER, FRAMEDIPADDRESS, ASCEND_CALLED_STATION_ID,
ASCEND_CALLING_STATION_ID, FORMATTED_DATE)
values
('[EMAIL PROTECTED]', 1022838646, 'Start', 0,
'1400', '172.', '172.xxx', '', '987654321',
'2002-05-31.11.50.46')
DBD::mysql::db do failed: MySQL server has gone away at
/usr/lib/perl5/site_perl/Radius/SqlDb.pm line 218.
Fri May 31 11:50:46 2002: ERR: do failed for 'insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTSESSIONID, NASIDENTIFIER, FRAMEDIPADDRESS, ASCEND_CALLED_STATION_ID,
ASCEND_CALLING_STATION_ID, FORMATTED_DATE)
values
('[EMAIL PROTECTED]', 1022838646, 'Start', 0,
'1400', '172.xx', '
Re: (RADIATOR) [RADIATOR] MySQL Errors
Hello Chris - On Wed, 29 Nov 2000, Chris M wrote: > DBD::mysql::db do failed: Duplicate entry '192.168.1.1-24' for key 1 at > /usr/l > ocal/lib/perl5/site_perl/5.6.0/Radius/SqlDb.pm line 230. > > Any ideas on what might be the problems? > As the message says, you are trying to insert a duplicate entry into a MySQL table. I will need to see the configuration file (no secrets) and a trace 4 to be able to say anything more. regards Hugh -- 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.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) [RADIATOR] MySQL Errors
DBD::mysql::db do failed: Duplicate entry '192.168.1.1-24' for key 1 at /usr/l ocal/lib/perl5/site_perl/5.6.0/Radius/SqlDb.pm line 230. Any ideas on what might be the problems? Thanks, Chris === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Radiator + mySQL
Hi Matt, On Apr 9, 4:20pm, Matt Chambers wrote: > Subject: (RADIATOR) Radiator + mySQL > > 1st a Question: Does anyone have any suggestions on how to import a comma > delimited file into mySQL? Its format is simple: uid,pwd Take a look at the buildsql script you get with radiator. As it stands, it can import a Unix password file (username:password format) and populate an SQL database. It should be able to be simply modified to do what you want. > > Also, my Radiator works perfectly! Thanks everyone for your help. This is > what I'm using if anyone cares. Good news. Cheers. -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Radiator + mySQL
In message <22d901be82c6$6ddeb540$[EMAIL PROTECTED]>, "Matt Chambers" <[EMAIL PROTECTED]> writes: | | 1st a Question: Does anyone have any suggestions on how to import a comma | delimited file into mySQL? Its format is simple: uid,pwd Fire up MS Excel or MS Word and IMPORT the comma delimited file. Then Export the table to a .dbf DBASE III or IV file The use dbf2mysql to get it into MySQL. Paul. -- Email pgregg at tibus.net | CLUB24 | Email pgregg at nyx.net| Technical Director| INTERNET | System Administrator | The Internet Business Ltd |Free Access| Nyx Public Access Internet | http://www.tibus.net | www.club24.co.uk | http://www.nyx.net | === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Radiator + mySQL
1st a Question: Does anyone have any suggestions on how to import a comma delimited file into mySQL? Its format is simple: uid,pwd Also, my Radiator works perfectly! Thanks everyone for your help. This is what I'm using if anyone cares. Redhat 5.2 MySQL 3.23.21 MD5 1.7-3 Perl 5.004 MySQL-mySQL Perl Mods 1.2017 DBI 1.06 -- Matt Chambers (Network Operations) 703-631-5755 ext 3001 The PressRoom http://www.pressroom.com email: [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
