mysql

mysql root password

Posted on June 14, 2010 - 4:12am by Knut Dybendahl.

Hi all,

Just installed Acquia - straight forward enough.
Went and changed the root password from nothing to 'something'.
'root'@'%' and 'root'@'localhost'....

Whenever I try to use the Acquia control panel - I get:
Access denied for root@localhost - using password: NO...

I've looked in the my.cnf file - no joy...

Any ideas anyone?

Kind regards,
Knut

Lifetime Networks, the most powerful media brand targeted to women, is a diverse, multi-media company, committed to offering the highest quality entertainment and informational content that celebrates, entertains and supports women. Among the top 500 most visited sites on the Internet, myLifetime.com, which is built on Drupal, receives 6.5 million visitors (3.6 million unique) and 50 million page views per month. Because of online campaigns, and the popularity of associated television shows, the Lifetime family of sites must be prepared to accommodate significant volume spikes. Read full article »

Date & time: Tuesday, May 18, 2010
12:00 PM EDT
Duration: 1 hour
Speakers: Nathan Potter, VP of Digital Media Technology, myLifetime.com

Bug: Can't import databases with "CREATE" in them

Posted on March 25, 2010 - 9:14pm by Tom Geller.

Hey, folks. I encountered an error while importing a database with a CREATE statement, e.g.:

CREATE DATABASE `mydatabase` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

It worked fine when I commented out that line. It would be wise to make DAMP ignore CREATE DATABASE statements.

Sorry if this has been reported already. Good luck!

--Tom

The S-Files: When node_load won't load, and the anonymous user has vanished

Posted on January 21, 2010 - 1:13pm by Robert Douglass.
Robert Douglass's picture

Tech Support Case Studies

Use these two SQL commands to repair your Drupal 6 site to restore the anonymous user database record: 

INSERT INTO users (name, mail) VALUES ('', '');
UPDATE users SET uid=0 WHERE name='';
Read full article »

The symptoms you'll see that tip you off that this is needed:
  1. node_load() is not loading nodes that you can prove are in the node table.
  2. node_delete() is not deleting nodes that you can prove are in the node table.
  3. The query SELECT * FROM users WHERE uid=0; returns zero rows.

DAMP causing error messages in /var/log/syslog

Posted on December 15, 2009 - 8:33pm by George O'Connor.

The following error messages keep repeating in the syslog file every 10 seconds: Read full article »

The S-Files: Acquia Drupal Stack installer Got packet bigger than max_allowed_packet bytes

Posted on September 25, 2009 - 2:20pm by Robert Douglass.
Robert Douglass's picture

Tech Support Case Studies

The S-Files are a taste of the support that you get with a subscription to Acquia Support. Our support team helps you solve technical problems relating to your Drupal sites.

The Acquia Drupal Stack installer is a major productivity booster for getting up and running in the development of your Drupal site. Sometimes, though, Drupal modules like to cache huge data packets in the database. This results in an error in your browser that says this:

Got packet bigger than ‘max_allowed_packet’ bytes

This is an indication that the data being sent between Drupal and the database is large, and exceeds the default setting.

Fortunately the fix for this is easy. In the application installation directory of the stack installer you'll find the following directory and file:

Applications/acquia-drupal on my Mac

Edit the my.ini file with whatever text editor you like, and add these lines to the end:

#Max packets
max_allowed_packet = 128M

Now stop and start the Acquia Drupal Stack using the Acquia Drupal Control Panel, and the new setting will come into effect. This should solve your max_allowed_packet problem!

XDebug, Komodo, and the Acquia Drupal Stack Installer

Posted on September 25, 2009 - 1:08pm by Robert Douglass.
Robert Douglass's picture

The Acquia Drupal Stack installer for Mac OS X 10.6 (Snow Leopard) has been released, and it’s pretty cool (works on 10.5 Leopard, too, of course). I’m now using it as my primary development environment, replacing MAMP. In this article I show how you can configure the stack installer to use XDebug for step through debugging. Read full article »

Database size limit

Posted on June 26, 2009 - 1:27am by Ryan Ornelas.

I would like to import our DB to the Acquia Mac Stack, but I am limited on size. How do I import a 10mb database?

Also to modify the www files of the stack, where should I look?

MySQL and Acquia Drupal: MyIsam or InnoDB?

Posted on April 11, 2009 - 9:32pm by Maura Clover.

I've set up Acquia Drupal on IIS 6, Win 2003, 1GB RAM VM server with multisites. Everything is working great. Acquia Drupal is fantastic, I like it tons.

Question: when installing MySQL 5.1, after reading everything I could find on Drupal.org, this site, and Sun's website, I finally went with the recommendation on Sun's site to install Mysql with mixed Myisam and Innodb, as there seem to be so many differing opinions on which is best for Drupal. I also read "Achieving Optimal Mysql Performance for Drupal". Read full article »

Many to one forms within forms

Posted on October 29, 2008 - 2:51pm by Josh Miller.

This is a common problem, so I'm sure I'm searching for the wrong things, but does anyone know where to find a stable module that will allow me to include children forms on parent node forms?

If I were, for instance, creating a recipe and wanted to add main ingredients from the same form.

CCK multi-fields would be adequate if each "field" could have multiple "fields" or could just create nodes instead of simple associated information.

Hopefully this ramble makes sense.

Thanks,
Josh

12next ›last »