Author Topic: Install hanging at "There is no active transaction"  (Read 6026 times)

fred

  • Newbie
  • *
  • Posts: 8
Install hanging at "There is no active transaction"
« on: April 05, 2009, 09:27:13 am »
I am running CentOS 5.3 (a respin for Red Hat Enterprise Linux). I am using MySQL 5.0.45 with Innodb tables enabled. I have made the file access rights changes as detailed in the instruction from Calem (well except for the one error - changed that from chown to chmod).

During install the script reports that it cannot verify the database and the file access rights and gives me two yellow splats beside those entries (I assume that means caution).

I have to manually create the user and database for CalemEAM versus using the Express script because it chokes on the user/password combination.

Once that is done, I use the Custom setup and the tables are created. All the tables are created properly. It appears that when the sample data is loaded an error is thrown with the "There is no active transaction" hint.

Here are the last few entries in the log:
2009-04-05 08:18:29,216 DEBUG CalemPdo - Transaction committed by CalemDbo.update@384
2009-04-05 08:18:29,216 DEBUG CalemAclGroupDbo - Reload cache for acl_group
2009-04-05 08:18:29,216 DEBUG CalemPDOStatement - Query time:0.0003, the query=select * from acl_group, params=NULL
2009-04-05 08:18:29,216 DEBUG CalemPdo - Rollback called by CalemDataLoader.updateRecord@111 , transaction stack=
2009-04-05 08:18:29,216 ERROR installation - Error at CalemInstDbSetupController.validateInput: There is no active transaction


fred

  • Newbie
  • *
  • Posts: 8
Re: Install hanging at "There is no active transaction"
« Reply #1 on: April 06, 2009, 10:43:53 pm »
I should have added that the PHP version is 5.1.6.

fred

  • Newbie
  • *
  • Posts: 8
Re: Install hanging at "There is no active transaction"
« Reply #2 on: April 12, 2009, 06:42:39 pm »
Well, after a long and fruitless search for a solution for this issue, I have switched over to the Ubuntu Server 8.10. Installation was nearly a breeze. Calem was unable to examine the MySQL and the PHP PDO pieces, but installation carried on.

So my surprise is that this program is marketed as Enterprise Asset Management, but when run under an enterprise class operating system, it choked. CentOS follows the Red Hat lineage and should be a slam dunk to install there. Are others able to install and run and under CentOS?

Fraal

  • Newbie
  • *
  • Posts: 1
Re: Install hanging at "There is no active transaction"
« Reply #3 on: September 30, 2009, 06:10:42 pm »
I had the exact same problem with my installation, what seems to work (for CentOS 5) is to install the latest version of PHP 5.2 from the CentOS testing repository.

Cheers,
Damian