https://wiki.archlinux.org/api.php?action=feedcontributions&user=Kurtis&feedformat=atomArchWiki - User contributions [en]2024-03-28T23:55:57ZUser contributionsMediaWiki 1.41.0https://wiki.archlinux.org/index.php?title=Talk:PhpMyAdmin&diff=256203Talk:PhpMyAdmin2013-05-06T00:24:33Z<p>Kurtis: /* Helpful info regarding config file, open_basedir, and a sample Nginx "sub-folder" */ new section</p>
<hr />
<div>'''I have just installed mysql, and I've got''' <br />
<br />
#mysql -u root<br />
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)<br />
<br />
<br />
'''Thanks to the wiki i've done:'''<br />
<br />
General MySQL Connectivity<br />
<br />
Check /var/run/mysqld for mysqld.sock and /tmp for mysql.sock. If mysql.sock doesn't exist, create a softlink:<br />
<br />
# ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock<br />
<br />
Then restart the daemon:<br />
<br />
# /etc/rc.d/mysqld restart<br />
<br />
<br />
'''But should the mysql package do this?'''<br />
<br />
<br />
<br />
== typo? ==<br />
<br />
in the section that begins with;<br />
<br />
Use for PHP 5.x:<br />
<br />
AddHandler php5-script php<br />
<br />
to <br />
<br />
AddHandler php5-script .php<br />
<br />
:It's the same, see the official documentation: http://httpd.apache.org/docs/2.2/mod/mod_mime.html#addhandler<br />
:"The extension argument is case-insensitive and can be specified with or without a leading dot." -- [[User:Kynikos|Kynikos]] 04:35, 4 June 2011 (EDT)<br />
<br />
== deny from all (.htaccess for phpmyadmin) ==<br />
<br />
Commenting out 'deny from all' as the article states will allow ''everyone'' access. Wouldn't a safer way to do this be:<br />
deny from all<br />
allow from localhost<br />
allow from 192.168.1.0/24<br />
Or something to this extent? [[User:Axanon|Axanon]] 06:54, 19 June 2011 (EDT)<br />
<br />
== Helpful info regarding config file, open_basedir, and a sample Nginx "sub-folder" ==<br />
<br />
I ran into some issues while configuring. It took me a really long time to realize why my config.inc.php file wasn't being read after updating it.<br />
<br />
The Wiki page currently states:<br />
<br />
Update open_basedir in /etc/php/php.ini and add "/usr/share/webapps/".<br />
<br />
It should emphasize that /etc/webapps is needed. This is very important and I spent a lot of time debugging.<br />
<br />
The wiki page should mention that the configuration file is located in /etc/webapps/phpmyadmin (unless it already does. Maybe I overlooked it?)<br />
<br />
Also, here is a sample configuration for using PHPMyAdmin as a sub-folder instead of a document root. It assumes PHPMyAdmin is linked at /srv/http/phpmyadmin. This may not be perfect but it is working for me. It follows the current configuration instructions and doesn't stray away from them as far as I can tell.<br />
<br />
server {<br />
location /phpmyadmin {<br />
root /srv/http/;<br />
index index.php;<br />
}<br />
location ~ ^/phpmyadmin.+.php$ {<br />
root /srv/http/; # Assumes PHPMyAdmin is linked at /srv/http/phpmyadmin<br />
fastcgi_pass unix:/var/run/php-fpm/php-fpm.sock;<br />
fastcgi_index index.php;<br />
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;<br />
include fastcgi_params;<br />
}<br />
}<br />
<br />
--[[User:Kurtis|Kurtis]] ([[User talk:Kurtis|talk]]) 00:24, 6 May 2013 (UTC)</div>Kurtis