3,254
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − {{Warning box|ONLY run smeserver-phpmyadmin-3.5.2.2-1.el5.sme and phpMyAdmin3-3.5.2.2-1.el5 or newer on a SME8. phpmyadmin 2 will corrupt your data if you intend to use it with SME8, as it runs php 5.3 with some deprecated functions missing. − + − + − <br>+ − <br> − <br> − <br> − <br> − <br> − <br> − <br> Line 27:
Line 20: − + Line 40:
Line 33: − + − This contrib is in the [[Stephdl|'''stephdl''']] and [[epel]], you have to enable it before to install the contrib − </noinclude>+ − db yum_repositories set stephdl repository \ − BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \ − EnableGroups no GPGCheck yes \ − Name "Mirror de Labrusse" \ − GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \ − Visible yes status disabled − − /sbin/e-smith/db yum_repositories set epel repository \ − Name 'Epel - EL6' \ − BaseUrl 'http://download.fedoraproject.org/pub/epel/6/$basearch' \ − MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \ − EnableGroups no \ − GPGCheck yes \ − GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \ − Visible no \ − status disabled − − − <noinclude> − After adding it to the database updating the configuration file is required: − signal-event yum-modify − − − + − or+ − expand-template /etc/phpMyAdmin/config.inc.php+ − expand-template /etc/httpd/conf/httpd.conf − service httpd-e-smith restart Line 126:
Line 93: + + + + + + + + + + + + + + + + + + + + + + Line 137:
Line 126: + + Line 146:
Line 137: + + + + + + +
no 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====
= '''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
====For SME9====
= '''For SME9''' =
yum install --enablerepo=smecontribs smeserver-phpmyadmin
yum install --enablerepo=stephdl,epel smeserver-phpmyadmin
then reconfigure
then reconfigure
signal-event post-upgrade; signal-event reboot
signal-event post-upgrade; signal-event reboot
or if you don't want to restart your server
or if you don't want to restart your server
signal-event console-save
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 ===
* 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
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.
=== 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]]