<div><div dir="auto">Hi, </div><div dir="auto"><br></div><div dir="auto">I'm sorry. I thought you did it just for root. </div><div dir="auto"><br></div><div dir="auto">Cheers. </div><div dir="auto"><br></div><div dir="auto"><br></div><br><div class="gmail_quote"><div>El El vie, 29 dic. 2017 a las 07:32, Raghavender <<a href="mailto:raghu6519@gmail.com">raghu6519@gmail.com</a>> escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Hi Diego,<div><br></div><div>We have tried to execute given command to grant all permissions to database, but still we get the same error.</div><div><br></div><div><br></div><div>Regards,</div><div>Raghu</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Dec 27, 2017 at 11:36 AM, Kranti Kumar <span><<a href="mailto:krantikumara@gmail.com" target="_blank">krantikumara@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><pre><br></pre><div dir="auto">Thank you so much Franz.</div><div dir="auto"><br></div><div dir="auto">As suggested, We have modified bind address to Physical address of the server, but still we have the same error message.(<span style="background:yellow none repeat scroll 0% 0%">Access denied for user 'pcscf'@'pcscf.net1.test' (using
password: YES))</span></div><div dir="auto"><span style="background:yellow none repeat scroll 0% 0%"><br></span></div><div><span style="background:yellow none repeat scroll 0% 0%"><br></span></div><div>Please fund the attached my.cnf file for your reference.</div><div><br></div><div>We tried to bind with 0.0.0.0 , HSS IP and P-CSCF IP.<br></div><span><div dir="auto">Following is the list of severs and their IP addresses:</div><div dir="auto">HSS- xx.xx.xx.171</div><div dir="auto">PCSCF- <span style="font-family:sans-serif"> xx.xx.xx.175</span></div><div dir="auto"><span style="font-family:sans-serif"><br></span></div></span><div><span style="font-family:sans-serif">Could you please help us to resolve this issue.<br></span></div><div><span style="font-family:sans-serif"><br></span></div><div><span style="font-family:sans-serif">Regards,</span></div><div><span style="font-family:sans-serif">-kranti<br></span></div><pre><span>From: <b class="gmail_sendername">Franz Edler</b> <span><<a href="mailto:franz.edler@kabsi.at" target="_blank">franz.edler@kabsi.at</a>></span><br>Date: Sat, Dec 23, 2017 at 10:49 AM<br></span>Subject: AW: [SR-Users] PCSCF Access denied issue<br>To: "Kamailio (SER) - Users Mailing List" <<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>>, "Kamailio (SER) - Users Mailing List" <<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>>, raghavender goud <<a href="mailto:raghu6519@gmail.com" target="_blank">raghu6519@gmail.com</a>><br><br><br></pre><span><p class="m_-5092258844834967142m_-1268743371233766192gmail-MsoNormal"><span lang="EN-US">You should try to set the </span><span lang="EN-US">bind-address in /etc/mysql/my.cnf to the corresponding physical address.</span></p><p class="m_-5092258844834967142m_-1268743371233766192gmail-MsoNormal"><span lang="EN-US"> </span></p><span lang="EN-US">BR Franz</span></span></div><div class="m_-5092258844834967142HOEnZb"><div class="m_-5092258844834967142h5"><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Dec 23, 2017 at 8:41 AM, Kranti Kumar <span><<a href="mailto:krantikumara@gmail.com" target="_blank">krantikumara@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hi All,<br><br></div>We are using <b>Kamailio IMS VM</b> image and we are able to run HSS(/hss.sh) successfully. But while running PCSCF (kamailio -f /usr/local/etc/kamailio/kamailio-pcscf.cfg), we are getting below errors.<br><br>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) DEBUG: <core> [db.c:209]: db_bind_mod(): using
db bind api for db_mysql</p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) DEBUG: <core> [db.c:314]: db_do_init2():
connection 0x7f208368d1b8 not found in pool</p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) DEBUG: db_mysql [km_my_con.c:98]:
db_mysql_new_connection(): opening co nnection:
mysql://xxxx:xxxx@server.net1.test/pcscf</p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) ERROR: db_mysql [km_my_con.c:124]:
db_mysql_new_connection(): driver er ror: <span style="background:yellow none repeat scroll 0% 0%">Access denied for user 'pcscf'@'pcscf.net1.test' (using
password: YES)</span></p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) ERROR: <core> [db.c:318]: db_do_init2(): could
not add connection to the pool 0(1772) ERROR: ims_usrloc_pcscf
[usrloc_db.c:79]: init_db(): unable to co nnect to the database</p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) ERROR: ims_usrloc_pcscf [ul_mod.c:203]: mod_init():
Error initializing db connection</p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">0(1772) ERROR: <core> [sr_module.c:962]: init_mod():
Error while initializing module ims_usrloc_pcscf
(/usr/local/lib64/kamailio/modules/ims_usrloc_pcscf.so)</p>
<p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">ERROR: error while initializing modules</p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal"><br></p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">To fix the above error, we tried below commands</p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal"><b>mysql -u root -p<br> GRANT ALL ON *.* TO root IDENTIFIED BY 'root';<br> quit</b><br>- replace bind-address in /etc/mysql/my.cnf to 0.0.0.0 <br></p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">But still we are getting the same issue.</p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">Could any one please help us to resolve this issue. Could any one please guide us the troubleshooting steps.</p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">Thank you so much in advance.<br></p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal"><br></p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">Regards,</p><p class="m_-5092258844834967142m_-1268743371233766192m_-5589097307075416820gmail-MsoNormal">-kranti<br></p>
</div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
_______________________________________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</blockquote></div></div>