Difference between revisions of "Phppgadmin"
From SME Server
Jump to navigationJump to searchUnnilennium (talk | contribs) (Created page with "{{Languages}} <!-- here we define the contrib name variable --> <!-- we get the page title, remove suffix for translated version; if needed you can define there with the value...") |
Unnilennium (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| 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:// | + | | url = https://github.com/phppgadmin/phppgadmin/ |
| − | |category= | + | | video = |
| − | |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 | + | 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: | ||
! | ! | ||
|- | |- | ||
| − | | | + | |Password |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|GENERATED | |GENERATED | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|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| ]] | ||
| − | |||
Latest revision as of 08:04, 27 December 2022
 | |
| phppgadmin logo | |
| Maintainer | Unnilennium |
|---|---|
| Url | https://github.com/phppgadmin/phppgadmin/ |
| Licence | GNU General Public License |
| Category | |
| Tags | pgsql, Postgresql |
Maintainer
Version
Description
phpPgAdmin is a mature web-based administration tool for PostgreSQL, for more information on phpPgAdmin
Installation
yum --enablerepo=smecontribs install smeserver-phppgadmin
then you can point your browser to https://URL/phppgadmin/ and use admin as user and password from
config getprop phppgadmin Password
Configuration
you can list the available configuration with the following command :
config show phppgadmin
Some of the properties are not shown, but are defaulted in a template or a script. Here a more comprehensive list with default and expected values :
| property | default | values | |
|---|---|---|---|
| Password | GENERATED | string | for mysql db |
| access | private | private, public | |
| status | enabled | enabled,disabled |
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
sudo -Hiu postgres $psql -c "ALTER ROLE admin WITH superuser;"
remove this
sudo -Hiu postgres $psql -c "ALTER ROLE admin WITH nosuperuser;"
Uninstall
yum remove smeserver-phppgadmin phppgadmin
Bugs
Please raise bugs under the SME-Contribs section in bugzilla
and select the smeserver-phppgadmin component or use this link
Below is an overview of the current issues for this contrib:
No open bugs found.
Changelog
Only released version in smecontrib are listed here.
smeserver-phppgadmin Changelog: SME 10 (smecontribs)
2022/12/26 Jean-Philippe Pialasse 1.5.0-1
- initial release for SME 10
- initial release for SME 10
2020/07/05 stephane de Labrusse 1.0.2
- Remove http templates after rpm removal
- Remove http templates after rpm removal
2020/03/05 stephane de Labrusse 1.0.1-1.ns7
- Fix bad sudoers permission
- Fix bad sudoers permission
2019/10/14 Stephane de Labrusse 0.0.4-1.ns7
- cockpit. added to legacy apps
- cockpit. added to legacy apps
2017/09/10 Stephane de Labrusse - 0.0.3-1.ns7
- Restart httpd service on trusted-network
- Restart httpd service on trusted-network
