CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • MySQLi
Pages: [1]

Author Topic: MySQLi  (Read 1491 times)

kmrciv

  • Guest
MySQLi
December 30, 2009, 06:55:13 pm
I am currently trying to install CiviCRM.  I get through the initial check requirements screen which checks requirements and get the green light:  "Database version and connection settings have been verified and look correct!" 

However, when I try to install and get the following error:

Cannot open mysql://mydatebase:XXXXXXXXX@localhost/mywebsite_civiCRM?new_link=true: DB Error: connect failed.

in drupal settings.php  I have mysqli rather than mysql.  Does this make a difference?

Thank you for your help.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: MySQLi
December 31, 2009, 07:17:02 am

try modifying the DSN settings in civicrm.settings.php (sites/default) to use mysqli instead of mysql

i think we always generate mysql based dsn's

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

kmrciv

  • Guest
Re: MySQLi
January 01, 2010, 10:39:38 am

Thanks so much for your reply.  I'm relatively new to website development and I really appreciate your taking the time to help.  I wanted to post my fix because I noticed a lot of people trying to fix this problem and if they are newbies like me they are probably as frustrated as I am.

I don't know which fix worked but this is what I did:

One of the things I noticed earlier is that when I went into sites/default/settings.php my password didn't match what I had in written down in my password book. I pulled the password from the file and used it for the install fields but I still got an error.  Next,  I changed the password in sites/default/settings.php to what I had written in my book.  When I went back to the civicrm install I got all green lights--so far so good--but when I tried to install I got the same mysql error as stated above. 

Just to make sure there was agreement between mysql and drupal, I went into mysql and changed the password to what I had put into the drupal settings.php file. 

Next, I created a new database and new db user in mysql.  I used the new db and the new db user for the civicrm install fields.  This time it worked.  This is probably what was intended in the first place but I'm a newbie so probably a little thick. 

Thanks again for your help Don.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • MySQLi

This forum was archived on 2017-11-26.