[phpLogCon] maintenance.sh / php script doesn't work

[Michael Mansour]

Hi,

I've just installed the latest LogAnalyzer 3.0.1 software and got it working
with rsyslog MySQL DB logging.

Everything is nice and clean and works well.

Trying to get the maintenance script working though fails, with this error:

# php ./maintenance.php cleardata 1 olderthan 86400
Num.    Facility .      Debug Message


        Critical Error occured  -       Errordetails:
        Logstream Source with ID '1' could not be found in the Database!

        Terminating now!

I've tried to trouble-shoot this extensively my end but can't figure out what
the problem is.

In config.php the source ID is:

$CFG['DefaultSourceID'] = 'Source1';

$CFG['Sources']['Source1']['ID'] = 'Source1';

and the config.php file which the script references has all the login details
to the DB with the correct DB privileges.

Any ideas what could be wrong here?

I'm thinking if I can't get this working I'll just need to generate some sort
of MySQL script/query to delete entries older than the time I need.

Thanks.

Michael.