Обсуждение: Cannot login, with C/C++ program

I have written a C/C++ program that trys to log into a local
PostgreSQL database.  Here is the code:

  pg_conn = PQconnectdb(
    "hostaddr = '127.0.0.1' port = '' dbname = 'TBDB' user = 'sysdba'
password = 'stelmo777' connect_timeout = '10'");
  if (!pg_conn)
  {
    return false;
  }
  if (PQstatus(pg_conn) != CONNECTION_OK)
  {
    return false;  // <- execution reaches here.

I checked the database, user and password by logging in with psql.
What could be wrong?

Daniel <danwgrace@gmail.com> writes:
> I have written a C/C++ program that trys to log into a local
> PostgreSQL database.  Here is the code:

>   pg_conn = PQconnectdb(
>     "hostaddr = '127.0.0.1' port = '' dbname = 'TBDB' user = 'sysdba'
> password = 'stelmo777' connect_timeout = '10'");
>   if (!pg_conn)
>   {
>     return false;
>   }
>   if (PQstatus(pg_conn) != CONNECTION_OK)
>   {
>     return false;  // <- execution reaches here.

> I checked the database, user and password by logging in with psql.
> What could be wrong?

If you print out the connection object's error message, you might
find out.  It's hard to guess about it without that information.

            regards, tom lane

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Did you check you pg_hba.conf ?
another thing: although port defaults to 5432 you *should* specify
that in the connection string.
also... is "sysdba" *really* an authorized user? check your permissions...

BR,
Pedro.

On 12/02/2009 09:42 PM, Tom Lane wrote:
> Daniel <danwgrace@gmail.com> writes:
>> I have written a C/C++ program that trys to log into a local
>> PostgreSQL database.  Here is the code:
>
>>   pg_conn = PQconnectdb(
>>     "hostaddr = '127.0.0.1' port = '' dbname = 'TBDB' user = 'sysdba'
>> password = 'stelmo777' connect_timeout = '10'");
>>   if (!pg_conn)
>>   {
>>     return false;
>>   }
>>   if (PQstatus(pg_conn) != CONNECTION_OK)
>>   {
>>     return false;  // <- execution reaches here.
>
>> I checked the database, user and password by logging in with psql.
>> What could be wrong?
>
> If you print out the connection object's error message, you might
> find out.  It's hard to guess about it without that information.
>
>             regards, tom lane
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAksW6nMACgkQ2FH5GXCfxAuOBgCeMdssoz+fE26lFX9StTCksUyp
tAkAoKKbnjPrE4fk8HpEbLYJHq3wq7UB
=e3vc
-----END PGP SIGNATURE-----

    Daniel wrote:

> I have written a C/C++ program that trys to log into a local
> PostgreSQL database.  Here is the code:
>
>   pg_conn = PQconnectdb(
>     "hostaddr = '127.0.0.1' port = '' dbname = 'TBDB' user = 'sysdba'
> password = 'stelmo777' connect_timeout = '10'");
>   if (!pg_conn)
>   {
>     return false;
>   }

In the program, you should
 fprintf(stderr, "%s", PQerrorMessage(pg_conn))
and/or
 copy-paste for us the psql command line that works.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

Oops, as it happens I had an error in my program logic and pg_conn was
actually true.