mysql question

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

mysql question

Steffan

Hello,

 

Im using the tutorial from

https://oss.oetiker.ch/rrdtool/doc/rrdgraph_libdbi.en.html

 

including the test database tables etc

 

but im getting

 

root@61 web]# DS_BASE="sql//mysql/host=sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=1141942900757789274"

[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"

ERROR: opening 'sql//mysql/host=sql1.tkservers.com/dbname=***/username=***/password=***//RRDValue/UnixTimeStamp/value/RRDKeyID=11419429007577892741141942900757789274': No such file or directory

 

 

--

-- Tabelstructuur voor tabel `RRDValue`

--

(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES

(1141942900757789274, 1510552800, 2345),

(1141942900757789274, 1510563600, 4563461);

 

 

Installed Packages

libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base

libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base

libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base

libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base

 

 

any idees where the problem is?

 

Thanxs
Steffan


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Reply | Threaded
Open this post in threaded view
|

Re: mysql question

Martin Sperl-4
Hi Steffan!

If you are using the default rpms of rrdtool then libdbi support may not be compiled in…

check the rrd shared library with ldd if it lists libdbi as a shared library it needs…

something like this:
ldd /usr/lib64/librrd.so.4 | grep dbi

At least standard Centos7 does not come with it enabled.

Martin

On 13.11.2017, at 16:17, Steffan <[hidden email]> wrote:

Hello,
 
Im using the tutorial from
 
including the test database tables etc
 
but im getting
 
[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"
 
 
--
-- Tabelstructuur voor tabel `RRDValue`
--
(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES
(1141942900757789274, 1510552800, 2345),
(1141942900757789274, 1510563600, 4563461);
 
 
Installed Packages
libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base
libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base
libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base
libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base
 
 
any idees where the problem is?
 
Thanxs
Steffan
_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Reply | Threaded
Open this post in threaded view
|

Re: mysql question

Steffan

Its centos 6

And your right

ldd /usr/lib64/librrd.so.4 | grep dbi

 

I installed it with yum

So I need do a manual install?

 

 

Van: [hidden email] [mailto:[hidden email]]
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question

 

Hi Steffan!

 

If you are using the default rpms of rrdtool then libdbi support may not be compiled in…

 

check the rrd shared library with ldd if it lists libdbi as a shared library it needs…

 

something like this:

ldd /usr/lib64/librrd.so.4 | grep dbi

 

At least standard Centos7 does not come with it enabled.

 

Martin

 

On 13.11.2017, at 16:17, Steffan <[hidden email]> wrote:

 

Hello,

 

Im using the tutorial from

 

including the test database tables etc

 

but im getting

 

[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"

 

 

--

-- Tabelstructuur voor tabel `RRDValue`

--

(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES

(1141942900757789274, 1510552800, 2345),

(1141942900757789274, 1510563600, 4563461);

 

 

Installed Packages

libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base

libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base

libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base

libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base

 

 

any idees where the problem is?

 

Thanxs
Steffan

_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

 


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Reply | Threaded
Open this post in threaded view
|

Re: mysql question

Steffan

What i meen is that

ldd /usr/lib64/librrd.so.4 | grep dbi

outputs nothing

 

 

Its centos 6

And your right

ldd /usr/lib64/librrd.so.4 | grep dbi

 

I installed it with yum

So I need do a manual install?

 

 

Van: [hidden email] [[hidden email]]
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question

 

Hi Steffan!

 

If you are using the default rpms of rrdtool then libdbi support may not be compiled in…

 

check the rrd shared library with ldd if it lists libdbi as a shared library it needs…

 

something like this:

ldd /usr/lib64/librrd.so.4 | grep dbi

 

At least standard Centos7 does not come with it enabled.

 

Martin

 

On 13.11.2017, at 16:17, Steffan <[hidden email]> wrote:

 

Hello,

 

Im using the tutorial from

 

including the test database tables etc

 

but im getting

 

[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"

 

 

--

-- Tabelstructuur voor tabel `RRDValue`

--

(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES

(1141942900757789274, 1510552800, 2345),

(1141942900757789274, 1510563600, 4563461);

 

 

Installed Packages

libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base

libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base

libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base

libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base

 

 

any idees where the problem is?

 

Thanxs
Steffan

_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

 


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Reply | Threaded
Open this post in threaded view
|

Re: mysql question

Martin Sperl-4
Yes, that means that you have to compile it yourself from sources…

If you want to avoid building all the dependencies that are required with the latest and greatest release of rrdtool, then try and take that exact same version from source that the rpm is providing - then all dependencies should (hopefully) be fullfilled…

If you want the latest and greatest, then I believe that there are also some scripts that do handle all those dependency installations for you - can not remember what it is called...

Martin

On 13.11.2017, at 17:00, Steffan <[hidden email]> wrote:

What i meen is that 
ldd /usr/lib64/librrd.so.4 | grep dbi
outputs nothing
 
 
Its centos 6
And your right
ldd /usr/lib64/librrd.so.4 | grep dbi
 
I installed it with yum 
So I need do a manual install?
 
 
Van: [hidden email] [[hidden email]] 
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question
 
Hi Steffan!
 
If you are using the default rpms of rrdtool then libdbi support may not be compiled in…
 
check the rrd shared library with ldd if it lists libdbi as a shared library it needs…
 
something like this:
ldd /usr/lib64/librrd.so.4 | grep dbi
 
At least standard Centos7 does not come with it enabled.
 
Martin
 
On 13.11.2017, at 16:17, Steffan <[hidden email]> wrote:
 
Hello,
 
Im using the tutorial from
 
including the test database tables etc
 
but im getting
 
[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"
 
 
--
-- Tabelstructuur voor tabel `RRDValue`
--
(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES
(1141942900757789274, 1510552800, 2345),
(1141942900757789274, 1510563600, 4563461);
 
 
Installed Packages
libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base
libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base
libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base
libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base
 
 
any idees where the problem is?
 
Thanxs
Steffan
_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
 
_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Reply | Threaded
Open this post in threaded view
|

Re: mysql question

Steffan

No alternative to get the sql data in a image?

I cant use rrd files the data is changed sometimes from the source so

The sql data is altered

 

 

Van: [hidden email] [mailto:[hidden email]]
Verzonden: maandag 13 november 2017 17:09
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question

 

Yes, that means that you have to compile it yourself from sources…

 

If you want to avoid building all the dependencies that are required with the latest and greatest release of rrdtool, then try and take that exact same version from source that the rpm is providing - then all dependencies should (hopefully) be fullfilled…

 

If you want the latest and greatest, then I believe that there are also some scripts that do handle all those dependency installations for you - can not remember what it is called...

 

Martin

 

On 13.11.2017, at 17:00, Steffan <[hidden email]> wrote:

 

What i meen is that 

ldd /usr/lib64/librrd.so.4 | grep dbi

outputs nothing

 

 

Its centos 6

And your right

ldd /usr/lib64/librrd.so.4 | grep dbi

 

I installed it with yum 

So I need do a manual install?

 

 

Van: [hidden email] [[hidden email]] 
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question

 

Hi Steffan!

 

If you are using the default rpms of rrdtool then libdbi support may not be compiled in…

 

check the rrd shared library with ldd if it lists libdbi as a shared library it needs…

 

something like this:

ldd /usr/lib64/librrd.so.4 | grep dbi

 

At least standard Centos7 does not come with it enabled.

 

Martin

 

On 13.11.2017, at 16:17, Steffan <[hidden email]> wrote:

 

Hello,

 

Im using the tutorial from

 

including the test database tables etc

 

but im getting

 

[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"

 

 

--

-- Tabelstructuur voor tabel `RRDValue`

--

(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES

(1141942900757789274, 1510552800, 2345),

(1141942900757789274, 1510563600, 4563461);

 

 

Installed Packages

libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base

libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base

libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base

libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base

 

 

any idees where the problem is?

 

Thanxs
Steffan

_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

 

_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

 


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
Reply | Threaded
Open this post in threaded view
|

Re: mysql question

Steffan
In reply to this post by Martin Sperl-4

Never mind

yum update rrdtool --enablerepo='rpmforge*'

 

fixed it for me.

thanxs

 

Van: [hidden email] [mailto:[hidden email]]
Verzonden: maandag 13 november 2017 17:09
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question

 

Yes, that means that you have to compile it yourself from sources…

 

If you want to avoid building all the dependencies that are required with the latest and greatest release of rrdtool, then try and take that exact same version from source that the rpm is providing - then all dependencies should (hopefully) be fullfilled…

 

If you want the latest and greatest, then I believe that there are also some scripts that do handle all those dependency installations for you - can not remember what it is called...

 

Martin

 

On 13.11.2017, at 17:00, Steffan <[hidden email]> wrote:

 

What i meen is that 

ldd /usr/lib64/librrd.so.4 | grep dbi

outputs nothing

 

 

Its centos 6

And your right

ldd /usr/lib64/librrd.so.4 | grep dbi

 

I installed it with yum 

So I need do a manual install?

 

 

Van: [hidden email] [[hidden email]] 
Verzonden: maandag 13 november 2017 16:51
Aan: Steffan <[hidden email]>
CC: [hidden email]
Onderwerp: Re: [rrd-users] mysql question

 

Hi Steffan!

 

If you are using the default rpms of rrdtool then libdbi support may not be compiled in…

 

check the rrd shared library with ldd if it lists libdbi as a shared library it needs…

 

something like this:

ldd /usr/lib64/librrd.so.4 | grep dbi

 

At least standard Centos7 does not come with it enabled.

 

Martin

 

On 13.11.2017, at 16:17, Steffan <[hidden email]> wrote:

 

Hello,

 

Im using the tutorial from

 

including the test database tables etc

 

but im getting

 

[root@61 web]# rrdtool graph test.png --imgformat=PNG --start=-1day --end=+3hours --width=1000 --height=600     "DEF:min=$DS_BASE:min:AVERAGE"     "LINE1:min#FF0000:value"     "DEF:avg=$DS_BASE:avg:AVERAGE"     "LINE1:avg#00FF00:average"     "DEF:max=$DS_BASE:max:AVERAGE"     "LINE1:max#FF0000:max"     "DEF:sigma=$DS_BASE:sigma:AVERAGE"     "CDEF:upper=avg,4,sigma,*,+"     "LINE1:upper#0000FF:+4 sigma"     "CDEF:lower=avg,4,sigma,*,-"     "LINE1:lower#0000FF:-4 sigma"

 

 

--

-- Tabelstructuur voor tabel `RRDValue`

--

(`RRDKeyID`, `UnixTimeStamp`, `value`) VALUES

(1141942900757789274, 1510552800, 2345),

(1141942900757789274, 1510563600, 4563461);

 

 

Installed Packages

libdbi.x86_64                                                                              0.8.3-4.el6                                                                      @base

libdbi-dbd-mysql.x86_64                                                                    0.8.3-5.1.el6                                                                    @base

libdbi-devel.x86_64                                                                        0.8.3-4.el6                                                                      @base

libdbi-drivers.x86_64                                                                      0.8.3-5.1.el6                                                                    @base

 

 

any idees where the problem is?

 

Thanxs
Steffan

_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

 

_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

 


_______________________________________________
rrd-users mailing list
[hidden email]
https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users