Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
D
Drupal
  • Project overview
    • Project overview
    • Details
    • Activity
  • Issues 50
    • Issues 50
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Create a new issue
  • Issue Boards
Collapse sidebar
  • Development
  • Drupal
  • Issues
  • #26

Closed
Open
Opened Jul 13, 2018 by somnolentsurfer@somnolentsurfer

Double quote (") should not be escaped in CIVICRM_UF_DSN in civicrm.settings.php

I'm a complete newbie to both CiviCRM and Drupal, but I've been trying to test out an installation for one of my clients. I completed a fresh, standard installation of Drupal 7, then followed the installation process for CiviCRM in the System Administrator Guide.

Once installation was complete, and I had filled in all the details of my database paths and users as requested, I tried to follow the process for setting up scheduled jobs at https://docs.civicrm.org/sysadmin/en/latest/setup/jobs/ using either the CLI or HTTP method.

Whatever I tried, every attempt to run Job.execute resulted in 'DB Error: connect failed'.

With the help of this StackExchange thread (https://civicrm.stackexchange.com/questions/25575/db-error-connect-failed-when-trying-to-call-job-execute-using-cli-php/) I tracked down the logs and discovered that MySQL was rejecting the password of the Drupal database user.

On looking up the password in CIVICRM_UF_DSN in civicrm.settings.php I noticed that a double quote character (") in my password was escaped with a backslash, even though the instructions in the file only say single quote (') or backslash () characters should be escaped. Taking the backslash out of the password allowed Job.execute to run as expected.

I had never touched civicrm.settings.php before, so it seems that whichever script had translated the password I entered in the GUI during installation into that file must have erroneously escaped the double quote.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: dev/drupal#26