Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id D7B2A4759D8
	for <pgsql-interfaces@postgresql.org>;
	Sat,  6 Jul 2002 08:23:17 -0400 (EDT)
Mailbox-Line: From ozric02@yahoo.gr  Sat Jul  6 08:23:17 2002
Received: from web13106.mail.yahoo.com (web13106.mail.yahoo.com
	[216.136.174.151])
	by postgresql.org (Postfix) with SMTP id 730134759D8
	for <pgsql-interfaces@postgresql.org>;
	Sat,  6 Jul 2002 08:22:40 -0400 (EDT)
Message-ID: <20020706122244.55874.qmail@web13106.mail.yahoo.com>
Received: from [212.251.92.232] by web13106.mail.yahoo.com via HTTP;
	Sat, 06 Jul 2002 13:22:44 BST
Date: Sat, 6 Jul 2002 13:22:44 +0100 (BST)
From: =?iso-8859-7?q?ozric=20tentacle?= <ozric02@yahoo.gr>
Subject: HELP FOR POSTGRESQL NEEDED...
To: pgsql-questions@postgresql.org, pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1365950118-1025958164=:50423"
Content-Transfer-Encoding: 8bit
X-Spam-Status: No, hits=-0.5 required=5.0
	tests=X_NOT_PRESENT,FROM_ENDS_IN_NUMS,DOUBLE_CAPSWORD,
	SUBJ_ALL_CAPS version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/19
X-Sequence-Number: 2828

--0-1365950118-1025958164=:50423
Content-Type: text/plain; charset=iso-8859-7
Content-Transfer-Encoding: 8bit


Hello.I am experiencing a quite strange behavior with my postgreSQL database.

I have edited the file pg_hba.conf like this:

# TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE  AUTH_ARGUMENT
local      all                                                                       password
host       all         127.0.0.1     255.255.255.255                   password

in order to require user authentication.This works perfectly when I connect to the database with psql or pgaccess and I'm able to perform

all kinds of queries.

However when I try to connect to the database with C++ even though it allows me to connect (providing the correct username & password)

all the queries fail...The C++ code I use is the following:


#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <iostream.h>
#include <string>

#include "libpq++.h"

using namespace std;


int main()

{
  string login,pwd;
  char name[10];
  char query_string[256];

  cout << ">username:";
  cin >> login;
  cout << ">password:";
  cin >> pwd;

  cout<<"user to search:";
  cin >> name;


  // Open the connection to the database and make sure it's OK

  PgDatabase data("dbname=goumero");


  char       *pghost,*pgport,*pgoptions,*pgtty;
  char       *dbName;

   pghost = NULL;              /* host name of the backend server */
   pgport = NULL;              /* port of the backend server */
   pgoptions = NULL;         /* special options to start up the backend server */
   pgtty = NULL;               /* debugging tty for the backend server */
   dbName = "goumero";

   PGconn* conn;

   conn =  PQsetdbLogin(pghost,pgport,pgoptions,pgtty,dbName,login.c_str(),pwd.c_str()) ;

  if (PQstatus(conn) == CONNECTION_BAD ) {
        fprintf(stderr, "Connection to database '%s' failed.\n", dbName);
        fprintf(stderr, "%s", PQerrorMessage(conn));
        return 1;
  }
  else
      //Connection successful...


      data.Exec("BEGIN WORK");
      data.Exec("LOCK TABLE account in ACCESS EXCLUSIVE  MODE");


            sprintf(query_string,                               // create an SQL query string
                    "SELECT *   \
                     FROM account \
                     WHERE name='%s'" , name);
              if ( !data.ExecTuplesOk(query_string) )             // send the query
            {
                cerr << "query failed." << endl;
                exit(1);
            }

            for (int i=0; i < data.Tuples(); i++)               // loop through all rows returned
                    cout << data.GetValue(i,0) << endl;   // print the value returned

/**************************************************************************************/

      data.Exec("COMMIT WORK");
      PQfinish(conn);

return 0;

} // End main()

Note:The same query above is correctly executed when I connect with psql .

Also if I remove the user authentication stuff then the same code is executed correctly.

I would be grateful if you helped me - I'm desperate....

  

 


 

 


 

 



---------------------------------
Do You Yahoo!?
Αποκτήστε την δωρεάν σας@yahoo.gr διεύθυνση  στο Yahoo! Mail.

--0-1365950118-1025958164=:50423
Content-Type: text/html; charset=iso-8859-7
Content-Transfer-Encoding: 8bit

<P>Hello.I am experiencing a quite strange behavior with my <STRONG>postgreSQL database</STRONG>.</P>
<P>I have edited the file <STRONG>pg_hba.conf</STRONG>&nbsp;like this:</P>
<P># TYPE&nbsp;&nbsp;&nbsp;&nbsp; DATABASE&nbsp;&nbsp;&nbsp; IP_ADDRESS&nbsp;&nbsp;&nbsp; MASK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTH_TYPE&nbsp; AUTH_ARGUMENT<BR>local&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password<BR>host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.0.0.1&nbsp;&nbsp;&nbsp;&nbsp; 255.255.255.255&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password</P>
<P>in order to require user authentication.This works perfectly when I connect to the database with <STRONG>psql</STRONG> or <STRONG>pgaccess</STRONG> and I'm able to perform</P>
<P>all kinds of queries.</P>
<P>However when I try to connect to the database with <STRONG>C++</STRONG>&nbsp;even though&nbsp;it allows me to connect (providing the correct username &amp; password)</P>
<P><STRONG>all the queries fail...</STRONG>The C++ code I use is the following:</P>
<P><BR>#include &lt;stdio.h&gt;<BR>#include &lt;stdlib.h&gt;<BR>#include &lt;string.h&gt;<BR>#include &lt;iostream.h&gt;<BR>#include &lt;string&gt;</P>
<P>#include "libpq++.h"</P>
<P>using namespace std;</P>
<P><BR>int main()</P>
<P>{<BR>&nbsp; string login,pwd;<BR>&nbsp; char name[10];<BR>&nbsp; char query_string[256];</P>
<P>&nbsp;&nbsp;cout &lt;&lt; "&gt;username:";<BR>&nbsp; cin &gt;&gt; login;<BR>&nbsp; cout &lt;&lt; "&gt;password:";<BR>&nbsp; cin &gt;&gt; pwd;</P>
<P>&nbsp; cout&lt;&lt;"user to search:";<BR>&nbsp; cin &gt;&gt; name;</P>
<P><BR>&nbsp; // Open the connection to the database and make sure it's OK</P>
<P>&nbsp; PgDatabase data("dbname=goumero");</P>
<P><BR>&nbsp; char&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *pghost,*pgport,*pgoptions,*pgtty;<BR>&nbsp; char&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *dbName;</P>
<P>&nbsp;&nbsp; pghost = NULL;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* host name of the backend server */<BR>&nbsp;&nbsp; pgport = NULL;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* port of the backend server */<BR>&nbsp;&nbsp; pgoptions = NULL;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* special options to start up the backend server */<BR>&nbsp;&nbsp; pgtty = NULL;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* debugging tty for the backend server */<BR>&nbsp;&nbsp; dbName = "goumero";</P>
<P>&nbsp;&nbsp; PGconn* conn;</P>
<P>&nbsp;&nbsp; conn =&nbsp; PQsetdbLogin(pghost,pgport,pgoptions,pgtty,dbName,login.c_str(),pwd.c_str()) ;</P>
<P>&nbsp; if (PQstatus(conn) == CONNECTION_BAD ) {<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fprintf(stderr, "Connection to database '%s' failed.\n", dbName);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fprintf(stderr, "%s", PQerrorMessage(conn));<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return 1;<BR>&nbsp; }<BR>&nbsp; else<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Connection successful...</P>
<P><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data.Exec("BEGIN WORK");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data.Exec("LOCK TABLE account in ACCESS EXCLUSIVE&nbsp; MODE");</P>
<P><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sprintf(query_string,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // create an SQL query string<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "SELECT *&nbsp;&nbsp; \<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM account \<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE name='%s'" , name);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( !data.ExecTuplesOk(query_string) )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // send the query<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cerr &lt;&lt; "query failed." &lt;&lt; endl;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit(1);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (int i=0; i &lt; data.Tuples(); i++)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // loop through all rows returned<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cout &lt;&lt; data.GetValue(i,0) &lt;&lt; endl;&nbsp;&nbsp;&nbsp;// print the value returned</P>
<P>/**************************************************************************************/</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data.Exec("COMMIT WORK");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PQfinish(conn);</P>
<P>return 0;</P>
<P>} // End main()</P>
<P><STRONG><FONT color=blue><U>Note</U></FONT></STRONG>:The same query above is correctly executed when I connect with <STRONG>psql</STRONG> .</P>
<P><STRONG><U>Also if I remove the user authentication stuff then the same code is executed&nbsp;correctly.</U></STRONG></P>
<P><STRONG><FONT color=red>I would be grateful if you helped me - I'm desperate....</FONT></STRONG></P>
<P>&nbsp;&nbsp;</P>
<P>&nbsp;</P>
<P><BR>&nbsp;</P>
<P>&nbsp;</P>
<P><BR>&nbsp;</P>
<P>&nbsp;</P><p><br><hr size=1><b>Do You Yahoo!?</b><br>Αποκτήστε την δωρεάν σας
@yahoo.gr διεύθυνση  στο 
<a href="http://www.otenet.gr/">Yahoo! Mail</a>.<br>
--0-1365950118-1025958164=:50423--