Member
Member
michas   2015-03-31, 23:25
#1

I recently updated my server from ubuntu precise to trusty. Initially everything worked with zenphoto 1.4.4.5 until it tried to access the admin page. This resulted in a "connection was reset". I tried to reinstall the zp-core folder, index.php but it resulted in a general "connection reset" also for the gallery. Even a plain new install of zenphoto 1.4.7 didnt work even with indicating a new MySQL database. The server runs PHP Version 5.5.9-1ubuntu4.7 and SQL 5.5.41. Can anybody help? Many thanks in advance!

Administrator
Administrator
acrylian   2015-04-01, 08:18
#2

Are you sure you entered the right database credentials on setup or within the config file?

Member
Member
michas   2015-04-01, 08:24
#3

in principal nothing has changed with regard to user and password of the database. As mentioned I even tried with a completely new MySQL db with the same result. I am completely stuck. I can access the db using phpmyadmin. So everything is there. No idea...

Member
Member
michas   2015-04-01, 08:26
#4

Forgot to say: Many thanks for the fast response! And 1 more thing: which config file are you talking about?

Administrator
Administrator
acrylian   2015-04-01, 09:10
#5

This one: zp-data/zenphoto.cfg.php.

Member
Member
michas   2015-04-01, 19:08
#6

wow, i didnt know that all credentials are actually included there in cleartext. Otherwise still no improvement: with a new install of zenphoto 1.4.7 the setup creates a new zenphoto.cfg.php including the credentials. But then again "connection reset" even using a fresh and clean MySQL db (actually it's a MySQLi db, does that make any difference?). I also noted that in the existing zenphoto db all tables are there twice: once with a prefix "zenphoto-zenphoto-1_4_45" and once with a "zp" prefix. The 1st are all empty. Only the "zp" tables contain data. Is that correct?

Administrator
Administrator
acrylian   2015-04-01, 19:22
#7

The config file is not accessible if the server is doing it right as requested by the setup script.

[i]I also noted that in the existing zenphoto db all tables are there twice: once with a prefix "zenphoto-zenphoto-1_4_45" and once with a "zp" prefix. The 1st are all empty. Only the "zp" tables contain data. Is that correct?[/i]
I cannot tell you. "zp_" is the default prefix for the tables (in case the database is shared with other systems or serveral ZP installs) if you don't set anything else. If "zenphoto-zenphoto-1_4_45" you must have set it somewhere, maybe on hte older install. Of ocurs you have to use the same on an update if you want to use the existing tables.

[i]MySQL db (actually it's a MySQLi db, does that make any difference?).[/i]
MySQLi is only the way of connecting PHP and MySQL. If you cannot connect to the database best contact your host about the right credentials, especially the server.

Member
Member
michas   2015-04-07, 21:21
#8

I got it working again by setting up everything completely new. I could even import my old zenphoto db into the new MySQL. This time I documented my setup. So in case anybody is interested I can provide a step by step documentation for setting up zenphoto 1.4.7 on ubuntu trusty.

Administrator
Administrator
acrylian   2015-04-08, 09:56
#9

Surely usefull for some if Ubunti requires anything special. Best post it on your site and we link to it.

Junior Member
Junior Member
mindhaq   2015-04-08, 13:42
#10

+1

I'm about to update my server to trusty, but I'm still a bit worried now what that will do with my zenphotos...

Member
Member
michas   2015-04-11, 21:56
#11

It's strange: even with the plain new install I have some issues. An plain new means in this case everything is new. I installed a virtual machine of ubuntu trusty on the existing trusty server. now when uploading some images to a new album some images are randomly duplicated. When removing them manually in the album folder it works fine. now I tried to reinstall the installation on the main server again by applying the documentation that I made for the virtual machine and the result is the same: connection reset when I try to access the admin pages. strange...

Administrator
Administrator
acrylian   2015-04-12, 08:16
#12

You mean there are physical duplicate images created within the albums within the /albums folder itself? I have never heard of or encountered that before. If images are created within /cache.

I am sorry but I can only assume that something is wrong with the servers somehow. I have installed Zenphoto on several different hosts and all are fairly standard shared hosts without any issue like that.

Developer
Developer
trisweb   2015-04-12, 15:55
#13

I will give an install a shot on a Trusty VM since it seems like there are several people concerned. Will report back shortly.

Developer
Developer
trisweb   2015-04-12, 16:01
#14

For what it's worth this server is running Trusty 14.04 without issues. I will still make sure a fresh install works as expected.

Developer
Developer
trisweb   2015-04-13, 00:34
#15

All went well with installs on both Trusty and Utopic (14.10).

However, I was able to reproduce the "random double upload" issue, and even got one triple upload! I believe this is the result of the jQuery uploader, but we'll have to do more debugging.

michas, did you use the jQuery uploader to upload when you experienced that issue?

Member
Member
michas   2015-04-14, 08:40
#16

That's right: i used jQuery to upload the new album! Thanks for investigating and confirming that this is not an issue with my installation on trusty!

Developer
Developer
trisweb   2015-04-18, 15:46
#17

Thanks for confirming! We are quite behind on that plugin so will probably upgrade it to a more recent version and see if that resolves.

Until then, as always, the easiest way to upload is to just drop directories of images into the albums folder by any method.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.