Topic: postgresql support for php under SME

[scrop]

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

[Jáder Marasca]

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

[scrop]

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

[Hardijs_]

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

[Jáder]

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]#