Home› General support

release update

michas Member
in General support
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!

Comments

  • acrylian Administrator, Developer
    Are you sure you entered the right database credentials on setup or within the config file?
  • michas Member
    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...
  • michas Member
    Forgot to say: Many thanks for the fast response! And 1 more thing: which config file are you talking about?
  • acrylian Administrator, Developer
    This one: `zp-data/zenphoto.cfg.php`.
  • michas Member
    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_4_5_" and once with a "zp_" prefix. The 1st are all empty. Only the "zp_" tables contain data. Is that correct?
  • acrylian Administrator, Developer
    The config file is not accessible if the server is doing it right as requested by the setup script.

    I also noted that in the existing zenphoto db all tables are there twice: once with a prefix "zenphoto-zenphoto-1_4_4_5_" and once with a "zp_" prefix. The 1st are all empty. Only the "zp_" tables contain data. Is that correct?
    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_4_5_" 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.

    MySQL db (actually it's a MySQLi db, does that make any difference?).
    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.
  • michas Member
    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.
  • acrylian Administrator, Developer
    Surely usefull for some if Ubunti requires anything special. Best post it on your site and we link to it.
  • mindhaq Member
    +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...
  • michas Member
    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...
  • acrylian Administrator, Developer
    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.
  • trisweb Administrator
    I will give an install a shot on a Trusty VM since it seems like there are several people concerned. Will report back shortly.
  • trisweb Administrator
    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.
  • trisweb Administrator
    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?
  • michas Member
    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!
  • trisweb Administrator
    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.
Sign In or Register to comment.