How to make Serendipity to work with oracle database?

[amita]

what does the path S9Y_INCLUDE_PATH and S9Y_DATA_Path contains?

where is the file "serendipity_config_local.inc.php" located?

[amita]

what does the path S9Y_INCLUDE_PATH and S9Y_DATA_Path contains?

where is the file "serendipity_config_local.inc.php" located?

Please provide me the proper paths...

Thanks,
Amita

[garvinhicking]

Hi!

S9Y_INCLUDE_PATH is the path to your serendipity installation (like /home/www/serendipity/

S9Y_DATA_PATH is the same path; it points to a different s9y directory when s9y is used in shared installations, but I think you need not bother with it.

The config_lcoal is located at S9Y_DATA_PATH . '/serendipity_config_local.inc.php'. In the root of your s9y installation. Check the serendipity_config.inc.php file at around line 190 to see how it is included.

Best regards,
Garvin

[falk]

again one thing, for MYSQL ... mysql is used , for Postgre, pg is used. Where is this defined? What we should use for oracle then?

I think it is good to call it oci, if you are using the oci-Extension. And attentione! There are funktions ociconnect und oci_connect! The first one is for PHP4, the socound for PHP5 and i think PHP4 will be used. But for PHP4 there are no all funktions avaible.

[srinathk11]

In the process of conversion to oracle should we create a file for oracle similar to the files \include\admin\importers\wordpress-pg.inc.php(this is for postgres) and wordpress.inc.php(this is for mysql)

[amita]

Falk wrote:
I think it is good to call it oci, if you are using the oci-Extension. And attentione! There are funktions ociconnect und oci_connect! The first one is for PHP4, the socound for PHP5 and i think PHP4 will be used. But for PHP4 there are no all funktions avaible.

i need to ask that we dont need to define somewhere that we are using "ora" or "oci" for oracle. Or is there something standard. for ex. i can use pgre for PostgreSql or is it necessary to use pg only?

[garvinhicking]

Hi srinkath!

Oracle has nothing to do with the importer files wordpress etc. that you are referring to. ORacle is a database layer; the importer files are there to import blog entries/data from other blog systems, not from other databases.

i need to ask that we dont need to define somewhere that we are using "ora" or "oci" for oracle. Or is there something standard. for ex. i can use pgre for PostgreSql or is it necessary to use pg only?

The choice on how to call your DB Layer does not matter. You just need to be consistent in your naming scheme, and are not allowed to mix it up by detecting the PHP extension. The PHP extension is called "oci" or "oci8" or something like that; if you call your DB layer "oracle", that is fine, but you still need to use "oci" or "oci8" to detect if PHP has the extension enabled in the checks that I mentioned earlier.

Regards,
Garvin

[falk]

I think it is posible to call it OCI, because there is an deprecated ORA-Extension for PHP and in the manual this is calling Oracle.

[srinathk11]

Hi,
In the process of making serendipity work with oracle we have created oci8.inc.php file and implemented various methods using mysql.inc.php as template.But we are facing some problems..There is no method oci8_select_db similar to mysql_select_db.Also we didn't find oci methods similar to the mysql_info(),mysql_insert_id,mysql_real_escape_string,and mysql_escape_string.Please provide some solutions for this one...without this we are unable to proceed further.
Thanks.
srinath.

[falk]

Welcome in the Club!

What is with addslashes?

And here a little Example, but it doesn't work for our/your problem in this version:

function oci_insertid(&$con, $sequence)
{
$stmt = oci_parse($con, 'SELECT '.$sequence.'.CURRVAL AS CV FROM DUAL');
if (!@oci_execute($stmt, OCI_DEFAULT)) {
return oci_error($stmt);
}
$row = oci_fetch_array($stmt, OCI_ASSOC);
oci_commit($con);
return $row['CV'];
}

[garvinhicking]

Hi!

Dang! Addslashes. I completey forgot about this in my response: http://www.s9y.org/forums/viewtopic.php?t=5776

Thanks, falk.

Regards,
Garvin

[srinathk11]

Hi garvin,
We were working for customising serendipity for Oracle 9i,PHP 5.1.2, Apache 2.0.55.We could make many links like New Entry/Edit entries,Create Category,etc work.
Now suddenly our requiremnts have been changed as:
PHP: 4.3.2
Apache web server: 2.0.46
Oracle: 10.2.0.2.0
Will the same changes we made earlier work fine with the new requirements or will there be any major changes.
Any suggestions or directions regarding this will be grateful.
Thanks.
srinath.

[garvinhicking]

Hi!

PHP 4.3.2 and Apache 2.0.46 are fine for Serendipity. About Oracle, you have to know which changes are needed.

Best regards,
Garvin