Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    516

    pqsql database error after server move

    I moved an account that uses pgsql databases from server A to server B.

    Now that it's on server B - the script DOES connect to the database, however it's throwing all sorts of permissions errors n such:

    Warning: pg_query(): Query failed: ERROR: tblnotes: permission denied in /home/usr/public_html/zelrik/inc/notes.inc on line 35

    Warning: pg_fetch_assoc(): supplied argument is not a valid PostgreSQL result resource in /home/usr/public_html/zelrik/inc/notes.inc on line 36

    Warning: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in /home/usr/public_html/zelrik/inc/notes.inc on line 59
    Those are just a few examples.
    It's the same version of pgsql running on both servers...
    All files and directories have the same ownerships/permissions as when they were on the old server..

    The only odd thing was that cPanel didn't transfer over the sql database - so I had to make a dump via root shell on server A and restore via root shell on server B.

    So... any ideas?

  2. #2
    Join Date
    Oct 2004
    Location
    Tampa, Florida
    Posts
    80
    database user permissions don't look right did you setup a new DB user for that DB ? Maybe the password is not the same as in the application configuration.
    eWebtricity
    Hosting | Web Design | Server Administration
    http://www.ewebtricity.net | [email protected]
    http://www.1and1faq.com 1and1 Customer Support

  3. #3
    Join Date
    Nov 2003
    Posts
    516
    yes - I checked the DB config script and setup the user accordingly.

    I know that it IS connecting - when it's not, another error is generated from the config script stating that the connection to the database has failed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •