>Can you ensure that Apache can write to the /path/to/matrix/cache directory? It >sounds like Apache isn't writing out the PHP session files properly.
It is OK. I see sess_ files in there at current time.
> check /path/to/matrix/data/private/logs/error.log for any obvious errors that
This is all I get there when I attempt a login.
[2006-07-26 16:46:51][7:Public User][1024:mysource notice][R] (/core/include/mysource.inc:402) - URL "shylock.ham.niwa.co.nz/favicon.ico" not found [SYS0218]
Usually the Login Key Error is due to Apache not being able to read/write from the PHP session files, or if the System Root URL is misconfigured (i.e. you've configured one FQDN but use another to try and access the Administration Interface). I'm not sure what else to recommend at this point.
[quote]Usually the Login Key Error is due to Apache not being able to read/write from the PHP session files, or if the System Root URL is misconfigured (i.e. you’ve configured one FQDN but use another to try and access the Administration Interface). I’m not sure what else to recommend at this point.
[right][post=“11162”]<{POST_SNAPBACK}>[/post][/right][/quote]
I’m quite stuck then! I Hope you can help further. Here’s some info which I think shows things are set as you describe:
ls -l /home/websites/mysource_matrix | grep -E "cache|data"
drwxrwxr-x 3 wwwrun www 8952 Jul 27 18:33 cache
drwxrwxr-x 7 wwwrun www 240 Jul 25 14:21 data
Dirs below those have the same permissions. Even if I set chmod 777 on those directories the same result.
ps -eF | grep httpd
root 18184 1 0 2855 6380 0 18:21 ? 00:00:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 18185 18184 0 4358 12668 0 18:21 ? 00:00:01 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 18186 18184 0 4362 12688 0 18:21 ? 00:00:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
apache2 seems to be running as wwwrun (as expected). I don't know why one thread is as root - I'm not familiar with apache.
My main.inc relevant lines:
define('SQ_CONF_DB_DSN', 'pgsql://matrix@shylock.ham.niwa.co.nz()/mysource_matrix');
define('SQ_CONF_DB2_DSN', 'pgsql://matrix@shylock.ham.niwa.co.nz()/mysource_matrix');
define('SQ_CONF_DB3_DSN', 'pgsql://matrix_secondary@shylock.ham.niwa.co.nz()/mysource_matrix');
define('SQ_CONF_SYSTEM_ROOT_URLS', 'shylock.ham.niwa.co.nz');
I do get the login prompt so I guess it's connecting to the DB OK.
Could it be a postgres issue?
ps -eF | grep postgres
postgres 6059 1 0 4716 2520 0 Jul26 ? 00:00:01 /usr/bin/postmaster -D /home/postgres
postgres 6060 6059 0 2416 2308 0 Jul26 ? 00:00:00 postgres: stats buffer process
postgres 6062 6060 0 2168 2356 0 Jul26 ? 00:00:00 postgres: stats collector process
Error log on a failed attempt seems quite specific.
[7:Public User][1024:mysource notice][R] (/core/include/mysource.inc:402) - URL "shylock.ham.niwa.co.nz/favicon.ico" not found [SYS0218]
The specified file does not exist on the disk.
find / -name favicon.ico
returns nothing.
[quote]Usually the Login Key Error is due to Apache not being able to read/write from the PHP session files, or if the System Root URL is misconfigured (i.e. you’ve configured one FQDN but use another to try and access the Administration Interface). I’m not sure what else to recommend at this point.
[right][post=“11162”]<{POST_SNAPBACK}>[/post][/right][/quote]
I have also tried other resolvable names for the same box in the main.inc and matched on the browser URL. Same issue.
(favicon.ico is a spurious error – its the browser trying to find that "Favourites" icon for the site and failing. It is not related to the login key error at all).
Is there any way to get remote access to this server? I can't think of anything else to suggest so I wanted to have a poke around to see if something else obvious jumped out at me.
[quote]Is there any way to get remote access to this server? I can’t think of anything else to suggest so I wanted to have a poke around to see if something else obvious jumped out at me.
[right][post=“11171”]<{POST_SNAPBACK}>[/post][/right][/quote]
Sure. Two ways. I have it as a vmware virtual machine (It’s currently 5.1 GB when tar/zipped) I could probably reduce it by a couple of GB at least. Our bandwidth would handle that.
Remote access - I would have to know the IP address your system would access it from then get a couple of our firewalls set to NAT translate & allow ssh & web traffic.
Let me know which you decide is best for you.
My phone number is XXX
Let me know your’s and I can give you a call.
(Edited to remove the phone number from a Google-indexed forum! <grin>)
Drop the VMware image onto a DVD and post it to me. I’ll take a look at it when it gets here. 
The postal address for the Melbourne office (which is where I am) can be found here: http://www.squiz.net/contact_squiz
Otherwise, you’d need to log a support request for me to take a look at the live system.