Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Postfix mysql unused parameter

  1. #1
    Join Date
    Jun 2008
    Location
    The Netherlands
    Posts
    249

    Question Postfix mysql unused parameter

    Hi,

    I'm running postfix on Tumbleweed. I configured the mysql plugin to certain data to a database so PostfixAdmin can pick them up.
    Since several weeks, when I check the journal for user postfix I see unused parameters for every line in the mySQL config lines:

    warning: mysql:/etc/postfix/mysql_virtual_alias_domainaliases_maps.cf: unused parameter: hosts=
    user=
    password=
    dbname=
    query=

    etc.. etc.. etc..

    This used to work without errors. So I figure something has changed perhaps within Postfix, but all I can find regarding this subject are the same settings I already have.

    Any ideas?

  2. #2
    Join Date
    Jan 2014
    Location
    Erlangen
    Posts
    966

    Default Re: Postfix mysql unused parameter

    Quote Originally Posted by Ricochet View Post
    Hi,

    I'm running postfix on Tumbleweed. I configured the mysql plugin to certain data to a database so PostfixAdmin can pick them up.
    Since several weeks, when I check the journal for user postfix I see unused parameters for every line in the mySQL config lines:

    warning: mysql:/etc/postfix/mysql_virtual_alias_domainaliases_maps.cf: unused parameter: hosts=
    user=
    password=
    dbname=
    query=

    etc.. etc.. etc..

    This used to work without errors. So I figure something has changed perhaps within Postfix, but all I can find regarding this subject are the same settings I already have.

    Any ideas?
    Watch fore these and try merging using sdiff:

    Code:
    erlangen:~ # ll $(rpmconfigcheck |grep postfix)
    -rw-r--r-- 1 root root 31459 May 25 23:25 /etc/postfix/main.cf.rpmnew
    -rw-r--r-- 1 root root  7674 Mar 20 22:35 /etc/postfix/master.cf.rpmnew
    -rw------- 1 root root   172 Feb 16 21:53 /etc/postfix/sasl_passwd.rpmnew
    -rw-r--r-- 1 root root   412 Feb 16 21:53 /etc/postfix/sender_canonical.rpmnew
    -rw-r--r-- 1 root root 12823 Feb 16 21:53 /etc/postfix/virtual.rpmnew
    erlangen:~ #
    AMD Athlon 4850e (2009), openSUSE 13.1, KDE 4, Intel i3-4130 (2014), i7-6700K (2016), i5-8250U (2018), openSUSE Tumbleweed, KDE Plasma 5

  3. #3
    Join Date
    Jun 2008
    Location
    The Netherlands
    Posts
    249

    Default Re: Postfix mysql unused parameter

    Hmm, ok Tnx. I'll examine them again. Must have missed something.

  4. #4
    Join Date
    Jun 2008
    Location
    The Netherlands
    Posts
    249

    Default Re: Postfix mysql unused parameter

    I can't find anything that shouldn't be there. Ofc my files are more filled. As far as I can see, it's all still in the postfix documentation.

  5. #5
    Join Date
    Jan 2014
    Location
    Erlangen
    Posts
    966

    Default Re: Postfix mysql unused parameter

    Quote Originally Posted by Ricochet View Post
    I can't find anything that shouldn't be there. Ofc my files are more filled. As far as I can see, it's all still in the postfix documentation.
    Well, at some point I made a backup of /etc/postfix, deleted the directory and forced a reinstall. Actually I copied main.cf and master.cf from /var/adm/backup/postfix/, installed yast2 e-mail-server and everything was fine again.
    AMD Athlon 4850e (2009), openSUSE 13.1, KDE 4, Intel i3-4130 (2014), i7-6700K (2016), i5-8250U (2018), openSUSE Tumbleweed, KDE Plasma 5

  6. #6
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,133
    Blog Entries
    2

    Default Re: Postfix mysql unused parameter

    Perhaps re-running mysql_secure_installation might fix your problem (It's the install script that configures your mariadb/mysql security configuration).

    The following web page I created describes what it is, and if you wish to create a HereDoc to standardize your configuration (Like your current situation, re-apply what you configured before, or if you're installing and maintain a farm to apply the same settings to all).

    https://en.opensuse.org/User:Tsu2/My...b_Secure_Setup

    Speculating if your MySQL was upgraded sometime, your security settings were lost but may still be running on default unconfigured settings.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  7. #7
    Join Date
    Jun 2008
    Location
    The Netherlands
    Posts
    249

    Default Re: Postfix mysql unused parameter

    Sorry for my late response, I was sick.

    I'll checkout what you both said, although, I don't believe in reinstalling and than hoping the problem goes away. That doesn't sound very logical to me. Especially when keeping the main and master files which most likely contain the wrong setting to begin with. Also, I didn't configure postfix with yast.

    It worked, and it stopped working without me touching it. So changes must have come with an update (guess).

  8. #8
    Join Date
    Jun 2008
    Location
    The Netherlands
    Posts
    249

    Default Re: Postfix mysql unused parameter

    I checked mariaDB. Settings are still there. All accounts work, other products connecting to a db are working also.
    I can log in with my 'superuser' from the cli.

    Also, if it was the database, you would get log in errors I think. Now it is clearly a Postfix error saying it just doesn't understand the parameters.

  9. #9

    Default Re: Postfix mysql unused parameter

    The same problem here.
    It started after Postfix update ftom 3.2.x to version 3.3.0 and I have not found a solution to get rid of these warnings.
    Basically, everything works, only the log file is full of these warnings.
    And warnings come when starting Postfix.
    Has anyone found the cause of these warnings?

  10. #10
    Join Date
    Jun 2008
    Location
    The Netherlands
    Posts
    249

    Default Re: Postfix mysql unused parameter

    Quote Originally Posted by Argosieger View Post
    The same problem here.
    It started after Postfix update ftom 3.2.x to version 3.3.0 and I have not found a solution to get rid of these warnings.
    Basically, everything works, only the log file is full of these warnings.
    And warnings come when starting Postfix.
    Has anyone found the cause of these warnings?
    I AM NOT ALONE!!! \o/

    (sorry for your problem )

Page 1 of 2 12 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •