You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by "Wesley C. Dias de Oliveira" <wc...@gmail.com> on 2019/12/02 18:45:29 UTC
MariaDB Nifi Connector
Hi, community.
I'm trying to set up an ExecuteSQL 1.9.2 to execute a query against a
MariaDB Server.
Here is my config( I'm omitting some fields value ):
[image: image.png]
When I try to run the processor, occurs the following error:
[image: image.png]
Does anyone know how to solve it?
I've tried with different driver versions and Class Names.
It seems to be a simple thing but I can't find out the problem.
PS: I've checked the permissions too. It's ok.
Thank you for all your help.
--
Grato,
Wesley C. Dias de Oliveira.
Linux User nº 576838.
Re: MariaDB Nifi Connector
Posted by Chad Zobrisky <cz...@gmail.com>.
No problem. Glad you got it working!
Chad
On Mon, Dec 2, 2019 at 2:26 PM Wesley C. Dias de Oliveira <
wcdoliveira@gmail.com> wrote:
> Wow!
>
> It's was exactly the error.
>
> Thank you very much, Chad.
>
>
> Em seg., 2 de dez. de 2019 às 16:19, Chad Zobrisky <cz...@gmail.com>
> escreveu:
>
>> Wesley,
>>
>> Are you missing a colon in your connection string? jdbc:mariadb// to
>> jdbc:mariadb://
>>
>> That second colon?
>>
>> Chad
>>
>> On Mon, Dec 2, 2019 at 2:16 PM Wesley C. Dias de Oliveira <
>> wcdoliveira@gmail.com> wrote:
>>
>>> Hello, Chad.
>>>
>>> Even restarting the server, the error persists.
>>>
>>> I've already checked the libs folder.
>>>
>>> The jar is there and all the system have access to it;
>>>
>>> Em seg., 2 de dez. de 2019 às 16:10, Chad Zobrisky <cz...@gmail.com>
>>> escreveu:
>>>
>>>> Wesley,
>>>>
>>>> I believe that you need to put the mariadb jdbc driver in the nifi/libs
>>>> folder (or another folder specified for extensions, it just needs to be on
>>>> the class path) and restart nifi.
>>>>
>>>> Chad
>>>>
>>>> On Mon, Dec 2, 2019 at 1:46 PM Wesley C. Dias de Oliveira <
>>>> wcdoliveira@gmail.com> wrote:
>>>>
>>>>> Hi, community.
>>>>>
>>>>> I'm trying to set up an ExecuteSQL 1.9.2 to execute a query against a
>>>>> MariaDB Server.
>>>>>
>>>>> Here is my config( I'm omitting some fields value ):
>>>>> [image: image.png]
>>>>>
>>>>> When I try to run the processor, occurs the following error:
>>>>> [image: image.png]
>>>>>
>>>>> Does anyone know how to solve it?
>>>>>
>>>>> I've tried with different driver versions and Class Names.
>>>>>
>>>>> It seems to be a simple thing but I can't find out the problem.
>>>>>
>>>>> PS: I've checked the permissions too. It's ok.
>>>>>
>>>>> Thank you for all your help.
>>>>>
>>>>> --
>>>>> Grato,
>>>>> Wesley C. Dias de Oliveira.
>>>>>
>>>>> Linux User nº 576838.
>>>>>
>>>>
>>>
>>> --
>>> Grato,
>>> Wesley C. Dias de Oliveira.
>>>
>>> Linux User nº 576838.
>>>
>>
>
> --
> Grato,
> Wesley C. Dias de Oliveira.
>
> Linux User nº 576838.
>
Re: MariaDB Nifi Connector
Posted by "Wesley C. Dias de Oliveira" <wc...@gmail.com>.
Wow!
It's was exactly the error.
Thank you very much, Chad.
Em seg., 2 de dez. de 2019 às 16:19, Chad Zobrisky <cz...@gmail.com>
escreveu:
> Wesley,
>
> Are you missing a colon in your connection string? jdbc:mariadb// to
> jdbc:mariadb://
>
> That second colon?
>
> Chad
>
> On Mon, Dec 2, 2019 at 2:16 PM Wesley C. Dias de Oliveira <
> wcdoliveira@gmail.com> wrote:
>
>> Hello, Chad.
>>
>> Even restarting the server, the error persists.
>>
>> I've already checked the libs folder.
>>
>> The jar is there and all the system have access to it;
>>
>> Em seg., 2 de dez. de 2019 às 16:10, Chad Zobrisky <cz...@gmail.com>
>> escreveu:
>>
>>> Wesley,
>>>
>>> I believe that you need to put the mariadb jdbc driver in the nifi/libs
>>> folder (or another folder specified for extensions, it just needs to be on
>>> the class path) and restart nifi.
>>>
>>> Chad
>>>
>>> On Mon, Dec 2, 2019 at 1:46 PM Wesley C. Dias de Oliveira <
>>> wcdoliveira@gmail.com> wrote:
>>>
>>>> Hi, community.
>>>>
>>>> I'm trying to set up an ExecuteSQL 1.9.2 to execute a query against a
>>>> MariaDB Server.
>>>>
>>>> Here is my config( I'm omitting some fields value ):
>>>> [image: image.png]
>>>>
>>>> When I try to run the processor, occurs the following error:
>>>> [image: image.png]
>>>>
>>>> Does anyone know how to solve it?
>>>>
>>>> I've tried with different driver versions and Class Names.
>>>>
>>>> It seems to be a simple thing but I can't find out the problem.
>>>>
>>>> PS: I've checked the permissions too. It's ok.
>>>>
>>>> Thank you for all your help.
>>>>
>>>> --
>>>> Grato,
>>>> Wesley C. Dias de Oliveira.
>>>>
>>>> Linux User nº 576838.
>>>>
>>>
>>
>> --
>> Grato,
>> Wesley C. Dias de Oliveira.
>>
>> Linux User nº 576838.
>>
>
--
Grato,
Wesley C. Dias de Oliveira.
Linux User nº 576838.
Re: MariaDB Nifi Connector
Posted by Chad Zobrisky <cz...@gmail.com>.
Wesley,
Are you missing a colon in your connection string? jdbc:mariadb// to
jdbc:mariadb://
That second colon?
Chad
On Mon, Dec 2, 2019 at 2:16 PM Wesley C. Dias de Oliveira <
wcdoliveira@gmail.com> wrote:
> Hello, Chad.
>
> Even restarting the server, the error persists.
>
> I've already checked the libs folder.
>
> The jar is there and all the system have access to it;
>
> Em seg., 2 de dez. de 2019 às 16:10, Chad Zobrisky <cz...@gmail.com>
> escreveu:
>
>> Wesley,
>>
>> I believe that you need to put the mariadb jdbc driver in the nifi/libs
>> folder (or another folder specified for extensions, it just needs to be on
>> the class path) and restart nifi.
>>
>> Chad
>>
>> On Mon, Dec 2, 2019 at 1:46 PM Wesley C. Dias de Oliveira <
>> wcdoliveira@gmail.com> wrote:
>>
>>> Hi, community.
>>>
>>> I'm trying to set up an ExecuteSQL 1.9.2 to execute a query against a
>>> MariaDB Server.
>>>
>>> Here is my config( I'm omitting some fields value ):
>>> [image: image.png]
>>>
>>> When I try to run the processor, occurs the following error:
>>> [image: image.png]
>>>
>>> Does anyone know how to solve it?
>>>
>>> I've tried with different driver versions and Class Names.
>>>
>>> It seems to be a simple thing but I can't find out the problem.
>>>
>>> PS: I've checked the permissions too. It's ok.
>>>
>>> Thank you for all your help.
>>>
>>> --
>>> Grato,
>>> Wesley C. Dias de Oliveira.
>>>
>>> Linux User nº 576838.
>>>
>>
>
> --
> Grato,
> Wesley C. Dias de Oliveira.
>
> Linux User nº 576838.
>
Re: MariaDB Nifi Connector
Posted by "Wesley C. Dias de Oliveira" <wc...@gmail.com>.
Hello, Chad.
Even restarting the server, the error persists.
I've already checked the libs folder.
The jar is there and all the system have access to it;
Em seg., 2 de dez. de 2019 às 16:10, Chad Zobrisky <cz...@gmail.com>
escreveu:
> Wesley,
>
> I believe that you need to put the mariadb jdbc driver in the nifi/libs
> folder (or another folder specified for extensions, it just needs to be on
> the class path) and restart nifi.
>
> Chad
>
> On Mon, Dec 2, 2019 at 1:46 PM Wesley C. Dias de Oliveira <
> wcdoliveira@gmail.com> wrote:
>
>> Hi, community.
>>
>> I'm trying to set up an ExecuteSQL 1.9.2 to execute a query against a
>> MariaDB Server.
>>
>> Here is my config( I'm omitting some fields value ):
>> [image: image.png]
>>
>> When I try to run the processor, occurs the following error:
>> [image: image.png]
>>
>> Does anyone know how to solve it?
>>
>> I've tried with different driver versions and Class Names.
>>
>> It seems to be a simple thing but I can't find out the problem.
>>
>> PS: I've checked the permissions too. It's ok.
>>
>> Thank you for all your help.
>>
>> --
>> Grato,
>> Wesley C. Dias de Oliveira.
>>
>> Linux User nº 576838.
>>
>
--
Grato,
Wesley C. Dias de Oliveira.
Linux User nº 576838.
Re: MariaDB Nifi Connector
Posted by Chad Zobrisky <cz...@gmail.com>.
Wesley,
I believe that you need to put the mariadb jdbc driver in the nifi/libs
folder (or another folder specified for extensions, it just needs to be on
the class path) and restart nifi.
Chad
On Mon, Dec 2, 2019 at 1:46 PM Wesley C. Dias de Oliveira <
wcdoliveira@gmail.com> wrote:
> Hi, community.
>
> I'm trying to set up an ExecuteSQL 1.9.2 to execute a query against a
> MariaDB Server.
>
> Here is my config( I'm omitting some fields value ):
> [image: image.png]
>
> When I try to run the processor, occurs the following error:
> [image: image.png]
>
> Does anyone know how to solve it?
>
> I've tried with different driver versions and Class Names.
>
> It seems to be a simple thing but I can't find out the problem.
>
> PS: I've checked the permissions too. It's ok.
>
> Thank you for all your help.
>
> --
> Grato,
> Wesley C. Dias de Oliveira.
>
> Linux User nº 576838.
>