Hi Stuart, I have installed php-syslog-ng on a Suse 9 with no problems but in a Suse 10 (over a VMWARE) I had the 1st problem you have, I solved it disabling the NAME CACHE. Go to <document root>/include/config.php and seek for the line define('USE_CACHE', TRUE) and set it to define('USE_CACHE', FALSE). The second problem is strange, please, set logging in mysql, when mysql daemon is started you set the --log flag, then you'll have logs stored in the same directory where your data is. This log file contains the queries the clients do against the BD, you can check it for problems. Sorry for my english, if you don't understand something I can rewrite it. Regards. On 9/19/06, Stuart Boyle <stuart.boyle@cybertrust.com> wrote:
Im having a couple of issue's with phpsyslog-ng, I cant seen any threads or posts that help with the problem's im having so I need to post, if im covering old ground, I apologize.
Im not well versed with MySQL or PHP, so if you could help please explain in "novice language".
1. When I open the browser and login, I then select "search" from the menu bar, I get the following error:
USING TABLE:logs
SELECT * FROM search_cache WHERE tablename='logs'Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Im getting the error displayed this way because I have it configured to echo the result. In the file search.php I see the following query configured: $sql = "SELECT * FROM ".CACHETABLENAME." WHERE tablename='".$useTable."'"; 2. When I try to add a user I input the username and password for the new account and then receive the following message:
No DB Link
Im sure these aren't difficult issues to resolve, but im done beating my head on a wall. Any help would be appreciated. Stuart _______________________________________________ syslog-ng maillist - syslog-ng@lists.balabit.hu https://lists.balabit.hu/mailman/listinfo/syslog-ng Frequently asked questions at http://www.campin.net/syslog-ng/faq.html