Obsolete Releases > SME 8.x Contribs

php-postgres

(1/3) > >>

BlueLake:
which command do I enter to install pdo-pgsql.so so far I have tried every conceivable thing I can think of including just about every google item there is in every forum I can find. When I enter yum install php5-pgsql I get the message "no package php5-ggsql available" so I have tried all variations on the theme with the same result...It is actually easier to walk on water than do anything with postgresql in SME ver 8

janet:
BlueLake

Considering your name, it's probably easier for you to walk on water, but for others, it's probably easier to nominate a suitable repo (repository) that has the required package.
That package is not in the standard repos that SME server uses by default, that's why the command you used is not finding & installing it.
I do not know where php5-pgsql is, or if it exists, but you might try epel, or dag or atrpms or webtatic repos.

If you can tell us where that package is, then we can tell you how to install it on SME server

Then you install it using a command like
yum install --enablerepo=epel php5-pgsql
(assuming you have first configured epel repo on your sme server & second that the package is in that repo, replace repo name as appropriate).
 
See the FAQ, link at top of forums, Section 1 Installation, for everything you need to know about repos, how to add & enable them etc.
particularly
http://wiki.contribs.org/SME_Server:Documentation:FAQ:Section01#Other_popular_repositories
and
http://wiki.contribs.org/Category:Yum_Repository
 
Be aware you may have compatibility & dependency issues installing additional packages like that, so proceed carefully.

I checked & it's not in dag, epel, webtatic or atrpms (for 32 bit system, there might be a 64 bit pkg if your system is 64 bit, so try), otherwise you will have to search around for it.
If you configure all those repos on SME, then run the command suggested (modified to suit each repo), & it will show you if that pkg is available or not, you can cancel the install also.

I googled & found rpm.pbone.net & rpmfind.net has a 64 bit pkg, so download it to a empty folder on your sme server & do a local yum install

wget http://websiteURLpath/filename.rpm
yum localinstall fullpackagename.rpm
signal-event post-upgrade
signal-event reboot

BlueLake:
Hi Janet and thanks for the reply
 Ok some history - first my original sme was ver 7 which I was able to install and use, following one of the published how to's. This box is was upgraded to ver 8 and is now giving some errors - up to this point great. Some time ago I decided to do a fresh install of ver 8, no problems so far - then tried to install postgresql 9+ which was impossible. So gave up.

 Now my original box is causing problems so decided once again to install a fresh copy of ver 8 and keep the postgresql DB on another linux server,  but to do this I need to install pgsql.so for php 5.3 (to read the postgresql DB) which isn't happening. Looking at every posting I have been able to find for centos etc... all say to "yum install php5-pgsql" Ok this i did, but the error (see original post) was displayed...again back to google searching for other examples, all of which were tried and all with the same result. What I need is a line in the php.ini which says "extension=pgsql.so" (which I have) for things to work, then reboot apache. Which is how I did it with the original ver 7. This is a clean 64 bit install of ver 8...

So...your bottom line will be something like wget http the rpm.bone etc... :???:   

BlueLake:
Hi
Could I just copy the required file from another machine...would that work? or rpmseeek.com have a 64 bit file

Thanks

Xavier.A:
hi,

Do u want to install phppgadmin?

First step :
have a look here  : http://blog.ansoult.fr/co/Installer_PostgreSQL92_sur_SME_Server_8.html
I did'nt test PosgreSQL 9.3 but it must be possible to install it on SME8, the wiki page will be updated soon (i will try, if i can :-) )

Second step :
Tell us about your yum repos already installed in your SME8
db yum_repositories show | grep repository

in my SME8s :
webtatic-el5=repository >> http://wiki.contribs.org/Webtatic
Atomic's repos seems to be a good choice too but i did'nt test it yet >>> http://wiki.contribs.org/Atomic

Tell us about your php RPMs already installed :
yum list installed | grep php
or
rpm -q -a --qf "%{Name}:%{Vendor}\n"| grep php

yum --enablerepo=webtatic-el5 search php-pgsql
yum --enablerepo=webtatic-el5 info php-pgsql

if it s good for u
yum --enablerepo=webtatic-el5 install php-pgsql

Done !

For PostgreSQL admin tools, may be u should look at pgadmin : http://www.pgadmin.org/

Xavier

Navigation

[0] Message Index

[#] Next page