Information: Forum is in read-only mode
For details and other support options see https://www.adiscon.com/news/support-forum-set-to-read-only-mode/

db working but No Syslog Records found

Everything which is related to the installation of phpLogCon.

Moderator: alorbach

Google Ads


db working but No Syslog Records found

Postby bluto » Wed Feb 03, 2010 4:08 pm

Hi all, I'm trying to use phplogcon 2.8.0. with a syslog-ng server (Debian Lenny). It collects logs from a windows 2003 server with Snare Agent; the data logging on a file works fine and I can see the events in the web browser, so I've done some attempts to use a mysql database, but with no luck.
First of all I've created the database in this way:

CREATE DATABASE syslog;
USE syslog;
CREATE TABLE logs (
host varchar(32) default NULL,
facility varchar(10) default NULL,
priority varchar(10) default NULL,
level varchar(10) default NULL,
tag varchar(10) default NULL,
date date default NULL,
time time default NULL,
program varchar(15) default NULL,
msg text, seq int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (seq),
KEY host (host),
KEY seq (seq),
KEY program (program),
KEY time (time),
KEY date (date),
KEY priority (priority),
KEY facility (facility)
) TYPE=MyISAM;

and in fact the database is full of events, as you can see in this image:
http://img64.imageshack.us/img64/8682/dataj.png
but in Show Events Window always appears the message "No Syslog Records found". In Sources Options I've changed from SyslogNG to Monitorware, but with no result. In Show Database statistics the Table filesize amounts (at this moment) to about 160kB and Rowcount is 288, so I guess the database is working correctly; it seems the problem is similar to this: problem-with-connection-mysql-data-base-t9881.html but I'm a newbie and I need a little help step by step :? Any help is appreciated and thanks to all in advance.

bluto
bluto
Avarage
 
Posts: 10
Joined: Wed Feb 03, 2010 3:03 pm

Urgent Question?

  • Pulling out your Hair?
  • Wasting Time and Money?
  • Deadline Approaching?

Re: db working but No Syslog Records found

Postby alorbach » Thu Feb 04, 2010 9:22 am

Hi,

this database layout is not supported, or predefined in phpLogCon.
You will either have to use the database layout supported by rsyslog, or manually create a custom database mapping within phpLogCon.
The UserDB System needs to be installed to do so.

best regards,
Andre Lorbach
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Re: db working but No Syslog Records found

Postby bluto » Thu Feb 04, 2010 11:05 pm

Thanks for reply, for best compatibility I'm planning to switch to use rsyslog instead of syslog-ng
regards
bluto
bluto
Avarage
 
Posts: 10
Joined: Wed Feb 03, 2010 3:03 pm

Re: db working but No Syslog Records found

Postby jaimet561 » Wed Jul 20, 2016 5:13 pm

alorbach wrote:Hi,

this database layout is not supported, or predefined in phpLogCon.
You will either have to use the database layout supported by rsyslog, or manually create a custom database mapping within phpLogCon.
The UserDB System needs to be installed to do so.

best regards,
Andre Lorbach


Hello alorbach,

I have created a Db Mapping but it still says The configured Table could not be found. But the table does exist. I have verified the spelling also.
Where can I find the supported databases layout? How can I create one of those?

Below is the DB Mapping that I have created.

log_time=>log_time,user_name=>user_name,database_name=>database_name,process_id=>process_id,connection_from=>connection_from,session_id=>session_id,session_line_num=>session_line_num,command_tag=>command_tag,session_start_time=>session_start_time,virtual_transaction_id=>virtual_transaction_id,transaction_id=>transaction_id,error_severity=>error_severity,sql_state_code=>sql_state_code,message=>message,detail=>detail,hint=>hint,internal_query=>internal_query,internal_query_pos=>internal_query_pos,context=>context,query=>query,query_pos=>query_pos,location=>location,application_name=>application_name
jaimet561
Avarage
 
Posts: 20
Joined: Fri Jun 10, 2016 4:10 pm

Re: db working but No Syslog Records found

Postby jaimet561 » Wed Jul 20, 2016 5:15 pm

I also had to create the field because I could not find them in the list provided.
Oh, I created the DB Mapping through the browser, I have the UserDB installed.

The database currently holds the logs from Postgres. I want to view these through Adiscon. Please help. anyone.

Thank you
jaimet561
Avarage
 
Posts: 20
Joined: Fri Jun 10, 2016 4:10 pm

Google Ads



Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests

cron