database.default.dsn not working |
hello, I am trying to connect to postresql using the dsn parameter for the default database schema
I have confirmed the pdo_pgsql is enabled in phpinfo, ultimately I need to be able to add sslverify to the dsn string to make an SSL only connection to the postgresql database here is my dsn - no connection, does not work database.default.dsn ='pgsql:host=xx.xx.xx.xx;port=5432;dbname=xx;username=xxx;password=xxxx;sslmode=verify-ca;sslrootcert=/ssl/db/server-ca.pem;sslcert=/ssl/db/client-cert.pem;sslkey=/ssl/db/client-key.pem' #database.default.hostname = ip #database.default.database = dbname #database.default.username = dbuser #database.default.password = dbpass #database.default.DBDriver = Postgre #database.default.port = 5432 #database.default.schema = public if I un comment the below - this works #database.default.dsn ='pgsql:host=xx.xx.xx.xx;port=5432;dbname=xx;username=xxx;password=xxxx' database.default.hostname = ip database.default.database = dbname database.default.username = dbuser database.default.password = dbpass database.default.DBDriver = Postgre database.default.port = 5432 I have been referencing the following database configuration page on codeigniter user guide https://codeigniter.com/user_guide/datab...h-env-file any help or guidance would be greatly appreciated |
Messages In This Thread |
database.default.dsn not working - by rwilson12 - 02-05-2022, 08:49 AM
RE: database.default.dsn not working - by iRedds - 02-05-2022, 11:29 AM
RE: database.default.dsn not working - by rwilson12 - 02-05-2022, 11:42 AM
RE: database.default.dsn not working - by iRedds - 02-05-2022, 08:12 PM
RE: database.default.dsn not working - by rwilson12 - 02-06-2022, 02:20 AM
RE: database.default.dsn not working - by FilembarEliJeevan - 02-16-2022, 04:27 AM
|