Author Topic: Setup CalemEAM on OpenSUSE  (Read 19811 times)

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #15 on: June 07, 2007, 06:33:52 am »
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.
Calem Community Forum Admin

harner

  • Newbie
  • *
  • Posts: 12
Setup CalemEAM on OpenSUSE
« Reply #16 on: June 07, 2007, 08:33:21 am »
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

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #17 on: June 07, 2007, 09:50:27 am »
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_
Calem Community Forum Admin

harner

  • Newbie
  • *
  • Posts: 12
Setup CalemEAM on OpenSUSE
« Reply #18 on: June 07, 2007, 11:29:24 am »
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

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #19 on: June 07, 2007, 12:18:05 pm »
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.
Calem Community Forum Admin

harner

  • Newbie
  • *
  • Posts: 12
Setup CalemEAM on OpenSUSE
« Reply #20 on: June 08, 2007, 07:58:38 am »
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

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #21 on: June 08, 2007, 09:59:53 am »
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/).
Calem Community Forum Admin

harner

  • Newbie
  • *
  • Posts: 12
Setup CalemEAM on OpenSUSE
« Reply #22 on: June 08, 2007, 12:18:54 pm »
Sent.  thank you.

vimal

  • Newbie
  • *
  • Posts: 2
Setup CalemEAM on OpenSUSE
« Reply #23 on: June 30, 2007, 12:16:58 am »
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

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #24 on: July 03, 2007, 08:59:28 am »
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/
Calem Community Forum Admin

calemadmin

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #25 on: July 03, 2007, 02:59:06 pm »
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
Calem Community Forum Admin

vimal

  • Newbie
  • *
  • Posts: 2
Setup CalemEAM on OpenSUSE
« Reply #26 on: July 04, 2007, 04:15:09 am »
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

  • Administrator
  • Calem Hero
  • *****
  • Posts: 300
    • http://www.calemeam.com
Setup CalemEAM on OpenSUSE
« Reply #27 on: July 04, 2007, 08:58:46 am »
We have installed on Fedora 6 with XAMPP. The installation seems straight forward (as in http://www.calemeam.com/support_setup.html).
Calem Community Forum Admin