Hi
I try to run mtotacct and totact scripts but these is
what i get
*****************************************************
DELETE FROM mtotacct WHERE AcctDate = '2005-03-01';
INSERT INTO mtotacct
(UserName,AcctDate,ConnNum,ConnTotDuration,
ConnMaxDuration,ConnMinDuration,InputOctets,OutputOctets,NASIPAddress)
SELECT
UserName,'2005-03-01',SUM(ConnNum),SUM(ConnTotDuration),
MAX(ConnMaxDuration),MIN(ConnMinDuration),SUM(InputOctets),
SUM(OutputOctets),NASIPAddress FROM totacct
WHERE AcctDate >= '2005-03-01' AND
AcctDate <= '2005-03-08' GROUP BY
UserName,NASIPAddress;
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)
______________________________________________
The user password in admin.conf had been entered as
shown:
sql_type: mysql
sql_server: localhost
sql_port: 3306
sql_username: root
sql_password: password
sql_database: radius
Or is there other file where I should specify the
mysql password? When I try to run the log_badlogin
scripts the following output produced:
###############################################
Malformed UTF-8 character (unexpected non-continuation
byte 0x78, immediately after start byte 0xf3) at
/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line
6488.
Malformed UTF-8 character (unexpected non-continuation
byte 0x78, immediately after start byte 0xf3) at
/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line
6488.
Malformed UTF-8 character (unexpected non-continuation
byte 0x6c, immediately after start byte 0xfa) at
/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line
6489.
Malformed UTF-8 character (unexpected non-continuation
byte 0x6c, immediately after start byte 0xfa) at
/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line
6489.
Malformed UTF-8 character (1 byte, need 3, after start
byte 0xe3) at
/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line
6497.
Malformed UTF-8 character (unexpected non-continuation
byte 0x73, immediately after start byte 0xea) at
/usr/lib/perl5/vendor_perl/5.8.0/Date/Manip.pm line
6501.
Could not open file
###############################
What file it couldn't open? Is it Manip.pm?Do I need
to restore the
Manip.pm or anything else happen here?
Is there any other way to run the scripts, allowing
them automatically filling tables in the sql database?
Appriciate any help. Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
