[BlueOnyx:19480] Re: Cannot Add Users Chorizo Error

[Michael Stauber]

Hi Rodrigo,

> We have a severe problem on an Upgraded Virtual Blueonyx 5107,

So this is now a BlueOnyx 5207R?

> ///////////////////////////////////////////
> 
>  A PHP Error was encountered
> 
> Severity: Notice
> 
> Message: Undefined variable: sql_query
> Filename: create.User/TrafficEmail.php
> Message: mysqli::query() [mysqli.query]: Empty query
> Filename: create.User/TrafficEmail.php
> 
> Line Number: 37

In the GUI under "Server Management" / "Network Services" / "AV-SPAM" go
to the tab "Services". Tick the checkbox for "Milter-GeoIP".

In the tab "SpamAssassin" tick the checkbox "Use AWL". Even if you don't
use SpamAssassin.

In the tab "GeoIP" tick the checkbox for "Protect SMTP-Auth" as a bare
minimum.

In the tab "MySQL" make sure that it says:

"MySQL Status: MySQL connection possible with this settings."

Should *that* not be the case and a connection to MySQL cannot be
established, then you need to troubleshoot why your GUI doesn't know the
current "root" password for MySQL. You can fix that under "Network
Services" / "MySQL".


-- 
With best regards

Michael Stauber