Installation step & MySQL database Question - Expect please~

[andersen]

Dear Expect User,

I am new here and very interested this scripts very much. Just introduce a bit about myself. Since I own my dedicated server, I have all right to access this server, but the main problem I am facing is, I am not well on setup my dedicated server setting.

P/s: My server had install “ Webmin “ control panel easy for me to manage.

Below is my step to setup the 4Images scripts:

I had set permissions for the following directories

chmod 777 "data"
chmod 777 "data/database"
chmod 777 "data/media"
chmod 777 "data/thumbnails"
chmod 777 "data/tmp_media"
chmod 777 "data/tmp_thumbnails"
chmod 777 "templates"
chmod 777 "templates/default"
chmod 777 "templates/default/media"

And also set permissions for the following files:

chmod 666 all files in the directory "templates/default"
chmod 666 all files in the directory "templates/default/media"

When I log into my site http://www.mysite.com/4images/install.php?install_lang=english (just example only)

I have few questions as below.

Question:-
========
1.)Where can I get this information :-

* Database server type
* Database server hostname
* Database name
* Database username
* Database password
* Prefix for tables in database
* Admin username
* Admin password

from my dedicated server?

2.) Since I had read through some message had posted from this categories that this scripts need to create a database for MySQL. I really do not know how to start to create it, but I had already enable MySQL on my server, just left the create database step. If some expect know how to create MySQL database by webmin, I really need your hand to me.

Thank you very much!

P/s: English is not my main languages, please forgive my broken English.

[Chris]

The FAQ contains details about what needs to appear in your config.php file.  Look for the post about "problems creating config.php".

As far as creating a MySQL database, you're best bet is to download phpMyAdmin.  It's an easy to use, browser based tool that lets you create and work with MySQL databases.  You can find it at www.phpmyadmin.net

[andersen]

- Chris

Thank you very much for answer my question.

I had done the setting on MySQL. later I got the message as below...

DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table 'mysql.4images_settings' doesn't exist

Do you have any idea to solve this problem?

[andersen]

Just give some detail information as below


<?php
/**************************************************************************
 *                                                                        *
 *    4images - A Web Based Image Gallery Management System               *
 *    ----------------------------------------------------------------    *
 *                                                                        *
 *             File: config.php                                           *
 *        Copyright: (C) 2002 Jan Sorgalla                                *
 *            Email: jan@4homepages.de                                    *
 *              Web: http://www.4homepages.de                             *
 *    Scriptversion: 1.7                                                  *
 *                                                                        *
 *    Never released without support from: Nicky (http://www.nicky.net)   *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz-       *
 *    bedingungen (Lizenz.txt) für weitere Informationen.                 *
 *    ---------------------------------------------------------------     *
 *    This script is NOT freeware! Please read the Copyright Notice       *
 *    (Licence.txt) for further information.                              *
 *                                                                        *
 *************************************************************************/

$db_servertype = "mysql";
$db_host = "localhost";
$db_name = "mysql";
$db_user = "root";
$db_password = "********";

$table_prefix = "4images_";

define('4IMAGES_ACTIVE', 1);

?>

[V@no]

DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
Table 'mysql.4images_settings' doesn't exist

that means u havent create the database yet.
just login into phpmyadmin and u'll see field "create new database" type a name and that's it.
then edit your config.php file to insure it has the correct database name.

[andersen]

New error

Warning: Failed opening './lang//main.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/httpd/html/bullroad/4images/global.php on line 238

DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1051989009 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Table 'mysql.4images_categories' doesn't exist

DB Error: Bad SQL Query: SELECT cat_id, COUNT(*) AS num_images FROM 4images_images WHERE image_active = 1 GROUP BY cat_id
Table 'mysql.4images_images' doesn't exist

DB Error: Bad SQL Query: DELETE FROM 4images_sessions WHERE session_lastaction < 1051989009
Table 'mysql.4images_sessions' doesn't exist

DB Error: Bad SQL Query: SELECT session_id FROM 4images_sessions
Table 'mysql.4images_sessions' doesn't exist

DB Error: Bad SQL Query: SELECT session_id FROM 4images_sessions WHERE session_id = 'b076e38d66e33cf5a0cf00d92b21f5b8'
Table 'mysql.4images_sessions' doesn't exist

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/html/bullroad/4images/includes/db_mysql.php on line 164

DB Error: Bad SQL Query: INSERT INTO 4images_sessions (session_id, session_user_id, session_lastaction, session_location, session_ip) VALUES ('b076e38d66e33cf5a0cf00d92b21f5b8', -1, 1051989009, 'index.php', '219.93.196.54')
Table 'mysql.4images_sessions' doesn't exist

Warning: Cannot add header information - headers already sent by (output started at /home/httpd/html/bullroad/4images/global.php:238) in /home/httpd/html/bullroad/4images/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/httpd/html/bullroad/4images/global.php:238) in /home/httpd/html/bullroad/4images/includes/sessions.php on line 85

Warning: Cannot add header information - headers already sent by (output started at /home/httpd/html/bullroad/4images/global.php:238) in /home/httpd/html/bullroad/4images/includes/sessions.php on line 85

Template Error: Couldn't open Template ./templates//header.html


==============

Expect, Could you provide me how many database had to create?

[Chris]

Just one database.  Installation steps are found in docs/Installation.txt

[andersen]

Dear Chris,

I really had follow all step as below the installation.txt


 ==========================================================
                  4images Installation
  ==========================================================

  ----------------------------------------------------------
  Systemvoraussetzungen:
  ----------------------------------------------------------
  - Ein Webserver oder ein Webhosting Account (Empfohlen wird Linux/Apache)
  - PHP Version 4.0.5 oder höher (Empfohlen wird die jeweils aktuellste Version)
  - MySQL Version 3.23 oder höher (Empfohlen wird MySQL Version 3.23.33)

  Optional:
  - ImageMagick (http://www.imagemagick.org) oder GD (http://www.boutell.com/gd)


  ----------------------------------------------------------
  Installation:
  ----------------------------------------------------------
  (Für Update von älteren Versionen siehe unten / For updating from earlier versions see below)

  1. Entpacken Sie das .zip Archiv (z.B. mit WinZip) und übertragen Sie alle Dateien
     in ein geeignetes Verzeichnis auf Ihren Webserver (Achten Sie darauf, dass die
     Verzeichnisstruktur erhalten bleibt) und rufen Sie dieses Verzeichnis
     über Ihren Browser auf.
     ********************************************************
     Decompress the .zip archive to a local directory on your system and FTP all
     the files it contains (being sure to retain the directory structure) to your host.
     Once all the files have been uploaded to your site you should point your browser
     at this location.

  2. Nun erscheint die Installationsmaske von 4images. Tragen Sie alle
     geforderten Daten in das Formular ein und klicken Sie auf "Installation starten".
     ********************************************************
     Now, the Install-Screen comes up. Fill out the required fields and press
     "Start Installation".

  3. Es werden jetzt die benötigten Tabellen in Ihrer Datenbank erstellt und
     Grundeinstellungen vorgenommen.
     ********************************************************
     The installation script will create and populate all the necessary tables in
     your database and some basics settings.

  4. Der Installer erstellt während der Installation eine Konfigurationsdatei mit dem
     Namen config.php im gewählten Installationsverzeichnis.
     Sollte der Installer diese Datei nicht direkt auf Ihrem Server speichern können
     (z.B. wenn er nicht die erforderlichen Schreibrechte besitzt), erscheint am Ende
     der Installation ein Hinweis und die Möglichkeit diese Datei herunterzuladen.
     Laden Sie sich die Datei herunter und übertragen Sie diese auf Ihren Webserver.
     ********************************************************
     The Install-Script will then attempt to write to the config.php file which will
     contain the basic configuration data . If the installer cannot write config.php
     directly you will be given the option of downloading the file. You should then
     re-upload the file to your server, overwriting the existing config.php in the
     process.

  5. Setzen die angegebenen Zugriffsrechte für folgende Verzeichnisse:

     chmod 777 (drwxrwxrwx) : data
     chmod 777 (drwxrwxrwx) : data/database
     chmod 777 (drwxrwxrwx) : data/media
     chmod 777 (drwxrwxrwx) : data/thumbnails
     chmod 777 (drwxrwxrwx) : data/tmp_media
     chmod 777 (drwxrwxrwx) : data/tmp_thumbnails
     chmod 777 (drwxrwxrwx) : templates
     chmod 777 (drwxrwxrwx) : templates/default
     chmod 777 (drwxrwxrwx) : templates/default/media

     Setzen die angegebenen Zugriffsrechte für folgende Dateien:

     chmod 666 (-rw-rw-rw-) : alle Dateien im Verzeichnis "templates/default"
     chmod 666 (-rw-rw-rw-) : alle Dateien im Verzeichnis "templates/default/media"

     Dies können Sie z.B. mit FTP-Programmen wie CuteFTP oder WS_FTP tun.
     ********************************************************
     Set permissions for the following directories:

     chmod 777 (drwxrwxrwx) : data
     chmod 777 (drwxrwxrwx) : data/database
     chmod 777 (drwxrwxrwx) : data/media
     chmod 777 (drwxrwxrwx) : data/thumbnails
     chmod 777 (drwxrwxrwx) : data/tmp_media
     chmod 777 (drwxrwxrwx) : data/tmp_thumbnails
     chmod 777 (drwxrwxrwx) : templates
     chmod 777 (drwxrwxrwx) : templates/default
     chmod 777 (drwxrwxrwx) : templates/default/media

     Set permissions for the following files:

     chmod 666 (-rw-rw-rw-) : all files in the directory "templates/default"
     chmod 666 (-rw-rw-rw-) : all files in the directory "templates/default/media"

     You can do this with FTP programs such as CuteFTP or WS_FTP.

  6. Löschen Sie die Datei "install.php" und alle "update_*_to_*.php" von Ihrem Server.
     Zusätzlich können Sie die Dateien im Ordner "data/database/default" und den
     Ordner "docs" löschen.
     ********************************************************
     You must ensure you remove "install.php" and any "update_*_to_*.php" files.
     Additionally you may delete all files in "data/database/default" and
     the "docs" directory if you wish.

  7. Die Installation ist nun abgeschlossen. Sie können sich nun mit Ihrem bei der
     Installation gewählten Usernamen und Passwort in den Administrationsbereich
     einloggen und unter "Allgemein -> Einstellungen" Die Einstellungen für Ihre Galerie
     vornehmen.
     ********************************************************
     At this point your basic installation is complete. Please be sure to check the
     General Configuration details and make any required changes in your Control Panel.

[andersen]

I really had follow all "chmod" as above installation.txt .

Can u please help me to check, any missing in this installation.txt?

P/s: I am copy and paste to above thread.

[V@no]

DB Error: Bad SQL Query: SELECT cat_id, COUNT(*) AS num_images FROM 4images_images WHERE image_active = 1 GROUP BY cat_id
Table 'mysql.4images_images' doesn't exist

u cannot use mysql database for anything!
u MUST create a new database or use any other already existing databases but mysql

p.s. did u actualy run install.php?

[andersen]

THANK YOU!!!!!!!!

V@no & Chris

Finally I understand 4images database must create a new 1 from mysql!!!!

Very thing done! I look further, see everything fine or not!

Thanks X 1000

[andersen]

I am sorry and for last question about this MySQL database

If setup 3 unit 4Images scritps in one server, can other 2 unit 4Images share with the first MySQL database or I need to create another 2 new databaese?  

[V@no]

basicaly yes, but that such a bad idea, because it will only share the db, but wont share the files itself, that means, when u uploaded an image at one 4images it will be missing in another one.
but, if u want just share users for both galleries, then try this:
http://4homepages.de/forum/viewtopic.php?t=5081

[andersen]

V@no,

Thanks for fast & great respone.

Thanks for the information that you had provided me.

Actually every single problem I had "search" you forum regarding my problem, just sometime I found ton of Q&A is not my need. May be I will repeat some here. (I am not lazy )

A question might be some one interested too...

If my had install example, http://mydomain.com/4images/index.php

Later I had just rename it to http://mydomain.com/photostore/index.php

will my process will have any site effect in future?

Need your hand again.

[V@no]

no, u can copy, move, rename the 4images root folder/dir as u want, just u can not rename any folders inside 4images.