Calem Community Forum

General => Setup => Topic started by: harner on June 06, 2007, 10:53:33 am

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 06, 2007, 10:53:33 am

Hello, there!  My name is Chris and I am very interested in trying our CalemEAM!  I was wondering if this will benefit my needs...

What I have:
Dell server running OpenSUSE 10.1, Apache/PHP/MySQL/Webmin

What I'm looking for:
I want a Vendor Management System. Some kind of PHP web interface where I can store information about vendors on a MySQL back-end.

What I've played with:
DARWIN - hardly developed/not secure
CMMS - install fails/not supported
free-cmms - DB script fails/not supported
myCMMS - DB script fails/waiting for support
Postnuke - too much on the interface
phpwcms- unknown issue

What the company has now:
A Lotus Notes database with the information stored in there.

From what the demo shows, I think we could use it, but what do you think?

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 11:32:49 am

CalemEAM is a EAM/CMMS package. It includes vendor functions in purchase module. It's not clear if the vendor function would be sufficient for you. If the demo looks good to you the real system should work. The demo is the same release on SourceForge (r1.0.1x) that you can download.

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 06, 2007, 12:17:47 pm

Cool, I'm installing it now.  INSTALL.txt has one error -
http://www.calemeam/support_setup.html should be
http://www.calemeam.com/support_setup.html


Also, in step 2 I edited the env.sh file.  I'm doing an install on an OpenSUSE 10.1 box.

Code: [Select]

HOME_DIR=/usr/lib/apache2
PHP_EXE=/usr/bin/php5
CALEM_HOME=/srv/www/htdocs/calemeam
export CALEM_DIR=$CALEM_HOME/


By HOME_DIR, do you mean the main folder of Apache2?  The default is /opt/lamp, but I have the packages installed differently.

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 01:22:34 pm

Only PHP_EXE and CALEM_DIR are used, HOME_DIR are used as an interim holder if you happen to install everything under one root directory (like XAMPP). So you are fine with your configuration.

We will correct the typo in next release.

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 06, 2007, 01:57:14 pm

Okay sounds good.  I did run into one small problem.  When I run ./setup.sh, I get this:
Error in finding log4php.properties. Logging is not configured.

The log_errors option is enabled in php.ini and it does spit out a file if there are errors.  There are none yet.

I didn't see anything else listed about logging on http://www.calemeam.com/support_setup.html

I did restart the Apache server after the changes, as well.

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 02:15:47 pm

Your env.sh has .../htdocs/calemeam, unzip the application will install it under .../htdocs/CalemEAM. Check your path to ensure they match.

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 06, 2007, 02:24:19 pm

Please move this thread to Setup Issues.

Still getting this error:
chpas-map:/srv/www/htdocs/calemeam/bin # ./setup.sh
Error in finding log4php.properties. Logging is not configured.


I changed it back to CalemEAM and /srv/www/htdocs/CalemEAM

Same issue.

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 02:33:32 pm

We would have to dive a bit deeper to figure out what's wrong:
- edit CalemEAM/bin/logging/CalemLoggingSetupCmd.php
add the following after line 31 (define('LOG4PHP_CONF', 'etc/log4php.properties');)

echo "_CALEM_DIR_=" . _CALEM_DIR_  . ", log4php=" . LOG4PHP_CONF . "\n";
echo "is_file: " . is_file(_CALEM_DIR_ . LOG4PHP_CONF) . "\n";

Save the file and run setup.sh again.  We will see the above printout.

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 06, 2007, 02:38:38 pm

Code: [Select]

chpas-map:/srv/www/htdocs/calemeam/bin # ./setup.sh
_CALEM_DIR_=/srv/www/htdocs/, log4php=etc/log4php.properties
is_file:
Error in finding log4php.properties. Logging is not configured.


Shouldnt the calem dir be saying it is in /srv/www/htdocs/CalemEAM?

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 02:40:47 pm

You're right, _CALEM_DIR_ should be /srv/www/htdocs/CalemEAM

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 02:42:28 pm

correction: _CALEM_DIR_ should be /srv/www/htdocs/CalemEAM/
(with '/' at the end of the path)

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 06, 2007, 02:49:48 pm

Do I change that in env.sh?  If so, I changed it to:

Code: [Select]

HOME_DIR=/srv/www/htdocs/CalemEAM/
PHP_EXE=/usr/bin/php5
CALEM_HOME=/srv/www/htdocs/CalemEAM/
export CALEM_DIR=$CALEM_HOME/


And still get

Code: [Select]

chpas-map:/srv/www/htdocs/calemeam/bin # ./setup.sh
_CALEM_DIR_=/srv/www/htdocs/, log4php=etc/log4php.properties
is_file:
Error in finding log4php.properties. Logging is not configured.


Hmmm...!

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 06, 2007, 03:04:43 pm

env.sh looks good to me. We could add another line after line 31:
<code>
    echo "ENV['CALEM_DIR']=" . $_ENV['CALEM_DIR'] . "\n"
</code>

and look at the printout.

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 07, 2007, 06:02:00 am

Here is the printout:

Code: [Select]

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


Where do I set these fields to be correct?

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin on June 07, 2007, 06:23:50 am

Seems the export from env.sh is not passed to PHP. It's not clear why this is happening. We could do some research about it...I'll check if there's a path to get around it.

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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.

Title: Setup CalemEAM on OpenSUSE
Post by: harner 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!

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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_

Title: Setup CalemEAM on OpenSUSE
Post by: harner 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.


Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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.

Title: Setup CalemEAM on OpenSUSE
Post by: harner 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...

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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/).

Title: Setup CalemEAM on OpenSUSE
Post by: harner on June 08, 2007, 12:18:54 pm

Sent.  thank you.

Title: Setup CalemEAM on OpenSUSE
Post by: vimal 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

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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/

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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

Title: Setup CalemEAM on OpenSUSE
Post by: vimal 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

Title: Setup CalemEAM on OpenSUSE
Post by: calemadmin 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).