Graylog 4 problem - Couldn't refresh data adapter

Graylog Central (peer support)
1

I have centos 7, graylog 4 and elk 7.

> 2021-04-02T00:57:50.153+06:00 ERROR [CSVFileDataAdapter] Couldn't parse CSV file /etc/graylog/services.csv (settings separator=<;> quotechar=<"> key_column=<fu> value_column=<fs>)
>     java.lang.IllegalStateException: Couldn't detect column number for key or value - check CSV file format
>     	at org.graylog2.lookup.adapters.CSVFileDataAdapter.parseCSVFile(CSVFileDataAdapter.java:153) ~[graylog.jar:?]
>     	at org.graylog2.lookup.adapters.CSVFileDataAdapter.doRefresh(CSVFileDataAdapter.java:109) ~[graylog.jar:?]
>     	at org.graylog2.plugin.lookup.LookupDataAdapter.refresh(LookupDataAdapter.java:109) ~[graylog.jar:?]
>     	at org.graylog2.lookup.LookupDataAdapterRefreshService.lambda$schedule$0(LookupDataAdapterRefreshService.java:142) ~[graylog.jar:?]
>     	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_282]
>     	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_282]
>     	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_282]
>     	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_282]
>     	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_282]
>     	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_282]
>     	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_282]
>     2021-04-02T00:57:56.153+06:00 ERROR [LookupDataAdapter] Couldn't refresh data adapter <fp_service_name/6065b6472b15f7228b4937b5/@45065fbf>
>     java.lang.NullPointerException: null
>     	at org.graylog2.lookup.adapters.CSVFileDataAdapter.doRefresh(CSVFileDataAdapter.java:102) ~[graylog.jar:?]
>     	at org.graylog2.plugin.lookup.LookupDataAdapter.refresh(LookupDataAdapter.java:109) ~[graylog.jar:?]
>     	at org.graylog2.lookup.LookupDataAdapterRefreshService.lambda$schedule$0(LookupDataAdapterRefreshService.java:142) ~[graylog.jar:?]
>     	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_282]
>     	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_282]
>     	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_282]
>     	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_282]
>     	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_282]
>     	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_282]
>     	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_282]
2

@hudojnick
Hello,
You might find your answer here.

FYI, Take a look here Help us, help you :slight_smile:

3

I’m already tried all of this…why are you think I post it)

4

@hudojnick
Hello,
Sorry I dont know what you have done, all I could do is offer a suggestion.Maybe some more details would have helped.

I assume all those links did not help you solve issue?
Was this from an upgrade or have you always had this problem?
What have you tried to do to solve this issue?

5

Yes, no of one didn’t help me.
It is new Graylog server and yes, I have this problem from first try.

6

I found where is my problem…)
It is in how I created csv file…I created it from Excel and save as csv utf8 and I thinked that all ok…))) But…i check hex of this file and found some strange hexes at the begining and re-create file manually in console, and It is ***** work)

7

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.