I check connectivity is ok, I also make php files and try to connect it working.
I enter Database setting in vi /etc/cluebringer.conf as follow
DSN=DBI:mysql:database=policyd;host=localhost
Username=root
Password=Pass

Still it showing following:
19084] [CBPOLICYD] WARNING: Failed to connect to database: Error
connecting to database: Access denied for user 'root'@'localhost'
(using password: NO) (19084)

I am missing some settings.

On Wed, Jan 9, 2013 at 5:30 PM,  <[email protected]> wrote:
> Send Users mailing list submissions to
>         [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
> or, via email, send a message with subject or body 'help' to
>         [email protected]
>
> You can reach the person managing the list at
>         [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
>    1. Access denied for user 'cbpolicyd'@'localhost'    (using
>       password: NO) (Naval Saini)
>    2. Re: Access denied for user 'cbpolicyd'@'localhost' (using
>       password: NO) (Nigel Kukard)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 8 Jan 2013 18:34:55 +0530
> From: Naval Saini <[email protected]>
> To: [email protected]
> Subject: [policyd-users] Access denied for user
>         'cbpolicyd'@'localhost' (using password: NO)
> Message-ID:
>         <CAM8htyLf_70tDPVqhR==rkkvhpbmarra6tqvarx8-kgmcod...@mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> I have installed cluebringer-v2.1.x-201211111115.noarch.rpm in centos
> 6.3 server when i start service cbpolicyd it's starting but when i
> check cbpolicyd log i found that
>
> "
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   => Greylisting: enabled
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   => Quotas: enabled
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   => Protocol(Postfix): enabled
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   => Protocol(Bizanga): enabled
> [2013/01/08-12:52:47 - 1059] [CBPOLICYD] NOTICE: Module load done.
> [2013/01/08-12:52:47 - 1059] [CBPOLICYD] NOTICE: Session tracking is ENABLED.
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: 2013/01/08-12:52:47 cbp
> (type Net::Server::PreFork) starting! pid(1059)
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: Binding to TCP port 10031 on host 
> *
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: Setting gid to "501 501"
> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: Setting uid to "501"
> [2013/01/08-12:52:47 - 1070] [CBPOLICYD] WARNING: Failed to connect to
> database: Error connecting to database: Access denied for user
> 'cbpolicyd'@'localhost' (using password: NO) (1070)
> [2013/01/08-12:52:47 - 1071] [CBPOLICYD] WARNING: Failed to connect to
> database: Error connecting to database: Access denied for user
> 'cbpolicyd'@'localhost' (using password: NO) (1071)
> [2013/01/08-12:52:47 - 1069] [CBPOLICYD] WARNING: Failed to connect to
> database: Error connecting to database: Access denied for user
> 'cbpolicyd'@'localhost' (using password: NO) (1069)
> [2013/01/08-12:52:47 - 1068] [CBPOLICYD] WARNING: Failed to connect to
> database: Error connecting to database: Access denied for user
> 'cbpolicyd'@'localhost' (using password: NO) (1068)
> "
> service cbpolicyd user cbpolicy/root whatever with all permission on
> database policyd denied to access database i have tried all sql
> permissions and privileges on these users but it's not working for me.
> before this i was using cluebringer-snapshot-2.1.x-201205100639
> virsion this never show me such kind off issue please confirm wether i
> am doing or missing something or it's a
> cluebringer-v2.1.x-201211111115.noarch.rpm bug
> Thanks.
>
>
>
> --
> --
> Regards,
> Naval Saini (Server administrator)
> ~:------------------------------------------:~
> SARV Webs Pvt Ltd.
> Global Phone: +44 141 4166 6666
> USA/Canada TollFree: 1-888 987 2698
> India TollFree: 1-800 102 7278
> w: www.sarvmail.com
> w: www.enowindia.com
>
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 09 Jan 2013 07:36:55 +0000
> From: Nigel Kukard <[email protected]>
> To: [email protected]
> Subject: Re: [policyd-users] Access denied for user
>         'cbpolicyd'@'localhost' (using password: NO)
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> On 08/01/2013 13:04, Naval Saini wrote:
>> I have installed cluebringer-v2.1.x-201211111115.noarch.rpm in centos
>> 6.3 server when i start service cbpolicyd it's starting but when i
>> check cbpolicyd log i found that
>>
>> "
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   =>  Greylisting: enabled
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   =>  Quotas: enabled
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   =>  Protocol(Postfix): enabled
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE:   =>  Protocol(Bizanga): enabled
>> [2013/01/08-12:52:47 - 1059] [CBPOLICYD] NOTICE: Module load done.
>> [2013/01/08-12:52:47 - 1059] [CBPOLICYD] NOTICE: Session tracking is ENABLED.
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: 2013/01/08-12:52:47 cbp
>> (type Net::Server::PreFork) starting! pid(1059)
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: Binding to TCP port 10031 on 
>> host *
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: Setting gid to "501 501"
>> [2013/01/08-12:52:47 - 1059] [CORE] NOTICE: Setting uid to "501"
>> [2013/01/08-12:52:47 - 1070] [CBPOLICYD] WARNING: Failed to connect to
>> database: Error connecting to database: Access denied for user
>> 'cbpolicyd'@'localhost' (using password: NO) (1070)
>> [2013/01/08-12:52:47 - 1071] [CBPOLICYD] WARNING: Failed to connect to
>> database: Error connecting to database: Access denied for user
>> 'cbpolicyd'@'localhost' (using password: NO) (1071)
>> [2013/01/08-12:52:47 - 1069] [CBPOLICYD] WARNING: Failed to connect to
>> database: Error connecting to database: Access denied for user
>> 'cbpolicyd'@'localhost' (using password: NO) (1069)
>> [2013/01/08-12:52:47 - 1068] [CBPOLICYD] WARNING: Failed to connect to
>> database: Error connecting to database: Access denied for user
>> 'cbpolicyd'@'localhost' (using password: NO) (1068)
>> "
>> service cbpolicyd user cbpolicy/root whatever with all permission on
>> database policyd denied to access database i have tried all sql
>> permissions and privileges on these users but it's not working for me.
>> before this i was using cluebringer-snapshot-2.1.x-201205100639
>> virsion this never show me such kind off issue please confirm wether i
>> am doing or missing something or it's a
>> cluebringer-v2.1.x-201211111115.noarch.rpm bug
>> Thanks.
>
> I'd suggest checking your database setup & login details.
>
> You can use   mysql -u username -p database    to test your database
> login details.
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: smime.p7s
> Type: application/pkcs7-signature
> Size: 5680 bytes
> Desc: S/MIME Cryptographic Signature
> URL: 
> <http://lists.policyd.org/pipermail/users_lists.policyd.org/attachments/20130109/effa8fdf/attachment-0001.p7s>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.policyd.org/mailman/listinfo/users_lists.policyd.org
>
>
> ------------------------------
>
> End of Users Digest, Vol 55, Issue 5
> ************************************



-- 
-- 
Regards,
Naval Saini (Server administrator)
~:------------------------------------------:~
SARV Webs Pvt Ltd.
Global Phone: +44 141 4166 6666
USA/Canada TollFree: 1-888 987 2698
India TollFree: 1-800 102 7278
w: www.sarvmail.com
w: www.enowindia.com

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

Reply via email to