Install failure for Gallery 3. . .

tamk

Joined: 2011-09-07
Posts: 22
Posted: Thu, 2013-06-13 15:09

I put the unzipped Gallery3 folder into the same folder where my website's index.php file was.
[See screenshot of file manager.]
I created a var folder and gave it write permissions to 777 status.
I created a mySQL database and noted the username & password details.
I then browsed to the webpage : myWebsite.com/gallery3 and only saw a listing of the various files and folders that are in the Gallery3 directory.
There is no sign of the mySQL configuration page that we are supposed to see.
[See screenshot of Gallery3 browse.]

What is gone wrong here ?
It seems to me that nothing is wrong !
What we see is truly what is in the Gallery3 folder.
The problem is that this folder has nothing in it to tell the browser to initiate the process of configuring the newly installed Gallery software.

Please advise as to what I ought do to get this software installed.

AttachmentSize
File Manager Screenshot.doc90.5 KB
Gallery3 Opening Page Screenshot.doc49 KB
 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Thu, 2013-06-13 18:20

I now realise what has gone wrong.
All the initializing files within the Gallery3 folder were on their own - i.e. not in any folder - within the Gallery3 skin. Prior to doing my FTP transfer I'd created a Gallery3 folder on my website file manager and intended uploading directly from the contents of the Gallery3 folder on my desktop. Of course the Filezilla browser only "saw" the folders within the desktop Gallery3 folder -- hence I never clicked on these individual files and they were thus never uploaded at all . . .
Que burro !

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Thu, 2013-06-13 19:57

But now I find that activation of Gallery 3 is impeded by the need for PHP Extension, Perl-Compatible Regular Expression (PCRE) with unicode support.
The Gallery Project Team may be interested to know that this PHP extension was deprecated by all PHP versions from PHP 5.3 onwards, as described here :

http://php.net/manual/en/intro.regex.php

This deprecation began on December 2010, nearly 2 months after the release of the Gallery 3 software which requires it . . .
I realize that Gallery is a voluntary project. But wouldn't it be only sensible to liaise with all vendors of interfacing software like PHP, mySQL, etc ahead of designing new versions ?
Otherwise all that hard work is for nought.
And customers can give up on the pack.

 
jnash
jnash's picture

Joined: 2004-08-02
Posts: 814
Posted: Thu, 2013-06-13 20:09

You're mistaken, the deprecation is on POSIX REGEX, the PCRE extensions are not.

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Thu, 2013-06-13 20:27

So you think that this is a matter of configuring the PHP 5.3 on my hosting server ?
All I can see for the moment is that PHP 5 is set to "Run as an Apache module".
Alternatives are "Run as a CGI application"; or else "OFF".

The hosting company has finished for the day here, so I can only email them now.

Ideas welcome.

 
jnash
jnash's picture

Joined: 2004-08-02
Posts: 814
Posted: Thu, 2013-06-13 20:45

I'm not sure why they would have php not compiled with PCRE support, as it's pretty default for most distro's.

It's something they are going to have to do. If they're unwilling, you should probably look for a new provider. PCRE is a fairly common php extension and just about everything I've ever run requires it.

Just my 2cents.

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Fri, 2013-06-14 11:48

Sorted it.
You were right on the PHP - PCRE thing.
It was installed.

Firstly, the database needed to be "Run as a CGI Application", not as an Apache module.
Secondly - somehow - I'd created a msSQL database rather than a mySQL one.

Latest hold-up is that FFmpeg is needed for viewing small movie files and my host uses a
Linux variant called CentOS
. I hear that 30% of Linux servers now use CentOS but that
has not resulted in a precompiled version of FFmpeg
being made available by FFmpeg[i] or
anyone else that I can see on the web.

Anyone know any better ?

Thanks to JNash. Regards to Alicia. (!)

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Fri, 2013-06-14 16:39
Quote:
FFmpeg is needed for viewing small movie files

Negative.
FFmpeg is only used to generate the thumb from a movie that is added. It also gets the height and width as well. Nothing to do with playing the movie.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
jnash
jnash's picture

Joined: 2004-08-02
Posts: 814
Posted: Fri, 2013-06-14 16:42

Is the noffmpeg module still supported? I don't think it is...

Also, there are several yum repositories that carry ffmpeg compiled for CentOS - DAG being one of them.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Fri, 2013-06-14 17:37

http://codex.galleryproject.org/Gallery3:Modules:noffmpeg not needed. New code does not prevent the user from adding videos if they don't have ffmpeg. If they dont have ffmpeg then a default thumb and size is selected.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Fri, 2013-06-14 21:43

That's good to hear. But I have not tried to put any .mov files on it yet.
I've had enough hassle with this all day.
I've got it going now for photos at least.

So much I have learned :

1. Always use FTP for uploading to a photos folder within the Gallery3/ folder.
Never upload directly more than a small number of small (<1 MB) photos as the server usually drops half of them.

2. If moving files from an existing FTP folder to a feeder directory within Gallery, use FTP also.
This is because internal web copying may have rstrictions on the number of files and/or filesizes that may be moved.

3. When using the serveradd function, just add one directory at a time, i.e. add no director that contains sub-directories of photos.

4. If you inadvertently create a folder within a folder, this can be sorted out by Gallery's Organize Albums feature.

5. Take a break every now and then from it !

Tamk.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Fri, 2013-06-14 22:30

Sounds to me like you have some restrictions that are not imposed by either of my hosts.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Tue, 2013-06-18 14:32

Not needed. New code does not prevent the user from adding videos if they don't have ffmpeg. If they dont have ffmpeg then a default thumb and size is selected.

My Gallery does not show these mpeg4 files within the albums, despite their being within the album folder and visible with the FTP client.

Should I therefore install this Ffmpeg tool ?

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2013-06-18 17:28

URL to see the behavior.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Tue, 2013-06-18 18:08

It's a private website. There's no URLs being handed out.
Besides, it would only do what I have said it's doing,
i.e. ignoring .mpeg4 files that are in photo albums.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2013-06-18 20:24

It works for me, with ffmpeg and without.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
jnash
jnash's picture

Joined: 2004-08-02
Posts: 814
Posted: Wed, 2013-06-19 00:54

same here - no problems

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Wed, 2013-06-19 11:31

What do you boys see when Gallery 3 opens ?

If you click on an album in which a movie file resides, can you see some sort of thumbnail for it ?
Even a name ?
Any chance of a screenshot ?

STOP PRESS !

I finally got one into an album.
Trouble now is, that when I click on the "Play" arrow, I hear the sound but I see no video. Looks like the video playing program (QuickTime, in my case) needs to be configured on Gallery.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2013-06-19 12:24

make sure the video is a true mp4 H.264/AAC

Try one of these to test:
http://www.mediacollege.com/adobe/flash/video/tutorial/example-flv.html

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Thu, 2013-06-20 13:31

I tried to attach one of these mpeg4 files but gallery Upload won't allow it.

The MediaCollege files lined by you seem to be something entirely different (flash video) to mpeg4 format.
the strange thing about this is how it reproduces the sound part of the video no problem . . .

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Thu, 2013-06-20 14:16

Send a url to a movie that does not work se we can test.

Quote:
The MediaCollege files lined by you seem to be something entirely different (flash video) to mpeg4 format.

I understand but did they work?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
tamk

Joined: 2011-09-07
Posts: 22
Posted: Thu, 2013-06-20 15:14

The .FLV runs fine on my Gallery.

I also notice that .MOV files - which I have a lot of - are not visible on the Gallery albums.