software installation

JustABird
New Contributor

Hi All,

I am installing JSS for the first time and got stuck at the MySQL db info screen where it's asking:
Server Name: localhost
Server Port: 3306
DB name: jamfsoftware
Username: jamfsoftware
Password: jamfsw03

I installed MySQL and tomcat and follow the exact steps from the admin guide:
/usr/local/mysql/bin/mysql -u root -p
CREATE DATABASE jamfsoftware

GRANT ALL ON jamfsoftware.* TO 'jamfsoftware'@localhost IDENTIFIED BY 'jamfsw03'

What am I doing wrong?
Please help?

9 REPLIES 9

talkingmoose
Moderator
Moderator

You've told us what you've done but you haven't said what error you're receiving. Keep in mind those CREATE and GRANT commands need to end with semi-colons ( ; ).

The JSS setup automatically populates the MySQL page using the default names and password provided in the instructions you're following. I don't believe you should need to modify anything.

JustABird
New Contributor

That did it.
I didn't put in the ; after each command, so no db was created.
Thanks a lot.

JustABird
New Contributor

I am finished with the installation.
Now, how do I login to jss with the web browser, and create my admin account and put in activation password?
What's the default web link?
I tried https://MacBookProServer:8443 where MacBookProServer is the name of my server, and it's not going anywhere.
Please advise!

talkingmoose
Moderator
Moderator

The URL you have is correct other than I don't know if the name is correct. Can you use Network Utility to ping MacBookProServer and get a response?

If you're actually on the server you can also use https://localhost:8443 or https://192.168.0.1:8443 (substituting your own IP address, of course).

donmontalvo
Esteemed Contributor III

@JustABird Why not contact JAMF support for assistance? I presume you purchased this software? ;)

--
https://donmontalvo.com

chris_kemp
Contributor III

One thing I believe you have to do is to invoke the GRANT ALL in mysql for each address you're using to access the database. If you granted 'localhost' then you have to log in with https://localhost:8443. If MacBookProServer has an IP address of 10.1.1.10, for example, then you should log back into mysql and run:

GRANT ALL ON jamfsoftware.* TO 'jamfsoftware'@10.1.1.10 IDENTIFIED BY 'jamfsw03';

I think that should get you going. :)

donmontalvo
Esteemed Contributor III

We usually set to 127.0.0.1.

--
https://donmontalvo.com

justinrummel
Contributor III

JustABird,

Substituting the name for an IP address will get you going, but I don't like doing that as there are some settings that get written that really need a full url.

I'll assume your environment has DHCP and DNS under your control. Create a forward A record in DNS for a static IP address that you have selected for your JSS and use http://server.domain.tld:8443/ . It will help you in the long run.

Chris_Hafner
Valued Contributor II

also, as a best practice you should pick a different database name and password. the jamfsoftware DB and default password are just give as examples and should NOT be used. Hopefully you're just using those as examples here in the forum?!?