Re: [jffnms-users] jffnms-users Digest, Vol 1, Issue 1395 - MySQL error

Simon Michuki Sat, 24 Jun 2006 14:35:57 -0700

I had the same error on Fedora C5, MySQL 5 and went for the jffnms-0.8.3-rc1 and all is well. It runs just fine. I am sure it will solve your problem.

Simon M

[EMAIL PROTECTED]

[EMAIL PROTECTED] wrote:

Send jffnms-users mailing list submissions to
jffnms-users@lists.sourceforge.net

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/jffnms-users
or, via email, send a message with subject or body 'help' to
[EMAIL PROTECTED]

You can reach the person managing the list at
[EMAIL PROTECTED]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of jffnms-users digest..."

Today's Topics:

1. Backup (Gerard Gacusan)
2. Debian and mySQL issue (Taylor Judd)
3. Re: Backup (Tim Nelson)
4. Re: Backup (Gerard Gacusan)
5. problems with new hosts (klx out)
6. Re: problems with new hosts (Javier Szyszlican)
7. external links (Travis Johnson)

----------------------------------------------------------------------

Message: 1
Date: Fri, 23 Jun 2006 15:27:11 -0500
From: "Gerard Gacusan" <[EMAIL PROTECTED]>
Subject: [jffnms-users] Backup
To: , <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"

Hello,

What are the necessary files or folders that need to backup the JFFNMS
before wiping out the server?

Thanks,

Gerard

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://sourceforge.net/mailarchive/forum.php?forum=jffnms-users/attachments/20060623/d89cb151/attachment.html

------------------------------

Message: 2
Date: Fri, 23 Jun 2006 15:04:38 -0700
From: "Taylor Judd" <[EMAIL PROTECTED]>
Subject: [jffnms-users] Debian and mySQL issue
To: jffnms-users@lists.sourceforge.net
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain; charset="iso-8859-1"

Greetings,

I'm evaluating JFFNMS as a possible alternative to Nagios, but I am running
into an issue with compatibility with mySQL 5.0 on a Debian 3.1 station. I
am following the documentation provided for both Debain and general *unix.
My issue comes up with executing the script for mySQL I get this error:

./mysql -u jffnms -p jffnms < /usr/local/jffnms-0.8.2/docs/jffnms-
0.8.2.mysql
Enter password:
ERROR 1064 (42000) at line 932: 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 'condition char(250) NOT NULL default '',
description char(60) NOT NULL default' at line 3

After talking to a college we modified the jffnms-0.8.2.mysql file to have
line 932 read:

conditi char(250) NOT NULL default ' ',

Taking out the keyword 'condition' and replacing it with 'conditi'. The
mySQL file now reads into my database without a problem. Now I haven't
tested it, but I imagine this destorys many calls placed on this table.

I'm by no strech a mySQL expert, but I am hoping for advice or ideas. Is
JFFNMS compatible with mySQL 5.0? Is there another mySQL dump that can
create the database structure? Or is there something I am doing wrong?

Taylor
[EMAIL PROTECTED]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://sourceforge.net/mailarchive/forum.php?forum=jffnms-users/attachments/20060623/7330b05b/attachment.html

------------------------------

Message: 3
Date: Fri, 23 Jun 2006 20:56:12 -0500
From: Tim Nelson <[EMAIL PROTECTED]>
Subject: Re: [jffnms-users] Backup
To: Gerard Gacusan <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED], jffnms-users@lists.sourceforge.net
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Assuming you installed according to the instructions and are using a
*NIX based solution, you would want to backup your entire /opt/jffnms
directory as well as do a mysqldump of your database so it can be
populated quickly once your rig is up and running properly again. I'm
not as familiar with PostgreSQL but I would assume there is a similar
way to pull data. If you are running a windows based solution, I believe
others here on the list would be a better help.

--Tim Nelson

Gerard Gacusan wrote:
>
> Hello,
>
>
>
> What are the necessary files or folders that need to backup the JFFNMS
> before wiping out the server?
>
>
>
> Thanks,
>
> Gerard
>
>
>
> ------------------------------------------------------------------------
>
> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> jffnms-users mailing list
> jffnms-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
>

------------------------------

Message: 4
Date: Fri, 23 Jun 2006 19:32:10 -0700 (PDT)
From: Gerard Gacusan <[EMAIL PROTECTED]>
Subject: Re: [jffnms-users] Backup
To: Tim Nelson <[EMAIL PROTECTED]>, Gerard Gacusan <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED], jffnms-users@lists.sourceforge.net
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="iso-8859-1"

i forgot to mention, it's running in Fedora Core 4. I am using mysql as well.

Tim Nelson <[EMAIL PROTECTED]>wrote: Assuming you installed according to the instructions and are using a
*NIX based solution, you would want to backup your entire /opt/jffnms
directory as well as do a mysqldump of your database so it can be
populated quickly once your rig is up and running properly again. I'm
not as familiar with PostgreSQL but I would assume there is a similar
way to pull data. If you are running a windows based solution, I believe
others here on the list would be a better help.

--Tim Nelson

Gerard Gacusan wrote:
>
> Hello,
>
>
>
> What are the necessary files or folders that need to backup the JFFNMS
> before wiping out the server?
>
>
>
> Thanks,
>
> Gerard
>
>
>
> ------------------------------------------------------------------------
>
> 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
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> jffnms-users mailing list
> jffnms-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
>

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
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users

---------------------------------
Want to be your own boss? Learn how on Yahoo! Small Business.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://sourceforge.net/mailarchive/forum.php?forum=jffnms-users/attachments/20060623/2ffdb8b5/attachment.html

------------------------------

Message: 5
Date: Sat, 24 Jun 2006 16:44:24 +0200
From: "klx out" <[EMAIL PROTECTED]>
Subject: [jffnms-users] problems with new hosts
To: jffnms-users@lists.sourceforge.net
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=iso-8859-1; format=flowed

Hi,

I have a problems with jffnms 0.8.2 on my fedora core 4, problems is when I
create a new hosts in folder rrd appears rrd files but graph are not
correctly show. Only when I make a chmod 777 * in rrd folder then appears
graphs

What Can I do?

thanks

_________________________________________________________________
Acepta el reto MSN Premium: Protecci?n para tus hijos en internet.
Desc?rgalo y pru?balo 2 meses gratis.
http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil

------------------------------

Message: 6
Date: Sat, 24 Jun 2006 12:18:15 -0300
From: Javier Szyszlican <[EMAIL PROTECTED]>
Subject: Re: [jffnms-users] problems with new hosts
To: klx out <[EMAIL PROTECTED]>
Cc: jffnms-users@lists.sourceforge.net
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

chown jffnms:jffnms -R /opt/jffnms/

Javier

klx out wrote:
> Hi,
>
> I have a problems with jffnms 0.8.2 on my fedora core 4, problems is when I
> create a new hosts in folder rrd appears rrd files but graph are not
> correctly show. Only when I make a chmod 777 * in rrd folder then appears
> graphs
>
> What Can I do?
>
> thanks
>
> _________________________________________________________________
> Acepta el reto MSN Premium: Protecci?n para tus hijos en internet.
> Desc?rgalo y pru?balo 2 meses gratis.
> http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil
>
>
> 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
> _______________________________________________
> jffnms-users mailing list
> jffnms-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jffnms-users

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
[EMAIL PROTECTED]

I hope JFFNMS or I were helpful to you, if you
can, please donate at http://jffnms.org/donate

------------------------------

Message: 7
Date: Sat, 24 Jun 2006 10:30:42 -0600
From: Travis Johnson <[EMAIL PROTECTED]>
Subject: [jffnms-users] external links
To: jffnms-users@lists.sourceforge.net
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi,

We currently have external links to show critical items, but we can only
show 1 graph per link. Is there a way to do two?

http://jffnms.ida.net/view_performance.php?interface_id=7309&graph_type=10028
is what we currently use.

Thanks,

Travis
Microserv

------------------------------

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

------------------------------

_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users

End of jffnms-users Digest, Vol 1, Issue 1395
*********************************************

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users

Re: [jffnms-users] jffnms-users Digest, Vol 1, Issue 1395 - MySQL error

Reply via email to