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 »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Issues with installing with Wordpress
Pages: [1]

Author Topic: Issues with installing with Wordpress  (Read 3216 times)

brennassp

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Wordpress
  • MySQL version: 5.096
  • PHP version: 5.3.24
Issues with installing with Wordpress
August 29, 2013, 08:28:08 am
Good morning everyone, hoping you can assist.

Running most current version of WP, trying to install CiviCRM.
while executing the requirements check, I am all green except on
"are the access credentials correct" : That username/password doesn't work:  - I have verified my DB credentials are correct quite a few times.

"Can I access/create InnoDB tables in the database": Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if mysql has innodb support. Assuming no  - I assume this is due to the above error

"Can I create temporary tables in the database   Could not login to the database."

"Can I create lock tables in the database   Could not login to the database."

"Can I create triggers in the database   Could not login to the database."

Everything else is good. Thanks ahead of time for the assistance

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: Issues with installing with Wordpress
August 29, 2013, 01:55:11 pm

1. ensure that you can login using those credential using PHPMyAdmin and/or the mysql command line

2. If the above is working, ensure that the username/password does not have spaces or any non-alpha numeric characters (this is a shot in the dark)

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

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issues with installing with Wordpress
September 02, 2013, 01:32:34 pm
Yes, all the other errors are due to the credentials not being correct. Be sure the server address is correct and check for a non-standard default port for MySQL or a pipe.

Then try changing the password for the user, or make a new user. It sounds like you're making a human error and just not catching it.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Ericjt

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: wordpress 3.7.1
  • MySQL version: 5.0
  • PHP version: latest at godaddy
Re: Issues with installing with Wordpress
December 01, 2013, 05:39:01 pm
I am having the same issue. Is it correct that the MySQL server can remain localhost, and that the MySQL username and database name are the same? I am able to log in via myPHPadmin with the credentials I have entered. I got the names and password out of my wp config file. Or does civi need a separate database?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issues with installing with Wordpress
December 02, 2013, 01:53:01 am
CiviCRM does not require a separate database and the DB server can be localhost. I can't say what the problem might be however.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

aglozier

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
Re: Issues with installing with Wordpress
December 10, 2013, 09:10:20 am
Did you create the civicrm database?  For my web host, I have to create the database for civiCRM in my control panel.  The CiviCRM install doesn't create it.  You don't want to use the WordPress database.  Create a separate one for CiviCRM

zaffarn

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: Version 4.4.3 WordPress
  • CMS version: wordpress 3.8
  • MySQL version: MySQL 5.5.33
  • PHP version: PHP version 5.3.27
Re: Issues with installing with Wordpress
December 25, 2013, 11:51:52 am
Hello

Not sure if this has been resolved, I am getting same error message.  The CivicCrm is installed on Wordpress 3.8 as plugin, and uses the same database as WP, the credentials are ok as its able to create the tables but not lock tables.  Everything else comes OK with doing the compatibility check.  Our setup is as follows

Hosting type: Shared hosting

Attached is output from CRM requirement check

I am only getting 3 errors in Database

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issues with installing with Wordpress
December 25, 2013, 11:54:20 am
zaffarn, I would ask your host about this. It seems they have limited the permissions of your MySQL user.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

zaffarn

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: Version 4.4.3 WordPress
  • CMS version: wordpress 3.8
  • MySQL version: MySQL 5.5.33
  • PHP version: PHP version 5.3.27
Re: Issues with installing with Wordpress
December 25, 2013, 12:04:15 pm
Thanks Hershel,

I have contacted them and am awaiting response, will update you when I get some more information,

o_moaka

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Wordpress 3.8
  • MySQL version: 5.1.71
  • PHP version: 5.3.3
Re: Issues with installing with Wordpress
December 26, 2013, 05:57:33 am
Hello,
 I have the same problem on WordPress 3.8 with CiviCrm 4.4.3
I am searching for 2 days for an answer and i thing i'm gonna be crazy. All PHP requirements are OK, i made a different db for CiviCrm but in admin dashbord i can't connect to the new db. My wordpress is on a host.
Can anyone help me, please?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issues with installing with Wordpress
December 26, 2013, 06:00:58 am
o_moaka, CiviCRM uses standard PHP methods to connect to MySQL. If it fails to connect, then your credentials are incorrect. I suggest you ask your host for assistance.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

o_moaka

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Wordpress 3.8
  • MySQL version: 5.1.71
  • PHP version: 5.3.3
Re: Issues with installing with Wordpress
December 26, 2013, 07:11:50 am
i just run this script for both db :
$dbcnx = @mysql_connect('localhost', 'root','password');

if (!$dbcnx)
{
  die ("<p>Unable to connect to the database server at this time.</p>\n" . "<p>" . mysql_error() . "</p>\n");
}
echo "<p>Connected to the database server!</p>\n";
echo "</p>\n";
echo "<p>End of script!</p>";

and it outputs Connected to the database server....so credentials are correct....the problem is other but i don't now which

o_moaka

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Wordpress 3.8
  • MySQL version: 5.1.71
  • PHP version: 5.3.3
Re: Issues with installing with Wordpress
December 26, 2013, 08:47:51 am
I finally managed to make green all my requirements after I replace localhost with 127.0.0.1.
But now I'm having another problem. After I click Install Crm, a 500 Internal Server occured(The server encountered an internal error or misconfiguration and was unable to complete your request.). The db is populated but the crm.settings.php doesn't appear.

I solved that by making a php.ini file with -- memory=20MB content and put it into wp-admin/ folder.
Maybe this info will help somebody  :)

« Last Edit: December 26, 2013, 09:31:50 am by o_moaka »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Issues with installing with Wordpress

This forum was archived on 2017-11-26.