PHP connection file is not successful with oracle cloud autonomous database wallet

user10740087

a simple connection file is not even working

<?php

$db = "(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=xxxxxxxxxxxxxx.oraclecloud.com))(connect_data=(service_name=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.oraclecloud.com))(security=(ssl_server_cert_dn="CN=xxxxxxxxxxxxxxx.oraclecloud.com, OU=xxxxxxxxxxxxxxxxxxxx, O=Oracle Corporation, L=xxxxxxxxxxxxx, ST=xxxxxxxxxxxxxx, C=US")))';

$conn = oci_connect("xxxxxxxxxxxx","xxxxxxxxxxxxxxxxx",$db);

if (!$conn) {

print "Sorry";

die();

}

else {

print "OK";

oci_close($conn);

}

?>

can help ????

Christopher Jones-Oracle

Where did you put the cwallet.sso file and sqlnet.ora file?

Have you checked https://blogs.oracle.com/opal/post/how-to-connect-to-oracle-autonomous-cloud-databases ?

user10740087

I put the cwallet.sso file and sqlnet.ora files in /usr/lib/oracle/21.3/client64/lib/network/admin

Christopher Jones-Oracle

What error are you getting?

Does SQL*Plus connect correctly? If not, then resolve that problem first. Maybe you need to open ports etc.

user10740087

if (!$conn) {

print "Sorry";

die();

connection not executing

Christopher Jones-Oracle

Does SQL*Plus work?

For PHP, you can get error message text using: https://www.php.net/manual/en/function.oci-error.php

User_XTXCO

Hi user10740087,

Have you found a solution for connection problem?

Christopher Jones-Oracle

@User_XTXCO Most people don't have a connection problem. If you describe your scenario we can offer advice.

Note that with the updated Linux x64 Instant Client 19.13 files you always don't need wallets. This update lets you use wallet-less, 1-way TLS.

User_XTXCO

Hi Christopher,

Please, let me clarify. I was trying to help user user10740087. I'm not facing any issue indeed.

So, when we get this confirmation, that the problem is still there (which I believe is unlikely), let's understand his scenario and try to help him.

Regards,

FN