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

Previous topic

Install & configuration

Next topic

Author	Message
Greg McAvoy-Jensen	Sunday 28 December 2003 1:31:09 am During the setup process I am returned to the database intialization page with the following error message: Please make sure that the username and the password is correct. Verify that your PostgreSQL database is configured correctly. See the PHP documentation for more information about this. Remember to start postmaster with the -i option. Perhaps the core of the problem is that when I try to run pgcrypto.sql I get this interaction: bash-2.05b$ psql -U gregory gregorybooks < /usr/share/pgsql/contrib/pgcrypto.sql SET SET ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c ERROR: permission denied for language c I actually had success with pgcrypto on the postgresql 7.3 that came with redhat 9, but I installed 7.4 to get the latest and now have this error. I had followed the instructions on http://ez.no/developer/ez_publish_3/documentation/installation/normal_installation/installing_ez_publish_on_a_windows_based_system for my postgresql server. To the questions asked about create user (can they make users and databases) I answered yes On the Site Details page I entered the domain name I use (different from where ezPublish is located). I also changed the title and the database. Here's the relevant data from my /var/lib/pgsql/data/pg_hba.conf: # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust # IPv4-style local connections: host all all 127.0.0.1 255.255.255.255 crypt # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff crypt Note also that I had postgresql 7.3 on my Redhat 9, and it's possible I've done something wrong when installing 7.4. My questions: 1. What do I need to do to get pgcrypto to work? 2. Did I answer the questions regarding create user correctly, or too liberally? 3. Should I have created a password for it? The instructions don't say to. 4. What do I need to do to get a step further in the install process? Thank you. Greg 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
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

Author

Message

Greg McAvoy-Jensen

Sunday 28 December 2003 1:31:09 am

During the setup process I am returned to the database intialization page with the following error message:

Please make sure that the username and the password is correct. Verify that your PostgreSQL database is configured correctly.
See the PHP documentation for more information about this.
Remember to start postmaster with the -i option.

Perhaps the core of the problem is that when I try to run pgcrypto.sql I get this interaction:

bash-2.05b$ psql -U gregory gregorybooks < /usr/share/pgsql/contrib/pgcrypto.sql
SET
SET
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c
ERROR: permission denied for language c

I actually had success with pgcrypto on the postgresql 7.3 that came with redhat 9, but I installed 7.4 to get the latest and now have this error.

I had followed the instructions on http://ez.no/developer/ez_publish_3/documentation/installation/normal_installation/installing_ez_publish_on_a_windows_based_system
for my postgresql server. To the questions asked about create user (can they make users and databases) I answered yes

On the Site Details page I entered the domain name I use (different from where ezPublish is located). I also changed the title and the database.

Here's the relevant data from my /var/lib/pgsql/data/pg_hba.conf:

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 crypt
# IPv6-style local connections:
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff crypt

Note also that I had postgresql 7.3 on my Redhat 9, and it's possible I've done something wrong when installing 7.4.

My questions:
1. What do I need to do to get pgcrypto to work?
2. Did I answer the questions regarding create user correctly, or too liberally?
3. Should I have created a password for it? The instructions don't say to.
4. What do I need to do to get a step further in the install process?

Thank you.

Greg

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

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.

eZ debug

Timing:	Jan 19 2025 07:25:59
Script start
Timing:	Jan 19 2025 07:25:59
Module start 'layout'
Timing:	Jan 19 2025 07:25:59
Module start 'content'
Timing:	Jan 19 2025 07:25:59
Module end 'content'
Timing:	Jan 19 2025 07:25:59
Script end

Main resources:

Total runtime	0.7016 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0102	591.0234	152.7188
Module start 'layout'	0.0102	0.0059	743.7422	39.5859
Module start 'content'	0.0161	0.6842	783.3281	525.2344
Module end 'content'	0.7003	0.0012	1,308.5625	16.0156
Script end	0.7016		1,324.5781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.4901	16	0.0002
Check MTime	0.0012	0.1781	16	0.0001
Mysql Total
Database connection	0.0015	0.2193	1	0.0015
Mysqli_queries	0.6304	89.8468	52	0.0121
Looping result	0.0006	0.0793	50	0.0000
Template Total	0.6597	94.0	2	0.3299
Template load	0.0019	0.2679	2	0.0009
Template processing	0.6578	93.7581	2	0.3289
Template load and register function	0.0001	0.0194	1	0.0001
states
state_id_array	0.0011	0.1521	1	0.0011
state_identifier_array	0.0017	0.2397	2	0.0008
Override
Cache load	0.0018	0.2574	113	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0008	0.1174	1	0.0008
Fetch class attribute name	0.0011	0.1546	3	0.0004
XML
Image XML parsing	0.0006	0.0818	1	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0013	4	0.0000
General
dbfile	0.0009	0.1258	18	0.0000
String conversion	0.0000	0.0019	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
7	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 22 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs