[Php-syslog-ng-support] NMS Wiki Available

2006-08-31 Thread Clayton Dukes
Folks, I've built a new site for Network Management related topics. If you feel you may have something to contribute to this effort, please do. Share the knowledge! http://nms.gdd.net = Clayton Dukes NMS Consulting Engineer, Advanced Services Cisco Systems, Inc. Offi

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Shane Presley
Jeff, That worked perfectly, thank you -- I can log in now! So we're getting closer. But it still appears something is wrong with my table structure? When I'm viewing log entries I have 6 columns. The column labels at the top are SEQ, HOST, FACILITY, DATE, TIME, MESSAGE, then a blank colum

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Jeffrey Chandler
Shane,When I did the install through the installer it gave me an account password for the admin account.  I logged in with that, and changed the passwords through the config page.But, just a small glimpse at the code, and in the old version it used sha1 as a hash, and in the new version it is using

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Vadim Pushkin
Are you sure that you've edited your config.php and added the same data that the original had? Aside from the obvious, be sure to look at this one: define('SITEADMIN', 'netadmin'); .vp >The alter commands worked fine, and I modified config.php manually >with my database passwords, and name (sy

Re: [Php-syslog-ng-support] Logrotate.php

2006-08-31 Thread Vadim Pushkin
Great news Ian. Are you also able to see data within the various logs with a date? Regards, .vp >I incorporated MattW's fix into logrotate.php which you can find as an >attachment here: > >http://code.google.com/p/php-syslog-ng/issues/list > >See item ID 6. > >I've used it for a week and it fi

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Shane Presley
Jeff, That sounds like my problem. How did you update the passwords? mysql commands? I'm not a database guy, but I did some googling and tried to hack it up, but couldn't get anything to work. Just for grins this is what I tried: update users set pwhash = password('mypassword') where username

Re: [Php-syslog-ng-support] Logrotate.php

2006-08-31 Thread Ian Fawcett
I incorporated MattW's fix into logrotate.php which you can find as an attachment here: http://code.google.com/p/php-syslog-ng/issues/list See item ID 6. I've used it for a week and it fixes the GUI login problem and deletes the old tables as specified by the retention config setting. On 8/29/0

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Jeffrey Chandler
Shane,I went through a similar situation and found out that the pwhash length / format changed.  I was lucky that there weren't many users, and ended up re-creating the passwords manually.  Is there a way to do this automatically? JeffOn 8/31/06, Shane Presley <[EMAIL PROTECTED]> wrote: The alter c

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Shane Presley
The alter commands worked fine, and I modified config.php manually with my database passwords, and name (syslog). But I can't log in. It tells me bad username/password. Not sure why -- the table names are the same? I kept my old php install around as -bak, and I can log in from that interface u

Re: [Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Vadim Pushkin
Looks like all you need to modify are the settings for hosts from 32 characters to 128 in the various logs tables. So, mysql> alter table logs modify host varchar(128) default NULL; Then for each of the tables that you've truncated names, do the same for them, i.e. mysql> alter table all_lo

[Php-syslog-ng-support] Upgrading to 2.9

2006-08-31 Thread Shane Presley
I decided to start a new thread since this was kind of off topic from the logrotate question. So I ran the full mysqldump, and cron'd it to run nightly, so we're safe. +--+ | Tables_in_syslog | +--+ | actions | | cemdb| | logs | ...