4 Replies Latest reply on Feb 18, 2014 12:29 PM by socalheel

    MySQL connection using JBOSS 4.0.1

    socalheel

      I am a complete jboss idiot.  This is my first time every dealing with it.

       

      Here is my scenario:

      Our customer had jboss 4.0.1 installed on an old windows box that got hacked and who knows all the damage that's been done.

       

      I stood up a new CentOS 6.5 server, installed mysql, jdk 1.5.0.4, and jboss 4.0.1.  I imported his database into the new instance and manually deployed his WAR file.

       

      Since his old server was hacked, I created a new user for his the database.  I need to update the mysql connection string but I have no idea where to find the file that contains the credentials.

       

      Can anyone point me in the right direction how to handle this?

        • 1. Re: MySQL connection using JBOSS 4.0.1
          welle

          You need to setup a database connection pool. It contain everything needed to connect to the database and is given a name that the application should know about so it can find it.

           

          Read Chapter 7. Connectors on JBoss  from The JBoss 4 Application Server Guide

          1 of 1 people found this helpful
          • 2. Re: MySQL connection using JBOSS 4.0.1
            rohitmk87

            Not sure if you got the ans. for your query. But you should be able to find "oracle-ds.xml" under the deploy directory that contains the datasource connection details. If the encryption is enabled you  may check login-config.xml under conf directory

            1 of 1 people found this helpful
            • 3. Re: MySQL connection using JBOSS 4.0.1
              socalheel

              thanks rohit and anders.

               

              i apologize for not responding sooner ... i must have missed my email notification that someone responded.  i just so happened to login this morning to check if anyone posted suggestions.

               

              i have time this morning to actually log into our jboss server and check these out.  i'll post up later on today further questions or if it's solved.

               

              thank you.

              • 4. Re: MySQL connection using JBOSS 4.0.1
                socalheel

                i did find the xml file with the credentials.  i updated the file and restarted but my page still looks the same.

                 

                what i have done is copy over the existing war and xml files from the original windows box to the new linux box and put them in the following directory:

                 

                /usr/jboss/server/all/deploy/

                 

                is there something more?