Trouble embedding Gallery 2 within Drupal

midgetwithamatch

Joined: 2010-12-13
Posts: 3
Posted: Mon, 2010-12-13 16:02


Gallery version : 2.3.1
PHP version : 5.2.14
Webserver : Apache
Database : MySQL 5.0.90
Activated toolkits : GD
Operating system : Linux
Browser : Chrome

I am attempting to embed Gallery 2 into Drupal 6.19. I have Gallery2 installed and configured. I also have drupal installed and configured. Both gallery 2 and drupal work independently of eachother. I have the gallery module copied into the drupal /modules directory. I also have the URL rewrite plugin up and running within Gallery 2.

When I go into drupal to configure gallery 2 and drupal together is when I encounter this error.

PHP memory limit reads OK.
Gallery 2 locations reads OK.
On the third step after inputting the path to the drupal .htacces file and clicking the "Configure URL Rewrite plugin" button I am dumped this error message:
warning: mysqli_real_connect() [function.mysqli-real-connect]: (00000/1045): Access denied for user: 'removed@localhost' (Using password: YES) in /home/adrenalin/www/www/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109.

When configuring Drupal it wouldn't allow me to authenticate through the localhost hostname so I had to use the remote hostname and remote port number to configure drupal. While installing and configurine Gallery 2 I could only get it to configure for the localhost hostname. I'm thinking this may be where the issue is arising since gallery is attempting to connect to the database from within drupal.

I was wondering if anyone has encountered this and how to go about handling it. Is it possible to configure gallery 2 to connect to a remote hostname and provide it with a port number? I was looking in the config.php file and didn't see a field for a port number to be inputted.

Much appreciated. Thanks
 
midgetwithamatch

Joined: 2010-12-13
Posts: 3
Posted: Mon, 2010-12-13 17:13
midgetwithamatch wrote:

Gallery version : 2.3.1
PHP version : 5.2.14
Webserver : Apache
Database : MySQL 5.0.90
Activated toolkits : GD
Operating system : Linux
Browser : Chrome

I am attempting to embed Gallery 2 into Drupal 6.19. I have Gallery2 installed and configured. I also have drupal installed and configured. Both gallery 2 and drupal work independently of eachother. I have the gallery module copied into the drupal /modules directory. I also have the URL rewrite plugin up and running within Gallery 2.

When I go into drupal to configure gallery 2 and drupal together is when I encounter this error.

PHP memory limit reads OK.
Gallery 2 locations reads OK.
On the third step after inputting the path to the drupal .htacces file and clicking the "Configure URL Rewrite plugin" button I am dumped this error message:
warning: mysqli_real_connect() [function.mysqli-real-connect]: (00000/1045): Access denied for user: 'removed@localhost' (Using password: YES) in /home/adrenalin/www/www/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109.

When configuring Drupal it wouldn't allow me to authenticate through the localhost hostname so I had to use the remote hostname and remote port number to configure drupal. While installing and configurine Gallery 2 I could only get it to configure for the localhost hostname. I'm thinking this may be where the issue is arising since gallery is attempting to connect to the database from within drupal.

I was wondering if anyone has encountered this and how to go about handling it. Is it possible to configure gallery 2 to connect to a remote hostname and provide it with a port number? I was looking in the config.php file and didn't see a field for a port number to be inputted.

Much appreciated. Thanks

My hosting company allows for local php.ini files.

After a short phone call to them they told me to place

Quote:
mysqli.default_socket = /tmp/mysql5.sock

inside my local php.ini file and use localhost as my hostname. The location of the socket will be different depending upon the hosting company. I believe you can locate it in your phpinfo() file as well.

This got my drupal running all nice and happy and attempted the embedding of Gallery2 again without a hiccup.

I hope this information proves viable to others.