Photo Organizer

  • Status Closed
  • Percent Complete
    100%
  • Task Type Bug Report
  • Category Backend / Core → Database
  • Assigned To No-one
  • Operating System Linux
  • Severity Critical
  • Priority Very Low
  • Reported Version 2.36
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Photo Organizer
Opened by Duncan Murray - 2008-09-18
Last edited by Solomon Peachy - 2008-09-18

FS#384 - PO does not create database tables on remote PostgreSQL server

everything looks fine until the PO's setup script trys to import the tables to the pgsql server. I am unable to proceed with the setup. No documentation for remote pgsql server only local server. po_user is able to connect manually but not install.php is not able to.

Closed by  Solomon Peachy
2008-09-18 02:58
Reason for closing:  Fixed
Additional comments about closing:  fix to the installer will be in 2.36.1
Admin
Solomon Peachy commented on 2008-09-18 02:24

To quote config.php:

// Use an external database via IP
// $db_dsn = "host=128.61.15.251 port=5432 dbname=po_db user=po_user password=po_password";

Admin
Solomon Peachy commented on 2008-09-18 02:25

it's worth mentioning that postgresql has its own access controls that may not be allowing a connection.

Duncan Murray commented on 2008-09-18 02:37

All parameters seem to be in place.

CONFIG FILE
[root@web include]# cat config_site.php
$db_dsn = "host=192.168.2.77 port=5432 dbname=po_db user=po_user password=*****";

CONNECTING TO PGSQL
[root@web include]# psql -h 192.168.2.77 -U po_user -d po_db
Password for user po_user:
Welcome to psql 8.3.3 (server 8.3.1), the PostgreSQL interactive terminal.

OUTPUT FROM po/install.php
Photo Organizer Installation/Update Utility
Note: The current maximum upload file size is 1024M. You may need to increase this. See the upload_max_filesize and post_max_size settings in your php.ini file.
Note: The current memory limit is 1024M. You may need to increase this. See the memory_limit setting in your php.ini file.
Current Photo Organizer DB version: (none)
Upgrading Photo Organizer DB v (none)

* Checking for PL/PGSQL support...FAILED
* Run this command as root:

su - postgres -c "createlang plpgsql "

Correct the above errors, and try again. We will pick up where we left off.

OUTPUT FROM RECOMMENDED COMMAND
[root@dbs tmp]# su - postgres -c "createlang plpgsql "
createlang: language "plpgsql" is already installed in database "postgres"

Admin
Solomon Peachy commented on 2008-09-18 02:52

*sigh* that should be:

su - postgres -c "createlang plpgsql po_db"

It looks like the installer needs a slight update.

Duncan Murray commented on 2008-09-18 02:54

Excellent everything works like a charm now. Thank you very much for your quick response.

OUTPUT FROM INSTALLER

Photo Organizer Installation/Update Utility
Note: The current maximum upload file size is 1024M. You may need to increase this. See the upload_max_filesize and post_max_size settings in your php.ini file.
Note: The current memory limit is 1024M. You may need to increase this. See the memory_limit setting in your php.ini file.
Current Photo Organizer DB version: (none)
Upgrading Photo Organizer DB v (none)

* Checking for PL/PGSQL support...OK
* Creating initial image repository layout...OK
* Loading initial database data...OK

Upgrading Photo Organizer DB v 2.35.A

* Upgrading database structure...OK

Upgrading Photo Organizer DB v 2.35.B

* Upgrading database structure...OK

Upgrading Photo Organizer DB v 2.36.A

o Migrating filter
o Migrating flash
o Migrating scanner
o Migrating support
o Migrating lens

Upgrading Photo Organizer DB v 2.36.B

* Upgrading database structure...OK

Upgrading Photo Organizer DB v 2.36.C

* Upgrading database structure...OK

Install/Upgrade to DB version 2.36.D complete.

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing