accessing kbox mysql.
I'm trying to get to the kbox database. I've downloaded the Mysql workbench and configured it as show in accordance with the insturctions found on the kace web site.
But I get the following error. "Error occured: Access denied for user 'R1'@'%' to database ' ORG1'"
I'm sure I'm missing something.
I also downloaded the MYsql connector and installed that. Tried to configure it but there is no selection for Mysql in User data sorce screens.
Kris
But I get the following error. "Error occured: Access denied for user 'R1'@'%' to database ' ORG1'"
I'm sure I'm missing something.
I also downloaded the MYsql connector and installed that. Tried to configure it but there is no selection for Mysql in User data sorce screens.
Kris
0 Comments
[ + ] Show comments
Answers (23)
Please log in to answer
Posted by:
wesjuhdabomb
14 years ago
Posted by:
airwolf
14 years ago
Posted by:
kdasanmartino
14 years ago
R1 is the user and box747 is the password that I'm trying to use. I done both upper and lower case. Cap just the first letter and still nothing.
Also, there doesn't seem to be a "Update Report User Password" in the version I'm using. The first one that I downloaded may of had that selection but this new verison doesn't seem to.
Also, there doesn't seem to be a "Update Report User Password" in the version I'm using. The first one that I downloaded may of had that selection but this new verison doesn't seem to.
Posted by:
airwolf
14 years ago
Posted by:
kdasanmartino
14 years ago
Posted by:
airwolf
14 years ago
Posted by:
sburkey2
13 years ago
I have a question about connecting to the KACE database via NUMARA Footprints. They want to be able to pull PC info from KACE into the help request portion of NUMARA, so the help desk person can see what kind of OS and system the user calling in is using. Is it possible to connect to the System org database to pull the needed PC info or does NUMARA have to create a connection for each created org?
Thanks,
Seth
Thanks,
Seth
Posted by:
a83547
9 years ago
what's root user default password?
Comments:
-
Charlie Root password is not public knowledge. Support has it if they need it. - RichB 9 years ago
Posted by:
sgreenwall
12 years ago
Posted by:
RichB
14 years ago
The instructions (http://www.kace.com/support/customer/faq/?action=artikel&cat=9&id=9) also say to enable database access. Have you done that? With a KBOX 1200 you have to go to System, KBOX Settings, Security Settings, and put a check mark next to "Enable database access."
In a KBOX 1200 the Report User Password is set in System, Organizations, and <select the desired organization>.
In a KBOX 1200 the Report User Password is set in System, Organizations, and <select the desired organization>.
Posted by:
RichB
14 years ago
Posted by:
kdasanmartino
14 years ago
Posted by:
cblake
14 years ago
Posted by:
TJSmithCIQ
14 years ago
On my Server 2008 box if I intentionally type the wrong password, my computer's FQDN is displayed where the % is in 'R1' @ '%'. I'm using MySQL Administrator (which has been replaced with MySQL Workbench). Not sure if that's a hint of anything.
I think if you were having trouble accessing the port, the error would be different, not "Access Denied" - that implies that MySQL is answering.
Also, I would disagree with people who say that it should work with the "box747" password. Unless someone else is successfully accessing MySQL and you're the only problem user, I would say change it. That way you know for sure that your password is good, and if no one else is connecting, it doesn't hurt anyone, just rules out one possibility.
Last thing - even though I don't have it, I believe if you have the Orgs module, R1 is only the password for the Default org. Other orgs would be R2, R3, R4, etc...
I think if you were having trouble accessing the port, the error would be different, not "Access Denied" - that implies that MySQL is answering.
Also, I would disagree with people who say that it should work with the "box747" password. Unless someone else is successfully accessing MySQL and you're the only problem user, I would say change it. That way you know for sure that your password is good, and if no one else is connecting, it doesn't hurt anyone, just rules out one possibility.
Last thing - even though I don't have it, I believe if you have the Orgs module, R1 is only the password for the Default org. Other orgs would be R2, R3, R4, etc...
Posted by:
airwolf
14 years ago
Changing the KBOX report user password is only necessary if you want to change it from the default "box747". Get it working first before messing with the password.
Since he's getting an access denied message, the first logical step is changing the password and verifying that it has been typed in correctly when attempting to login.
I think if you were having trouble accessing the port, the error would be different, not "Access Denied" - that implies that MySQL is answering.
Right.
I believe if you have the Orgs module, R1 is only the password for the Default org. Other orgs would be R2, R3, R4, etc...
I don't have the Orgs module, but I do believe you are correct. I remember this being brought up at some point when I attended the KACE Konference back in November.
Posted by:
airwolf
14 years ago
You shouldn't have to use an older version of MySQL Tools... If you are attempting to connect with valid credentials to the appropriate server (you are pointing at the IP/Host Name of your KBOX, right?), then I'd suggest submitting a support ticket to KACE so they can tether to your KBOX and figure out why the R1 account is not working.
Posted by:
airwolf
14 years ago
Posted by:
vaelin
14 years ago
Posted by:
dtuttle
14 years ago
ORIGINAL: vaelin
It should be R1 for the user, box747 (unless changed) for password, and ORG1 for the database. Case sensitive.
It should be R1 for the user, box747 (unless changed) for password, and ORG1 for the database. Case sensitive.
You can change your password under the general settings.
Posted by:
kdasanmartino
14 years ago
Posted by:
kdasanmartino
14 years ago
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.