Connection problem to MySQL, hot_gym_swarm test on Ubuntu 16.04LTS

swarming
question
nupic

#22

Found it, its at:
’/usr/local/lib/python2.7/dist-packages/'
I see that in the ‘support’ folder within nupic there’s a ‘nupic-default.xml’ file. Should I make a copy of the ‘nupic-default.xml’ file within ‘support’, rename it ‘nupic-site.xml’ and add in my password to the password field?


#23

Yes try that.

You only need to provide XML in nupic-site.xml for overridden values, so yours should look something like this:

nupic-site.xml

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>

<!-- database credentials, used for swarming -->

<property>
  <name>nupic.cluster.database.user</name>
  <value>YOUR_USERNAME</value>
  <description>Username for the MySQL database server </description>
</property>

<property>
  <name>nupic.cluster.database.passwd</name>
  <value>YOUR_PASSWORD</value>
  <description>Password for the MySQL database server </description>
</property>

</configuration>


#24

Hello,

I found and edit the nupic-site.xml file, but still did not work. I found this solution: http://www.dangtrinh.com/2017/08/fix-mysql-error-1698-28000-access.html

Basically you have to set the root (or any user) user to use the mysql_native_password plugin instead of auth_socket.

Cheers.


#25

It really works. Thanks :slight_smile: