Problem with TNS

[ilyosjon09]

Hello!

I installed the package as per guidelines. I am trying to database using TNS string. Thus I changed config accordingly by showing tns key only.

How ever when try to test it throws Undefined index: database.

I tried to connect with oci extension in a custom PHP script and it worked. But I cannot connect using this package. Please help.

FYI:
I am setting tns to something like (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=servicename)(SERVER=DEDICATED)))

[ilyosjon09]

[yajra]

Can you provide an example config that you use? I think you can also use service_name and might yield the same TNS you need?

'oracle' => [
    'driver' => 'oracle',
    'host' => 'oracle.host',
    'port' => '1521',
    'database' => 'xe',
    'service_name' => 'sid_alias',
    'username' => 'hr',
    'password' => 'hr',
    'charset' => '',
    'prefix' => '',
]

[ilyosjon09]

Here's the config:

In $tns variable I am storing TNS string similar to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=servicename)(SERVER=DEDICATED)))

I was trying to set up a config similar to the sample from docs:

[yajra]

I think you need to include the database key, TNS will still be prioritize even if it's set.

[ilyosjon09]

Ah, okay thank you!

[aditeleanjar]

Where i put database key?

[ilyosjon09]

Just include it in the config

[
    'connections' => [
       'oracle' => [
          'driver' => 'oracle',
          'tns' => 'tns',
+       'database' => 'db',
       ]
    ]
]