DSM-G600, DNS-3xx and NSA-220 Hack Forum

ZilverZurfarn · 2007-09-25 13:50:03

After getting lighttpd + php up & running by following this guide http://dns323.kood.org/dsmg600/howto:lighttpd_php to the letter (very simple in fact!) I started thinking about what to do with it.
A private web album of course.
After some digging and trials, i found this http://spgm.sourceforge.net/?lg=us&id=main , Simple Picture Gallery Manager. Worked out of the box, needs no GD library nor mySQL.
http://253418.redirectme.net/gallery

/Zilver

Last edited by ZilverZurfarn (2007-09-25 13:50:15)

qn1234 · 2007-09-26 07:49:47

Very nice!

ZilverZurfarn · 2007-09-26 09:35:34

Last nite I also worked on adapting the admin script for SPGM, http://www.bluepalmtrees.com/?id=10, and have it working on DSM-G600 using ImageMagick instead of GD. It lets you upload images and automatically creates thumbnails for the uploads. A bit slow, but workable. I'll post a link when I have tidied it up a bit, and written some instructions.

BTW, While working with this, I discovered you have to set the upload dir in both php.ini and lighttpd.conf to a directory on your HDD to make http upload work. There's no space left in the default dir, which is /var/tmp

/Zilver

Last edited by ZilverZurfarn (2007-09-26 11:54:07)

ZilverZurfarn · 2007-10-01 19:56:24

Put together the web admin script I promised a while back. If you have problems making it work, I'll try to help if you post questions here.
Also available @ http://253418.redirectme.net/pub/download/webadm.zip

/Zilver

qn1234 · 2007-10-04 05:08:01

Looks like your site has a problem. Here's the error:

PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft JET Database Engine Description: Syntax error (comma) in query expression '[Id] = 10, AND [Available] = True'.' in D:\domains\bluepalmtrees.com\wwwroot\my\private\database.class.php:60
Stack trace:
#0 D:\domains\bluepalmtrees.com\wwwroot\my\private\database.class.php(60): com->Execute('SELECT * FROM [...')
#1 D:\domains\bluepalmtrees.com\wwwroot\index.php(19): database->query('SELECT * FROM [...')
#2 {main}
thrown in D:\domains\bluepalmtrees.com\wwwroot\my\private\database.class.php on line 60

ZilverZurfarn · 2007-10-04 08:52:48

Nope, that's not my site - That's the site of the original SPGM admin script. My adaptation is attached to my previous post.

Cheers!
/Zilver

JackShepard · 2007-10-04 14:30:53

Hi ZilverZurfarn!

I tried to install SPGM to my DNS-323 with your config files. SPGM runs, but adding some of my pictures failed with the following error message: "gal/test/MarkusSmall.jpg: no associated thumbnail or insufficient permissions"

path to SPGM: /mnt/HD_a2/www/pages/spgm
path to test gallery: /mnt/HD_a2/www/pages/spgm/gal/test -> here i put the jpeg image
tmp path : /mnt/HD_a2/www/spgm/tmp

I think i has something to do with the fact that preview thumbnails for my pictures currently are'nt created ...

Any ideas?

BR

Markus

Last edited by JackShepard (2007-10-04 14:34:41)

ZilverZurfarn · 2007-10-04 19:29:14

IIRC, I think you must have a corresponding thumbnail for each full size image.
Yes:

SPGM wrote:
Pictures are .jpg / .png / .gif files which must be associated to a thumbnail (use your favorite tool for thumbnail edition), and possibly to a caption.
The thumbnail filename is the picture filename prefixed by "_thb_" (e.g. pic01.jpg, _thb_pic01.jpg).

My adaptation of the web admin script generates a thumbnail for images uploaded using it. Else, you have to create the thumbnails "by hand".

/Zilver

JackShepard · 2007-10-04 22:56:41

Okay thanks. Now i understand why the error message appears but i don't really know how i can fix it. I'm not really a linux junky ... Can you help?

I followed your instructions found in your zip archive webadm.zip

Thats what i did:

1. Update of the version of lighttpd that was included in funplug 0.3 to 1.4.17 and added PHP (lighttpd is stored in the following dir: /mnt/HD_a2/funplug.d/bin, web dir is /mnt/HD_a2/www)
2. Installation of imagemagick-6.3.4_9.tgz
3. Installation of SPGM in /mnt/www/pages/spgm
4. Copy of the files webmin.php and settings.php to /mnt/HD_a2/www/pages/spgm/gal
5. Editing the file webmin.php: line10 -> /mnt/HD_a2/funplug.d/bin/convert and line12: /mnt/HD_a2/funplug.d/bin/identify
6. Editing of file settings.php: $webroot="/test"; // relative path from admin script to pictures^M
define("BASE_DIR","/mnt/HD_a2/www/pages/spgm/gal/test"); // absolute path to gal
7. Adding the following to /mnt/HD_a2/funplug.d/etc/php.ini:

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
file_uploads = On

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
upload_tmp_dir =/mnt/HD_a2/www/spgm/tmp

; Maximum allowed size for uploaded files.
upload_max_filesize = 8M

8. Adding the following to /mnt/HD_a2/funplug.d/etc/lighttpd.conf:

#Set temp-dir to HDD
server.upload-dirs = ( "/mnt/HD_a2/www/pages/spgm/tmp" )

9. Creation of the folder /mnt/HD_a2/www/pages/spgm/gal/test
10. Putting a jpg image into this directory and restarted the webserver deamon ...

What's wrong?

Edit:

Today i tried everything from the beginning again. Now i understand what your program should do but i can't get it working I think the problem is that i don't really understand where i have to place your php files ...

BR,

Markus

Last edited by JackShepard (2007-10-07 15:58:21)

ZilverZurfarn · 2007-10-07 12:49:58

Basically, the webmin scripts can be anywhere inside the lighttpd www folder - I put them in a subdir to the spgm base dir.
In the attachment a "tree" of my "www" dir, defined as server.document-root in lighttpd.conf.

gallery is the SPMG main dir.
That's where the spmg.php & cetera are.

In the webadm dir, inside gallery, are my web admin scripts.

The base photo gallery folder is in the gal folder under gallery. In gal, each album is created in its own directory. Initially I forgot the trailing "/" - It's important to have trailing "/" both for $webroot & BASE_DIR.

My settings.php looks like this:

Code:

<?php
$webroot="../gal/"; // relative path from admin script (=this folder) to pictures
define("BASE_DIR","/mnt/HD_a2/lighttpd/www/gallery/gal/"); // absolute path to galleries for spgm
define("MAX_THUMB_WIDTH",160);     // max width for thumbnails
define("MAX_THUMB_HEIGHT",120);    // max height for thumbnails
define("MAX_IMAGE_WIDTH",800);     // max width for displaying image for cropping
define("MAX_IMAGE_HEIGHT",600);    // max height for displaying image for cropping
define("GAL_FILE","gal-desc.txt"); // where the gallery descriptions are, default to spgm
define("PIC_FILE","pic-desc.txt"); // where the picture descriptions are, default to spgm
define("THUMB_PREFIX","_thb_");    // thumbnail prefix, _thb_ default to spgm
define("COLUMNS",4);               // the number of thumbs to display per row
define("JPG_QUALITY",75);          // 1-100, typically 75, bigger number = better quality, larger files
define("LANG","en");               // defines the language to use, default is English (en)

// the image types allowed, "type"=>true (1), all lowercase
$pic_extensions=array("png"=>1,"jpg"=>1,"gif"=>1);
?>

/Zilver

Last edited by ZilverZurfarn (2007-10-07 13:26:45)

JackShepard · 2007-10-08 01:00:36

Okay. I checked everything and corrected my settings.php but the error still occures ...

May it help if i send my complete www-dir to you? Mhhh somehow i cannot add the tar-file ...

Do I have to say the SPGM in some config file that it should excute your webadm.php file perhaps?!?

BR Markus

Last edited by JackShepard (2007-10-08 12:20:55)

ZilverZurfarn · 2007-10-08 09:37:15

JackShepard wrote:
but the error still occures ...

What error are you getting? SPGM still complaining about missing thumbnails?

I can look at your files if you'd like but:
SPGM and WebMin don't interact in any way. WebMin is just means to:
1) Create and maintain albums.
2) Upload images to albums, and create thumbnails for the uploads.
3) Add and edit comments to your albums/pictures

Cheers!

/Zilver

DSM-G600, DNS-3xx and NSA-220 Hack Forum

Announcement

#1 2007-09-25 13:50:03

Web Album

#2 2007-09-26 07:49:47

Re: Web Album

#3 2007-09-26 09:35:34

Re: Web Album

#4 2007-10-01 19:56:24

Re: Web Album

#5 2007-10-04 05:08:01

Re: Web Album

#6 2007-10-04 08:52:48

Re: Web Album

#7 2007-10-04 14:30:53

Re: Web Album

#8 2007-10-04 19:29:14

Re: Web Album

SPGM wrote:

#9 2007-10-04 22:56:41

Re: Web Album

#10 2007-10-07 12:49:58

Re: Web Album

Code:

#11 2007-10-08 01:00:36

Re: Web Album

#12 2007-10-08 09:37:15

Re: Web Album

JackShepard wrote:

Board footer