Announcement

#1 2019-01-16 13:16:25

kdmiller45
Member
Phoenix
2018-07-16
30

Moving Piwigo server

Hello All,

I removed all pluggins from the old site, then copied the complete photo site to the new server, then exported the database with phpmyadmin from old site and uploaded to new site, I get the following error

Warning: mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/ourlifeinpixs/include/dblayer/functions_mysqli.inc.php on line 67

Warning: my_error(): Couldn't fetch mysqli in /var/www/ourlifeinpixs/include/dblayer/functions_mysqli.inc.php on line 837

Warning: my_error(): Couldn't fetch mysqli in /var/www/ourlifeinpixs/include/dblayer/functions_mysqli.inc.php on line 837
Piwigo encountered a non recoverable error

[mysql error ]
Can't connect to server

#1    my_error /var/www/ourlifeinpixs/include/common.inc.php(128)
#2    include_once /var/www/ourlifeinpixs/index.php(26)


    Server: Localhost via UNIX socket
    Server type: MySQL
    Server version: 5.7.24-0ubuntu0.18.04.1 - (Ubuntu)
    Protocol version: 10
    User: phpmyadmin@localhost
    Server charset: UTF-8 Unicode (utf8)
     Apache/2.4.29 (Ubuntu)
    Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
    PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
    PHP version: 7.2.10-0ubuntu0.18.04.1
Piwigo v 2.9.4
can you assist
Keith

Last edited by kdmiller45 (2019-01-16 13:19:43)

Offline

 

#2 2019-01-16 14:53:15

erAck
Piwigo Team
2015-09-06
232

Re: Moving Piwigo server

Change in /var/www/ourlifeinpixs/local/config/database.inc.php the $conf['db_...'] variables to the correct new settings.


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2019-01-16 15:39:26

kdmiller45
Member
Phoenix
2018-07-16
30

Re: Moving Piwigo server

are you able to see or imagine what Variables I need to change from what you see here, I'm not a DB person

Last edited by kdmiller45 (2019-01-16 15:40:02)

Offline

 

#4 2019-01-17 01:55:33

kdmiller45
Member
Phoenix
2018-07-16
30

Re: Moving Piwigo server

Ok for the simpletons like me here is what I did to move my Piwigo site from one server to another

1. created new site on the new server in the /var/www/sitename and performed a sudo chmod 777
    sitename
2. using phpmyadmin I exported old website sql database to local workstation
3. using phpmyadmin I created a new DB on the new location
4. copied the complete website from old location to the new (not sure if the whole site needed to be
   moved, but I did.)
5. then import the old database into the new location
6. I did have to modify the database.inc.php located here /var/www/sitename/local/config/
   and change this information

<?php
$conf['dblayer'] = 'mysqli';
$conf['db_base'] = 'yoursitename';
$conf['db_user'] = 'username for mysql';
$conf['db_password'] = 'Pswd that goes with username';
$conf['db_host'] = 'localhost';

6. I restarted the server and Bingo I was up and going

thanks for the help here
Keith

Last edited by kdmiller45 (2019-01-17 01:56:53)

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact