[MySQL] Creare un nuovo database & pagefusion

Salve a tutti,

Io avrei bisogno di creare un nuovo database :D

Io ne ho già uno che si chiama "my_tatosoft", ma adesso avrei bisogno di crearne un altro per far funzionare Pagefusion

Vi riporto la pagina con le istruzioni così forse capirete meglio ;)

Pagefusion; Pagefusion Core Platform
Description: A powerful, easy-to-use, and highly customizable content management system.
Copyright (C), 2006-2007 Pagefusion.com, All Rights Reserved.
Author: Chris Davis, chris@pagefusion.com
Support site: www.pagefusion.com

Filename: /install.txt
Description: installation procedure

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
---

Server-specific requirements:

	1. Access rights to Unix or Linux web server via FTP or file share.
	2. Latest, stable version of PHP (tested with PHP 4.3.8).
	3. MySQL server 3.23 or later (and access rights via MySQL Monitor (shell) or web-based access via phpMyAdmin, or other management application).

Optional (not required) libraries used for additional functionality:

	1. ImageMagick library for dynamic image resizing. See http://www.imagemagick.org for details.
	2. PHP compiled with GD2 extension for dynamic image generation. See http://www.boutell.com/gd for details.
	3. InfoZip's zip and unzip for archive compression and decompression.

Browser compatibility requirements (tested with):

	Internet Explorer 5+
	Internet Explorer 5.2.3 for Mac
	Gecko-based (including Mozilla, Firefox, Netscape, and Safari)
	Opera 6+

Browser DOM requirements:

	Cascading Style Sheets (CSS2)
	Javascript 1.2+
	Cookies

---
NOTE: Pagefusion Platform Core is released as a traditional zip archive (pagefusion_core_[version].zip), a
rar archive (pagefusion_core_[version].rar) or as a GNU TAR archive (pagefusion_core_[version].tar.gz). This
archive is the Pagefusion "core" or files necessary to administer the Pagefusion platform. Additional
content modules are available for immediate download through the Pagefusion Update Network. This is
accessible from the Pagefusion Toolbar (Host > Pagefusion Update) after installing and logging into the platform as
Host Administrator.

Be sure to check the zip archive's MD5 hash to verify that the file originated from http://www.pagefusion.com.

Installation:

	1. Transfer and decompress the archive into your web server's document root directory (or subdirectory where your
	   domain name points to). In this document, all filenames such as "/sql/pagefusion.sql", or "/index.php" are
	   displayed with their path location relative to the document root folder.

	   For example, your web server has document root specified as: "/home/pagefusion/htdocs", therefore
           "/home/pagefusion/htdocs" is the "document root" of your web server, or rather, the folder that begins
           the hierarchy of folders and sub-folders that your web server is allowed to serve from.
           Knowing this, you could install Pagefusion in "/home/pagefusion/htdocs" and when a filename is given
           in the documentation below, such as "/sql/pagefusion.sql", you immediately know
	   that the file location on your server refers to "/home/pagefusion/htdocs/sql/pagefusion.sql".

		# apache virtual host example:

		<VirtualHost *:80>
			ServerAdmin chris@pagefusion.com
			ServerName pagefusion.com
			ServerAlias *.pagefusion.com
			DocumentRoot /home/pagefusion/htdocs
			ServerPath /
		<VirtualHost />
		
			
	2. If you use a third-party hosting service, you may not be able to set file permissions on the web server, however,
	   most of these services automatically set the correct file permissions for uploaded files. If you use a
	   third-party hosting service, skip to step #4.
	
	3. If you're running Pagefusion on a Unix or Linux server, login to the web server via shell and go to
           the document root directory. Run the following commands below CHANGING "username" TO YOUR FTP/SHELL
           ACCOUNT USERNAME and "www-data" TO YOUR WEB SERVER'S DAEMON GROUP respectively.
			
		$ cd /home/pagefusion/htdocs (OR your web server's document root folder)
		$ chown -R username.www-data *
		$ chmod -R 770 components
		$ chmod -R 770 libraries
		$ chmod -R 770 modules
		$ chmod -R 770 portals
		$ chmod -R 770 skins

		So, basically, you've got to allow the web server to read and write to all Pagefusion files if you want to
                use Pagefusion's Update Network.

	4. Now, open the file /config.php and change the variable values to reflect your particular setup. Read the
	   comments in this file for further direction.

           NOTE: If you work at a University, or office location where you DO NOT have control over Domain Name Services (i.e. www.usu.edu) and
           are, for example, installing Pagefusion on a server assigned the domain name "www.engineering.usu.edu" that has the IP address of
           129.123.120.175, set the following configuration variables accordingly:

           $PAGEFUSION["host"] = "www";
           $PAGEFUSION["domain"] = "engineering.usu.edu";
           $PAGEFUSION["enable_subdomains"] = "N";
           $PAGEFUSION["ip"] = "129.123.120.175";


	5. Next, create a MySQL database called "pagefusion" or create the database name you specified in /config.php. Also,
           allow access to the user you specified in /config.php. If you use a 3rd-party hosting solution, see if
           they offer access to PHPMyAdmin (most do) or simply contact their tech support to receive help on creating a MySQL database.
	   
	   If you have access to the MySQL Monitor (from the Unix/Linux command line), you may use the following example, otherwise, after using
           PHPMyAdmin, or your hosting provider's tech support to setup the MySQL host, database name, database username and password,
           continue to step #6:
  
	   The following is assumed:
	   - In /config.php, you defined the following:
	     	 $PAGEFUSION["dbhost"] = "localhost";
		 $PAGEFUSION["dbname"] = "pagefusion";
		 $PAGEFUSION["dbuser"] = "www";
		 $PAGEFUSION["dbpass"] = "abc123";
		  
           - Log into the MySQL Monitor:
	   $ ./mysql -uroot -p[root password]
	   
	   - Create the user "www" with the password "abc123" for the database "pagefusion" on "localhost":
	   mysql> GRANT USAGE ON `pagefusion`.* TO 'www'@'localhost' IDENTIFIED BY 'abc123';
	   
	   - Grant user "www" permission to execute the following operations on database "pagefusion":
	   mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `pagefusion`.* TO 'pagefusion'@'localhost';
	   
	   - Log out of the MySQL Monitor
	   mysql> quit;
	
	6. Point your browser to Pagefusion's /index.php (i.e. http://www.yourdomain.com/index.php). If you've set up your
	   /config.php and MySQL database correctly, you should be greeted with an install/license page. If you DO NOT see this page, or
	   encounter other errors, repeat steps 1 through 5 or go to the community forum board located on http://www.pagefusion.com
	   for further help.
	   
	   Place a check mark in the box next to the phrase "I agree with the terms listed above:" and then press the "Continue" button to
           proceed to the next tab/page.

           Read and pay close attention to the settings shown under the "Configuration Check" section. If any alerts or errors are shown, a
           solution will be recommended.
           
           Next, in the "Host Setup" section, fill in the fields displayed. This will set up your Host Administrator account.
	   
	   Next, after pressing the "Install Platform" button, you'll be redirected to the front page of your first portal. You can extend the 
           "yellow message banner" to see all messages returned from the installation process by simply clicking on it. Log in using the username
	   and password you specified for the Host Administrator account and you will be presented with the Pagefusion toolbar at the
           top of your browser.
	   
	   From the Pagefusion toolbar, go to Help > Documentation, or Help > Tutorials for details on how to understand and use Pagefusion.

---			
For more answers to your questions, please see the community forum located on http://www.pagefusion.com.

---
install.txt, revised 2006-10-03	by Chris Davis, chris@pagefusion.com

Ma ho anche un altro dubbio che riguarda (le parti in grassetto):

           $PAGEFUSION["host"] = "www";
           $PAGEFUSION["domain"] = "engineering.usu.edu";
           $PAGEFUSION["enable_subdomains"] = "N";
           $PAGEFUSION["ip"] = "129.123.120.175";

e

	     	 $PAGEFUSION["dbhost"] = "localhost";
		 $PAGEFUSION["dbname"] = "pagefusion";
		 $PAGEFUSION["dbuser"] = "www";
		 $PAGEFUSION["dbpass"] = "abc123";

Considerate che voglio fare il tutto sotto un dominio di 3° Livello.

Come dovrei fare?

Grazie a tutti. ;)

[funcool]

Non puoi creare un altro database.
Per il secondo problema leggi qui.

Peccato, mi serviva creare un nuovo database :(

Proverò a piazzarlo nel mio. ;)

Però l'IP del mio dominio AV come lo ricavo?

[funcool]

Però l'IP del mio dominio AV come lo ricavo?

Metti localhost.

se intendi conoscere l'indirizzo per la connessione questo è localhost sempre!

Innanzitutto vi ringrazio demenziale e funcool. ;)

VI farò sapere com'e' andata. :D


EDIT: Ok ieri ci ho provato ma è andata a buca :(

Quindi aspetterò ulteriori aggiornamenti da AV per far fungere Pagefusion


FunCool: Non fare UP, usa il tasto Edita.

Che problemi hai avuto?
Forse se posti gli errori riusciamo a risolvere il problema.

Semplicemente quando avviavo Pagefusion dopo aver moddato il file Config.php e messo tutti i file nella Directory non partiva vedevo solo una pagina bianca :(

Forse sbaglio qualcosa non so. :(

Cmq nel caso voleste provare vi linko qua: www.pagefusion.com

il link che hai postato è visibile forse non c'entra una mazza?

se vedi una pagina bianca (mi ricordo da un post vecchio) il problema puo' essere risolto cambiando i permessi dei file interessati (chmod 777 nomeDelFile o qualcosa del genere)

ciao