var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
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:
Those are just a few examples.
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
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?
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.
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.