1 Topic by Pokey (edited by Pokey 2014-08-08 01:15:51)

  • Pokey
  • Member
  • Offline
  • Registered: 2013-07-17
  • Posts: 18

Topic: AuthMYSQLEnable

======== Required information ====
- iRedMail version: 0.8.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS 6.5
====

Hello,

I get the following error message when trying to start apache after installing iRedMail:

Starting httpd: Syntax error on line 22 of /etc/httpd/conf.d/cluebringer.conf:
Invalid command 'AuthMYSQLEnable', perhaps misspelled or defined by a module not included in the server configuration

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: AuthMYSQLEnable

Do you have Apache module 'auth_mysql' enabled?

3 Reply by Pokey

  • Pokey
  • Member
  • Offline
  • Registered: 2013-07-17
  • Posts: 18

Re: AuthMYSQLEnable

I installed the mod_auth_mysql module and it now works. The problem is that the iRedMail.sh install script did not install this module when it installed httpd. So the script is not working perfectly "out of the box" in version 0.8.7 on CentOS 6.5. I guess this is a bug report...

Thank you for your time, Zhang.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: AuthMYSQLEnable

I cannot reproduce this issue. Not sure whether it's an issue/error during iRedMail installation or other problems.

5 Reply by Pokey

  • Pokey
  • Member
  • Offline
  • Registered: 2013-07-17
  • Posts: 18

Re: AuthMYSQLEnable

Well I do not know why, but this has now happened twice on two different VPS servers (serveraxis.com and linode.com).

[root@shadow etc]# apachectl start
Syntax error on line 22 of /etc/httpd/conf.d/cluebringer.conf:
Invalid command 'AuthMYSQLEnable', perhaps misspelled or defined by a module not included in the server configuration

running "yum install mod_auth_mysql" fixed it.

Pokey

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: AuthMYSQLEnable

Could you please show me output of below command?

# yum info mod_auth_mysql

7 Reply by Pokey

  • Pokey
  • Member
  • Offline
  • Registered: 2013-07-17
  • Posts: 18

Re: AuthMYSQLEnable

Here is the output from Linode:

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.linode.com
 * epel: mirror.prgmr.com
 * extras: mirrors.linode.com
 * updates: mirrors.linode.com
Installed Packages
Name        : mod_auth_mysql
Arch        : x86_64
Epoch       : 1
Version     : 3.0.0
Release     : 11.el6_0.1
Size        : 49 k
Repo        : installed
From repo   : base
Summary     : Basic authentication for the Apache web server using a MySQL database
URL         : http://modauthmysql.sourceforge.net/
License     : ASL 1.1
Description : mod_auth_mysql can be used to limit access to documents served by a
            : web server by checking data in a MySQL database.

Here is the output from ServerAxis:

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/metalink                                            |  13 kB     00:00     
 * base: mirror.fdcservers.net
 * epel: mirror.steadfast.net
 * extras: mirror.fdcservers.net
 * updates: mirror.fdcservers.net
base                                                     | 3.7 kB     00:00     
epel                                                     | 4.4 kB     00:00     
epel/primary_db                                          | 6.3 MB     00:01     
extras                                                   | 3.4 kB     00:00     
iRedMail                                                 |  951 B     00:00     
updates                                                  | 3.4 kB     00:00     
updates/primary_db                                       | 4.7 MB     00:00     
Installed Packages
Name        : mod_auth_mysql
Arch        : x86_64
Epoch       : 1
Version     : 3.0.0
Release     : 11.el6_0.1
Size        : 49 k
Repo        : installed
From repo   : base
Summary     : Basic authentication for the Apache web server using a MySQL
            : database
URL         : http://modauthmysql.sourceforge.net/
License     : ASL 1.1
Description : mod_auth_mysql can be used to limit access to documents served by
            : a web server by checking data in a MySQL database.

8 Reply by Pokey

  • Pokey
  • Member
  • Offline
  • Registered: 2013-07-17
  • Posts: 18

Re: AuthMYSQLEnable

Well I just rebuilt my Linode and this time the iRedMail script DID install mod_auth_mysql. The only thing I can think of that was different was that I installed Perl 5.20 first and ran yum update. Weird...