Moving Gallery 2 from Old server to new server

gilesaj

Joined: 2009-06-27
Posts: 14
Posted: Fri, 2012-11-09 09:07

Information from Gallery on OLD Server

Gallery URL = http://dingo-den.com/gallery2/main.php
Gallery version = 2.3.1 core 1.3.0.1
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.1.6 apache2handler
Webserver = Apache/2.2.3 (CentOS)
Database = mysqli 5.0.95, lock.system=flock
Toolkits = ArchiveUpload, Exif, Ffmpeg, NetPBM
Acceleration = none, none
Operating system = Linux coopers.dingo-den.com 2.6.18-308.16.1.el5 #1 SMP Tue Oct 2 22:01:43 EDT 2012 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (X11; Linux x86_64; rv:10.0.10) Gecko/20121026 Firefox/10.0.10
Rows in GalleryAccessMap table = 12
Rows in GalleryAccessSubscriberMap table = 4483
Rows in GalleryUser table = 2
Rows in GalleryItem table = 4483
Rows in GalleryAlbumItem table = 34
Rows in GalleryCacheMap table = 0

Information on New Server:

Gallery Same as Old ( I copied the cplete folder over to new server)
Mysql version: 5.1.61
PHP version: 5.3.3
Operating system = Linux coopers.dingo-den.com Centos 6 2.6.32-279_14_1

I got this error when I was trying to move the database over from the old server.

[root@coopers move]# mysql -u root -h coopers.dingo-den.com -p gallery2 < g2.bak.sql
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'coopers.dingo-den.com' (111)

I just took the "-h coopers.dingo-den.com" part off and it worked fine I think.

After folowing the guide to moving from the Gallery site I tried to open the Gallery and just got a big "ERROR" on the screen.

I then turned on debugging and got the following which may be the same arror from mysql as above.

------------------------------
Error
Warning: file_get_contents(/var/g2data/cache/module/core/0/0/0.inc): failed to open stream: Permission denied in /var/www/html/gallery2/modules/core/classes/GalleryPlatform.class on line 321 Error (ERROR_STORAGE_FAILURE)

in modules/core/classes/GalleryStorage.class at line 239 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 470 (GalleryStorage::_getConnection)
in modules/core/classes/Gallery.class at line 209 (GalleryStorage::search)
in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 317 (Gallery::search)
in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 222 (GalleryPluginHelper_simple::_fetchAllParameters)
in modules/core/classes/GalleryCoreApi.class at line 302 (GalleryPluginHelper_simple::getParameter)
in modules/core/classes/GalleryTranslator.class at line 370 (GalleryCoreApi::getPluginParameter)
in modules/core/classes/GalleryTranslator.class at line 294 (GalleryTranslator::getDefaultLanguageCode)
in modules/core/classes/Gallery.class at line 548 (GalleryTranslator::init)
in init.inc at line 157 (Gallery::initTranslator)
in main.php at line 81

Debug Output

file_exists(/var/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc)
mysqli error: [2003: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)] in CONNECT(coopers.dingo-den.com, ?, ?,
gallery2)

Could't connect :

coopers.dingo-den.com: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)

getParameter language.useBrowserPref for core plugin
file_exists(/var/g2data/cache/module/core/0/0/0.inc)
mysqli error: [2003: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)] in CONNECT(coopers.dingo-den.com, ?, ?,
gallery2)

Warning: mysqli_real_connect(): (HY000/2003): Can't connect to MySQL server
on 'coopers.dingo-den.com' (13) in
/var/www/html/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109
Could't connect :

coopers.dingo-den.com: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)

file_exists(/var/g2data/cache/module/_all/0/0/GalleryFactoryHelper_loadRegistry.inc)
mysqli error: [2003: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)] in CONNECT(coopers.dingo-den.com, ?, ?,
gallery2)

Warning: mysqli_real_connect(): (HY000/2003): Can't connect to MySQL server
on 'coopers.dingo-den.com' (13) in
/var/www/html/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109
Could't connect :

coopers.dingo-den.com: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)

getParameter id.adminGroup for core plugin
file_exists(/var/g2data/cache/module/core/0/0/0.inc)
mysqli error: [2003: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)] in CONNECT(coopers.dingo-den.com, ?, ?,
gallery2)

Warning: mysqli_real_connect(): (HY000/2003): Can't connect to MySQL server
on 'coopers.dingo-den.com' (13) in
/var/www/html/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109
Could't connect :

coopers.dingo-den.com: Can't connect to MySQL server on
'coopers.dingo-den.com' (13)

realpath(/var/www/html/gallery2/modules/core/classes/../../../)
realpath(/var/www/html/gallery2/)
----------------------------------------

Any help would be appresiated.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2012-11-09 12:18
 
gilesaj

Joined: 2009-06-27
Posts: 14
Posted: Sun, 2012-11-11 05:32

I gave up as I just got toooo many error. I am trying to install Gallery 3 on the new server.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2012-11-11 05:49

Comments are now locked for this topic.