Knime DB driver mySQL on a server without GUI

KNIME Analytics Platform
1

Hi everybody,

Could you help me to find the "Knime Preferences" file to configure my Database driver ?

I have a linux server without GUI (only command line) and I have to configure my "MySQL driver".

I don't know where to add my driver for Knime.

Thanks a lot,

Thierry Crettol

2

Hi,

Go to your local workspace directory and run this command :
grep -lR "mysql-connector-java-5.1.40-bin.jar"

Then, follow the both post to add your database driver to your server preferences :

https://tech.knime.org/forum/knime-users/knime-preferences

https://tech.knime.org/faq#q12

copy-past your exported preferences to your new knime-workspace

modify the path of the driver in the preferences file.

On my server, the root user does not work (mysql) so you have to make a new user for your mysql-server to use with knime.

For exemple :

/home/knime/knime_3.3.1/knime -nosplash -reset -nosave -preferences=/home/knime/knime-workspace/prefs.epf -application org.knime.product.KNIME_BATCH_APPLICATION -workflowDir="/home/knime/knime-workspace/test_server"

3

Hi Thierry,

I have the feeling I am always too late for your questions :-)

Thanks for sharing the solution 

Cheers, Iris 

4