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!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.