Webpage for photos...

Guru · 18 Jun 2012 at 21:46

Hi all,

I've got an FTP which I've uploaded about 500mb of images to, I want these to be displayed in a webpage where people have to use a username and password to access it and can view and download the pictures.

I have a server 2008 box and an SBS 2003 box, I would prefer to use the 2008 box to do this.

What's the best way to go about doing this? Share point?

I'd ideally like to host ALL of our family photos on this and be able to setup a read only log in to my wholse family.

Thanks,

G

Guru · 19 Jun 2012 at 14:23

I have considered this:

http://piwigo.org/basics/installation_netinstall

But I am struggling at the first hurdle.

IT is saying that I need this:

A hosting space with MySQL 5 and PHP 5
Full

a webserver supporting PHP *
MySQL 5 *
PHP 5 *
5Mb storage for the software, and much more for your photos *
an FTP client (e.g. FileZilla for Windows or Linux)
and, well, a still camera!

* : all these often come bundled in hosting offers. Check yours.

I'm guessing that none of this is standard on either SBS2003 or Server 2008.

Sir SpankalotUK · 19 Jun 2012 at 17:36

personally I would use a apache/mysql/php5 installation and use a simple wordpress install with a plugin like NextGen Gallery, that way you'd be able to search and browse thumbnails quite easy. Tagging pictures properly would make them findable, but it would take a while to tag a large library correctly.

Or the other option is write a .htaccess and thumbnail maker (jQuery gallery) so people can just browse the plain folder structure, as new folders are added people just need to refresh, but you'd have no search function though.

EDIT: you can install apache/mysql/php (xampp) to a windows box, you'd have to change the web port in apache's httpd.conf though to avoid conflicting with anything already present, or run a virtual box on the server, thing like Turnkey Wordpress appliance, small install and ready to go once installed.

uniQ · 19 Jun 2012 at 17:55

Do you have PHP? It's pretty simple to automate a full photo gallery from just a folder of images without installing any scripts.

Guru · 19 Jun 2012 at 18:01

I now have the pre-requisites for Piwigo, including PHP. I've installed them all and I'm trying to setup the Piwigo using the automated setup but it's asking for the database name and I don't know it or how to find out.

Guru · 19 Jun 2012 at 18:02

This is what it's asking for:

Database configuration
Host localhost, sql.multimania.com, toto.freesurf.fr
User user login given by your host provider
Password user password given by your host provider
Database name also given by your host provider
Database tables prefix database tables names will be prefixed with it (enables you to manage your tables better)

This is what I get in mysql:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| photos |
| sakila |
| test |
| world |
+--------------------+
7 rows in set (0.00 sec)

I have tried Database and photos as the database name, but both say "Cannot connect to server"

/nvm I think I'm getting there...

uniQ · 19 Jun 2012 at 18:28

It also requires MySQL you need to create a database and user normally via PhpMyAdmin then point the installation to it.

Guru · 20 Jun 2012 at 09:09

I've got it all working brilliantly now apart from one tiny snag that's irritating me...

It spams this all over the page lol:

Warning: strftime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead in D:\WEBSITE\Photos\Gallery\include\smarty\libs\Smarty_Compiler.class.php on line 400

Guru · 20 Jun 2012 at 15:42

i have tried creating a php.ini file with iust this in it:

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = "Europe/London"

; http://php.net/date.default-latitude
;date.default_latitude = 31.7667

; http://php.net/date.default-longitude
;date.default_longitude = 35.2333

; http://php.net/date.sunrise-zenith
;date.sunrise_zenith = 90.583333

; http://php.net/date.sunset-zenith
;date.sunset_zenith = 90.583333

doesnt seem to have helped.

/edit I put this file in d:\website\photos

Not sure if this is right?

AHarvey · 20 Jun 2012 at 16:12

http://piwigo.org/forum/viewtopic.php?pid=115421#p115421

Guru · 20 Jun 2012 at 16:17

Thanks for the link

I am not running apache though, I am using IIS in Server 2008 so I am not sure where the ini file should be.

AHarvey · 20 Jun 2012 at 16:45

its all a bit beyond my experience but a quick google says that if you've installed PHP using the installer it should be in C:\WINNT\system32

Guru · 20 Jun 2012 at 19:25

AHarvey said:
its all a bit beyond my experience but a quick google says that if you've installed PHP using the installer it should be in C:\WINNT\system32

Thanks!! I've put it in c:\windows\ and added:

// --- Europe --- //

// London, England, Europe
date.timezone = "Europe/London"
date.default_latitude = 51.500181
date.default_longitude = -0.12619

No more irritating message for now

Guru · 25 Jun 2012 at 09:08

This piwigo is really good by the way

can get some decent addons for it to change appearance etc.