Koozali.org: home of the SME Server

opensis and postgresl

Offline kwak

  • *
  • 13
  • +0/-0
    • http://www.aimschool.ac.th
opensis and postgresl
« on: July 24, 2008, 12:07:51 PM »
Hi,

I tried the wiki post on how to install postgres. It went well, but I can't access it from a remote location using pgadmin3. I check port 5432 using nmap from another machine and it 5432 is not open. I already modified the postgresql.conf, listen-addresses to '*' but still the same thing. I did a lot of trial and error, search the net for solutions but can't get it  to work.

Another problem that I have is this, I uploaded the opensis files in the primary>html folder. It has an automated installer and can be accessed via localhost/ins/index.php but when I access this, i get a blank page and the URL becomes localhost/index.php. I created a file called phpinfo.php and uploaded into the same location, accessed it and it seems to be working (php).

Can somebody please help me with this? Thanks in advance.

Lastly, has anybody tried installing KOHA 3 beta in sme7.

Thanks again,
Edward TH

Offline byte

  • *
  • 2,183
  • +2/-0
Re: opensis and postgresl
« Reply #1 on: July 24, 2008, 07:28:11 PM »
Moving this topic to the SME 7.x contribs forum, it is more appropriate there. Thanks!
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline kwak

  • *
  • 13
  • +0/-0
    • http://www.aimschool.ac.th
Re: opensis and postgresl - postgresql 8.1 working - but not php site
« Reply #2 on: July 25, 2008, 09:07:58 AM »
hi again,

after fiddling around with it, it suddenly work. i followed the postgres installation guide again and suddenly it worked. port 5432 is open and i can access postgresql from remote machine using pgadmin3.

but i still can't get opensis to display. as i have said, i uploaded in the primary--html folder and it only shows me blank page. well the favicon.ico is showing at least. i also tried creating an ibay uploaded it there and the same thing. what could be wrong, please help

regards,
edward th

Offline kwak

  • *
  • 13
  • +0/-0
    • http://www.aimschool.ac.th
Re: opensis and postgresl
« Reply #3 on: July 25, 2008, 10:55:36 AM »
Hi,

Now I get this error

Fatal error: Call to undefined function: pg_connect() in /home/e-smith/files/ibays/Primary/html/database.inc.php on line 20

database.inc.php gets its data from data.php which are all correct. i checked phpinfo() and pgsql is included. I really don't know what's the meaning of this. Please help

Edward TH

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: opensis and postgresl
« Reply #4 on: July 25, 2008, 11:48:31 AM »
kwak

check if that function is supported by the version of php running on sme7.3 eg 4.3.9
It may require php 5.x
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.