Difference between revisions of "Piwigo"
From SME Server
Jump to navigationJump to search| (3 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
=== Create a MySQL database for Piwigo === | === Create a MySQL database for Piwigo === | ||
:$ mysqladmin create 'piwigo' –default-character-set=utf8 | :$ mysqladmin create 'piwigo' –default-character-set=utf8 | ||
| − | === | + | === Create a MySQL user for the new database === |
:$ mysql | :$ mysql | ||
| − | : > grant insert,update,delete,create,alter,drop on piwigo.* to piwigo@localhost | + | : > grant select,insert,update,delete,create,alter,drop on piwigo.* to piwigo@localhost identified by 'my_secret_password'; |
: > flush privileges; | : > flush privileges; | ||
: > quit; | : > quit; | ||
| Line 30: | Line 30: | ||
| Password || my_secret_password (the database user's password) | | Password || my_secret_password (the database user's password) | ||
|- | |- | ||
| − | | Database name || | + | | Database name || piwigo |
|- | |- | ||
| Database table prefix || piwigo_ | | Database table prefix || piwigo_ | ||
| Line 48: | Line 48: | ||
=== Importing from Gallery === | === Importing from Gallery === | ||
If you have previously used Gallery, Piwigo can import the images, comments etc. from your albums there. Checkout the Menalto2Piwigo-plugin | If you have previously used Gallery, Piwigo can import the images, comments etc. from your albums there. Checkout the Menalto2Piwigo-plugin | ||
| + | |||
| + | [[Category:Howto]] | ||
Latest revision as of 15:45, 25 September 2016
Now that Gallery isn't being maintained anymore, Piwigo may be good replacement for having photo galleries on a SME Server. This is a first attempt of a "How to"...
Log in to a shell as user root and enter the following commands
Install ImageMagick
- $ yum install ImageMagick
Create a MySQL database for Piwigo
- $ mysqladmin create 'piwigo' –default-character-set=utf8
Create a MySQL user for the new database
- $ mysql
- > grant select,insert,update,delete,create,alter,drop on piwigo.* to piwigo@localhost identified by 'my_secret_password';
- > flush privileges;
- > quit;
Of course, "my_secret_password" should be replaced with a password of your own choice.
Download and install the source code for Piwigo
- $ cd /home/e-smith/files/ibays/Primary/html
- $ wget http://piwigo.org/download/dlcounter.php?code=latest -O piwigo.zip
- $ unzip piwigo.zip
- $ rm piwigo.zip
- $ mv piwigo photos
- $ chown root.web -R photos
- $ chmod g+w -R photos
Setup Piwigo
In a browser, open http://yourserver.com/photos, and fill out the form
| Host | localhost |
| User | piwigo (the database user) |
| Password | my_secret_password (the database user's password) |
| Database name | piwigo |
| Database table prefix | piwigo_ |
| Webmaster login | myuser (user name of your own choice, for administration of Piwigo) |
| Webmaster password | mypassword (password of your own choice) |
| Webmaster mail address | myuser@myserver.com (mail address shown on the Piwigo site) |
Click "Start Installation"
Adding photos
Hopefully everything will then be set up to your satisfaction, and you can start adding photos.
Importing from Gallery
If you have previously used Gallery, Piwigo can import the images, comments etc. from your albums there. Checkout the Menalto2Piwigo-plugin
