CB System Params - DB Credentials

Hello,

Is there a way to retrieve credentials of current DB (server, DB name, DB user, DB pw) as a CB substitution?
Would be great for auto actions with eg. PHP code to open DB to fire SQL statements.

Thanks.

Is there a way to retrieve credentials of current DB (server, DB name, DB user, DB pw) as a CB substitution?

No, that'd be a security vulnerability.

Would be great for auto actions with eg. PHP code to open DB to fire SQL statements.

You don't need those credentials to execute SQL in PHP. Use Joomla or CBs database API for that. See Joomlas documentation regarding Joomlas API.

docs.joomla.org/Accessing_the_database_using_JDatabase

For CBs API you need to set a global then you'd use the global as you would a JDatabase object. Example as follows.

Thank you for your instant reply.

We're used to dev. code for CB Auto Action with PHP on server directly and then to transfer and adapt it to CB Auto Action action requirements.
This is straightforward and works well.

The Joomla code suggested by Joomla returned just a HTTP 500 server error.
Is code mentioned in the Joomla doc not intended to be used as a PHP program but inside Joomla?
Sorry for a stupid question, but may be you will give us a helping hand to sort this out.

Thanks.

Both Joomla and CB API can be used within the code action perfectly fine, but most of the classes are namespaced so you need to be sure to provide the full namespace path. Accessing CBs database API is just done using a global variable so don't need any namespace usage.