I tried to install mysource couple of times.
Everytime i got error on step 10. "DB Error: unknown error".
I followed the instruction and created db name mysource first, i can connect the db from phppgadmin.
I am running win2k/Apache/2.0.52/PHP5.0.3/PostgresSQL 8.0.0 with all the PHP modules.
Please hlep.
Thanx
You can't run MySource Matrix on PHP5. You need to downgrade to PHP 4.3.
Can you make sure to turn the debug level to high in step 4? That should give you some more info about the db error.
I setup the debug as High but the error msg is the same "DB Error: unknown error"
Is that a must for downgrade PHP to 4.X in order to setup Mysource?
Yes. Matrix will not work on PHP5.
Even i used PHP 4.3.8, i still got the same error msg.
Please help
Have you enabled PostgreSQL support in PHP? Have you installed the PEAR modules for PHP?
Yes, i can use phppgadmin which is PHP prog. and i installed all the modules.
Can you check the MatrixRoot/data/private/logs/error.log file? It should give you some more info about what's causing the error.
There are no log file at all.
I too am having the same problem as this person. Same error, php4 and log error log. I've been trying to install this program for the last day. My personal opinion would be that there be a non-wizard install for us users that like to see whats going on. I don't want to offend anyone by that comment and appreciate the work you all put into the project.
I'd appreciate any help with this issue.
Note. This is on step 10 and if I check the "Empty database" checkbox the it procedes to the next step, but issues some warnings:
Expected to find sequences, found none.
Expected to find tables, found none.
I'm thinking this is just because it's trying delete the tables and sequences.
The only other way of installing Matrix is by using the CLI-based installer. You will need to reset all of your existing installation to use it though.
I am so disappoint about all this setup procedure. I even tried with FC3, the same problem at step 10 through the web installer.
I tried to find out why i can not connect to DB.
Compare MySQL, PostgreSQL has so litter help resource on the internet, i can see so many people have the same simple question like i had. But not many help over there. I think that is why Postgresql is not popular as MYSQL.
FC3 setup Postgresql into different dir then /val/local/pgsql.
I can not get the log file for the postgresql, is anybody know, so i can track the problem.
I am very like mysource matrix, that is why i tried to set it up in different OS, but none of them can pass the step 10, PLease help!!!
I am confused with php-cli things, why we must use it to setup?
Please somebody give the simple instruction to go through this.
Is that really difficut to give us the simple instructions?
EX:
if you got ERROR msg:
DB Error: connect failed when connecting to database.
Could not get database handler for dsn pgsql://postgres:@unix()/intranet
then you should do…
or whatever…
please help!
Is there anyway to reset the installation other than deleting and untaring the files?
I'm afraid not. You'll also have to drop and recreate your database.
On my Debian install which hosts both MySource and Pgsql, I’ve used: ‘localhost’ instead of the recommended ‘unix()’ and it works like a charm.
Edited: Ignore the above, ‘localhost’ works only if Pgsql is listening on tcp/ip which is disabled by default on FC (cf. Known Issues with Installation). Sorry.
Alrighty. I was running through the CLI install and felt a little better that I could see what was going on but still got the same error.
on php4 install/step_03.php .
I'm getting the following:
--------------------------+
| MySource Error |
|------------------------------------------------------------------------------------------------------------------------------------------|
| [ASSERT EXCEPTION] DB Error: no such table |
| SELECT type_code, version, name, instantiable, allowed_access, parent_type, dir, customisation |
| FROM sq_ast_typ [nativecode=ERROR: relation "sq_ast_typ" does not exist] (LINE 110 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) |
±-----------------------------------------------------------------------------------------------------------------------------------------+
genghis:/opt/usr/mysource# 2005-04-18 15:12:51 [23394] LOG: connection received: host=[local] port=
2005-04-18 15:12:51 [23394] LOG: connection authorized: user=mysource database=mysource_wis
2005-04-18 15:12:51 [23394] ERROR: relation "sq_ast_typ" does not exist
Anyone seen this issue? Or know why sq_ast_typ wasn't created. I've grepped for it but can't find anything.
Did you remove the files in the data/private/db directory when you cleaned your install up? If there were files from a previous install in there (which represent cached tables, sequences and so on), it would not have created any tables in the new database, and would have said so in step 2.
Ok,
I think i figured out what was going on.
After trying to install step 2 the script would respond back that I needed to run the createlang for plsql(sp?).
After running the createlang on the database, I reran step 2 without errors. However running step 3 would gives me the error:
--------------------------+
| MySource Error |
|------------------------------------------------------------------------------------------------------------------------------------------|
| [ASSERT EXCEPTION] DB Error: no such table |
| SELECT type_code, version, name, instantiable, allowed_access, parent_type, dir, customisation |
| FROM sq_ast_typ [nativecode=ERROR: relation "sq_ast_typ" does not exist] (LINE 110 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) |
±-----------------------------------------------------------------------------------------------------------------------------------------+
genghis:/opt/usr/mysource# 2005-04-18 15:12:51 [23394] LOG: connection received: host=[local] port=
2005-04-18 15:12:51 [23394] LOG: connection authorized: user=mysource database=mysource_wis
2005-04-18 15:12:51 [23394] ERROR: relation "sq_ast_typ" does not exist
It seems if you don't createlang before running step 2 then it's not going to work. Perhaps step 1 or 2 should check for the plpgsql language or prompt the user to create it before step 2???