Photo Organizer

Notice: Undefined index: tasklist_type in /var/www/flyspray/includes/class.tpl.php(128) : eval()'d code on line 85 Notice: Undefined index: tasklist_type in /var/www/flyspray/includes/class.tpl.php(128) : eval()'d code on line 90
  • Status Closed
  • Percent Complete
    100%
  • Task Type Bug Report
  • Category Backend / Core → Database
  • Assigned To No-one
  • Operating System Linux
  • Severity Critical
  • Priority Normal
  • Reported Version 2.36
  • Due in Version Undecided
  • Due Date Undecided
  • Votes 0
  • Private No
Attached to Project: Photo Organizer
Opened by Duncan Murray (Gompho) - 2008-09-18
Last edited by Solomon Peachy (pizza) - 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.

This task does not depend on any other tasks.

Closed by  Solomon Peachy (pizza)
Thursday, 18 September 2008, 02:58 GMT
Reason for closing:  Fixed
Additional comments about closing:  fix to the installer will be in 2.36.1
Solomon Peachy (pizza)
Thursday, 18 September 2008, 02:24 GMT
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";
Solomon Peachy (pizza)
Thursday, 18 September 2008, 02:25 GMT
it's worth mentioning that postgresql has its own access controls that may not be allowing a connection.
Duncan Murray (Gompho)
Thursday, 18 September 2008, 02:37 GMT
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"

Solomon Peachy (pizza)
Thursday, 18 September 2008, 02:52 GMT
*sigh* that should be:

su - postgres -c "createlang plpgsql po_db"

It looks like the installer needs a slight update.
Duncan Murray (Gompho)
Thursday, 18 September 2008, 02:54 GMT
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...