Differences

This shows you the differences between the selected revision and the current version of the page.

howto:1st_steps 2018/02/12 00:50 howto:1st_steps 2018/02/12 02:17 current
Line 212: Line 212:
</code> </code>
  * Test webserver \\ Navigate browser to http://10.10.10.123:8080 and read the page   * Test webserver \\ Navigate browser to http://10.10.10.123:8080 and read the page
 +
Line 230: Line 231:
</code> </code>
-  * Prepare webserver for PHP <code>+  * Prepare webserver for PHP (**fun_plug** 0.5 and **fun_plug** 0.7) <code>
    # cp /ffp/etc/examples/lighttpd.conf-with-php /ffp/etc/lighttpd.conf     # cp /ffp/etc/examples/lighttpd.conf-with-php /ffp/etc/lighttpd.conf
    # sed -i s/#server.username.*/'server.username            = "www-data"'/ /ffp/etc/lighttpd.conf     # sed -i s/#server.username.*/'server.username            = "www-data"'/ /ffp/etc/lighttpd.conf
    # sed -i s/#server.groupname.*/'server.groupname            = "www-data"'/ /ffp/etc/lighttpd.conf     # sed -i s/#server.groupname.*/'server.groupname            = "www-data"'/ /ffp/etc/lighttpd.conf
 +</code>
 +
 +  * Copy the php.ini file (**fun_plug** 0.5) <code>
    # cp /ffp/etc/examples/php.ini-dist /ffp/etc/php.ini     # cp /ffp/etc/examples/php.ini-dist /ffp/etc/php.ini
 +</code>
 +
 +  * Copy the php.ini file (**fun_plug** 0.7) <code>
 +    # cp /ffp/etc/examples/php.ini-production /ffp/etc/php.ini
 +</code>
 +
 +  * Build a test PHP page and restart lighttpd. (**fun_plug** 0.5 and **fun_plug** 0.7) <code>
    # echo "<?php phpinfo(); ?>" > /mnt/HD_a2/www/pages/a.php     # echo "<?php phpinfo(); ?>" > /mnt/HD_a2/www/pages/a.php
    # sh /ffp/start/lighttpd.sh restart     # sh /ffp/start/lighttpd.sh restart
Line 240: Line 251:
  * Test PHP in webserver \\ Navigate browser to http://10.10.10.123:8080/a.php and read the page   * Test PHP in webserver \\ Navigate browser to http://10.10.10.123:8080/a.php and read the page
 +
 +
 +
 +
 +
 +
 +
 +
===== Step 11. Add MySQL packages into to Lighttpd ===== ===== Step 11. Add MySQL packages into to Lighttpd =====
Line 245: Line 264:
See at http://forum.dsmg600.info/viewtopic.php?id=3466 See at http://forum.dsmg600.info/viewtopic.php?id=3466
-  * Install MySql <code>+  * Install MySql (**fun_plug** 0.5) <code>
    # cd /mnt/HD_a2/ffp/pkg     # cd /mnt/HD_a2/ffp/pkg
    # wget http://81.216.140.39/dns-323/mysql_and_php/mysql-5.1.28-rc-1.tgz     # wget http://81.216.140.39/dns-323/mysql_and_php/mysql-5.1.28-rc-1.tgz
    # funpkg -i mysql-5.1.28-rc-1.tgz     # funpkg -i mysql-5.1.28-rc-1.tgz
 +</code>
 +
 +  * Install MySql (**fun_plug** 0.7) <code>
 + # funpkg -i /ffp/pkg/packages/mysql-*.txz
</code> </code>
Line 257: Line 280:
    # vi /ffp/etc/php.ini     # vi /ffp/etc/php.ini
-</code> comment extension dir line <code>+</code> 
 + 
 +Comment extension dir line. This line is under the //Paths and Directories// heading, which is 42% of the way through the file.<code>
    ;extension_dir = "./"     ;extension_dir = "./"
-</code> and below that, add extension dir with path /ffp/lib/php/extensions/no-debug-non-zts-20060613/ <code>+</code> 
 + 
 +Below it, add a new extension directory path. (**fun_plug** 0.5) <code>
    extension_dir = "/ffp/lib/php/extensions/no-debug-non-zts-20060613/"     extension_dir = "/ffp/lib/php/extensions/no-debug-non-zts-20060613/"
</code> </code>
-  * Prepare MySQL. Be careful, initial password setting is possible only at the first time <code>+Below it, add a new extension directory path. (**fun_plug** 0.7) <code> 
 +    extension_dir = "/ffp/lib/php/extensions/no-debug-non-zts-20090626/" 
 +</code> 
 + 
 +  * Copy the my.cnf template. (**fun_plug** 0.5) <code>
    # cp /ffp/etc/examples/my.cnf /ffp/etc/.     # cp /ffp/etc/examples/my.cnf /ffp/etc/.
-    # sh /ffp/start/mysqld.sh start+</code>
-    # mysql_secure_installation +  * Copy the my.cnf template. (**fun_plug** 0.7) <code> 
-    # mysql_install_db+    # cp /ffp/etc/examples/mysql/my-small.cnf /ffp/etc/my.cnf
</code> </code>
 +  * Edit the my.cnf template. Here is how it looks before editing. (**fun_plug** 0.7)
 +<code>
 +    # The MySQL server
 +    [mysqld]
 +    port = 3306
 +    socket = /ffp/var/run/mysql/mysql.sock
 +    skip-locking
 +    key_buffer_size = 16K
 +</code>
 +
 +  * This is what it should look like after editing. A //datadir// row has been added, and //skip-locking// has been changed to //skip-external-locking//. (**fun_plug** 0.7)
 +<code>   
 +    # The MySQL server
 +    [mysqld]
 +    port = 3306
 +    socket = /ffp/var/run/mysql/mysql.sock
 +    datadir = /ffp/var/lib/mysql
 +    skip-external-locking
 +    key_buffer_size = 16K
 +</code>
 +
 +Create space for logs, then initialize the data directory. (**fun_plug** 0.7) <code>
 +    # mkdir -p /srv/mysql
 +    # mysql_install_db --datadir=/ffp/var/lib/mysql
 +</code>
 +
 +Prepare MySQL. Be careful, initial password setting is possible only at the first time
 +<code>
 +    # sh /ffp/start/mysqld.sh start
 +    # mysql_secure_installation
 +</code>
  * Test MySQL local connection <code>   * Test MySQL local connection <code>
-    # /ffp/bin/mysql -uroot -ptoor+    # /ffp/bin/mysql -uroot -p
      mysql> show databases;       mysql> show databases;
      mysql> use mysql;       mysql> use mysql;
Line 283: Line 345:
    # sh /ffp/start/lighttpd.sh restart     # sh /ffp/start/lighttpd.sh restart
</code> Navigate browser to http://10.10.10.123:8080/a.php and see mysql section at the page </code> Navigate browser to http://10.10.10.123:8080/a.php and see mysql section at the page
 +
Line 293: Line 356:
  * Allow user 'root' to connect remotely, for instance to administrate MySQL with graphical tools (SQLYog mysqladmin) <code>   * Allow user 'root' to connect remotely, for instance to administrate MySQL with graphical tools (SQLYog mysqladmin) <code>
-    # /ffp/bin/mysql -uroot -ptoor +    # /ffp/bin/mysql -uroot -p 
-      mysql> GRANT ALL ON *.* TO root@'10.10.10.150'IDENTIFIED BY 'toor' ;+      mysql> GRANT ALL ON *.* TO root@'10.10.10.150'IDENTIFIED BY 'put-your-root-password-here' ;
      mysql> FLUSH PRIVILEGES;       mysql> FLUSH PRIVILEGES;
</code> </code>
  * Add new user with strictly defined rights <code>   * Add new user with strictly defined rights <code>
-    # /ffp/bin/mysql -uroot -ptoor+    # /ffp/bin/mysql -uroot -p
      mysql> INSERT INTO mysql.user       mysql> INSERT INTO mysql.user
( HOST, USER, PASSWORD, select_priv, insert_priv, update_priv, delete_priv,  create_priv, drop_priv, reload_priv, shutdown_priv, process_priv,  file_priv, grant_priv, references_priv, index_priv, alter_priv, show_db_priv, super_priv, create_tmp_table_priv, lock_tables_priv, execute_priv, repl_slave_priv, repl_client_priv, create_view_priv, show_view_priv, create_routine_priv, alter_routine_priv, create_user_priv, event_priv, trigger_priv ) ( HOST, USER, PASSWORD, select_priv, insert_priv, update_priv, delete_priv,  create_priv, drop_priv, reload_priv, shutdown_priv, process_priv,  file_priv, grant_priv, references_priv, index_priv, alter_priv, show_db_priv, super_priv, create_tmp_table_priv, lock_tables_priv, execute_priv, repl_slave_priv, repl_client_priv, create_view_priv, show_view_priv, create_routine_priv, alter_routine_priv, create_user_priv, event_priv, trigger_priv )

Navigation
[Edit]
Personal Tools