Differences

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

howto:1st_steps 2018/02/12 00:37 howto:1st_steps 2018/02/12 02:17 current
Line 132: Line 132:
    root@joes_nas:~# chmod -x /ffp/start/telnetd.sh     root@joes_nas:~# chmod -x /ffp/start/telnetd.sh
</code> </code>
 +
Line 138: Line 139:
See at http://nas-tweaks.net/CH3SNAS:Tutorials/ffp-packages See at http://nas-tweaks.net/CH3SNAS:Tutorials/ffp-packages
See at http://ffp.wolf-u.li/additional/ See at http://ffp.wolf-u.li/additional/
 +
 +**It appears that inreto.de is no longer accepting connections via rsync.** The following commands are no longer working. If they do not work for you, you can download the packages by some other means (such as wget).
 +
<code> <code>
  $ ssh -l root 10.10.10.123   $ ssh -l root 10.10.10.123
Line 146: Line 150:
</code> </code>
-Note, if you are using the 0.7 version the comand is:+Note, if you are using the 0.7 version the command is:
<code> <code>
rsync -av --delete inreto.de::dns323/fun-plug/0.7/XXXXXXXXXXXXXX/packages/ rsync -av --delete inreto.de::dns323/fun-plug/0.7/XXXXXXXXXXXXXX/packages/
Line 208: 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 215: Line 221:
See at http://forum.dsmg600.info/viewtopic.php?id=3466 See at http://forum.dsmg600.info/viewtopic.php?id=3466
-  * Install PHP <code>+  * Install PHP (**fun_plug** 0.5) <code>
    # funpkg -i /ffp/pkg/additional/dev-lang/php-*.tgz     # funpkg -i /ffp/pkg/additional/dev-lang/php-*.tgz
    # funpkg -i /ffp/pkg/additional/net-misc/curl-*.tgz     # funpkg -i /ffp/pkg/additional/net-misc/curl-*.tgz
</code> </code>
-  * Prepare webserver for PHP <code>+  * Install PHP (**fun_plug** 0.7) <code> 
 +    # funpkg -i /ffp/pkg/packages/php-*.txz 
 +    # funpkg -i /ffp/pkg/packages/curl-*.txz 
 +</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 230: 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 235: 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 247: 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 273: 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 283: 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

Personal Tools