when I run the install_db.php with : php install_db.php on the command line I recived this:
Error: Could not install database: Could not drop the created database after unsuccessful creation attempt: ERROR: DROP DATABASE: database "psa_db" is being accessed by other users
Creation error: could not initialize the table "psa_profiles" (ERROR: relation named "id" already exists
) and then could not drop the table (ERROR: current transaction is aborted, queries ignored until end of transaction block
)
I tried creating before the database but I recived this error:
Error: Could not install database: ERROR: CREATE DATABASE: database "securitydb" already exists
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For instlaling the database, first you have to edit the confi.php file to include your database server login details.
Then you have to edit the xml schema file to have the correct database name. (Default is psa_db)
You also have to have database creation rights on the server that you want to install the databse. Do not create the database namually unless you set the <create>1</create> to <create>0</create> in the xml schema file so metabase doesn't try to create the database.
If this doesn't help, then more infromation will be needed...
What DB server (MySQL, PostgreSQL, MS SQL, etc.)?
What OS is the DB server?
What OS is the web server?
What version of PHP?
What version of DB server?
What web server are you using (Apache, IIS, etc.)?
What version of the web server?
Maybe a few others as well depending on where that gets us.
Justin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-05-23
I'm working with postgresql 7.3.2, Apache 2 and PHP 4.2.2 on Red Hat Linux 9.
I've probed following your suggestions and it's the same, with Postgresql. But I tried with Mysql 3.23.54 and It works correctly. The problem is that I need it working with postgresql. have you proved it with any postgresql version?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't have any postgresql servers to test on, but my understanding is that as long as Metabase handles it, the database shouldn't matter. I know I have successfully installed it on an MS SQL server, and development is done with MySQL. I'd be curious to know more about this when it is working. I'd suggest trying to update the postgre metabase driver fist to be sure that Metabase is working for you http://koivi.users.phpclasses.org/browse.html/package/20.html
Also be sure to check out the devel page for Metabase to see if there are updates or messages about PostgreSQL.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I hope anyone could help me.
when I run the install_db.php with : php install_db.php on the command line I recived this:
Error: Could not install database: Could not drop the created database after unsuccessful creation attempt: ERROR: DROP DATABASE: database "psa_db" is being accessed by other users
Creation error: could not initialize the table "psa_profiles" (ERROR: relation named "id" already exists
) and then could not drop the table (ERROR: current transaction is aborted, queries ignored until end of transaction block
)
I tried creating before the database but I recived this error:
Error: Could not install database: ERROR: CREATE DATABASE: database "securitydb" already exists
For instlaling the database, first you have to edit the confi.php file to include your database server login details.
Then you have to edit the xml schema file to have the correct database name. (Default is psa_db)
You also have to have database creation rights on the server that you want to install the databse. Do not create the database namually unless you set the <create>1</create> to <create>0</create> in the xml schema file so metabase doesn't try to create the database.
If this doesn't help, then more infromation will be needed...
What DB server (MySQL, PostgreSQL, MS SQL, etc.)?
What OS is the DB server?
What OS is the web server?
What version of PHP?
What version of DB server?
What web server are you using (Apache, IIS, etc.)?
What version of the web server?
Maybe a few others as well depending on where that gets us.
Justin
I'm working with postgresql 7.3.2, Apache 2 and PHP 4.2.2 on Red Hat Linux 9.
I've probed following your suggestions and it's the same, with Postgresql. But I tried with Mysql 3.23.54 and It works correctly. The problem is that I need it working with postgresql. have you proved it with any postgresql version?
I don't have any postgresql servers to test on, but my understanding is that as long as Metabase handles it, the database shouldn't matter. I know I have successfully installed it on an MS SQL server, and development is done with MySQL. I'd be curious to know more about this when it is working. I'd suggest trying to update the postgre metabase driver fist to be sure that Metabase is working for you http://koivi.users.phpclasses.org/browse.html/package/20.html
Also be sure to check out the devel page for Metabase to see if there are updates or messages about PostgreSQL.