Conversation:

Notices

1. Douglas A. Whitfield (musicman)'s status on Tuesday, 02-Jun-2020 17:52:40 EDT Douglas A. Whitfield

   Remote profile options...
   this is owned by the proper user: [centos@ip-10-250-75-75 16:44:13 wildfly-19.0.0.Final]$ ls -la /opt/wildfly-19.0.0.Final/modules/com/mysql/main/mysql-connector-java.jar -rw-r--r-- 1 wildfly wildfly 883898 Jun 2 16:21 /opt/wildfly-19.0.0.Final/modules/com/mysql/main/mysql-connector-java.jar But it doesn't show up as a JDBC driver in the #wildfly #HAL. I did use a different pro…
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 09:35:20 EDT Douglas A. Whitfield

     Remote profile options...
     so I think the driver may have shown up and I was looking under Data Sources, not Drivers.
     
     Regardless, now I have three different mysql drivers. idk which one is right, so time to pick one :)
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 09:36:24 EDT Douglas A. Whitfield

     Remote profile options...
     they all appear to be the same version...maybe they all work
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 10:37:04 EDT Douglas A. Whitfield

     Remote profile options...
     the driver name is just the jar name. Why don't they just say that?
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 10:38:02 EDT Douglas A. Whitfield

     Remote profile options...
     username and password correct...not sure why I can't connect to db
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 10:39:15 EDT Douglas A. Whitfield

     Remote profile options...
     post is open via IP and localhost so that's not the issue...
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 10:58:59 EDT Douglas A. Whitfield

     Remote profile options...
     I couldn't post the stacktrace here...too many char. Here's a link: https://joindiaspora.com/posts/18277830
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 11:24:19 EDT Douglas A. Whitfield

     Remote profile options...
     lol: "As I was going through this task, I ran into the whole “there’s so much documentation, but none of it is working or makes sense” problem that’s so common with the JBoss Application Server. So, this post is designed to help out!"
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1)'s status on Wednesday, 03-Jun-2020 11:55:17 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     @musicman You could use the pastebin at https://pointer.federati.net/
     Douglas A. Whitfield likes this.
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1)'s status on Wednesday, 03-Jun-2020 14:05:54 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     Dumb questions, as I've never used #Wildfly, but is that the usual location for a #JDBC driver? Could it be looking elsewhere?
     
     Secondly, is there a Wildfly config file that has an option like JDBC driver path? (or full path of a desired JDBC driver)?
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1)'s status on Wednesday, 03-Jun-2020 14:27:46 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     https://joindiaspora.com/posts/6dfd1d2087d80138be8a002590d8e506#3bd27e6087f10138bec2002590d8e506
     
     Is the #MySQL #JDBC mysql-connector-j driver very different from the #MariaDB version? I would expect that they try to stay pretty close to upstream, so that their software is easily inserted in place of #Oracle MySQL.
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 14:58:13 EDT Douglas A. Whitfield

     Remote profile options...

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     in theory, HAL should be taking care of the location, as I uploaded it through a deployment. I suppose uninstalling the driver I installed via yum wouldn't hurt though.
   • Douglas A. Whitfield (musicman)'s status on Wednesday, 03-Jun-2020 15:00:33 EDT Douglas A. Whitfield

     Remote profile options...

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     that was my first assumption as well. I can diff the source, of course, but I suspect there will be lots of meaningless differences that I won't understand. It can't hurt to try though.
   • Douglas A. Whitfield (musicman)'s status on Thursday, 04-Jun-2020 14:37:30 EDT Douglas A. Whitfield

     Remote profile options...
     beware of typos in https://loadaverage.org/url/5940821 module != moduels
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1)'s status on Thursday, 04-Jun-2020 15:03:31 EDT LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     Remote profile options...

     • Douglas A. Whitfield
     Did the Medium blog post solve your problem with Wildfly and the MySQL JDBC driver?
   • Douglas A. Whitfield (musicman)'s status on Friday, 05-Jun-2020 09:11:21 EDT Douglas A. Whitfield

     Remote profile options...

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     nope. I don't see how this is a 19.x vs 17.x issue, but maybe. I have the driver installed, but when I used the same document to create a datasource, the CLI says the datasource was created but it does not show up in HAL.
   • Douglas A. Whitfield (musicman)'s status on Friday, 05-Jun-2020 10:02:19 EDT Douglas A. Whitfield

     Remote profile options...

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     this is the one I ended up using, but it is against Wildfly 12, so again, might be part of the problem with HAL: https://www.techgalery.com/2019/09/add-mysql-driver-to-wildfly.html