PostgreSQL integration


(Sanx El Santo) #1

Greetings to all

Is there a process for setting up ElasticSearch to automatically index
data in PostgreSQL and make it search-able?

I am begining a project and I'm not quite sure where I have to start

anyone have any suggestions

Thanks for your attention


(Jörg Prante) #2

You can try the JDBC river plugin

Best regards,

Jörg

On Wednesday, July 4, 2012 5:32:31 PM UTC+2, Sanx El Santo wrote:

Greetings to all

Is there a process for setting up ElasticSearch to automatically index
data in PostgreSQL and make it search-able?

I am begining a project and I'm not quite sure where I have to start

anyone have any suggestions

Thanks for your attention


(DavidLR-2) #3

I cannot get this going with postgresql 9.1, I only get the error "no
suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here:
http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in
/usr/share/elasticsearch/plugins/river_jdbc which is where the
elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for
postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for
postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at
org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at
org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and
search postgresql databases with elasticsearch.
Thanks

--


(David Pilato) #4

Try to put postgresql jar in es lib dir. And restart ES.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 23 août 2012 à 21:58, DavidLR davidlreiff@gmail.com a écrit :

I cannot get this going with postgresql 9.1, I only get the error "no suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here: http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in /usr/share/elasticsearch/plugins/river_jdbc which is where the elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and search postgresql databases with elasticsearch.
Thanks

--

--


(David Pilato) #5

And try with jdbc:postgresql://localhost:5432/test (not jdbc.postgresql)

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 23 août 2012 à 22:00, David Pilato david@pilato.fr a écrit :

Try to put postgresql jar in es lib dir. And restart ES.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 23 août 2012 à 21:58, DavidLR davidlreiff@gmail.com a écrit :

I cannot get this going with postgresql 9.1, I only get the error "no suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here: http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in /usr/share/elasticsearch/plugins/river_jdbc which is where the elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and search postgresql databases with elasticsearch.
Thanks

--

--

--


(DavidLR-2) #6

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--


(David Pilato) #7

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

I hope this helps.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff davidlreiff@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in addition to being in /plugins/river-jdbc) and I've tried several combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need "org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--


(Sourav Gulati) #8

Use ODBC driver instaed of JDBC. that will help
On Friday, August 24, 2012 1:28:13 AM UTC+5:30, DavidLR wrote:

I cannot get this going with postgresql 9.1, I only get the error "no
suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here:
http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in
/usr/share/elasticsearch/plugins/river_jdbc which is where the
elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for
postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for
postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at
org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at
org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and
search postgresql databases with elasticsearch.
Thanks

--


(DavidLR-2) #9

I'm really grateful for your help, David, but I still don't have it going.
I haven't had much time to work on it since my last post, but I'm beginning
to think that the postgres jdbc driver is not in the class path. Again, I
know nothing about java or class paths; I get this from google searches.
I'm open to any ideas about how to check my elastic search class path and
how to add the postgresql jdbc driver to it, if that's needed. The examples
I've seen about setting class paths seem to apply if I were creating my own
java program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :

jdbc:postgresql:database

jdbc:postgresql://host/database

jdbc:postgresql://host:port/database

I hope this helps.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff <david...@gmail.com <javascript:>> a
écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--


(David Pilato) #10

Could you "ls -l" your es lib dir ?

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR davidlreiff@gmail.com a écrit :

I'm really grateful for your help, David, but I still don't have it going. I haven't had much time to work on it since my last post, but I'm beginning to think that the postgres jdbc driver is not in the class path. Again, I know nothing about java or class paths; I get this from google searches. I'm open to any ideas about how to check my elastic search class path and how to add the postgresql jdbc driver to it, if that's needed. The examples I've seen about setting class paths seem to apply if I were creating my own java program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:
Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

I hope this helps.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff david...@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in addition to being in /plugins/river-jdbc) and I've tried several combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need "org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

--


(Ivan Brusic) #11

Are you using the service wrapper by any chance? Given your startup
command above, probably not.

--
Ivan

On Thu, Sep 6, 2012 at 7:20 PM, DavidLR davidlreiff@gmail.com wrote:

I'm really grateful for your help, David, but I still don't have it going. I
haven't had much time to work on it since my last post, but I'm beginning to
think that the postgres jdbc driver is not in the class path. Again, I know
nothing about java or class paths; I get this from google searches. I'm open
to any ideas about how to check my elastic search class path and how to add
the postgresql jdbc driver to it, if that's needed. The examples I've seen
about setting class paths seem to apply if I were creating my own java
program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :

jdbc:postgresql:database

jdbc:postgresql://host/database

jdbc:postgresql://host:port/database

I hope this helps.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff david...@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

--


(DavidLR-2) #12

Sure -

dave@dave-desktop:~$ ls -l /usr/share/elasticsearch/lib
total 14952
-rw-r--r-- 1 root root 9998142 2012-07-02 15:04 elasticsearch-0.19.8.jar
-rw-r--r-- 1 root root 865400 2012-07-02 15:04 jna-3.3.0.jar
-rw-r--r-- 1 root root 481535 2012-07-02 15:04 log4j-1.2.16.jar
-rw-r--r-- 1 root root 1172498 2012-07-02 15:04 lucene-analyzers-3.6.0.jar
-rw-r--r-- 1 root root 1535258 2012-07-02 15:04 lucene-core-3.6.0.jar
-rw-r--r-- 1 root root 89201 2012-07-02 15:04 lucene-highlighter-3.6.0.jar
-rw-r--r-- 1 root root 29814 2012-07-02 15:04 lucene-memory-3.6.0.jar
-rw-r--r-- 1 root root 47407 2012-07-02 15:04 lucene-queries-3.6.0.jar
-rw-rw-r-- 1 dave dave 507454 2012-08-23 13:34 postgresql-9.1-902.jdbc3.jar
-rw-rw-r-- 1 dave dave 561969 2012-08-17 10:58 postgresql-9.1-902.jdbc4.jar
drwxr-xr-x 2 root root 4096 2012-08-22 09:14 sigar

I added the jdbc3.jar in case it might help, but, no help.

On Fri, Sep 7, 2012 at 12:42 AM, David Pilato david@pilato.fr wrote:

Could you "ls -l" your es lib dir ?

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR davidlreiff@gmail.com a écrit :

--


(DavidLR-2) #13

No, I'm not. I was hoping to just get a simple database table indexed to
get started, then move on to learning more, but I can't get any indexing
going. For now I'm starting it with ./bin/elasticsearch -f
-Des.config=/etc/elasticsearch/elasticsearch.yml

Thanks Dave

On Fri, Sep 7, 2012 at 11:18 AM, Ivan Brusic ivan@brusic.com wrote:

Are you using the service wrapper by any chance? Given your startup
command above, probably not.

--
Ivan

On Thu, Sep 6, 2012 at 7:20 PM, DavidLR davidlreiff@gmail.com wrote:

I'm really grateful for your help, David, but I still don't have it
going. I
haven't had much time to work on it since my last post, but I'm
beginning to
think that the postgres jdbc driver is not in the class path. Again, I
know
nothing about java or class paths; I get this from google searches. I'm
open
to any ideas about how to check my elastic search class path and how to
add
the postgresql jdbc driver to it, if that's needed. The examples I've
seen
about setting class paths seem to apply if I were creating my own java
program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :

jdbc:postgresql:database

jdbc:postgresql://host/database

jdbc:postgresql://host:port/database

I hope this helps.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff david...@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f
-Des.config=/etc/elasticsearch/elasticsearch.yml'

and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

--

--


(David Pilato) #14

Hmmm.

Adding jdbc3 won't help. Remove it.

I misread Jörg Prante readme. You have to put your jar in plugins/river-jdbc
directory.
Sorry.

See here: https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart

HTH
David

Le 7 septembre 2012 à 22:04, David Reiff davidlreiff@gmail.com a écrit :

Sure -

dave@dave-desktop:~$ ls -l /usr/share/elasticsearch/lib
total 14952
-rw-r--r-- 1 root root 9998142 2012-07-02 15:04 elasticsearch-0.19.8.jar
-rw-r--r-- 1 root root 865400 2012-07-02 15:04 jna-3.3.0.jar
-rw-r--r-- 1 root root 481535 2012-07-02 15:04 log4j-1.2.16.jar
-rw-r--r-- 1 root root 1172498 2012-07-02 15:04 lucene-analyzers-3.6.0.jar
-rw-r--r-- 1 root root 1535258 2012-07-02 15:04 lucene-core-3.6.0.jar
-rw-r--r-- 1 root root 89201 2012-07-02 15:04 lucene-highlighter-3.6.0.jar
-rw-r--r-- 1 root root 29814 2012-07-02 15:04 lucene-memory-3.6.0.jar
-rw-r--r-- 1 root root 47407 2012-07-02 15:04 lucene-queries-3.6.0.jar
-rw-rw-r-- 1 dave dave 507454 2012-08-23 13:34 postgresql-9.1-902.jdbc3.jar
-rw-rw-r-- 1 dave dave 561969 2012-08-17 10:58 postgresql-9.1-902.jdbc4.jar
drwxr-xr-x 2 root root 4096 2012-08-22 09:14 sigar

I added the jdbc3.jar in case it might help, but, no help.

On Fri, Sep 7, 2012 at 12:42 AM, David Pilato <david@pilato.fr
mailto:david@pilato.fr > wrote:

Could you "ls -l" your es lib dir ?

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR < davidlreiff@gmail.com
mailto:davidlreiff@gmail.com > a écrit :

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--


(DavidLR-2) #15

Well, I hate to drive you crazy but I've tried with only the jdbc4 driver
in the /plugins/river-jdbc directory; with only the jdbc4 driver in both
the /lib and the /plugins/river-jdbc directories, with only the jdbc4
driver in the /lib directory, and with both the jdbc4 driver and the jdbc3
driver in the /lib directory (as shown in my previous post).

A reply to a similar question here


says that this error has two causes:

  1. The JDBC driver is not loaded at all.
  2. URL does not match any of the loaded JDBC drivers.

If this is the right path for me to follow, maybe somehow my jdbc driver is
not being loaded at all??

On Fri, Sep 7, 2012 at 3:32 PM, David Pilato david@pilato.fr wrote:

**

Hmmm.

Adding jdbc3 won't help. Remove it.

I misread Jörg Prante readme. You have to put your jar in plugins/river-jdbc
directory.

Sorry.

See here:
https://github.com/jprante/elasticsearch-river-jdbc/wiki/Quickstart

HTH

David

Le 7 septembre 2012 à 22:04, David Reiff davidlreiff@gmail.com a
écrit :

Sure -

dave@dave-desktop:~$ ls -l /usr/share/elasticsearch/lib
total 14952
-rw-r--r-- 1 root root 9998142 2012-07-02 15:04 elasticsearch-0.19.8.jar
-rw-r--r-- 1 root root 865400 2012-07-02 15:04 jna-3.3.0.jar
-rw-r--r-- 1 root root 481535 2012-07-02 15:04 log4j-1.2.16.jar
-rw-r--r-- 1 root root 1172498 2012-07-02 15:04 lucene-analyzers-3.6.0.jar
-rw-r--r-- 1 root root 1535258 2012-07-02 15:04 lucene-core-3.6.0.jar
-rw-r--r-- 1 root root 89201 2012-07-02 15:04
lucene-highlighter-3.6.0.jar
-rw-r--r-- 1 root root 29814 2012-07-02 15:04 lucene-memory-3.6.0.jar
-rw-r--r-- 1 root root 47407 2012-07-02 15:04 lucene-queries-3.6.0.jar
-rw-rw-r-- 1 dave dave 507454 2012-08-23 13:34
postgresql-9.1-902.jdbc3.jar
-rw-rw-r-- 1 dave dave 561969 2012-08-17 10:58
postgresql-9.1-902.jdbc4.jar
drwxr-xr-x 2 root root 4096 2012-08-22 09:14 sigar

I added the jdbc3.jar in case it might help, but, no help.

On Fri, Sep 7, 2012 at 12:42 AM, David Pilato david@pilato.fr wrote:

Could you "ls -l" your es lib dir ?

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR < davidlreiff@gmail.com> a écrit :

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/

Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--

--


(DavidLR-2) #16

Anyone who knows java, could this be related to my problem?

This person says there's a bug in Mule 3.1.2. Could this be an issue for me
also? If so, what do I do?
I'm lost with any java-related stuff.

--


(Jörg Prante) #17

Hi,

I did a write-up here how to use JDBC river and PostgreSQL 9.1, in the hope
it helps.

Best regards,

Jörg

On Saturday, September 8, 2012 3:54:46 AM UTC+2, DavidLR wrote:

Anyone who knows java, could this be related to my problem?

http://stackoverflow.com/questions/7790609/no-suitable-driver-found-for-jdbc-postgresql?rq=1

This person says there's a bug in Mule 3.1.2. Could this be an issue for
me also? If so, what do I do?
I'm lost with any java-related stuff.

--


(DavidLR-2) #18

I got it going! I had a space in my url, like this:

"url" : "jdbc: postgresql://localhost:5432/nibbel",

which should be

"url" : "jdbc:postgresql://localhost:5432/nibbel",

(no space after jdbc:) That little space caused the "no suitable driver
found" error to come up.

Also had to edit pg_hba.conf to allow access to the database.

I can't work on this every day so it took a while. Thanks, David, for quick
replies and thanks Jorge for working out the procedure for Postgresql.

On Saturday, September 8, 2012 4:11:10 PM UTC-5, Jörg Prante wrote:

Hi,

I did a write-up here how to use JDBC river and PostgreSQL 9.1, in the
hope it helps.

https://github.com/jprante/elasticsearch-river-jdbc/wiki/JDBC-river-and-PostgreSQL

Best regards,

Jörg

On Saturday, September 8, 2012 3:54:46 AM UTC+2, DavidLR wrote:

Anyone who knows java, could this be related to my problem?

http://stackoverflow.com/questions/7790609/no-suitable-driver-found-for-jdbc-postgresql?rq=1

This person says there's a bug in Mule 3.1.2. Could this be an issue for
me also? If so, what do I do?
I'm lost with any java-related stuff.

--


(chaithanya) #19

HI can any one help me out how to generate reports using postgresql in ELK,in elastic search i configured jdbc jar files and its working fine later wat step i have to do in logslash and ui kebina..please help me out


(system) #20