Hello,
I am having trouble installing MySource Matrix on Ubuntu 10.04. In step 02 I have the following error
Fatal error: Uncaught exception 'DALException' with message 'SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sq_ast_typ" does not exist
LINE 2: FROM sq_ast_typ
^' in /home/ubuntu/mysource_matrix/core/lib/DAL/DAL.inc:658
I had previously completed all the steps in the installation, but got the following error when attempting to login to the webserver.
[2010-05-12 22:41:24][0:MySource System][256:mysource error][R] (/core/include/locale_manager.inc:504) - [ASSERT EXCEPTION] Asset "session_handler_default" is not installed on the system, unable to include its source file [SYS0320]
At that time, I followed the instructions to drop the database and start again, and this is where I am currently, stuck on Step02.
Basic Information:
POSTGRES IS SETUP WITH THE FOLLOWING
postgres=# \l
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------------+----------+----------+-------------+-------------+-----------------------
mysource_matrix | matrix | UTF8 | en_AU.UTF-8 | en_AU.UTF-8 |
postgres | postgres | UTF8 | en_AU.UTF-8 | en_AU.UTF-8 |
template0 | postgres | UTF8 | en_AU.UTF-8 | en_AU.UTF-8 | =c/postgres
: postgres=CTc/postgres
template1 | postgres | UTF8 | en_AU.UTF-8 | en_AU.UTF-8 | =c/postgres
: postgres=CTc/postgres
(4 rows)
postgres=# \du
List of roles
Role name | Attributes | Member of
------------------+-------------+-----------
matrix | | {}
matrix_secondary | | {}
postgres | Superuser | {}
: Create role
: Create DB
db.conf looks like this
<?php
$db_conf = array (
'db' => array (
'DSN' => 'pgsql:dbname=mysource_matrix',
'user' => 'matrix',
'password' => 'matrix',
'type' => 'pgsql',
),
'db2' => array (
'DSN' => 'pgsql:dbname=mysource_matrix',
'user' => 'matrix',
'password' => 'matrix',
'type' => 'pgsql',
),
'db3' => array (
'DSN' => 'pgsql:dbname=mysource_matrix',
'user' => 'matrix_secondary',
'password' => 'matrix',
'type' => 'pgsql',
),
'dbcache' => array (
'DSN' => 'pgsql:dbname=mysource_matrix',
'user' => 'matrix',
'password' => 'matrix',
'type' => 'pgsql',
),
'dbsearch' => NULL,
);
return $db_conf;
?>
I am not an expert with PEAR, and when running ‘pear install Net_URL’, it seems to download the tar file, but doesn’t come up in the ‘pear list’ list.??