Looks like you haven't configured the DSN2 and DSN3 settings in main.inc. Can you post the contents of your mysource_matrix/data/private/conf/main.inc file?
[quote]Looks like you haven’t configured the DSN2 and DSN3 settings in main.inc. Can you post the contents of your mysource_matrix/data/private/conf/main.inc file?
[right][post=“9216”]<{POST_SNAPBACK}>[/post][/right][/quote]
Thanks for the quick reply.
I only have one db connection method, so I duplicated it for the secondary.
I am replacing 3.6.2 with 3.8. That is to say, I installed 3.6.2 successfully, but didn't get much chance to play with it and only had some rudimentary pages created, so I'm completely replacing the installation rather than upgrading. I dropped the previous database and the users and started completely from scratch, with a new source directory, following the new installation instructions.
When I attempt step 02 I get
root# php install/step_02.php /Library/WebServer/mysource_matrix
+------------------------------------------------+
| MySource Error |
|------------------------------------------------|
| File : [SYSTEM_ROOT]/core/include/mysource.inc |
| Line : 1822 |
|------------------------------------------------|
| DB Error: extension not found |
+------------------------------------------------+
As I said, I had 3.6.2 installed fine, nothing in my system configuration has changed, and there don't appear to be any new requirements for 3.8 over 3.6.2. Where else should I be looking for problems?
I didn’t upgrade, but a security patch came through and it looks like the default php cli is, indeed, now 4.4.1 with no pgsql support. Fortunately, the older cli is still on my system (a custom compile so the updater didn’t see it, I guess). Using that seems to be working fine.
[quote]I didn’t upgrade, but a security patch came through and it looks like the default php cli is, indeed, now 4.4.1 with no pgsql support. Fortunately, the older cli is still on my system (a custom compile so the updater didn’t see it, I guess). Using that seems to be working fine.
[right][post=“9286”]<{POST_SNAPBACK}>[/post][/right][/quote]
No worries. We just did an upgrade on one of our MacOS X Server based clients and ran into the same problem.
I managed to get the DSN's entered in correctly, and the install proceeded without error.
I followed the apache alias'es and permissions instructions, however when I try to load the admin interface (…url _admin, correct?) I get the following errors:
I had a quick look through the manuals, but wasn't able to find advice on this issue - any advice greatly appreciated.
Kind Regards,
Andrew
[quote]MySource Warning
System asset name "public_user" not installed or not known [SYS0209]
PHP Warning
Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:174)
PHP Warning
Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:174)
MySource Warning
System asset name "root_folder" not installed or not known [SYS0209]
Doesn't look like the install finished properly: Did you run step_02.php and step_03.php? Those system assets should have been created during the step_03.php execution.
[quote]Doesn’t look like the install finished properly: Did you run step_02.php and step_03.php? Those system assets should have been created during the step_03.php execution.
[right][post=“9425”]<{POST_SNAPBACK}>[/post][/right][/quote]
Hi, I re-ran step 3 and noticed the following errors:
| '') [nativecode=ERROR: column "is_admin" of relation "sq_ast_attr" does not exist] (LINE 588 IN [SYSTEM_ROOT]core/include/asset_management.inc) [SYS0270] |
I would suggest dropping the database, deleting the mysource_matrix directory and starting again: You've got a completely confused installation. The filesystem believes the database is configured but the tables and columns have not been successfully created yet. There is no easy way to fix this except by starting again clean.
[quote]I would suggest dropping the database, deleting the mysource_matrix directory and starting again: You’ve got a completely confused installation. The filesystem believes the database is configured but the tables and columns have not been successfully created yet. There is no easy way to fix this except by starting again clean.
[right][post=“9441”]<{POST_SNAPBACK}>[/post][/right][/quote]
| Error text not found for this code and locale [SYS0270] |
| array ( |
| 0 => 'DB Error: unknown error |
| – creates a function that grants access to the secondary user. |
| – This function should be called after all the tables in the system |
| – have been created |
| CREATE OR REPLACE FUNCTION sq_grant_access(character varying) RETURNS TEXT AS \' |
| DECLARE |
| user_name ALIAS FOR $1; |
| table RECORD; |
| tablename TEXT; |
| BEGIN |
| FOR table IN SELECT c.relname AS name FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (\'\'r\'\',\'\'v\'\',\'\'S\'\',\'\'\'\') AND n.nspname NOT IN (\'\'pg_catalog\'\', \'\'pg_toast\'\') AND pg_catalog.pg_table_is_visible(c.oid) LOOP |
| tablename=table.name; |
| RAISE NOTICE \'\'tablename is %\'\', tablename; |
| EXECUTE \'\'GRANT ALL ON \'\' || quote_ident(tablename) || \'\' TO \'\' || quote_ident(user_name::text); |
Weird. I haven't seen that one in ages. Did you completely drop the database or just empty it? It feels like your sequences weren't erased, so it didn't start numbering at 1.
You're going to hate me for saying this, but the simplest fix is to drop the database, and erase the filesystem and start from a fresh tarball.
[quote]Weird. I haven’t seen that one in ages. Did you completely drop the database or just empty it? It feels like your sequences weren’t erased, so it didn’t start numbering at 1.
You’re going to hate me for saying this, but the simplest fix is to drop the database, and erase the filesystem and start from a fresh tarball.
I used “DROP DATABASE” to drop the database to start from scratch, then removed the old mysource_matrix directory, and unpacked from a fresh tarball. I’ll try again.
I am using a version of postgresql that is on the fringe of the requirements (it is within the version requirements, but just), could this be creating my problems?
[quote]I am using a version of postgresql that is on the fringe of the requirements (it is within the version requirements, but just), could this be creating my problems?
[right][post=“9528”]<{POST_SNAPBACK}>[/post][/right][/quote]
No, 7.4.7 should work (though its pretty slow). v8.1 is significantly faster.
