Line 7: |
Line 7: |
| {{#vardefine:lang| {{lc: {{#titleparts: {{PAGENAME}} | | -1}} }} |en }} | | {{#vardefine:lang| {{lc: {{#titleparts: {{PAGENAME}} | | -1}} }} |en }} |
| {{Infobox contribs | | {{Infobox contribs |
− | |name={{#var:contribname}} | + | | name = {{#var:contribname}} |
− | |image={{#var:contribname}}.jpg | + | | image = {{#var:contribname}}.jpg |
− | |description_image= {{#var:contribname}} logo | + | | description_image = {{#var:contribname}} logo |
− | |maintainer= Unnilennium | + | | maintainer = Unnilennium |
− | |licence= GNU General Public License | + | | licence = GNU General Public License |
− | |url= https://wiki.koozali.org | + | | url = https://github.com/phppgadmin/phppgadmin/ |
− | |category= Category you want | + | | video = |
− | |tags=File,this,with,a,list,of,tags | + | | category = databases |
| + | | tags = pgsql,Postgresql |
| }} | | }} |
| | | |
Line 28: |
Line 29: |
| === Description === | | === Description === |
| <!-- add a description here --> | | <!-- add a description here --> |
− | phpPgAdmin is a mature web-based administration tool for PostgreSQL, for more information on phpPgAdmin, check out our project page at https://github.com/phppgadmin/phppgadmin/ | + | phpPgAdmin is a mature web-based administration tool for PostgreSQL, for more information on phpPgAdmin |
| | | |
| === Installation === | | === Installation === |
| <tabs container style="display: inline-block;" ><tab name="For SME 10"> | | <tabs container style="display: inline-block;" ><tab name="For SME 10"> |
| yum --enablerepo=smecontribs install {{#var:smecontribname}} | | yum --enablerepo=smecontribs install {{#var:smecontribname}} |
− | </tab></tabs> | + | </tab></tabs>then you can point your browser to <nowiki>https://URL/phppgadmin/</nowiki> and use admin as user and password from |
| + | |
| + | config getprop {{#var:contribname}} Password |
| | | |
| === Configuration === | | === Configuration === |
Line 46: |
Line 49: |
| ! | | ! |
| |- | | |- |
− | |DbName | + | |Password |
− | |nextcloud
| |
− | |string
| |
− | |for mysql db
| |
− | |-
| |
− | |DbPassword
| |
| |GENERATED | | |GENERATED |
− | |string
| |
− | |for mysql db
| |
− | |-
| |
− | |DbUser
| |
− | |nextcloud
| |
| |string | | |string |
| |for mysql db | | |for mysql db |
Line 71: |
Line 64: |
| |} | | |} |
| | | |
| + | you can also alter php-fpm value if needed for php. |
| + | |
| + | |
| + | allow public access |
| + | config setprop phppgadmin access public |
| + | signal-event smeserver-phppgadmin-update |
| + | disable the web access |
| + | config setprop phppgadmin status disabled |
| + | signal-event smeserver-phppgadmin-update |
| + | |
| + | === Connect as super user === |
| + | at your own risks<syntaxhighlight lang="bash"> |
| + | sudo -Hiu postgres $psql -c "ALTER ROLE admin WITH superuser;" |
| + | </syntaxhighlight>remove this<syntaxhighlight lang="bash"> |
| + | sudo -Hiu postgres $psql -c "ALTER ROLE admin WITH nosuperuser;" |
| | | |
| + | </syntaxhighlight> |
| | | |
| === Uninstall === | | === Uninstall === |
Line 93: |
Line 102: |
| <!-- Please keep there the template revision number as is --> | | <!-- Please keep there the template revision number as is --> |
| [[contribtemplate::2| ]] | | [[contribtemplate::2| ]] |
− | [[contriblang:: {{#var:lang}} | ]]
| |