Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
docker_notes:docker-mailserver [2026-08-22 Sat wk34 10:00] – [Docker mailserver] baumkpdocker_notes:docker-mailserver [2026-08-23 Sun wk34 19:41] (current) – [ISPmail Admin] baumkp
Line 224: Line 224:
 I will setup DNS and Traefik for this to be ''mailadmin.local.kptree.net''.  This will only be accessible on the LAN. I will setup DNS and Traefik for this to be ''mailadmin.local.kptree.net''.  This will only be accessible on the LAN.
 Admin user is mailserver with associated password. Admin user is mailserver with associated password.
 +
 +  *[[https://ima.jungclaussen.com/|ISPMail Admin]] download latest version
 +  *''scp 192.168.1.71:/home/baumkp/Downloads/ispmailadmin-0.9.11.tar.gz /mnt/docker_store/mail-db/''
 +  *''sudo tar -xvf ispmailadmin-0.9.11.tar.gz -C .config_nginx/html/ispmailadmin/''  (documents are stored in multiple sub-directors and be moved to correct location.
 +  *''sudo cp .config_nginx/html/ispmailadmin.old/cfg/config.inc.php .config_nginx/html/ispmailadmin/cfg/config.inc.php''  This configuration file has the setting including access login details.
 +
 =====adminer===== =====adminer=====
 **phpMyAdmin** is a web based mysql management interface. **phpMyAdmin** is a web based mysql management interface.
  
-**adminer** is a web based single php file database manager, that is suitable for many type of databases, including **sqlite** and being only a single file is easier to implement. Copy the latest version of adminer to ''.config/adminer''  +**adminer** is a web based single php file database manager, that is suitable for many type of databases, including **sqlite** and being only a single file is easier to implement.  
 +++++To download and install latest version:| 
 +  *Download the latest version of [[https://www.adminer.org/|adminer]] and copy to ''.config/adminer''  
 +  *''scp 192.168.1.71:/home/baumkp/Downloads/adminer-6.0.1-en.php /mnt/docker_store/mail-db/'' 
 +  *''mv adminer-6.0.1-en.php .config_nginx/html/adminer/'' 
 +  *''sudo chown 3000:3000 adminer-4.8.1-en.php'' 
 +  *''sudo ln -f adminer-6.0.1-en.php index.php''  Create hardlink ''index.php'' to latest version of adminer
  
   *[[https://www.adminer.org/|Adminer Database management in a single PHP file]]   *[[https://www.adminer.org/|Adminer Database management in a single PHP file]]
   *[[https://kinsta.com/blog/adminer/|How to Use Adminer to Manage Databases Easily with a Single PHP File]]   *[[https://kinsta.com/blog/adminer/|How to Use Adminer to Manage Databases Easily with a Single PHP File]]
- +++++ 
-To test:+++++ To test:| 
 +sqlite:
 <code> <code>
 192.168.1.14:8910 192.168.1.14:8910
Line 240: Line 252:
 password: standard password: standard
 database: /app/mailserver.db</code> database: /app/mailserver.db</code>
 +
 +mysql:
 +<code>
 +system: MySQL / MariaDB
 +Server: mail_db
 +Username: mailserver
 +Password:  See mailserver password or mailserver container ''.config/dovecot/dovecot-sql.conf.ext''
 +Database: mailserver </code>
 +++++
 +
  
 There is another program call [[https://www.sqlitestudio.pl/|SQLiteStudio]]. This look looks like a full GUI program, that will probably not be suitable for installation on a Docker mailserver.  <fc #6495ed>Noted.</fc> There is another program call [[https://www.sqlitestudio.pl/|SQLiteStudio]]. This look looks like a full GUI program, that will probably not be suitable for installation on a Docker mailserver.  <fc #6495ed>Noted.</fc>
Line 1045: Line 1067:
    
 =====References===== =====References=====
-  *Workaround.org [[https://workaround.org/ispmail/bullseye/|ISPmail guide for Debian 11 “Bullseye”]]+  *Workaround.org [[https://workaround.org/ispmail-trixie/|ISPmail guide for Debian 13 “Trixie”]]
   *Gentoo [[https://wiki.gentoo.org/wiki/Complete_Virtual_Mail_Server|Complete Virtual Mail Server]]   *Gentoo [[https://wiki.gentoo.org/wiki/Complete_Virtual_Mail_Server|Complete Virtual Mail Server]]
   *[[https://kinsta.com/blog/adminer/|How to Use Adminer to Manage Databases Easily with a Single PHP File]]   *[[https://kinsta.com/blog/adminer/|How to Use Adminer to Manage Databases Easily with a Single PHP File]]