/build/static/layout/Breadcrumb_cap_w.png

Why is connection to K1000 mysql failing?

I'm having difficulty connecting to the k1000 mysql database. I'm following the directions specified here: http://www.kace.com/support/resources/kb/article/Can-I-access-the-K1000-appliance-database-using  . I changed the password under "Settings>Control Panel>General Settings>Update Reporting User Password". I made sure the "Enable Database Access" checkbox was checked under "Settings>Control Panel>Security Settings". My connection settings and the error I get when I try to test them look like this:

I'm guessing that somehow I'm doing something stupid, and that this should be very simple... Any ideas?

 


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Changing the password didn't work for whatever reason.
Posted by: jverbosk 11 years ago
Red Belt
0

See if part 7 of this post helps:

http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example

John

Posted by: Ben M 11 years ago
9th Degree Black Belt
0

I ended up getting this to work. The problem? The K1000 was still using the default password for the MYSQL DB despite the fact I changed it... twice. I changed the password using the text box here "Settings>Control Panel>General Settings>Update Reporting User Password", but it still was using the original password. Mostly because I'm curious, has anyone else experienced this? Since its working I'm not to concerned about it, but I'm a little puzzled.

 


Comments:
  • Hi Ben M,

    You should be able to change the default password for R1, please feel free to file a support ticket so that we may resolve this issue for you. - KevinG 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ