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? Do I need to restore the
Manip.pm? Anything else happen here? Appriciate to 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
