Setup CalemEAM on OpenSUSE

[calemadmin]

There's a workaround by editing setup.sh.

Code: [Select]


#!/bin/bash

. env.sh
$PHP_EXE logging/CalemLoggingSetupCmd.php


Change to:

Code: [Select]


#!/bin/bash

. env.sh
cd logging
$PHP_EXE CalemLoggingSetupCmd.php

This will make setup.sh to work without CALEM_DIR being set.

[harner]

I tried what you asked and it couldn't open the input file for whatever reason.  I changed the permissions of CalemLoggingSetupCmd.php to see if it would work but it did not.  Then I tried just executing the logging setup PHP file.

Code: [Select]

chpas-map:/srv/www/htdocs/CalemEAM/bin # ./setup.sh
Could not open input file: logging/CalemLoggingSetupCmd.php
chpas-map:/srv/www/htdocs/CalemEAM/bin # php5 logging/CalemLoggingSetupCmd.php
ENV['CALEM_DIR']=
_CALEM_DIR_=/srv/www/htdocs/, log4php=etc/log4php.properties
is_file:
Error in finding log4php.properties. Logging is not configured.

No luck, yet!

[calemadmin]

Let's fix _CALEM_DIR_ by a change in CalemLoggingSetupCmd.php

Code: [Select]


chdir('../..');

(line 23) change to:

Code: [Select]


chdir('..')


This should fix the _CALEM_DIR_

[harner]

Is this it?

Code: [Select]

chpas-map:/srv/www/htdocs/CalemEAM/bin # ./setup.sh
Could not open input file: logging/CalemLoggingSetupCmd.php
chpas-map:/srv/www/htdocs/CalemEAM/bin # php5 logging/CalemLoggingSetupCmd.php
ENV['CALEM_DIR']=
_CALEM_DIR_=/srv/www/htdocs/CalemEAM/, log4php=etc/log4php.properties
is_file: 1
Logging is already configured.


[calemadmin]

Yes, the setup.sh ran correctly.
You may need to repeat that for other php files you are going to run. I know it's a pain...but I don't know why the environment variable is not picked up in your setup (OpenSuse). I haven't found any similar errors from googling. Maybe someone on this forum else has an insight on this issue.

[harner]

Okay, so I'm attempting the MySQL install scripts...  I know I'm becoming a pain!

Here is the output for createSchema.sh

Code: [Select]

chpas-map:/srv/www/htdocs/CalemEAM/bin/database # ./createSchema.sh
June 8, 2007, 9:53:36 am - Schema created!<br>chpas-map:/srv/www/htdocs/CalemEA

loadInitData.sh

Code: [Select]

chpas-map:/srv/www/htdocs/CalemEAM/bin/database # ./loadInitData.sh
June 8, 2007, 9:54:02 am - Loading init data...<br>PHP Fatal error:  Uncaught exception 'PDOException' with message 'There is no active transaction' in /srv/www/htdocs/CalemEAM/server/include/core/database/CalemPdo.php:201
Stack trace:
#0 /srv/www/htdocs/CalemEAM/server/include/core/database/CalemPdo.php(201): PDO->rollBack()
#1 /srv/www/htdocs/CalemEAM/server/setup/CalemDataLoader.php(111): CalemPdo->rollback()
#2 /srv/www/htdocs/CalemEAM/server/setup/CalemDataLoader.php(140): CalemDataLoader->updateRecord(Object(CalemTableDd), Array)
#3 /srv/www/htdocs/CalemEAM/server/setup/CalemDataLoader.php(176): CalemDataLoader->loadFile(Object(CalemTableDd), '/srv/www/htdocs...')
#4 /srv/www/htdocs/CalemEAM/server/setup/LoadInitDataCmd.php(52): CalemDataLoader->load(Object(CalemDataLoadConf))
#5 {main}
  thrown in /srv/www/htdocs/CalemEAM/server/include/core/database/CalemPdo.php on line 201


loadSampleData.sh

Code: [Select]

chpas-map:/srv/www/htdocs/CalemEAM/bin/database # ./loadSampleData.sh
June 8, 2007, 9:55:21 am - Loading sample data...<br>PHP Fatal error:  Uncaught exception 'PDOException' with message 'There is no active transaction' in /srv/www/htdocs/CalemEAM/server/include/core/database/CalemPdo.php:201
Stack trace:
#0 /srv/www/htdocs/CalemEAM/server/include/core/database/CalemPdo.php(201): PDO->rollBack()
#1 /srv/www/htdocs/CalemEAM/server/setup/CalemDataLoader.php(111): CalemPdo->rollback()
#2 /srv/www/htdocs/CalemEAM/server/setup/CalemDataLoader.php(140): CalemDataLoader->updateRecord(Object(CalemTableDd), Array)
#3 /srv/www/htdocs/CalemEAM/server/setup/CalemDataLoader.php(176): CalemDataLoader->loadFile(Object(CalemTableDd), '/srv/www/htdocs...')
#4 /srv/www/htdocs/CalemEAM/server/setup/LoadSampleDataCmd.php(52): CalemDataLoader->load(Object(CalemDataLoadConf))
#5 {main}
  thrown in /srv/www/htdocs/CalemEAM/server/include/core/database/CalemPdo.php on line 201


loadInit and loadSample look a little off...

[calemadmin]

Congrats for getting schema created, we are much closer than yesterday.
Both data loading scripts failed. We would like to get the logs from you if it's okay (send the logs to forum.admin@calemeam.com). The logs should include:
- php log
- calem log (CalemEAM/logs/).

[harner]

Sent.  thank you.

[vimal]

hi I have installed calemEAM on a Ubuntu server 6.06, have been able to successfully install calemeam and its dependancies. But on loading the initial data (loadInitData.sh) I am getting the following error.

Code: [Select]


root@ciappsrv:/var/www/CalemEAM/bin/database# ./loadInitData.sh
June 30, 2007, 5:54:44 am - Loading init data...<br>

Fatal error: Uncaught exception 'PDOException' with message 'There is no active transaction' in /var/www/CalemEAM/server/include/core/database/CalemPdo.php:201
Stack trace:
#0 /var/www/CalemEAM/server/include/core/database/CalemPdo.php(201): PDO->rollBack()
#1 /var/www/CalemEAM/server/setup/CalemDataLoader.php(111): CalemPdo->rollback()
#2 /var/www/CalemEAM/server/setup/CalemDataLoader.php(140): CalemDataLoader->updateRecord(Object(CalemTableDd), Array)
#3 /var/www/CalemEAM/server/setup/CalemDataLoader.php(176): CalemDataLoader->loadFile(Object(CalemTableDd), '/var/www/CalemE...')
#4 /var/www/CalemEAM/server/setup/LoadInitDataCmd.php(52): CalemDataLoader->load(Object(CalemDataLoadConf))
#5 {main}
  thrown in /var/www/CalemEAM/server/include/core/database/CalemPdo.php on line 201


Can you help me out
Regards
Vimal

[calemadmin]

We have not tried on Ubuntu yet. CalemEAM uses PDO to access database. The error seems related to PDO support on Ubuntu. The following is a link about configuring PDO on Ubuntu. How did you set up the PDO?

http://bhiv.com/getting-pdo-to-work-with-ubuntus-606-lts-dapper-drake/

[calemadmin]

BindValue is used when loading data to MySQL.  There's a known problem with PDO bindValue/bindParam in Ubuntu. Take a look and see if this link helps.

http://pecl.php.net/bugs/bug.php?id=9958&edit=1

[vimal]

Thanks for hte help, As for installing PDO, I had exactly followed the steps given on http://bhiv.com/getting-pdo-to-work-with-ubuntus-606-lts-dapper-drake/. If pdo & ubuntu do have a bug/problem which distribution of linux would you suggest.


Regards
Vimal

[calemadmin]

We have installed on Fedora 6 with XAMPP. The installation seems straight forward (as in http://www.calemeam.com/support_setup.html).