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
 </code>
@@ Line 138: / Line 139: @@
 See at http://nas-tweaks.net/CH3SNAS:Tutorials/ffp-packages
 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>
   $ ssh -l root 10.10.10.123
@@ Line 146: / Line 150: @@
 </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>
 rsync -av --delete inreto.de::dns323/fun-plug/0.7/XXXXXXXXXXXXXX/packages/
@@ Line 208: / Line 212: @@
 </code>
   * 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
-  * Install PHP <code>
+  * Install PHP (**fun_plug** 0.5) <code>
     # funpkg -i /ffp/pkg/additional/dev-lang/php-*.tgz
     # funpkg -i /ffp/pkg/additional/net-misc/curl-*.tgz
 </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
     # 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
+</code>
+  * Copy the php.ini file (**fun_plug** 0.5) <code>
     # 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
     # 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
 ===== Step 11. Add MySQL packages into to Lighttpd =====
@@ Line 235: / Line 264: @@
 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
     # 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
+</code>
+  * Install MySql (**fun_plug** 0.7) <code>
+ # funpkg -i /ffp/pkg/packages/mysql-*.txz
 </code>
@@ Line 247: / Line 280: @@
     # 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 = "./"
-</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/"
 </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/.
-    # 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>
+  * 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>
-    # /ffp/bin/mysql -uroot -ptoor
+    # /ffp/bin/mysql -uroot -p
       mysql> show databases;
       mysql> use mysql;
@@ Line 273: / Line 345: @@
     # 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
@@ Line 283: / Line 356: @@
   * 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;
 </code>
   * Add new user with strictly defined rights <code>
-    # /ffp/bin/mysql -uroot -ptoor
+    # /ffp/bin/mysql -uroot -p
       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 )

Differences

Views

Navigation

Personal Tools

Search

Toolbox