Mailing List Archive

error with phplogcon
The installation instructions say I need php, apache and mysql.

When I run the installation for phplogcon, it finishes and then I get an
error:

Errordetails:
Error, MYSQL Extensions are not enabled! Function 'mysql_connect' does
not exist.

There are several things I could install here... I installed the
mysql-connector-odbc rpm, but this may or may not be the right thing. It
still doesn't work, and docs on this are pretty scarce. So, what am I
missing? Which rpm should I be using to get the mysql_connect function?
error with phplogcon [ In reply to ]
On Mon, 28 Jul 2008 16:11:52 -0700, Rory Toma wrote:
> The installation instructions say I need php, apache and mysql.
>
> When I run the installation for phplogcon, it finishes and then I get an
> error:
>
> Errordetails:
> Error, MYSQL Extensions are not enabled! Function 'mysql_connect' does
> not exist.
>
> There are several things I could install here... I installed the
> mysql-connector-odbc rpm, but this may or may not be the right thing. It
> still doesn't work, and docs on this are pretty scarce. So, what am I
> missing? Which rpm should I be using to get the mysql_connect function?

I believe it would be php-mysql or php#-mysql (where # is either 4 or 5,
depending on your installed php version). ODBC connector is quite a different
thing.

--
Elisamuel Resto <samuel at dragonboricua.net>
Source Mage General Guru / http://sourcemage.org
GPG ID: 18615F19/1024D / http://simplysam.us
error with phplogcon [ In reply to ]
Yes, turns out after random google searching that I needed php-mysql. I
am past this stage now.

However...

I now get at error

"No syslog records found. - Error Details
Unknown or unhandled error occurred"

I can connect manually and do a select * from the SystemEvents db and
see records, using the user/passwd combo.

One thing I couldn't find... What is supposed to go into the field
"Table type"? I put in "rsyslog" but I'm not sure what is supposed to go
there.

thx
>
> I believe it would be php-mysql or php#-mysql (where # is either 4 or 5,
> depending on your installed php version). ODBC connector is quite a different
> thing.
>
>
error with phplogcon [ In reply to ]
Hi,

> Yes, turns out after random google searching that I needed php-
> mysql. I am past this stage now.
>
> However...
>
> I now get at error
>
> "No syslog records found. - Error Details
> Unknown or unhandled error occurred"

I get this error all the time when I install phplogcon.

It's just the case of the "systemevents" name in the config file, I change it
to "SystemEvents" and it works.

Maybe it's an idea to post your config to the list (just the last bit at the
bottom) so we can see what you're doing.

Regards,

Michael.

> I can connect manually and do a select * from the SystemEvents db
> and see records, using the user/passwd combo.
>
> One thing I couldn't find... What is supposed to go into the field
> "Table type"? I put in "rsyslog" but I'm not sure what is supposed
> to go there.
>
> thx
> >
> > I believe it would be php-mysql or php#-mysql (where # is either 4 or 5,
> > depending on your installed php version). ODBC connector is quite a different
> > thing.
> >
> >
>
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
------- End of Original Message -------
error with phplogcon [ In reply to ]
Here ya go, thx.

$CFG['Sources']['Source1']['ID'] = 'Source1';
$CFG['Sources']['Source1']['Name'] = 'rsyslog';
$CFG['Sources']['Source1']['SourceType'] = 2;
$CFG['Sources']['Source1']['DBTableType'] = 'rsyslog';
$CFG['Sources']['Source1']['DBType'] = '0';
$CFG['Sources']['Source1']['DBServer'] = 'localhost';
$CFG['Sources']['Source1']['DBName'] = 'Syslog';
$CFG['Sources']['Source1']['DBUser'] = 'syslogreader';
$CFG['Sources']['Source1']['DBPassword'] = 'somecleverpasswd';
$CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';
$CFG['Sources']['Source1']['DBEnableRowCounting'] = false;
error with phplogcon [ In reply to ]
Hi,

> Here ya go, thx.
>
> $CFG['Sources']['Source1']['ID'] = 'Source1';
> $CFG['Sources']['Source1']['Name'] = 'rsyslog';
> $CFG['Sources']['Source1']['SourceType'] = 2;
> $CFG['Sources']['Source1']['DBTableType'] = 'rsyslog';
> $CFG['Sources']['Source1']['DBType'] = '0';
> $CFG['Sources']['Source1']['DBServer'] = 'localhost';
> $CFG['Sources']['Source1']['DBName'] = 'Syslog';
> $CFG['Sources']['Source1']['DBUser'] = 'syslogreader';
> $CFG['Sources']['Source1']['DBPassword'] = 'somecleverpasswd';
> $CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';
> $CFG['Sources']['Source1']['DBEnableRowCounting'] = false;

This is mine:

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

$CFG['Sources']['Source1']['ID'] = 'Source1';
$CFG['Sources']['Source1']['Name'] = 'somename';
$CFG['Sources']['Source1']['ViewID'] = 'SYSLOG';
$CFG['Sources']['Source1']['SourceType'] = SOURCE_DB;
$CFG['Sources']['Source1']['DBTableType'] = 'monitorware';
$CFG['Sources']['Source1']['DBServer'] = 'somedbserver';
$CFG['Sources']['Source1']['DBName'] = 'somedbname';
$CFG['Sources']['Source1']['DBUser'] = 'someuser';
$CFG['Sources']['Source1']['DBPassword'] = 'longstringofcharacters';
$CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';
$CFG['Sources']['Source1']['DBEnableRowCounting'] = false;

Regards,

Michael.
error with phplogcon [ In reply to ]
Thx, that fixed it. I didn't iterate over each difference, but...

thx again.


Michael Mansour wrote:
> Hi,
>
>
>> Here ya go, thx.
>>
>> $CFG['Sources']['Source1']['ID'] = 'Source1';
>> $CFG['Sources']['Source1']['Name'] = 'rsyslog';
>> $CFG['Sources']['Source1']['SourceType'] = 2;
>> $CFG['Sources']['Source1']['DBTableType'] = 'rsyslog';
>> $CFG['Sources']['Source1']['DBType'] = '0';
>> $CFG['Sources']['Source1']['DBServer'] = 'localhost';
>> $CFG['Sources']['Source1']['DBName'] = 'Syslog';
>> $CFG['Sources']['Source1']['DBUser'] = 'syslogreader';
>> $CFG['Sources']['Source1']['DBPassword'] = 'somecleverpasswd';
>> $CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';
>> $CFG['Sources']['Source1']['DBEnableRowCounting'] = false;
>>
>
> This is mine:
>
> $CFG['DefaultSourceID'] = 'Source1';
>
> $CFG['Sources']['Source1']['ID'] = 'Source1';
> $CFG['Sources']['Source1']['Name'] = 'somename';
> $CFG['Sources']['Source1']['ViewID'] = 'SYSLOG';
> $CFG['Sources']['Source1']['SourceType'] = SOURCE_DB;
> $CFG['Sources']['Source1']['DBTableType'] = 'monitorware';
> $CFG['Sources']['Source1']['DBServer'] = 'somedbserver';
> $CFG['Sources']['Source1']['DBName'] = 'somedbname';
> $CFG['Sources']['Source1']['DBUser'] = 'someuser';
> $CFG['Sources']['Source1']['DBPassword'] = 'longstringofcharacters';
> $CFG['Sources']['Source1']['DBTableName'] = 'SystemEvents';
> $CFG['Sources']['Source1']['DBEnableRowCounting'] = false;
>
> Regards,
>
> Michael.
> _______________________________________________
> rsyslog mailing list
> http://lists.adiscon.net/mailman/listinfo/rsyslog
>