Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: scrop on November 28, 2003, 02:41:21 AM

Title: postgresql support for php under SME
Post by: scrop on November 28, 2003, 02:41:21 AM

Hi everyone,

I just wondering anyone know how to do postgresql support for php under SME server. I have followed instruction posted in following web site:

http://www.leiinc.com/repository/Linux/Mitel_SME_Server/HowToGuides/sme56_imp-horde-php_upgrade.htm

But it doesn't have the postgres support.

Thanx,

Scrop

Title: Re: postgresql support for php under SME
Post by: Jáder Marasca on November 29, 2003, 04:03:05 PM

go to rpmfind.net and search for php module for postgresql. You must use same version of module as you have PHP.
So install it on your server.

If you like some help please post your EXACT version of PHP.

Jáder

Title: Re: postgresql support for php under SME
Post by: scrop on November 30, 2003, 04:23:52 PM

Thanx Jader, I have installed following rpm in my SME. But it doesn't show up any postgresql in my system. Do we need to do anything in SME

php-4.3.2-4db.i386.rpm
php-ldap-4.3.2-4db.i386.rpm
php-devel-4.3.2-4db.i386.rpm
php-mysql-4.3.2-4db.i386.rpm
php-imap-4.3.2-4db.i386.rpm
php-pgsql-4.3.2-4db.i386.rpm


Scrop

Title: edit php.ini
Post by: Hardijs_ on February 17, 2004, 10:24:55 AM

edit php.ini (or template-custom  after  test) so that it includes the pgsql.so (right where the mysql.so is)

then phpinfo() shows some postgres info - in theory it should work

Title: configuration of one SME server running postgresql
Post by: Jáder on February 17, 2004, 10:49:29 AM

This is from a SME server running Postgresql :
(It´s a long post...but I hope it help!)

[root@iguana root]# rpm -qa|grep php
php-mysql-4.1.2-7.3.4
dmc-mitel-phpsysinfo-2.1-1
dmc-mitel-phpmyadmin-2.2.3-1
php-4.1.2-7.3.4
php-ldap-4.1.2-7.3.4
php-imap-4.1.2-7.3.4
php-pgsql-4.1.2-2es3
e-smith-php-1.8.0-01

[root@iguana root]# rpm -qa|grep postgre
postgresql-7.1.3-2
postgresql-libs-7.1.3-2
postgresql-server-7.1.3-2
[root@iguana root]#

[root@iguana root]# rpm -qa|grep pgsql
php-pgsql-4.1.2-2es3

[root@iguana root]# ll /etc/e-smith/templates-custom/etc/php.ini/
total 16
-rw-r--r--    1 root     root          175 Aug 22  2002 30ErrorHandling
-rw-r--r--    1 root     root          385 Aug 24  2002 40DataHandling
-rw-r--r--    1 root     root          240 Jan 14 17:54 50PathsDirectories
-rw-r--r--    1 root     root           19 Aug 24  2002 70DynamicExtension80pgsql[root@iguana root]# cat /etc/e-smith/templates-custom/etc/php.ini/30ErrorHandling
error_reporting =       E_ALL & ~E_NOTICE
#error_reporting =      E_ALL
display_errors  =       On
display_startup_errors = Off
log_errors              =       Off
track_errors    =       Off
warn_plus_overloading   =       Off
[root@iguana root]#[root@iguana root]# cat /etc/e-smith/templates-custom/etc/php.ini/40DataHandling
variables_order         =       "EGPCS"
register_globals        =       On
register_argc_argv      =       On
post_max_size           ={
    my $ms = db_get_prop($confref, 'php', 'PostMaxSize') || "8M";
    $OUT .= "$ms";
}
gpc_order                       =       "GPC"
magic_quotes_gpc        =       On
magic_quotes_runtime=   Off
magic_quotes_sybase     =       Off
auto_prepend_file       = "/usr/share/phplib-7.2d/php/prepend.php3"
auto_append_file        =
default_mimetype = "text/html"


[root@iguana root]# cat /etc/e-smith/templates-custom/etc/php.ini/50PathsDirectories
include_path            = "./:/home/e-smith/files/ibays/c/W/lcbc/php:/home/e-smi
th/files/ibays/c/W/php/framework:/usr/share/phplib-7.2d/php:/usr/share/phpFastTe
mplate"
doc_root                =
user_dir                =
extension_dir   =       /usr/lib/php4
enable_dl               = On
[root@iguana root]#


[root@iguana root]# cat /etc/e-smith/templates-custom/etc/php.ini/70DynamicExtension80pgsql
extension=pgsql.so
[root@iguana root]#