Is there an easy 'how to' to set those environment variables and make them available for php cli?
That indicates that the php cli is compiled with oracle support. You need to insure the user that the squiz server is running as has the correct oracle enviromental variables setup to conect to oracle. These will include, but is not limited to:
ORACLE_HOME
ORACLE_SIDyou can see if these are setup by issuing a 'env' command to see what environmental vairables are set up.
To see what env vars are available to php you can issue:
php -r 'phpinfo();' | less
and scroll down the section that states the current env vars set.
The best way to test this is to create a little php script that you can run as the user that is used to run the squiz server (or cron jobs) to determine if you environment is setup properly.
something like:
<?php
require_once 'DB.php';
$dsn = 'oci8://scott:tiger@matrix';
$db = DB::connect($dsn);
if (DB::isError($db)) {
trigger_error('could not connect to the db :'.$db->getMessage());
exit;
}
$tables = $db->getCol('select table_name from user_tables');
if (DB::isError($tables)) {
trigger_error('could not get tables :'.$tables->getMessage());
exit;
}
print_r($tables);
?></pre><br />
Once you can asertain that you environment is setup correctly, you should be able to successfully run the squiz server and cron jobs.
[quote]That suggests to me that your CLI version of PHP can’t connect to Oracle. You’ll need to ensure that the user that Squiz Server can connect to Oracle properly via PHP.
[right][post=“6896”]<{POST_SNAPBACK}>[/post][/right][/quote]
Spot on thanks - we added the appropriate environment variables and are up and running.
Sarah
[quote]Spot on thanks - we added the appropriate environment variables and are up and running.
[right][post=“6918”]<{POST_SNAPBACK}>[/post][/right][/quote]
Glad to hear it. 
We had similar issues with an Oracle install here on Solaris, where the Squiz Server user wasn’t getting the correct profile on startup. It was an annoying thing to troubleshoot.
Or perhaps this…
php -i | less
we are now getting the same messages as the original post in this thread. it's only happening to random assets from what i can tell. any ideas?
You need to contact Squiz Support for assistance with the Squiz Server. The message in the original post should only happen if Matrix can't connect to running Squiz Server, which suggests that either your Squiz Server has stopped for some reason, or the configuration is incorrect. It really shouldn't be happening randomly at all.