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