Access MySQL from SQL Server Managment Studio

[noah_swanson]

Our asset management grabs information from SCCM SQL database. I was asked to see if we can connect to the MySQL database on our Mac Server to grab computer information. Does anyone know how you can connect to MySQL to grab information from the JSS database? I found some stuff online editing the Config file for mysql but didn't want to try to do anything that might break the database.

Thanks,
Noah Swanson
Imaging Specialist
Enterprise Desktop Services
Phone: 309-765-3153
SwansonNoah at johndeere.com

[donmontalvo]

Have you looked at:

http://www.jamfsoftware.com/libraries/pdf/press_release/CasperSuite-SCCM_Integration-Press_Release.p...

Don

[jarednichols]

http://jamfsoftware.com/kb/article.php?id=022
---
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436

[noah_swanson]

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[nessts]

export the sql file from JSS setup tool open it and find the password for the DB.

--
Todd Ness
Technology Consultant/Non-Windows Services
Americas Regional Delivery Engineering
HP Enterprise Services

[jarednichols]

No. You need to allow remote access on the database. It's a security feature of MySQL. This is what step 3 of the KB article is doing. The <hostname> part is the machine you want to allow <username> access from. Use * if you want that user to access the database from any host.

Also, why would you ever ever ever use root for remote access to anything? Make a read only account.

Good lord.
---
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436

[talkingmoose]

Just wanted to make sure.
On 6/20/11 9:13 AM, "Swanson Noah" <SwansonNoah at JohnDeere.com> wrote:

Are you aware that JAMF offers a JSS --> SCCM connector? Of course, this
wouldn't be a solution if you don't want to populate your SCCM with Mac
assets but since you already have that connection then this would be an
easy solution.

--

William Smith
Technical Analyst
Merrill Communications LLC
(651) 632-1492

[noah_swanson]

The jamf KB says to "sudo mysql", then it prompts me for an admin password for sudo. I'm assuming it's passing those creds for mysql and not asking for another password.

[jarednichols]

No, it's not. MySQL has its own user structure.

j
---
Jared F. Nichols
Desktop Engineer, Client Services
Information Services Department
MIT Lincoln Laboratory
244 Wood Street
Lexington, Massachusetts 02420
781.981.5436