Thread: Problem Connecting to DB After 8.1 Upgrade

Problem Connecting to DB After 8.1 Upgrade

From

Date:

14 November 2005, 13:41:47

i have the following adodb code (which shouldn't be
too hard to figure out for those not familiar with
adodb):

$db = &ADONewConnection('postgres8');
$db->Connect('localhost','postgres','3mydata5','mydb');
if (!$db) die('Connection failed');
$db->debug = true;

$sql_product = 'SELECT product_id, product_number FROM
t_product ' .
'ORDER BY product_number ASC';

$sql_employee = 'SELECT employee_id, first_name || \'
\' || last_name FROM t_employee ORDER BY
LOWER(first_name) ASC';

$db->StartTrans();
$rs_product = $db->Execute($sql_product);
$rs_employee = $db->Execute($sql_employee);
$db->CompleteTrans();

$db is true, but i don't think i'm connecting to the
db.  i can echo text prior to the transaction, but i
can't echo anything after the transaction.  i removed
the transaction and just left the Execute statements -
same problem.

does anyone have any idea why this isn't working?

tia...



__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs

Re: Problem Connecting to DB After 8.1 Upgrade

From

Date:

14 November 2005, 14:39:12

--- operationsengineer1@yahoo.com wrote:

> i have the following adodb code (which shouldn't be
> too hard to figure out for those not familiar with
> adodb):
>
> $db = &ADONewConnection('postgres8');
>
$db->Connect('localhost','postgres','3mydata5','mydb');
> if (!$db) die('Connection failed');
> $db->debug = true;
>
> $sql_product = 'SELECT product_id, product_number
> FROM
> t_product ' .
> 'ORDER BY product_number ASC';
>
> $sql_employee = 'SELECT employee_id, first_name ||
> \'
> \' || last_name FROM t_employee ORDER BY
> LOWER(first_name) ASC';
>
> $db->StartTrans();
> $rs_product = $db->Execute($sql_product);
> $rs_employee = $db->Execute($sql_employee);
> $db->CompleteTrans();
>
> $db is true, but i don't think i'm connecting to the
> db.  i can echo text prior to the transaction, but i
> can't echo anything after the transaction.  i
> removed
> the transaction and just left the Execute statements
> -
> same problem.
>
> does anyone have any idea why this isn't working?
>
> tia...

upon further review, it appears my users and groups
didn't survive the backup and restore procedure since
pgsql 8.1 is looking for group roles and login roles.

even so, i don't understand why postgres (a current
login role) is not connecting to the db.

i will try and mimic my prior setup and go from there.




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Re: Problem Connecting to DB After 8.1 Upgrade

From

Jaime Casanova

Date:

14 November 2005, 15:04:26

On 11/14/05, operationsengineer1@yahoo.com
<operationsengineer1@yahoo.com> wrote:
> --- operationsengineer1@yahoo.com wrote:
>
> > i have the following adodb code (which shouldn't be
> > too hard to figure out for those not familiar with
> > adodb):
> >
> > $db = &ADONewConnection('postgres8');
> >
> $db->Connect('localhost','postgres','3mydata5','mydb');
> > if (!$db) die('Connection failed');
> > $db->debug = true;
> >
> > $sql_product = 'SELECT product_id, product_number
> > FROM
> > t_product ' .
> > 'ORDER BY product_number ASC';
> >
> > $sql_employee = 'SELECT employee_id, first_name ||
> > \'
> > \' || last_name FROM t_employee ORDER BY
> > LOWER(first_name) ASC';
> >
> > $db->StartTrans();
> > $rs_product = $db->Execute($sql_product);
> > $rs_employee = $db->Execute($sql_employee);
> > $db->CompleteTrans();
> >
> > $db is true, but i don't think i'm connecting to the
> > db.  i can echo text prior to the transaction, but i
> > can't echo anything after the transaction.  i
> > removed
> > the transaction and just left the Execute statements
> > -
> > same problem.
> >
> > does anyone have any idea why this isn't working?
> >
> > tia...
>
> upon further review, it appears my users and groups
> didn't survive the backup and restore procedure since
> pgsql 8.1 is looking for group roles and login roles.
>
> even so, i don't understand why postgres (a current
> login role) is not connecting to the db.
>
> i will try and mimic my prior setup and go from there.
>
>

provide some info from your postgres log files (error messages)...
have configurated the pg_hba.conf and postgresql.conf?

all your users and groups will turn into roles are you sure you can
login from them?

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

Re: Problem Connecting to DB After 8.1 Upgrade

From

Date:

14 November 2005, 17:14:30

--- Jaime Casanova <systemguards@gmail.com> wrote:

> On 11/14/05, operationsengineer1@yahoo.com
> <operationsengineer1@yahoo.com> wrote:
> > --- operationsengineer1@yahoo.com wrote:
> >
> > > i have the following adodb code (which shouldn't
> be
> > > too hard to figure out for those not familiar
> with
> > > adodb):
> > >
> > > $db = &ADONewConnection('postgres8');
> > >
> >
>
$db->Connect('localhost','postgres','3mydata5','mydb');
> > > if (!$db) die('Connection failed');
> > > $db->debug = true;
> > >
> > > $sql_product = 'SELECT product_id,
> product_number
> > > FROM
> > > t_product ' .
> > > 'ORDER BY product_number ASC';
> > >
> > > $sql_employee = 'SELECT employee_id, first_name
> ||
> > > \'
> > > \' || last_name FROM t_employee ORDER BY
> > > LOWER(first_name) ASC';
> > >
> > > $db->StartTrans();
> > > $rs_product = $db->Execute($sql_product);
> > > $rs_employee = $db->Execute($sql_employee);
> > > $db->CompleteTrans();
> > >
> > > $db is true, but i don't think i'm connecting to
> the
> > > db.  i can echo text prior to the transaction,
> but i
> > > can't echo anything after the transaction.  i
> > > removed
> > > the transaction and just left the Execute
> statements
> > > -
> > > same problem.
> > >
> > > does anyone have any idea why this isn't
> working?
> > >
> > > tia...
> >
> > upon further review, it appears my users and
> groups
> > didn't survive the backup and restore procedure
> since
> > pgsql 8.1 is looking for group roles and login
> roles.
> >
> > even so, i don't understand why postgres (a
> current
> > login role) is not connecting to the db.
> >
> > i will try and mimic my prior setup and go from
> there.
> >
> >
>
> provide some info from your postgres log files
> (error messages)...

if you could give me the name of the file, i'll search
for it and post the contents.

> have configurated the pg_hba.conf and
> postgresql.conf?

i don't recall having to do this for 7.4.x (i might
have done something TCP/IP related, but that was it,
IIRC).  did anything change going to 8.1?

> all your users and groups will turn into roles are
> you sure you can
> login from them?

this did not occur in my case - the users and groups
didn't transfer.  the only role i had in the new db is
postgres.

i've linked my pg_restore output here....

http://www.geocities.com/operationsengineer1/pgsql_restore.xhtml

i created the db then did a restore...  i'm not sure
if that is the correct procedure.

i tried creating a simple new database with no
password and i can't connect to it either.

> --
> Atentamente,
> Jaime Casanova
> (DBA: DataBase Aniquilator ;)

tia for the help...



__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs

Re: Problem Connecting to DB After 8.1 Upgrade

From

Date:

14 November 2005, 20:46:54

i'm reinstalling after figuring out i didn't delete
all the pgsql 8.0 files and i didn't configure php.ini
correctly.

--- operationsengineer1@yahoo.com wrote:

> --- Jaime Casanova <systemguards@gmail.com> wrote:
>
> > On 11/14/05, operationsengineer1@yahoo.com
> > <operationsengineer1@yahoo.com> wrote:
> > > --- operationsengineer1@yahoo.com wrote:
> > >
> > > > i have the following adodb code (which
> shouldn't
> > be
> > > > too hard to figure out for those not familiar
> > with
> > > > adodb):
> > > >
> > > > $db = &ADONewConnection('postgres8');
> > > >
> > >
> >
>
$db->Connect('localhost','postgres','3mydata5','mydb');
> > > > if (!$db) die('Connection failed');
> > > > $db->debug = true;
> > > >
> > > > $sql_product = 'SELECT product_id,
> > product_number
> > > > FROM
> > > > t_product ' .
> > > > 'ORDER BY product_number ASC';
> > > >
> > > > $sql_employee = 'SELECT employee_id,
> first_name
> > ||
> > > > \'
> > > > \' || last_name FROM t_employee ORDER BY
> > > > LOWER(first_name) ASC';
> > > >
> > > > $db->StartTrans();
> > > > $rs_product = $db->Execute($sql_product);
> > > > $rs_employee = $db->Execute($sql_employee);
> > > > $db->CompleteTrans();
> > > >
> > > > $db is true, but i don't think i'm connecting
> to
> > the
> > > > db.  i can echo text prior to the transaction,
> > but i
> > > > can't echo anything after the transaction.  i
> > > > removed
> > > > the transaction and just left the Execute
> > statements
> > > > -
> > > > same problem.
> > > >
> > > > does anyone have any idea why this isn't
> > working?
> > > >
> > > > tia...
> > >
> > > upon further review, it appears my users and
> > groups
> > > didn't survive the backup and restore procedure
> > since
> > > pgsql 8.1 is looking for group roles and login
> > roles.
> > >
> > > even so, i don't understand why postgres (a
> > current
> > > login role) is not connecting to the db.
> > >
> > > i will try and mimic my prior setup and go from
> > there.
> > >
> > >
> >
> > provide some info from your postgres log files
> > (error messages)...
>
> if you could give me the name of the file, i'll
> search
> for it and post the contents.
>
> > have configurated the pg_hba.conf and
> > postgresql.conf?
>
> i don't recall having to do this for 7.4.x (i might
> have done something TCP/IP related, but that was it,
> IIRC).  did anything change going to 8.1?
>
> > all your users and groups will turn into roles are
> > you sure you can
> > login from them?
>
> this did not occur in my case - the users and groups
> didn't transfer.  the only role i had in the new db
> is
> postgres.
>
> i've linked my pg_restore output here....
>
>
http://www.geocities.com/operationsengineer1/pgsql_restore.xhtml
>
> i created the db then did a restore...  i'm not sure
> if that is the correct procedure.
>
> i tried creating a simple new database with no
> password and i can't connect to it either.
>
> > --
> > Atentamente,
> > Jaime Casanova
> > (DBA: DataBase Aniquilator ;)
>
> tia for the help...
>
>
>
> __________________________________
> Start your day with Yahoo! - Make it your home page!
>
> http://www.yahoo.com/r/hs
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will
> ignore your desire to
>        choose an index scan if your joining column's
> datatypes do not
>        match
>





__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Re: Problem Connecting to DB After 8.1 Upgrade (SOLVED)

From

Date:

16 November 2005, 13:42:58

the upgrade to 8.1 went great...  i just missed the
*minor* detail of enabling pgsql support in php.ini.
excuse me while i go fall on my sword a few times.

--- operationsengineer1@yahoo.com wrote:

> i'm reinstalling after figuring out i didn't delete
> all the pgsql 8.0 files and i didn't configure
> php.ini
> correctly.
>
> --- operationsengineer1@yahoo.com wrote:
>
> > --- Jaime Casanova <systemguards@gmail.com> wrote:
> >
> > > On 11/14/05, operationsengineer1@yahoo.com
> > > <operationsengineer1@yahoo.com> wrote:
> > > > --- operationsengineer1@yahoo.com wrote:
> > > >
> > > > > i have the following adodb code (which
> > shouldn't
> > > be
> > > > > too hard to figure out for those not
> familiar
> > > with
> > > > > adodb):
> > > > >
> > > > > $db = &ADONewConnection('postgres8');
> > > > >
> > > >
> > >
> >
>
$db->Connect('localhost','postgres','3mydata5','mydb');
> > > > > if (!$db) die('Connection failed');
> > > > > $db->debug = true;
> > > > >
> > > > > $sql_product = 'SELECT product_id,
> > > product_number
> > > > > FROM
> > > > > t_product ' .
> > > > > 'ORDER BY product_number ASC';
> > > > >
> > > > > $sql_employee = 'SELECT employee_id,
> > first_name
> > > ||
> > > > > \'
> > > > > \' || last_name FROM t_employee ORDER BY
> > > > > LOWER(first_name) ASC';
> > > > >
> > > > > $db->StartTrans();
> > > > > $rs_product = $db->Execute($sql_product);
> > > > > $rs_employee = $db->Execute($sql_employee);
> > > > > $db->CompleteTrans();
> > > > >
> > > > > $db is true, but i don't think i'm
> connecting
> > to
> > > the
> > > > > db.  i can echo text prior to the
> transaction,
> > > but i
> > > > > can't echo anything after the transaction.
> i
> > > > > removed
> > > > > the transaction and just left the Execute
> > > statements
> > > > > -
> > > > > same problem.
> > > > >
> > > > > does anyone have any idea why this isn't
> > > working?
> > > > >
> > > > > tia...
> > > >
> > > > upon further review, it appears my users and
> > > groups
> > > > didn't survive the backup and restore
> procedure
> > > since
> > > > pgsql 8.1 is looking for group roles and login
> > > roles.
> > > >
> > > > even so, i don't understand why postgres (a
> > > current
> > > > login role) is not connecting to the db.
> > > >
> > > > i will try and mimic my prior setup and go
> from
> > > there.
> > > >
> > > >
> > >
> > > provide some info from your postgres log files
> > > (error messages)...
> >
> > if you could give me the name of the file, i'll
> > search
> > for it and post the contents.
> >
> > > have configurated the pg_hba.conf and
> > > postgresql.conf?
> >
> > i don't recall having to do this for 7.4.x (i
> might
> > have done something TCP/IP related, but that was
> it,
> > IIRC).  did anything change going to 8.1?
> >
> > > all your users and groups will turn into roles
> are
> > > you sure you can
> > > login from them?
> >
> > this did not occur in my case - the users and
> groups
> > didn't transfer.  the only role i had in the new
> db
> > is
> > postgres.
> >
> > i've linked my pg_restore output here....
> >
> >
>
http://www.geocities.com/operationsengineer1/pgsql_restore.xhtml
> >
> > i created the db then did a restore...  i'm not
> sure
> > if that is the correct procedure.
> >
> > i tried creating a simple new database with no
> > password and i can't connect to it either.
> >
> > > --
> > > Atentamente,
> > > Jaime Casanova
> > > (DBA: DataBase Aniquilator ;)
> >
> > tia for the help...
> >
> >
> >
> > __________________________________
> > Start your day with Yahoo! - Make it your home
> page!
> >
> > http://www.yahoo.com/r/hs
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will
> > ignore your desire to
> >        choose an index scan if your joining
> column's
> > datatypes do not
> >        match




__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com