Changes

Jump to navigation Jump to search
541 bytes added ,  09:04, 27 December 2022
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}} | ]]
 
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,250

edits

Navigation menu