3,239
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
{{usefulnote}}
== PHPMyAdmin for SME Server ==
== PHPMyAdmin for SME Server ==
{{Level|Medium}}
{{Level|Medium}}
---[[User:Unnilennium|Unnilennium]] 13:32, 24 September 2012 (MDT)
---[[User:Unnilennium|Unnilennium]] 13:32, 24 September 2012 (MDT)
}}
}}
{{#smeversion:phpmyadmin|description}}
{{#smeversion:phpMyAdmin|Description}}
{{#smeversion:smeserver-phpmyadmin|description}}
{{#smeversion:smeserver-phpmyadmin|Description}}
=== Maintainer ===
=== Maintainer ===
JP Pialasse (aka Unnilennium)
JP Pialasse (aka Unnilennium)
=== Installation ===
=== Installation ===
= '''For SME8''' =
This contrib can be found in the smecontribs repository. To install this contrib you will have to get shell access as root user, and issue the following command:
This contrib can be found in the smecontribs repository. To install this contrib you will have to get shell access as root user, and issue the following command:
yum --enablerepo=smecontribs install smeserver-phpmyadmin
yum --enablerepo=smecontribs install smeserver-phpmyadmin
On sme8 this will also install the dependencies libmcrypt, php53-mcrypt, php53-php-gettext & phpMyAdmin3
then do either
signal-event post-upgrade; signal-event reboot
signal-event post-upgrade; signal-event reboot
or
or
expand-template /etc/httpd/conf/httpd.conf
expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith restart
service httpd-e-smith restart
= '''For SME9''' =
yum install --enablerepo=smecontribs smeserver-phpmyadmin
then reconfigure
signal-event post-upgrade; signal-event reboot
or if you don't want to restart your server
signal-event phpmyadmin-update
<headertabs/>
=== Configuration ===
=== Configuration ===
{{Tip box| remember that at any time you can see you db configuration by the command "config show phpmyadmin in a root Terminal}}
{{Tip box| remember that at any time you can see you db configuration by the command "config show phpmyadmin in a root Terminal}}
====specific SME Server 9 settings====
Only for SME9 you have some more settings available by DB
# config show phpmyadmin
phpmyadmin=configuration
DbName=phpmyadmin
DbPassword=rvAd9ShvG2GyiWPXiH+oAK3/yk4GwCxDW5PWzy2CWdtMG7zu3SSH7XkJUEV7EpY8HSVaCCHKL//2
DbUser=phpmyadmin
access=private
adminaccess=enabled
multiaccess=disabled
sqladminPassword=mcJ1Tad4I0XENJrl+sfzkKjS8rs4Bq6C0MsjbTkgyv3evFLrPgrXy8eP1u23vANuGtSkQ3//8tmM
status=enabled
* status
You can enable/disable phpmyadmin (enabled|disabled)
config setprop phpmyadmin status disabled
signal-event phpmyadmin-update
* sqladmin
You have a super sql user when you use the cookies authentication mode (phpmyadmin-multi or multiaccess enabled)<br />
login : sqladmin<br />
password : content of the db '''sqladminPassword'''<br />
=== Additional information ===
=== Additional information ===
* '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
* Adminaccess with admin username/password via: https://yourdomain/phpmyadmin
* Adminaccess with admin username/password via: https://yourdomain/phpmyadmin
* multiaccess with the '''Mysql user account of a database''' and its password via: https://your-sme-ip/phpmyadmin-multi
* multiaccess with the '''Mysql user account of a database''' and its password via: https://your-sme-ip/phpmyadmin-multi (or https://yourdomain/phpmyadmin if admin access disabled)
* The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
* The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
* Did we mention : '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
* If you see this error '''#1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist''' when viewing data see a solution here: http://forums.contribs.org/index.php/topic,51696.0.html
More information about PhpMyAdmin can be found on the [http://www.phpmyadmin.net PHPMyAdmin] site.
More information about PhpMyAdmin can be found on the [http://www.phpmyadmin.net PHPMyAdmin] site.
=== Uninstall ===
=== Uninstall ===
yum remove smeserver-phpmyadmin phpmyadmin
yum remove smeserver-phpmyadmin phpMyAdmin3 libmcrypt php53-mcrypt php53-php-gettext
signal-event post-upgrade; signal-event reboot
signal-event post-upgrade; signal-event reboot
=== Bugs ===
=== Bugs ===
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-phpmyadmin component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-phpmyadmin|title=this link}}.
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-phpmyadmin component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-phpmyadmin|title=this link}}.
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |component=smeserver-phpmyadmin |noresultsmessage="No open bugs found."}}
===Changelog===
Only released version in smecontrib are listed here.
{{ #smechangelog: smeserver-phpmyadmin}}
----
----
[[Category: Contrib]]
[[Category: Contrib]]
[[Category: Administration]]
[[Category: Administration]]
