Forum GLPI-Project

PeterWI

Member

Registered: 2008-12-09

Posts: 3

ocsng mode configuration for a newbie

we have ocs setup and running on myphpadmin. I am trying to setup glpi import config module and it keeps failing.  I tested connecting to the ocs mysql db from outside glpi, and had no issues.  any pointers?

MHI

Member

From: Germany

Registered: 2007-06-28

Posts: 367

Re: ocsng mode configuration for a newbie

Peter,

could you please give some more details on the setup. Is the OCS database on the same server as the GLPI one ? Which versions of OCS and GLPI are you using ? What are the errors you'll get when setting up the import in glpi ? (use glpi in debug mode) Which OS are you using ?

As soon as you have posted these kind of infomation, maybe someone is able to help you.

---

RedHat Enterprise Linux 5 ES 32Bit x86
PHP 5.1.6 -- Apache 2.2.3
MySQL 5.0.45  --  GLPI 0.72.4 -- OCS 1.32 -- Home brewed MS CM import script

PeterWI

Member

Registered: 2008-12-09

Posts: 3

Re: ocsng mode configuration for a newbie

Thank you in advance for your help!

OCS and GLPI are running on seperate servers.  Both running Server 2003.

OCS version 1.01 running on XAMPP ver1.5.5. (Apache 2.2.3, MySQL 5.0.27, PHP 5.2.0 )
GLPI version 0.71.2  -iis6(php 5.2.6)and mysql5(5.1.29) .

Error occurs in Setup, OCSNG, added a new ocsng template.  Ran glpi in debug mode and got the following error: Field 'glpi_link_enabled' doesn't have a default value.

sql-errors.log:
2008-12-16 15:45:26
*** MySQL query error :
***
SQL: INSERT INTO glpi_ocs_config (`name`,`ocs_db_host`,`ocs_db_name`,`ocs_db_user`,`ocs_db_passwd`,`ID`,`date_mod`)
Error: Field 'glpi_link_enabled' doesn't have a default value
Backtrace :
C:\Inetpub\wwwroot\glpi\inc\commondbtm.class.php:223        DBmysql->query()
C:\Inetpub\wwwroot\glpi\inc\commondbtm.class.php:417        CommonDBTM->addToDB()
C:\Inetpub\wwwroot\glpi\front\ocsng.form.php:67        CommonDBTM->add()
C:\Inetpub\wwwroot\glpi\front\ocsng.form.php

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: ocsng mode configuration for a newbie

It seems than you run MySQL in strict mode.

Can you try in normal mode (sql-mode in your my.cnf) to confirm this ?

+

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

PeterWI

Member

Registered: 2008-12-09

Posts: 3

Re: ocsng mode configuration for a newbie

Disabling strict mode in Mysql did the trick.  I was able to connect to ocs database.