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) »
  • New Install: Access denied for user <webserverdaemonuser>@'localhost'
Pages: [1]

Author Topic: New Install: Access denied for user <webserverdaemonuser>@'localhost'  (Read 1923 times)

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
New Install: Access denied for user <webserverdaemonuser>@'localhost'
March 13, 2008, 09:45:46 am
Wow - this is a weird one!

New Install of Drupal 5.7 - working aok.
Attempt install of CiviCRM 2.0 - the install page gives me 'green lights' on our setup and configuration.
(We had previously created the separate drupal and civicrm databases, and set up appropriate privileges for master user)

our mysql log reports:
Access denied for user <webserverdaemonuser>@'localhost'

Where is CiviCRM getting this user name?  Please note that our input into the installation page was of the master user of both databases, not the webserver daemon user name... !

I will begin digging into CiviCRM default config files...

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: New Install: Access denied for user <webserverdaemonuser>@'localhost'
March 13, 2008, 02:05:06 pm

we get the data from the input form. the webserverdaemonuser is not hardcoded

please debug and let us know what the issue was. do you have any browser based "form fill" helper which might be adding those to the form fields? (just a random guess)

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

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: New Install: Access denied for user <webserverdaemonuser>@'localhost'
March 13, 2008, 07:47:17 pm
Hello Mr. Lobo!  (and thanks for your help in the past)

Yes, I'll debug it and reply.  For the moment, I'm reinstalling MySQL altogether, and am debugging an InnoDB 'raw' driver issue.  Because the error on INSERT INTO, when entered directly into the MySQL CLI, indicates an InnoDB engine issue.

CiviGuy

  • I’m new here
  • *
  • Posts: 25
  • Karma: 1
Re: New Install: Access denied for user <webserverdaemonuser>@'localhost'
March 14, 2008, 09:47:46 pm
Lobo:

Here's the reproducible diagnostic you requested - this is weird one!  Situation, as outlined above, is of a newly-installed Drupal 5.7.  When trying to install CiviCRM 2.0.1, I've entered some  bogus MySQL usernames to highlight the problem.  (The precipitating event is the Re-check requirements button):
(Of course, webservd is the Apache daemon user, but we do not use this in any entry...!)

CiviCRM Settings: MySQL username: fubarCIVICRM, MySQL database: civicrm
Drupal     Settings: MySQL username: fubarDRUPAL,  MySQL database: drupal

MySQL log output: ---------------------
080315  0:30:07      53 Connect     Access denied for user 'webservd'@'localhost' (using password: NO)
                     54 Connect     Access denied for user 'fubarCIVCRM'@'localhost' (using password: YES)
                     55 Connect     Access denied for user 'fubarCIVCRM'@'localhost' (using password: YES)
                     56 Connect     Access denied for user 'webservd'@'localhost' (using password: NO)
                     57 Connect     Access denied for user 'webservd'@'localhost' (using password: NO)
                     58 Connect     Access denied for user 'fubarCIVCRM'@'localhost' (using password: YES)
                     59 Connect     Access denied for user 'webservd'@'localhost' (using password: NO)
                     60 Connect     Access denied for user 'fubarDRUPAL'@'localhost' (using password: YES)
                     61 Connect     Access denied for user 'fubarDRUPAL'@'localhost' (using password: YES)
                     62 Connect     Access denied for user 'webservd'@'localhost' (using password: NO)

With the correct MySQL user names (and after we had addressed an underlying issue with our InnoDB setup), CiviCRM does ultimately install correctly.  But where is this reference to the webservd coming from?
« Last Edit: March 14, 2008, 10:00:35 pm by CiviGuy »

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: New Install: Access denied for user <webserverdaemonuser>@'localhost'
March 15, 2008, 01:30:47 am

sorry, no idea about this. you'll have to instrument the installer code and see where those values are coming from.

There are a couple of places within the installer code that call mysql_connect

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • New Install: Access denied for user <webserverdaemonuser>@'localhost'

This forum was archived on 2017-11-26.