[SR-Users] Kamailio PostgreSQL Asking Password Everytime

[Barış Şekerciler]

Hello Sammy,Thanks your for reply.
I could not find the /root/.pgpass. Both Kamailio and PGS server.Should I manually create it?
Regards,Barış.

Date: Fri, 25 Mar 2016 12:00:35 -0400
From: govoiper at gmail.com
To: sr-users at lists.sip-router.org
Subject: Re: [SR-Users] Kamailio PostgreSQL Asking Password Everytime

Hi,I've experienced the same in past couple of weeks, apparently if you've the file /root/.pgpass with the pgsql user/password in it something like
*:*:*:kamailio:kamailiopass
Then it should not ask you over and over again. I kept pasting password until it was done doing it's DB stuff, so I can only assume that it keeps asking for password for each new table/schema creation. 
Although not a big probelm but I too would like to get a fix for this situation.
Regards,Sammy



On Fri, Mar 25, 2016 at 9:47 AM, Barış Şekerciler <baris.sekerciler at outlook.com> wrote:



Hello Daniel,Thanks for your reply.
So I can't see any password for root user option in the kamctlrc file by default.How can I add?
Regards.Barış.
To: sr-users at lists.sip-router.org
From: miconda at gmail.com
Date: Wed, 23 Mar 2016 08:26:58 +0100
Subject: Re: [SR-Users] Kamailio PostgreSQL Asking Password Everytime


  
    
  
  
    Hello,

    

    I haven't used the postgres in a long while, but I think it should
    ask only once.

    

    Can you try by setting the password inside the kamctlrc file and see
    if works straight away?

    

    Cheers,

    Daniel

    

    On 22/03/16 11:52, Barış Şekerciler
      wrote:

    
    
      
      Hello,
        I have one postgres server at one server and Kamailio at
          another server.
        So I believe I did true configuration to the Kamailio.
          Actually I made some tests and I could create user and
          authenticated etc.
        

        
        But I have a problem. When I tried to present "kamdbctl
          create" Kamailio asks password 50 times (almost, much or less
          idk certainly).
        After 50 times Db created successfully and works.
        

        
        And it looks like this:
        

        
        
          root at bs-kamailio:/home/bs-kamailio#
              kamdbctl create

          INFO: creating database
              kamailio ...

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          Password for user postgres: 

          

            

          So how can I solve this
              situation? I want Kamailio to asks password one time and
              handle it's job.

          

            

          Regards.

          

          

        
      
      

      
      

      _______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users at lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

    
    

    -- 
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
  


_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users at lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 		 	   		   		 	   		  

_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users





_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users at lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160326/93f891ff/attachment.html>