CiviCRM Community Forums (archive)

Well, I've searched and searched, but i don't see an answer for this... 

I installed CiviCRM 2.02 on a fresh install of Joomla 1.0.15. The install went smoothly with no errors.  However, when I try to access CiviCRM through the Joomla Administrator interface I get the following message (note: the server/database configs below are obfuscated, but are correct on my install):

Cannot open mysql://DBUser:DBPassword@localhost:/tmp/mysql5.sock/MySite_DBName?new_link=true: DB Error: connect failed
I've also noticed that the notorious "civicrm.settings.php" cannot be found anywhere in the install.

Server:
Host: ICDSoft
PHP: v 5.2.5
MySQL: v 5.0.45
Open basedir: none
Timeout set to 600 through php.ini

Also,

• I checked the database with PHPMyAdmin and the CiviCRM tables were inserted during the install.
• I've tried installing using the typical Joomla installation method (my PHP settings are set high enough to allow the larger file upload) and installing from the directory as delineated elsewhere in the documentation.  I get the same results both ways.

So...

• Is "civicrm.settings.php" supposed to be installed with CiviCRM v2.02? Do I need to manually install and configure this?
• It appears that CiviCRM is pulling the database config from the Joomla configuration.php, yet it still cannot connect.  Joomla is obviously buzzing along fine with the same settings. Any ideas why? Can I manually change these settings somewhere, and if so where?

Any help, advice or kicks in the head for being a dolt would be appreciated!
Matt

hi lobo... thanks for the response!

can u check the civicrm.settings.php file and see what the value is there

Well, that's the weird part. I can't see/find a civicrm.settings.php anywhere in the install (other than the sample in the templates).

Here are the contents of the administrator/components/com_civicrm/ directory:
   admin.civicrm.php
   Civicrm (Directory)
   civicrm.xml
   configure.php
   install.civicrm.php
   toolbar.civicrm.php
   uninstall.civicrm.php

Side note/More Info: i just confirmed MySQL supports InnoDB.  When i look at the DB using phpMyAdmin, i notice the following message when i click on one of the CiviCRM tables:  ""InnoDB free: 0 kB; (`domain_id`) REFER `MySite_DBName/civicrm_domain`(`id`)"

Again... thank you for the help!
matt

It seems i much learning to do!

Here's a screen shot of the error message, with DB name/user/password obscured.

matt

we construct the dsn from joomla variables using the following piece of code:

    $dsn =  'mysql://' .
        $mosConfig_user     . ':' .
        $mosConfig_password . '@' .
        $mosConfig_host     . '/' .
        $mosConfig_db       .
        '?new_link=true';

For some reason, that dsn is not liked by us / PEAR DB library, and hence we cannot connect. i have not seen a dsn like that either. You'll need to investigate and figure out whats happening and why. The code for this is in: configure.php, line 63 and line 125. I'd start by checking the values for mosConfig_host and mosConfig_db and going from there. See my previous post for what PEAR::DB thinks is a good dsn

please report back with how you fixed things.

I have no idea what you/ICDSoft mean by connecting remotely and then it works by connecting via localhost, so a bit lost there

We use PEAR::DB to manage all database connections. You can check on the DSN formats it accepts here:

http://pear.php.net/reference/DB-latest/DB/DB.html#methodparseDSN

lobo

After discussing this issue with my host it appears that using the hosts remote connection settings are the way to go.  They've told me that my concerns of slower connection using remote connection are unfounded (but they said it much nicer than that), and that the script will still connect locally. 

There is a way to connect to PEAR DB with a socket (http://pear.php.net/manual/en/package.database.db.intro-dsn.php), wherein you change the syntax for localhost/socket to something like this:mysql://user:pass@localhost(/path/to/socket)/DBName  - but when i try that it boinks my Joomla install, so that's a no go.

So, here it is in a nut shell. If your host requires that you specify a socket setting in your host connection syntax (i.e. - something like: "localhost:/tmp/mysql5.sock"), use the hosts remote connection settings instead (i.e. - something like "mysql5.abc.yourhost.com:1234" - with "1234" being the port that your hosts provides).  If you don't know how to connect remotely just contact your host for assistance.

Oh, and this change needs to only be made in the Joomla "configuration.php" file of your root directory (Joomla will still run correctly).  CiviCRM picks up the DB info from that file.  No hacks of CiviCRM are needed with this method.

Thanks again for all of the help lobo!  If i've farked any of this up in the explanation, please let me know!
matt

mcsmom-

You may want to start a new thread for your question, unless you're having a localhost connection problem like discussed in this thread.
Also, any additional details/information (host, CiviCRM version, etc, etc) that you can provide will help in getting a faster/better response.

-matt