3,240
edits
Changes
From SME Server
Jump to navigationJump to search→Installation
{{usefulnote}}
{{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]]<nowiki> 13:32, 24 September 2012 (MDT)
}}
}}</nowiki>
{{#smeversion:phpMyAdmin|Description}}
{{#smeversion:phpMyAdmin|Description}}
{{#smeversion:smeserver-phpmyadmin|Description}}
{{#smeversion:smeserver-phpmyadmin|Description}}
=== Maintainer ===
===Maintainer===
JP Pialasse (aka Unnilennium)
JP Pialasse (aka Unnilennium)
=== Description ===
===Description===
PHPMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.
PHPMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.
This contrib provides PHPMyAdmin for SME Server.
This contrib provides PHPMyAdmin for SME Server.
=== Installation ===
===Installation===
= '''For SME10''' =
='''For SME10'''=
yum install --enablerepo=smecontribs smeserver-phpmyadmin
yum install --enablerepo=smecontribs smeserver-phpmyadmin
then configure according to your needs
= '''For SME9''' =
='''For SME9'''=
signal-event phpmyadmin-update
signal-event phpmyadmin-update
= '''For SME8''' =
='''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
service httpd-e-smith restart
service httpd-e-smith restart
<headertabs/>
<headertabs />
=== Configuration ===
===Configuration===
By default, access to phpmyadmin is restricted to the local network, and to any trusted networks. To make phpmyadmin accessible to external networks (the internet), the configuration parameter for access has to be changed. Changing this parameter requires you to use the SME Server shell.
By default, access to phpmyadmin is restricted to the local network, and to any trusted networks. To make phpmyadmin accessible to external networks (the internet), the configuration parameter for access has to be changed. Changing this parameter requires you to use the SME Server shell.
sqladminPassword=mcJ1Tad4I0XENJrl+sfzkKjS8rs4Bq6C0MsjbTkgyv3evFLrPgrXy8eP1u23vANuGtSkQ3//8tmM
sqladminPassword=mcJ1Tad4I0XENJrl+sfzkKjS8rs4Bq6C0MsjbTkgyv3evFLrPgrXy8eP1u23vANuGtSkQ3//8tmM
status=enabled
status=enabled
* status
*status
You can enable/disable phpmyadmin (enabled|disabled)
You can enable/disable phpmyadmin (enabled|disabled)
config setprop phpmyadmin status disabled
config setprop phpmyadmin status disabled
signal-event phpmyadmin-update
signal-event phpmyadmin-update
* sqladmin
*sqladmin
You have a super sql user when you use the cookies authentication mode (phpmyadmin-multi or multiaccess enabled)<br />
You have a super sql user when you use the cookies authentication mode (phpmyadmin-multi or multiaccess enabled)<br />
login : sqladmin<br />
login : sqladmin<br />
password : content of the db '''sqladminPassword'''<br />
password : content of the db '''sqladminPassword'''<br />
* Blowfish secret
*Blowfish secret
Starting SME10, you also have a secret generated,for blowfish, but you can change it if you want.
Starting SME10, you also have a secret generated,for blowfish, but you can change it if you want.
BlowfishSecret=ssdfgsdg/sdfgsdffgsdrtert546y654bttbt
BlowfishSecret=ssdfgsdg/sdfgsdffgsdrtert546y654bttbt
=== Additional information ===
===Additional information===
* '''NEVER''' MODIFY MYSQL ROOT user PASSWORD
*'''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 (or https://yourdomain/phpmyadmin if admin access disabled)
*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
*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
*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 phpMyAdmin
yum remove phpMyAdmin
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."}}
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |component=smeserver-phpmyadmin |noresultsmessage="No open bugs found."}}
Only released version in smecontrib are listed here.
Only released version in smecontrib are listed here.
{{ #smechangelog: smeserver-phpmyadmin}}
{{#smechangelog: smeserver-phpmyadmin}}
----
----
[[Category: Contrib]]
[[Category: Contrib]]
[[Category: Administration]]
[[Category: Administration]]
