[syslog-ng] PHP Syslog NG error's

[Manuel Mora]

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 at 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 at lists.balabit.hu
> https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Frequently asked questions at
> http://www.campin.net/syslog-ng/faq.html
>
>
>
>