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,
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 :
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"
I have the feeling I am always too late for your questions :-)
Thanks for sharing the solution