manuel setup for phpmyadmin - step by step

rampa99 · ‎2013-03-31

Just thought it could be useful for some. A simple step by step "how to" to setup php & phpmyadmin on a readynas duo v2. Of course, you follow my instructions at your own risks, & i wont be responsible should your nas crash, bricks, become sentient or kill your cat.

0. starting point :
0.1 Matériel: Readnyas duo v2 up-to-date with both netgear photo modules (so mysql is up and running) and Photo II et SSLConnect activés,
0.2 Softs : PuTTy, Notepad++, Filezilla
0.3 Sources : Many thanks to kiokoman & loustik, whose ideas i just test and reordered.
0.3.1 http://www.readynas.com/forum/viewtopic.php?t=63434 / kiokoman
0.3.2 http://www.readynas.com/forum/viewtopic.php?f=36&t=48440 / loustik

1. Package installation using PuTTy
1.1

apt-get update #to make sure your nas got the last packages

1.2

apt-get install -f

#fix broken/missing packages http://www.readynas.com/forum/viewtopic.php?t=63434
1.3

apt-get install nano libapache2-mod-php5 php5 php5-mysql php5-gd phpmyadmin

#install php & phpmyadmin
1.4 When ask, let phpmyadmin selfconfigure and type your admin password

2. setup Php
2.1 open /etc/frontview/apache/httpd.conf
one may use nano & Putty

nano /etc/frontview/apache/httpd.conf

ou use (like me) Filezilla via an SFTP account to edit and backup via your favorite tool (Notepad++ via windows for me)

2.2 after LoadModule addonhandler_module /frontview/lib/mod_addonhandler.so (ligne 22), add

LoadModule php5_module /usr/lib/apache2/modules/libphp5.so
		AddType application/x-httpd-php .php
		PHPIniDir /etc/php5/apache2

2.3 At the end of the file, add

# Ajout Phpmyadmin
Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
        Options FollowSymLinks
        DirectoryIndex index.php

        <IfModule mod_php5.c>
                AddType application/x-httpd-php .php

                php_flag magic_quotes_gpc Off
                php_flag track_vars On
                php_flag register_globals Off
                php_value include_path .
        </IfModule>

</Directory>

# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
    <IfModule mod_authn_file.c>
    AuthType Basic
    AuthName "phpMyAdmin Setup"
    AuthUserFile /etc/phpmyadmin/htpasswd.setup
    </IfModule>
    Require valid-user
</Directory>

# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/libraries>
    Order Deny,Allow
    Deny from All
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
    Order Deny,Allow
    Deny from All
</Directory>

3. restart apache using PuTTy so the modifications are activated

killall apache-ssl
apache-ssl -f /etc/frontview/apache/httpd.conf

4. Php is now running and phpmyadmin accessible via http://ip-readynas/phpmyadmin, but no user is defined

5. create a user (TOTO / PASSWORD_TOTO) via PuTTy

mysql -u root
GRANT ALL PRIVILEGES ON *.* TO 'TOTO'@'localhost' IDENTIFIED BY 'PASSWORD_TOTO' WITH GRANT OPTION;

6. Remember why you wanted to install phpmyadmin in the first place and start using it 😉