Crawling MySQL Data Store Fail

  • PS:I’m not good at English, part of the content may be from Google Translate.

Here’s some info that might be helpful:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/stx_test
username=root
password={cipher}6173cd8ecda1fae97375d1785f7f8477
sql=select title, text from stx_test.typecho_contents WHERE type = ‘post’ OR type = ‘page’;

Script

url=“http://localhost:8080/” + id
host=“localhost”
site=“localhost”
title=title
content=content
cache=content
digest=content
content_length=content.length()

I don’t know where the problem is, it’s hard to find information about it on the Internet.
Maybe the url in the Script Config is wrong? But I’m not quite sure what exactly it should be written as…

Additional Information:

  • FESS and OpenSearch both run on WSL2 (as a test).

extremely grateful

oh i left out the id field in the url, so sorry…but problem solved

2 Likes

您好 可以教教我嘛 万分感谢 qq81348646

您好 我可以跟您学习一下fess爬取mysql数据是如何的配置嘛 我的qq81348646 万分感谢

之前写的 …… 可以看看