Share » Forums » Install & configuration » Wizard can't connect to database on...

Wizard can't connect to database on my Redhat 9.0 postgresql installation. pgcrypto.sql problem.

Wizard can't connect to database on my Redhat 9.0 postgresql installation. pgcrypto.sql problem.

Sunday 28 December 2003 1:31:09 am - 1 reply

Modified on Sunday 28 December 2003 9:09:55 pm by Greg McAvoy-Jensen

Author Message

Greg McAvoy-Jensen

Saturday 03 January 2004 2:29:14 pm

OK, I'll answer my own question. I was unable to get postgresql to work, though I probably could have eventaully (permissions problem?). Instead, I installed mysql, reinstalled apache:

./configure --enable-rewrite=shared --enable-so
make
make install

And I reinstalled php:

rm -rf /usr/local/php
su
cd /home/gregmj/php-4.3-4
./configure --prefix=/usr/local/php --with-config-file-path=/etc/php --with-apxs2=/usr/local/apache2/bin/apxs --enable-track-vars --enable-magic-quotes --enable-debugger --with-mysql --with-mysql-sock=/tmp/mysql.sock
make
make install
cp php.ini-dist /etc/php.ini

There was much more work regarding permissions. It's been too long for me to remember what it was now. I include a script I wrote per the ezPublish installation wizard, to be run in the directory where the ezPublish files are.

#!/bin/bash
# Run this in the root ezpublish directory.
# This fixes permissions needed after you tar the ezpublish file.
# This is the error message it's addressing:
#chmod -R a+rwx settings
#chmod -R a+rwx settings/override
#chmod -R a+rwx var
#chmod -R a+rwx var/storage
#chmod -R a+rwx var/cache
#chmod -R a+rwx settings/siteaccess/admin
#chmod -R a+rwx design

#If you know the user and group of the webserver it's recommended to use a different set of permissions. To do this you need to change all the chmod commands.
#Example

#chmod -R og+rwx var
#chown -R nouser.nouser var

cd /var/www/html/gregorybooks
chmod -R og+rwx settings
chmod -R og+rwx settings/override
chmod -R og+rwx var
chmod -R og+rwx var/storage
chmod -R og+rwx var/cache
chmod -R og+rwx settings/siteaccess/admin
chmod -R og+rwx design

chown -R nobody.nobody settings
chown -R nobody.nobody settings/override
chown -R nobody.nobody var
chown -R nobody.nobody var/storage
chown -R nobody.nobody var/cache
chown -R nobody.nobody settings/siteaccess/admin
chown -R nobody.nobody design
-----------------
It saved met time to have it as a script. I hope this helps someone.

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu