Skip to main content
Solved

MySQL Database Location Settings

  • June 18, 2014
  • 8 replies
  • 38 views
T
Forum|alt.badge.img+14

I'm sure this has probably been answered, but I cannot find anything on it.

We are working on upgrading our JSS system to 9.32 over the next couple of days and I'm having an issue with the location of the database.I currently have a Windows 2012 Server box running the JSS installation.

Our MySQL database is on a separate local drive. For some reason, when I installed JSS it didn't give me the option to connect to it at a specified location. I'm somewhat new at this and was wondering if I could get some assistance?

Sincerely,
TJ

Best answer by emily

From what I understand, when you install the JSS it looks for a local instance of MySQL. If there isn't one, it asks for a location. So assuming it's on the same box as the JSS, it grabs it automatically.

    8 replies

    J
    Forum|alt.badge.img+7
    • jdziat
    • Contributor
    • June 19, 2014

    You don't need a local path. Its going to essentially use localhost:3306 to connect to the mysql service. It's not a file you specify as much a network address and port number that the service interacts with. I would google MySQL and read the wiki article at least if you need to know more specifics.

    T
    Forum|alt.badge.img+14
    • tthurman
    • Author
    • Valued Contributor
    • June 19, 2014

    So, as long as the MySQL service is running on the machine, it doesn't matter where the database is stored?

    That's kinda nice.

    emily
    Forum|alt.badge.img+26
    • emily
    • Hall of Fame
    • Answer
    • June 19, 2014

    From what I understand, when you install the JSS it looks for a local instance of MySQL. If there isn't one, it asks for a location. So assuming it's on the same box as the JSS, it grabs it automatically.

    ekw | jamf @ jamf
    T
    Forum|alt.badge.img+14
    • tthurman
    • Author
    • Valued Contributor
    • June 19, 2014

    Fantastic.

    Thank you very much to the both of you. @emilykausalik and @jdziat.

    Y
    Forum|alt.badge.img+13
    • yan1212
    • Contributor
    • June 19, 2014

    You could have a look in the database.xml file, this is where the database location, path, name etc are stored.

    In Windows this 'should' be in: C:Program Files/Apache Tomcat Foundation/Tomcat 7/webapps/ROOT/WEB-INF/xml/database.xml

    Hope this helps

    D
    Forum|alt.badge.img+2

    Is there anyway, that the DataBase.xml can be encrypted, as the <DataBaseUser> & <DataBasePassword> are clear text?

    bentoms
    Forum|alt.badge.img+35
    • bentoms
    • Hall of Fame
    • February 21, 2017

    @Dinnerticketboy AFAIK that's a Tomcat thing...

    I'd be more worried about folks getting far enough to read the contents of the xml.. & not so much the contents itself.

    R
    Forum|alt.badge.img+9
    • robmorton
    • Contributor
    • June 27, 2017

    Yeah, I would need that file encrypted as well. Basic rule of thumb, do not store a password in clear text. If you are working for the government, no clear text password can exist like that. This would be a show stopper.

    Terms & ConditionsCookie settingsAccessibility statement