[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 ;)
Codice:
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):
Codice:
$PAGEFUSION["host"] = "www";
$PAGEFUSION["domain"] = "engineering.usu.edu";
$PAGEFUSION["enable_subdomains"] = "N";
$PAGEFUSION["ip"] = "129.123.120.175";
e
Codice:
$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. ;)
