[OpenSIPS-Users] Problem creating Registrar database for OpenSIPS with PostgreSQL

[David Santiago]

Installing postgresql-client package and configuring a ./pgpass file
with the following format fixed the problem:

hostname:port:database:username:password


Regards,
David

On Fri, Oct 22, 2010 at 3:26 PM, David Santiago
<david.santiago at almiralabs.com> wrote:
>
> Hello,
>
> I have successfully compiled and installed OpenSIPS 1.6.3 (no tls) with the PostgreSQL module for an OpenSIPS Registrar testing installation.
>
> I have edited the opensipsctlrc file to specify the connection details for a remote PostgreSQL database server I want to use as the persistence store for an OpenSIPS Registrar  installation. I have set the hostname, database name, usernames and passwords.
>
> Nevertheless, when executing the opensipsdbctl command, I get the following error:
>
> -e \E[37;31mERROR: ~./pgpass does not exist, please create this file and support proper credentials for user postgres.
> -e \E[37;31mERROR: Note: you need at least postgresql>= 7.3
>
> Any ideas?
>
>
> Thx