Ok,
I donwloaded the current version yesterday, and installed it.
It looks to work great (no more problem with the fields formats of the .MRG table) and thank for help.
But there is something that looks frozen :
I launch every midnight the logrotate.php and it seems to have build me a new table, which name is made of the current date.
This table is available in the comboBox of the search menu.
So every day, i'll get a new table, and it's great.
But the problem is that this table looks empty (for the web interface).
When i select it in my browser and want to look in it, the phpsyslog tells me that :
No results found.
The sql syntax is :SELECT SQL_CALC_FOUND_ROWS * FROM logs20061024 WHERE datetime > '2006-10-24 00:00:00' ORDER BY datetime DESC LIMIT 0, 100
The sql syntax is :SELECT SQL_CALC_FOUND_ROWS * FROM logs20061024 WHERE datetime > '2006-10-24 00:00:00' ORDER BY datetime DESC LIMIT 0, 100
For information, the size of the table isnt null :
-rw-rw---- 1 mysql mysql 8826 Oct 23 11:45 logs20061024.frm
-rw-rw---- 1 mysql mysql 211488 Oct 24 00:00 logs20061024.MYD
-rw-rw---- 1 mysql mysql 88064 Oct 24 00:00 logs20061024.MYI
-rw-rw---- 1 mysql mysql 211488 Oct 24 00:00 logs20061024.MYD
-rw-rw---- 1 mysql mysql 88064 Oct 24 00:00 logs20061024.MYI
Any idea why it lokks empty ? Maybe i havent undrestood something .....
Another question :
What are the difference beetween the logs table and the all_logs table ?
Thanks =)
2006/10/23, Clayton Dukes <[EMAIL PROTECTED]>:
You need to upgrade to the latest version.
On 10/23/06, fredzy padzy < [EMAIL PROTECTED]> wrote:-------------------------------------------------------------------------Hello everyoneI do not understand :I've got the same probleme ("All tables in the MERGE table are not identically defined
") but i do not have a hostYYYYMMDD field in my logs table.So this doesn' work (for me)Where am i wrong ?
2006/7/17, Jason Martens <[EMAIL PROTECTED]>:After you upgrade your installation to 2.9.2 , you must upgrade *all* of
your previous log tables to the new varchar(128) format for the host
column like so:
alter table logs modify hostYYYYMMDD varchar(128) default NULL;
Otherwise, you will get the following after it's upgraded, and logrotate
runs:
Query failed: All tables in the MERGE table are not identically defined
I didn't update my logrotate script after I upgraded from 2.9.1, so that
might be part of the problem too.
Jason Martens
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
--
=============================
Clayton Dukes
NMS Consulting Engineer, Advanced Services
Cisco Systems, Inc.
Office: 919.392.6122
Fax: : 919.869.1580
Cell: 813.545.7373
Email: [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
=============================
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Php-syslog-ng-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
