Elxis CMS Forum

Support => Installation => Topic started by: bibi92 on August 04, 2009, 16:52:25

Title: Error Oracle Step4 Database
Post by: bibi92 on August 04, 2009, 16:52:25

Hi,

I have this error when I try to setup Elxis on Oracle Database :

Warning: ocilogon() [function.ocilogon]: ORA-12154: TNS:could not resolve the connect identifier specified in C:\wamp\www\elxis_2009\includes\adodb\drivers\adodb-oci8.inc.php on line 228

Do you have a solutions,please ?

Thanks

Regards

Bibi92

Title: Re: Error Oracle Step4 Database
Post by: datahell on August 04, 2009, 20:08:25

Take a look here:
http://ora-12154.ora-code.com/ (http://ora-12154.ora-code.com/)
and here:
http://www.orafaq.com/wiki/ORA-12154 (http://www.orafaq.com/wiki/ORA-12154)

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 05, 2009, 10:43:34

Hi,

Thanks
Elxis is installed on another machine.
How it is possible to use the tns via the interface ?

Thanks

Regards

Bibi92

Title: Re: Error Oracle Step4 Database
Post by: datahell on August 05, 2009, 11:23:57

You should ask an Oracle expert. I am not such a guy :)

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 05, 2009, 12:15:43

Hi,

Thanks
I'm dba Oracle but  how I can configure the db connection settings with :

Enter the database name or pathway. To avoid problems creating the database by the Elxis installer make sure database already exists., I use Oracle SID, but where can I use tnsnames.ora, please or which php file I have to modify ?

Thanks

Regards

Bibi92

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 05, 2009, 18:48:07

Hi,

is it possible de setup elxis if the oracle db is on another machine ?

Thanks

Regards

Bibi92

Title: Re: Error Oracle Step4 Database
Post by: datahell on August 06, 2009, 08:27:57

Yes, but I guess you have to permit that in db settings.

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 10, 2009, 15:56:51

Hi,

Thanks, exactly, I don't understand why It doesn't work, which php file have I to modify ?

Regards

Bibi

Title: Re: Error Oracle Step4 Database
Post by: datahell on August 10, 2009, 17:00:09

Here is my local settings for oracle

$mosConfig_host = 'localhost';
$mosConfig_user = 'xxxxx';
$mosConfig_password = 'xxxxx';
$mosConfig_db = 'elxis';
$mosConfig_dbtype = 'oci8';

And it just works....
If the database is on an other machine then you have to set he proper value for the $mosConfig_host parameter.

Elxis database handler: includes/Core/database.php
ADOdb: includes/adodb/adodb.inc.php
oci8 ADOdb extension: includes/adodb/drivers/adodb-oci8.inc.php

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 10, 2009, 17:05:19

Thanks, But which php file I have to modify ?

Regards

Bibi

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 10, 2009, 17:06:23

Sorry, You have always reply to my question.

Regards

Bibi

Title: Re: Error Oracle Step4 Database
Post by: bibi92 on August 10, 2009, 17:17:44

Thanks, I have another error now :

Deprecated: Function ereg() is deprecated in C:\wamp\www\elxis_2009\installation\includes\elxisinstaller.php on line 419


Regards

Bibi

Title: Re: Error Oracle Step4 Database
Post by: datahell on August 10, 2009, 19:59:48

You use php 5.3 or php 6....
ereg functions are deprecated in these versions....
Elxis is not yet ready for php 5.3/6. Use php 5.2

Title: Re: Error Oracle Step4 Database
Post by: fhahim987 on October 29, 2009, 11:42:55

I'm dba Oracle but  how I can configure the db connection settings with :

Enter the database name or pathway. To avoid problems creating the database by the Elxis installer make sure database already exists., I use Oracle SID, but where can I use tnsnames.ora, please or which php file I have to modify ?

Title: Re: Error Oracle Step4 Database
Post by: datahell on October 29, 2009, 13:47:02

I guess you want to SPAM rather than ask.