Code Monkey home page Code Monkey logo

Comments (8)

DavidGoodwin avatar DavidGoodwin commented on September 26, 2024

Hi @dexter74 - What's logged in /var/log/apache2/error.log and /var/log/php7.4-fpm.log ? Anything relevant?

from postfixadmin.

dexter74 avatar dexter74 commented on September 26, 2024

Hello,

I think where is a problem "$CONF" is delete when use echo .

Outch : i was login.php , i go setup.php ...

Create New DB

mysql -u root -padmin -e "DROP DATABASE IF EXISTS MAIL; DROP USER IF EXISTS 'postfix'@'localhost';"

mysql -u root -padmin -e "CREATE DATABASE IF NOT EXISTS MAIL; CREATE USER IF NOT EXISTS 'postfix'@'localhost' IDENTIFIED BY 'admin';"
mysql -u root -padmin -e "GRANT ALL PRIVILEGES ON MAIL.* TO 'postfix'@'localhost';"
mysql -u root -padmin -e "ALTER USER postfix@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD('admin');"
mysql -u postfix -padmin -e "SHOW DATABASES;"

*Result

+--------------------+
| Database           |
+--------------------+
| MAIL               |
| information_schema |
+--------------------+
<?php
$CONF['database_type']     = 'mysqli';
$CONF['database_host']     = 'localhost';
$CONF['database_name']     = 'MAIL';
$CONF['database_user']     = 'postfix';
$CONF['database_password'] = 'admin';
$CONF['configured']        = true;
?>
[php7:error] PHP Fatal error:  
Uncaught Exception: DEBUG INFORMATION: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'MAIL.config' doesn't exist<br/> Check your error_log for the failed query in /srv/postfixadmin/functions.inc.php:1872\nStack trace:\n#0 /srv/postfixadmin/functions.inc.php(1821): db_query()\n#1 /srv/postfixadmin/functions.inc.php(2159): db_query_one()\n#2 /srv/postfixadmin/public/login.php(40): check_db_version()\n#3 {main}\n  thrown in /srv/postfixadmin/functions.inc.php on line 1872

from postfixadmin.

DavidGoodwin avatar DavidGoodwin commented on September 26, 2024

Running/accessing setup.php in your browser should result in the db being setup, and that config table being created.

from postfixadmin.

dexter74 avatar dexter74 commented on September 26, 2024

i think a echo to "Database denied acces" to php is more to Error 500.

from postfixadmin.

dexter74 avatar dexter74 commented on September 26, 2024

fsockopen failed - errno: 111 - errstr: Connection refused, referer: http://mail.lan.local/pfa/sendmail.php

from postfixadmin.

DavidGoodwin avatar DavidGoodwin commented on September 26, 2024

the sendmail page is expecting a mail server to be running locally (I think) - but you oughtto be able to override this with this config -

$CONF['smtp_server'] = "some.host.name";

from postfixadmin.

dexter74 avatar dexter74 commented on September 26, 2024
==> /var/log/mail.log <==
Oct 31 13:48:23 mail dovecot: imap-login: Disconnected (auth failed, 2 attempts in 13 secs): user=<marc>, method=PLAIN, rip=192.168.10.2, lip=192.168.10.3, TLS, session=</VEwkQIJIevAqAoC>

==> /var/log/mail.info <==
Oct 31 13:48:23 mail dovecot: imap-login: Disconnected (auth failed, 2 attempts in 13 secs): user=<marc>, method=PLAIN, rip=192.168.10.2, lip=192.168.10.3, TLS, session=</VEwkQIJIevAqAoC>

==> /var/log/mail.log <==
Oct 31 13:48:41 mail dovecot: imap-login: Disconnected (auth failed, 2 attempts in 18 secs): user=<[email protected]>, method=PLAIN, rip=192.168.10.2, lip=192.168.10.3, TLS, session=<UZDukQIJJOvAqAoC>

==> /var/log/mail.info <==
Oct 31 13:48:41 mail dovecot: imap-login: Disconnected (auth failed, 2 attempts in 18 secs): user=<[email protected]>, method=PLAIN, rip=192.168.10.2, lip=192.168.10.3, TLS, session=<UZDukQIJJOvAqAoC>

from postfixadmin.

DavidGoodwin avatar DavidGoodwin commented on September 26, 2024

tried to enable logging in dovecot ?

I'd suggest you check what format hashes you have in the postfixadmin database, and what format dovecot is actually expecting .. perhaps they're not in sync.

from postfixadmin.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.