Re: [Phpwiki-talk] Oracle invalid character error preventing virgin DB loading

[umfan866 <mh...@so...>]

Note - I get this error message when using "ADODB" in config.ini, 
when using "SQL" I get the message:

Fatal Error: 
lib/WikiDB/backend/PearDB.php:59:Error[256]:Can't connect to database:
WikiDB_backend_PearDB_oci8:
fatal database erorr 
 * DB error: connect failed
 *([ nativecode=ORA-12514:TNS:listener does not currently know of service
requested in connect descriptor]**
       oci8://phpwiki:XXXXXX@192.168.0.100:1521/pwiki)

Note: I am an Oracle DBA and the Database PWIKI is up on this machine, and I
can connect to it fine when
using php calls 

If anyone is able to get Phpwiki to work with Oracle at all, in any shape or
form, please let me know. Oracle
is a requirement -- I am not allowed to use MySql for the backend. Thanks
Marvin. 


umfan866 wrote:
> 
> Hi, I am starting to use phpwiki. My goal is to have
> this in an Oracle database eventually, but I am using
> MySql at first to get it going.
> 
> I am using the following: 
>   RHEL4 with SELinux turned off 
>   phpwiki-1.3.12p3
>   ZendCoreForOracle-v1.4.1-Linux-x86.tar.gz1
>     (provides php 5 pre-compiled)
>   MySql 5.0.22-0 for rhel4
>   Oracle 10g R2 (10.2.0.2)
>  
> For both MySql and Oracle, I am finding 
> DATABASE_TYPE = ADODB works better/fewer 
> errors than with DATABASE_TYPE = SQL so,
> I don't change this value anymore. 
> 
> Also, for both MySql and Oracle, I have prepended
> phpwiki_ to every table, so that I can go between
> the 2 databases in the future (and Oracle needs it
> for sure). Have edited the create/destroy schema
> scripts accordingly.
>  
> I am able to get the virgin wiki to load
> nicely in MySql using  
> 
> DATABASE_DSN="mysql://phpwiki:passwd@localhost(/var/lib/mysql/mysql.sock)/phpwiki" 
> 
>  
> For Oracle, I was able to get connectivity working by
> installing ZendCore for Oracle (basically a pre-compiled 
> verusion of php 5).  I also had to unlock the phpwiki user
> for it to work at all (as sysadmin, "alter user phpwiki 
> account unlock") -- this is a new 10g security feature 
> and so is not in the oci install doc for phpwiki. FOr 
> 
> Oracle my connect string is  
> DATABASE_DSN="oci8://phpwiki:phpwiki@192.168.0.100:1521/pwiki>"
> (where the SERVICE_NAME / SID = pwiki, the 1521 is optional 
> as it is the default db port). 
>  
> I am able to connect to the oracle, but the virgin wiki still
> does not load. It connects (was able to get through past 
> connect errors, but then shows the  following ADODB error): 
>  
> lib/WikiDB/adodb/adodb-errorhandler.inc.php:76: Error[256]:
> oci8 error: [911: ORA-00911: invalid character] in EXECUTE
> ("UPDATE phpwiki_page SET hits=?, pagedata=? WHERE pagename=?")  
>  
> I think that Oracle does not like the question marks --it
> probably wants quotes around the question marks - that
> may be the issue, but not sure how to fix that (which file
> or part of the code). Thanks for any pointers. 
> 
> 

-- 
View this message in context: http://www.nabble.com/Oracle-invalid-character-error-preventing-virgin-DB-loading-tf2155588.html#a6765833
Sent from the phpwiki-talk mailing list archive at Nabble.com.