Changes

From SME Server
Jump to navigationJump to search

PHPMyAdmin (view source)

Revision as of 15:35, 26 July 2016

163 bytes added ,  15:35, 26 July 2016
no edit summary
Line 1: Line 1:  +
{{usefulnote}}
 
== PHPMyAdmin for SME Server ==
 
== PHPMyAdmin for SME Server ==
 
{{Level|Medium}}
 
{{Level|Medium}}
−
{{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.
      
---[[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}}
−
<br>
+
 
−
<br>
  −
<br>
  −
<br>
  −
<br>
  −
<br>
  −
<br>
  −
<br>
   
=== Maintainer ===
 
=== Maintainer ===
 
JP Pialasse (aka Unnilennium)
 
JP Pialasse (aka Unnilennium)
Line 27: Line 20:  
=== 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
Line 40: Line 33:  
  service httpd-e-smith restart
 
  service httpd-e-smith restart
   −
====For SME9====
+
= '''For SME9''' =
−
 
  −
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
     −
 
+
  yum install --enablerepo=smecontribs smeserver-phpmyadmin
−
<noinclude>
  −
After adding it to the database updating the configuration file is required:
  −
signal-event yum-modify
  −
 
  −
  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 phpmyadmin-update
 
  signal-event phpmyadmin-update
 +
 +
<headertabs/>
    
=== Configuration ===
 
=== Configuration ===
Line 122: Line 93:     
{{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 ===
Line 133: Line 126:     
* 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.
Line 142: Line 137:  
=== 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]]
Unnilennium
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,233

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/25279...31736"

Navigation menu