CiviCRM Community Forums (archive)

You need to fix your CIVICRM_UF_DSN setting. we've modified the code to make the error message more friendly

lobo

Check you civicrm.settings.php for CIVICRM_UF_DSN.

kurund

Sync users is the ONLY place where we use CIVICRM_UF_DSN, hence you only see the message there. There ate TWO dsn's in your settings file. One is the civicrm dsn (CIVICRM_DSN) and the other is the DSN of the CMS (CIVICRM_UF_DSN). Its the latter that is most likely missing

Its complaining about a missing file because its parsing an empty string etc (i.e. not great code in the PEAR package, IMO)

lobo

Had a major playaround with this and I now have a version 2 civicrm.settings.php file in /var/www/html/sites/default/.

Adding a debug statement to DB::connect showed that it was being called twice, the second time with a null string for the $dsn.  first time looked ok.

----snip ----
--- /var/www/html/sites/all/modules/civicrm/packages/DB.php.bak200803061145     2008-02-21 10:38:17.000000000 +1300
+++ /var/www/html/sites/all/modules/civicrm/packages/DB.php     2008-03-07 00:47:29.000000000 +1300
@@@ -518,6 +518,7 @@
     function &connect($dsn, $options = array())
     {
         $dsninfo = DB::parseDSN($dsn);
+        print ("\$dsn='$dsn'\n");
         $type = $dsninfo['phptype'];

         if (!is_array($options)) {

----snip ----

output (details removed) = :

$dsn='mysql://username:password@localhost/database?new_link=true'
$dsn=''

We investigated enough to find out the second time was called from the synchronise users function. Not sure about the first.



print ("\$dsn='$dsn'\n");

    function &connect($dsn, $options = array())
    {
        $dsninfo = DB::parseDSN($dsn);
        print_r($dsninfo);


Bugger - should have done what I said I would & upgraded before trying to figure it out - Beta 5 fixed it!