Discussion:
[Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2
Martyn
2009-02-05 20:21:16 UTC
Permalink
Hi Group.

I'm trying to install Centreon on my Ubuntu box, I'm following the install
guide and hit a snag.
Looking at the site install guide here
http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2 I'm hit a problem
at this stage.

# mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql

When I run that query it just returns with -> and sits there forever or
until I press ctrl c

Do you know what the issue is at all.

Thanks

Martyn
Andy Shellam
2009-02-05 21:12:22 UTC
Permalink
Martyn,

By the looks of it, there's a missing ";" at the end of one of the
queries in that file. I don't use NDODB so I cannot elaborate any more
than that.

Try running the command again and simply putting ;<ENTER> on the line
beginning with "->"

HTH,
Andy
Post by Martyn
Hi Group.
I'm trying to install Centreon on my Ubuntu box, I'm following the
install guide and hit a snag.
Looking at the site install guide here
_http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2_ I'm hit a
problem at this stage.
# mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql
When I run that query it just returns with -> and sits there forever
or until I press ctrl c
Do you know what the issue is at all.
Thanks
Martyn
------------------------------------------------------------------------
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
------------------------------------------------------------------------
_______________________________________________
Nagios-users mailing list
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
::: Messages without supporting info will risk being sent to /dev/null
Martyn
2009-02-05 22:36:32 UTC
Permalink
Now it looks as though the DB is missing something

mysql> mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql;
ERROR 1064 (42000): 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 'mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql' at line 1

Will take a look into in to see what it is

Thanks for the reply though, it got me one stage further

Martyn

-----Original Message-----
From: Andy Shellam [mailto:andy-***@networkmail.eu]
Sent: 05 February 2009 21:12
To: Martyn
Cc: nagios-***@lists.sourceforge.net
Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2

Martyn,

By the looks of it, there's a missing ";" at the end of one of the queries
in that file. I don't use NDODB so I cannot elaborate any more than that.

Try running the command again and simply putting ;<ENTER> on the line
beginning with "->"

HTH,
Andy
Post by Martyn
Hi Group.
I'm trying to install Centreon on my Ubuntu box, I'm following the
install guide and hit a snag.
Looking at the site install guide here
_http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2_ I'm hit a
problem at this stage.
# mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql
When I run that query it just returns with -> and sits there forever
or until I press ctrl c
Do you know what the issue is at all.
Thanks
Martyn
----------------------------------------------------------------------
--
----------------------------------------------------------------------
-------- Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use
existing skills and code to build responsive, highly engaging
applications that combine the power of local resources and data with
the reach of the web. Download the Adobe AIR SDK and Ajax docs to
start building applications today-http://p.sf.net/sfu/adobe-com
----------------------------------------------------------------------
--
_______________________________________________
Nagios-users mailing list
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
Post by Martyn
::: Messages without supporting info will risk being sent to /dev/null
Andy Shellam
2009-02-05 23:13:33 UTC
Permalink
Martyn,

You've probably figured that out by now, but that command-line should be
typed into your shell command prompt, not the MySQL one! Make sure your
command prompt does not start "mysql >" before you type that command
in. If it does, first use "quit" to exit back to your system shell,
then try it again.

As for your other question, yes because it's a string you need to quote
it using '.

Andy
Post by Martyn
Now it looks as though the DB is missing something
mysql> mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql;
ERROR 1064 (42000): 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 'mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql' at line 1
Will take a look into in to see what it is
Thanks for the reply though, it got me one stage further
Martyn
-----Original Message-----
Sent: 05 February 2009 21:12
To: Martyn
Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2
Martyn,
By the looks of it, there's a missing ";" at the end of one of the queries
in that file. I don't use NDODB so I cannot elaborate any more than that.
Try running the command again and simply putting ;<ENTER> on the line
beginning with "->"
HTH,
Andy
Post by Martyn
Hi Group.
I'm trying to install Centreon on my Ubuntu box, I'm following the
install guide and hit a snag.
Looking at the site install guide here
_http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2_ I'm hit a
problem at this stage.
# mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql
When I run that query it just returns with -> and sits there forever
or until I press ctrl c
Do you know what the issue is at all.
Thanks
Martyn
----------------------------------------------------------------------
--
----------------------------------------------------------------------
-------- Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use
existing skills and code to build responsive, highly engaging
applications that combine the power of local resources and data with
the reach of the web. Download the Adobe AIR SDK and Ajax docs to
start building applications today-http://p.sf.net/sfu/adobe-com
----------------------------------------------------------------------
--
_______________________________________________
Nagios-users mailing list
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
Post by Martyn
::: Messages without supporting info will risk being sent to /dev/null
Martyn
2009-02-05 23:00:55 UTC
Permalink
Just looking at one on the lines again below, do I need to use 'centreon';
or just centreon; leaving out the '

mysql -u root
mysql> use centreon;
mysql> update cfg_ndo2db set db_user = 'centreon';
mysql> exit;

Thanks

Martyn

-----Original Message-----
From: Martyn [mailto:***@chetnet.co.uk]
Sent: 05 February 2009 22:37
To: 'Andy Shellam'
Cc: nagios-***@lists.sourceforge.net
Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2

Now it looks as though the DB is missing something

mysql> mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql;
ERROR 1064 (42000): 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 'mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql' at line 1

Will take a look into in to see what it is

Thanks for the reply though, it got me one stage further

Martyn

-----Original Message-----
From: Andy Shellam [mailto:andy-***@networkmail.eu]
Sent: 05 February 2009 21:12
To: Martyn
Cc: nagios-***@lists.sourceforge.net
Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2

Martyn,

By the looks of it, there's a missing ";" at the end of one of the queries
in that file. I don't use NDODB so I cannot elaborate any more than that.

Try running the command again and simply putting ;<ENTER> on the line
beginning with "->"

HTH,
And
Post by Martyn
Hi Group.
I'm trying to install Centreon on my Ubuntu box, I'm following the
install guide and hit a snag.
Looking at the site install guide here
_http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2_ I'm hit a
problem at this stage.
# mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql
When I run that query it just returns with -> and sits there forever
or until I press ctrl c
Do you know what the issue is at all.
Thanks
Martyn
----------------------------------------------------------------------
--
----------------------------------------------------------------------
-------- Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use
existing skills and code to build responsive, highly engaging
applications that combine the power of local resources and data with
the reach of the web. Download the Adobe AIR SDK and Ajax docs to
start building applications today-http://p.sf.net/sfu/adobe-com
----------------------------------------------------------------------
--
_______________________________________________
Nagios-users mailing list
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
Post by Martyn
::: Messages without supporting info will risk being sent to /dev/null
----------------------------------------------------------------------------
--
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing
skills and code to build responsive, highly engaging applications that
combine the power of local resources and data with the reach of the web.
Download the Adobe AIR SDK and Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Nagios-users mailing list
Nagios-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
Martyn
2009-02-06 14:06:13 UTC
Permalink
Yes cheers Andy I worked it out thanks

Martyn

-----Original Message-----
From: Andy Shellam [mailto:andy-***@networkmail.eu]
Sent: 05 February 2009 23:14
To: Martyn
Cc: nagios-***@lists.sourceforge.net
Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2

Martyn,

You've probably figured that out by now, but that command-line should be
typed into your shell command prompt, not the MySQL one! Make sure your
command prompt does not start "mysql >" before you type that command in. If
it does, first use "quit" to exit back to your system shell, then try it
again.

As for your other question, yes because it's a string you need to quote it
using '.

Andy
Post by Martyn
Now it looks as though the DB is missing something
mysql> mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql;
ERROR 1064 (42000): 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 'mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql' at line 1
Will take a look into in to see what it is
Thanks for the reply though, it got me one stage further
Martyn
-----Original Message-----
Sent: 05 February 2009 21:12
To: Martyn
Subject: Re: [Nagios-users] Ubunt- Nagios3-Centreon 2-ndo2
Martyn,
By the looks of it, there's a missing ";" at the end of one of the
queries in that file. I don't use NDODB so I cannot elaborate any more
than that.
Post by Martyn
Try running the command again and simply putting ;<ENTER> on the line
beginning with "->"
HTH,
Andy
Post by Martyn
Hi Group.
I'm trying to install Centreon on my Ubuntu box, I'm following the
install guide and hit a snag.
Looking at the site install guide here
_http://en.doc.centreon.com/Nagios3_Centreon2_Ubuntu_ndo2_ I'm hit a
problem at this stage.
# mysql -u root ndo <
/usr/local/src/centreon-2.0/www/install/createNDODB.sql
When I run that query it just returns with -> and sits there forever
or until I press ctrl c
Do you know what the issue is at all.
Thanks
Martyn
---------------------------------------------------------------------
-
--
---------------------------------------------------------------------
-
-------- Create and Deploy Rich Internet Apps outside the browser
with
Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use
existing skills and code to build responsive, highly engaging
applications that combine the power of local resources and data with
the reach of the web. Download the Adobe AIR SDK and Ajax docs to
start building applications today-http://p.sf.net/sfu/adobe-com
---------------------------------------------------------------------
-
--
_______________________________________________
Nagios-users mailing list
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when
reporting any issue.
Post by Martyn
::: Messages without supporting info will risk being sent to
/dev/null
Loading...