Skip to main content
Solved

MySQL Database Location Settings


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.

View original
Did this topic help you find an answer to your question?

8 replies

Forum|alt.badge.img+7
  • Contributor
  • 44 replies
  • 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.


Forum|alt.badge.img+14
  • Author
  • Valued Contributor
  • 156 replies
  • 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+24
  • Employee
  • 871 replies
  • 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.


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

Fantastic.

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


Forum|alt.badge.img+13
  • Contributor
  • 64 replies
  • 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


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
  • Legendary Contributor
  • 4331 replies
  • 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.


Forum|alt.badge.img+9
  • Contributor
  • 39 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings