[quote]If you’re using unix() then you don’t need to turn on tcpip = true in postgresql.conf, though I say that just for informational purposes rather than anything else. 
Do you have the following RPMs installed:
php
php-gd
php-pear
php-pgsql
I’m just wondering if your CLI binary has PgSQL support, but the Apache mod_php4 doesn’t (i.e. the php-pgsql RPM is not installed).
[right][post=“7206”]<{POST_SNAPBACK}>[/post][/right][/quote]
Ok one step further i didnt have php-pgsql installed. Also i thought php-gd and pear were rolled into php? I think i read that somewhere.
The response is much quicker now, but still an error.
Fatal error: Call to undefined function: quotesmart() in /var/www/html/sauce/core/include/asset_manager.inc on line 5582
Install ok DB ERROR
[quote]Fatal error: Call to undefined function: quotesmart() in /var/www/html/sauce/core/include/asset_manager.inc on line 5582[right][post=“7217”]<{POST_SNAPBACK}>[/post][/right][/quote]Sounds like PEAR isn’t set up correctly, DB_pgsql::quoteSmart() is in PEAR::DB.
On RHEL3, you need to install php-pear and php-gd for that functionality. You will then need to upgrade the PEAR DB module for the RPM package.
[quote]On RHEL3, you need to install php-pear and php-gd for that functionality. You will then need to upgrade the PEAR DB module for the RPM package.
[right][post=“7219”]<{POST_SNAPBACK}>[/post][/right][/quote]
Checked on redhat network, no such package as php-pear or php-gd, i have a package called gd installed.
[quote]Sounds like PEAR isn’t set up correctly, DB_pgsql::quoteSmart() is in PEAR::DB.
[right][post=“7218”]<{POST_SNAPBACK}>[/post][/right][/quote]
Actually, it’s likely that RHEL3’s php-pear package has an outdated version of the PEAR packages (in particular PEAR::DB) - DB::quoteSmart() only came in with version 1.6.0RC1 of PEAR::DB which was released after RHEL3 was (as far as I know). So you may need to upgrade your PEAR::DB version to the latest version.
(You’re probably better listening to Avi than me though; it’s likely there’s an update on RHN or something but if you have a vanilla version of RHEL3, then PEAR::DB will be out-of-date.)
[quote]Actually, it’s likely that RHEL3’s php-pear package has an outdated version of the PEAR packages (in particular PEAR::DB) - DB::quoteSmart() only came in with version 1.6.0RC1 of PEAR::DB which was released after RHEL3 was (as far as I know). So you may need to upgrade your PEAR::DB version to the latest version.
(You’re probably better listening to Avi than me though; it’s likely there’s an update on RHN or something but if you have a vanilla version of RHEL3, then PEAR::DB will be out-of-date.)
[right][post=“7222”]<{POST_SNAPBACK}>[/post][/right][/quote]
Your right pear:DB was out of date, but i ran into this error previously and was forced to update during the install. So after that incident i made sure all pear packages were up to date.
Pear List (i just rolled back pear:db to preq on my souce matrix but it was the latest).
Installed packages:
===================
Package Version State
Archive_Tar 1.3.1 stable
Cache 1.5.5RC4 beta
Console_Getopt 1.2 stable
DB 1.6.2 stable
HTTP 1.3.6 stable
HTTP_Client 1.0.0 stable
HTTP_Request 1.2.4 stable
Mail 1.1.9 stable
Mail_Mime 1.3.1 stable
Net_SMTP 1.0 stable
Net_Socket 1.0.1 stable
PEAR 1.4.2 stable
XML_HTMLSax 2.1.2 stable
XML_Parser 1.2.7 stable
XML_RPC 1.0.4 stable
So I would have thought the DB extension was fine, seeing how it has overcome the intallation error.
Ok, just checked a RHEL3 box of mine, and you're right: There is no php-pear package. There is a php-pear package on RHEL4 though (which is what I'm running locally), hence the confusaion. Sorry about that.
[quote]Ok, just checked a RHEL3 box of mine, and you’re right: There is no php-pear package. There is a php-pear package on RHEL4 though (which is what I’m running locally), hence the confusaion. Sorry about that.
[right][post=“7224”]<{POST_SNAPBACK}>[/post][/right][/quote]
Yeah its ok, just remembered reading something about it a while ago.
So where to from here?
It shouldnt matter that i link php-cli in the /usr/bin ? Just made things easier that way.
[quote]Any chance we can get remote access to this server?
[right][post=“7227”]<{POST_SNAPBACK}>[/post][/right][/quote]
Fraid not, internel network only and the boys upstairs wont auth it 
[quote]Fraid not, internel network only and the boys upstairs wont auth it
[right][post=“7229”]<{POST_SNAPBACK}>[/post][/right][/quote]
I guess i could try updating my version of php? I think there is a slightly newer version available from redhat.
[quote]Fraid not, internel network only and the boys upstairs wont auth it
[right][post=“7229”]<{POST_SNAPBACK}>[/post][/right][/quote]
I’m at a loss here. Matrix loves all the RHEL3 and RHEL4 boxes I have it running on. I’ve never encountered anything like this problem. Is there anything interesting in the Apache error_log by any chance?
[quote]I’m at a loss here. Matrix loves all the RHEL3 and RHEL4 boxes I have it running on. I’ve never encountered anything like this problem. Is there anything interesting in the Apache error_log by any chance?
[right][post=“7235”]<{POST_SNAPBACK}>[/post][/right][/quote]
HP Fatal error: Call to undefined function: quotesmart() in /var/www/html/sauce/core/include/asset_manager.inc on line 5582
[Wed Oct 19 12:08:27 2005] [error] [client 192.168.25.30] File does not exist: /var/www/html/sauce/core/web/index.phpfavicon.ico
[Wed Oct 19 12:10:50 2005] [notice] caught SIGTERM, shutting down
[Wed Oct 19 12:13:09 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Oct 19 12:13:09 2005] [notice] Digest: generating secret for digest authentication …
[Wed Oct 19 12:13:09 2005] [notice] Digest: done
[Wed Oct 19 12:13:10 2005] [notice] Apache/2.0.46 (Red Hat) configured – resuming normal operations
PHP Fatal error: Call to undefined function: quotesmart() in /var/www/html/sauce/core/include/asset_manager.inc on line 5582
[Wed Oct 19 12:13:31 2005] [error] [client 192.168.25.30] File does not exist: /var/www/html/sauce/core/web/index.phpfavicon.ico
PHP Fatal error: Call to undefined function: quotesmart() in /var/www/html/sauce/core/include/asset_manager.inc on line 5582
[Wed Oct 19 13:52:44 2005] [error] [client 192.168.25.30] File does not exist: /var/www/html/sauce/core/web/index.phpfavicon.ico
[Wed Oct 19 14:31:41 2005] [warn] child process 2076 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2077 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2078 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2079 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2080 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2081 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2082 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [warn] child process 2083 still did not exit, sending a SIGTERM
[Wed Oct 19 14:31:41 2005] [notice] caught SIGTERM, shutting down
[Wed Oct 19 14:34:35 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Oct 19 14:34:35 2005] [notice] Digest: generating secret for digest authentication …
[Wed Oct 19 14:34:35 2005] [notice] Digest: done
[Wed Oct 19 14:34:36 2005] [notice] Apache/2.0.46 (Red Hat) configured – resuming normal operations
PHP Warning: fopen(/var/www/html/sauce/data/private/logs/error.log): failed to open stream: Permission denied in /var/www/html/sauce/core/include/general.inc on line 798
PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/sauce/core/include/general.inc on line 799
PHP Warning: Error occurred [SYS0051] in /var/www/html/sauce/core/include/general.inc on line 891
[Wed Oct 19 14:36:44 2005] [error] [client 192.168.25.30] File does not exist: /var/www/html/sauce/core/web/index.phpfavicon.ico
PHP Warning: fopen(/var/www/html/sauce/data/private/logs/error.log): failed to open stream: Permission denied in /var/www/html/sauce/core/include/general.inc on line 798
PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/sauce/core/include/general.inc on line 799
PHP Warning: Error occurred [SYS0051] in /var/www/html/sauce/core/include/general.inc on line 891
[Wed Oct 19 14:37:34 2005] [warn] child process 2078 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2079 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2080 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2081 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2082 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2083 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2084 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [warn] child process 2085 still did not exit, sending a SIGTERM
[Wed Oct 19 14:37:34 2005] [notice] caught SIGTERM, shutting down
[Wed Oct 19 14:37:36 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Oct 19 14:37:36 2005] [notice] Digest: generating secret for digest authentication …
[Wed Oct 19 14:37:36 2005] [notice] Digest: done
[Wed Oct 19 14:37:37 2005] [notice] Apache/2.0.46 (Red Hat) configured – resuming normal operations
PHP Warning: fopen(/var/www/html/sauce/data/private/logs/error.log): failed to open stream: Permission denied in /var/www/html/sauce/core/include/general.inc on line 798
PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/sauce/core/include/general.inc on line 799
PHP Warning: Error occurred [SYS0051] in /var/www/html/sauce/core/include/general.inc on line 891
[Wed Oct 19 14:38:40 2005] [error] [client 192.168.25.30] File does not exist: /var/www/html/sauce/core/web/index.phpfavicon.ico
[Wed Oct 19 14:38:47 2005] [warn] child process 2503 still did not exit, sending a SIGTERM
[Wed Oct 19 14:38:47 2005] [warn] child process 2504 still did not exit, sending a SIGTERM
[Wed Oct 19 14:38:47 2005] [warn] child process 2505 still did not exit, sending a SIGTERM
[Wed Oct 19 14:38:47 2005] [notice] caught SIGTERM, shutting down
[Wed Oct 19 14:38:49 2005] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Oct 19 14:38:49 2005] [notice] Digest: generating secret for digest authentication …
[Wed Oct 19 14:38:49 2005] [notice] Digest: done
[Wed Oct 19 14:38:50 2005] [notice] Apache/2.0.46 (Red Hat) configured – resuming normal operations
[Wed Oct 19 14:39:52 2005] [error] [client 192.168.25.30] File does not exist: /var/www/html/sauce/core/web/index.phpfavicon.ico
Just installed slightly newer php no good // no such db error again that doesnt bother me that will be the php - pgsql package.
When i install redhat i deselect everything except dev tools, web, and sql.
Then get the currently installed php source rebuild with config options from forum (remove openssl, fails for some reason)
Then sym link php.
Install postgresql.
initdb /usr/local/pgsql/data
Make a postgresql user, then createdb
createlang
Untar mysouce into /var/www/html/folder (grant open recursive permissions to eliminate permissions issues for now)
Change httpd.conf
default dir is /folder
Put Alias in the alias section, AccecptPathInfo On in global options.
change the pgb_hba, unrem local and host. remove loopback ip and mask.
Then followed other forum on Install. using step 1 -3.
Removed Indexs from tables.xml
Added pgsql://user@unix()/db_name
URL = XXX.XXX.XX.XXX
Open browswer and no good.
PHP Fatal error: Call to undefined function: quotesmart()
That's your problem right there. What version of PEAR:DB are you using? It should be at least 1.6.4 (i think 1.6.2 was the last version without quotesmart), but DB's now up to 1.7.x so that'll work fine.
[quote]PHP Fatal error: Call to undefined function: quotesmart()
That’s your problem right there. What version of PEAR:DB are you using? It should be at least 1.6.4 (i think 1.6.2 was the last version without quotesmart), but DB’s now up to 1.7.x so that’ll work fine.
[right][post=“7244”]<{POST_SNAPBACK}>[/post][/right][/quote]
running latest version 1.7 something, Will pear still work even though it was compiled from source?
[quote]running latest version 1.7 something, Will pear still work even though it was compiled from source?
[right][post=“7245”]<{POST_SNAPBACK}>[/post][/right][/quote]
Alrighty people new error, i found that the pear shared files were conflicting e.g. usr/share/pear has pear files and /usr/local/php-cli/lib/php had pear share files and when i added news ones they went into one dir and not the other the whole thing was a bit fidgety.
Now the page takes a while to load and displays this…
MySource Error
[ASSERT EXCEPTION] DB Error: unknown error
SELECT DISTINCT(l.majorid), a.type_code, t.treeid FROM sq_ast_lnk l INNER JOIN sq_ast_lnk_tree t ON l.linkid = t.linkid INNER JOIN sq_ast a ON l.majorid = a.assetid WHERE t.treeid IN ( SELECT * FROM sq_get_parent_treeids(‘7’, 4) ) AND a.type_code IN ( SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code IN (‘user’, ‘user_group’) ) ORDER BY t.treeid [nativecode=ERROR: Function array_upper(bytea[], integer) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts] (LINE 2424 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]
Any clues?
D'oh! You're going to virtually hit me over this one. I completely forgot about this:
Matrix v3.6 requires PostgreSQL 7.4 or higher (due to some of the requirements of the new rollback stored procedures). You'll either need to upgrade the PostgreSQL on RHEL3 or upgrade to RHEL4.
[quote]D’oh! You’re going to virtually hit me over this one. I completely forgot about this:
Matrix v3.6 requires PostgreSQL 7.4 or higher (due to some of the requirements of the new rollback stored procedures). You’ll either need to upgrade the PostgreSQL on RHEL3 or upgrade to RHEL4.
[right][post=“7249”]<{POST_SNAPBACK}>[/post][/right][/quote]
Ok it works i can get to /_admin but when i do all the little java bits dont seem to work e.g. workspace? And none of the images seem to load on login or past that?
Sounds like your System Root URL is not correct. Check to make sure that the URL you're using in the browser matches the entry in data/private/conf/main.inc.
[quote]Sounds like your System Root URL is not correct. Check to make sure that the URL you’re using in the browser matches the entry in data/private/conf/main.inc.
[right][post=“7274”]<{POST_SNAPBACK}>[/post][/right][/quote]
its just an ip. ‘192.168.25.153’
And that matches the one in main.inc?