> I can login to my mysql database as root on localhost
> mysql --user=root --password=mypassword
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 6
> Server version: 5.0.45-log Source distribution
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> show databases;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | mysql              |
> | policyd            |
> | sa_bayes           |
> | test               |
> +--------------------+
> 5 rows in set (0.00 sec)
> 
> The debug output from mysql ...
> 080918 11:05:01      20 Connect     [EMAIL PROTECTED] on
>                       20 Query       select @@version_comment limit 1
> 
> if I browse to the localhost /webui, I get the "Policyd Web 
> Administration" web page.  I click on "Quotas->Configure" and I get ...
> Error connecting to Policyd v2 DB: SQLSTATE[28000] [1045] Access denied 
> for user 'root'@'localhost' (using password: NO)
> 
> 
> If I look at the mysqld.log file, the startup of cbpolicyd starts with no
> mysql errors(I can force an error by using the wrong password), however, 
> when I try to use the webui, I cannot access the database ...
> cbpolicyd startup ...
> 080918 11:14:47      45 Connect     [EMAIL PROTECTED] on policyd
>                       45 Query       set autocommit=1
>                       46 Connect     [EMAIL PROTECTED] on policyd
>                       46 Query       set autocommit=1
>                       47 Connect     [EMAIL PROTECTED] on policyd
>                       47 Query       set autocommit=1
>                       48 Connect     [EMAIL PROTECTED] on policyd
>                       48 Query       set autocommit=1
> webui request to configure quota ...
> 080918 11:16:24      49 Connect     Access denied for user 
> 'root'@'localhost' (using password: NO)
> 
> any clues?

Are you using safe mode sql? This enforces settings no matter what you 
try and do, could be the reason you have (using password: NO) in the error?

-N
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users

Reply via email to