Mysql Extension 5.1.40 updates automatically to latest

Dear Team
I have lucee up and running on serveral servers, for datasources, we use the mysql extension version 5.1.40 (because we have “old” mysql server on that specific machines) and need the old mysql extension version to connect successfully.
now the odd thing (which is unfortunately not suitable for production enviroments): the mysql extension updates from time to time automatically (!) to the newest version. we don’t have to auto update feature on, it is disabled.

  1. lucee newest version Lucee 5.3.6.61
  2. mysql extension 5.1.40
  3. Restart lucee service (windows 2016 server)
  4. suddenly, datasources with connection error, our applications stop working (no database connection) - due (guess what) -> mysql extension is suddenly on latest version 8.0.19!!

How can I be sure that the extension will not update automatically on server restarts or “from self”? We need 5.1.40 and stay with it…
I am so lost, lucee is not usable for us as long as suddenly the extension gets newer (and not able to connect to mysql servers). It should definitely stick to the configurated version…
I would be so glad if someone could help…
thank you so much guys…
best regards from switzerland
Raffael Meier

Don’t forget to tell us about your stack!

OS: Windows 2016 Standard
Java Version: 11.0.4 (AdoptOpenJDK) 64bit
Tomcat Version: Apache Tomcat/9.0.24
Lucee Version: Lucee 5.3.6.61

@raffaelmeier, Welcome
I can sure it’ll not update the extension as latest version when restart the lucee. Could you please make sure once again, you’ve extension latest version 8.0.19 or version 5.1.40 before restart?

Can you set the log level for deploy.log to trace (server admin) and then reproduce the problem and then post the log here?

hi zac, hi CF Mitrah
thanks for your superfast reaction! wish the adobe teams in earlier days would have been so responsive (and i felt like they took loads of money for beeing slow :wink:
yes, I will put log level to trace and try to reproduce… I reach out later… thanks so much!
Raffael

hi zac, hi CF Mitrah
I could reproduce the problem, although it needed a windows restart.
Before restart, installed version was 5.1.40, after windows reboot, I went into lucee admin screen > extension > applications and see mysql extension updated to 8.0.19 (latest).

the log (deploy.log) shows only the following, which is cryptic for me (since the file names do not say anything to me):

“ERROR”,“http-nio-8888-exec-10”,“07/21/2020”,“17:08:57”,“extension”,“C:\lucee\tomcat\lucee-server\context\extensions\installed\114yic6o1sm8f.lex (Das System kann die angegebene Datei nicht finden);C:\lucee\tomcat\lucee-server\context\extensions\installed\114yic6o1sm8f.lex (Das System kann die angegebene Datei nicht finden);java.io.FileNotFoundException: C:\lucee\tomcat\lucee-server\context\extensions\installed\114yic6o1sm8f.lex (Das System kann die angegebene Datei nicht finden)
at java.base/java.io.FileInputStream.open0(Native Method)
at java.base/java.io.FileInputStream.open(Unknown Source)
at java.base/java.io.FileInputStream.(Unknown Source)
at lucee.commons.io.res.type.file.FileResource.getInputStream(FileResource.java:231)
at lucee.runtime.extension.RHExtension.load(RHExtension.java:277)
at lucee.runtime.extension.RHExtension.getFlds(RHExtension.java:1199)
at lucee.runtime.extension.RHExtension.populate(RHExtension.java:952)
at lucee.runtime.extension.RHExtension.toQuery(RHExtension.java:909)
at lucee.runtime.tag.Admin.doGetRHServerExtensions(Admin.java:2454)
at lucee.runtime.tag.Admin._doStartTag(Admin.java:549)
at lucee.runtime.tag.Admin.doStartTag(Admin.java:353)
at update_cfm$cf.call(/admin/update.cfm:78)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1127)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1073)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
…”
“ERROR”,“http-nio-8888-exec-8”,“07/21/2020”,“17:12:21”,“extension”,“C:\lucee\tomcat\lucee-server\context\extensions\installed\bg7w3s4v2yrg.lex (Das System kann die angegebene Datei nicht finden);C:\lucee\tomcat\lucee-server\context\extensions\installed\bg7w3s4v2yrg.lex (Das System kann die angegebene Datei nicht finden);java.io.FileNotFoundException: C:\lucee\tomcat\lucee-server\context\extensions\installed\bg7w3s4v2yrg.lex (Das System kann die angegebene Datei nicht finden)
at java.base/java.io.FileInputStream.open0(Native Method)
at java.base/java.io.FileInputStream.open(Unknown Source)
at java.base/java.io.FileInputStream.(Unknown Source)
at lucee.commons.io.res.type.file.FileResource.getInputStream(FileResource.java:231)
at lucee.runtime.extension.RHExtension.load(RHExtension.java:277)
at lucee.runtime.extension.RHExtension.getFlds(RHExtension.java:1199)
at lucee.runtime.extension.RHExtension.populate(RHExtension.java:952)
at lucee.runtime.extension.RHExtension.toQuery(RHExtension.java:909)
at lucee.runtime.tag.Admin.doGetRHServerExtensions(Admin.java:2454)
at lucee.runtime.tag.Admin._doStartTag(Admin.java:549)
at lucee.runtime.tag.Admin.doStartTag(Admin.java:353)
at update_cfm$cf.call(/admin/update.cfm:78)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1127)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1073)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
…”

I just could reproduce the problem with only restarting lucee in the admin screen (with “services > restart”). before restart, mysql extension was 5.1.40, after restart, it shows 8.0.19 - and datasources show error on verify and application can not connect to mysql (need 5.1.40 due older mysql server version).
I really stuck… the only entry in deploy.log which is now is:

“ERROR”,“http-nio-8888-exec-2”,“07/21/2020”,“20:30:06”,“extension”,“C:\lucee\tomcat\lucee-server\context\extensions\installed\114yic6o1sm8f.lex (Das System kann die angegebene Datei nicht finden);C:\lucee\tomcat\lucee-server\context\extensions\installed\114yic6o1sm8f.lex (Das System kann die angegebene Datei nicht finden);java.io.FileNotFoundException: C:\lucee\tomcat\lucee-server\context\extensions\installed\114yic6o1sm8f.lex (Das System kann die angegebene Datei nicht finden)
at java.base/java.io.FileInputStream.open0(Native Method)
at java.base/java.io.FileInputStream.open(Unknown Source)
at java.base/java.io.FileInputStream.(Unknown Source)
at lucee.commons.io.res.type.file.FileResource.getInputStream(FileResource.java:231)
at lucee.runtime.extension.RHExtension.load(RHExtension.java:277)
at lucee.runtime.extension.RHExtension.getFlds(RHExtension.java:1199)
at lucee.runtime.extension.RHExtension.populate(RHExtension.java:952)
at lucee.runtime.extension.RHExtension.toQuery(RHExtension.java:909)
at lucee.runtime.tag.Admin.doGetRHServerExtensions(Admin.java:2454)
at lucee.runtime.tag.Admin._doStartTag(Admin.java:549)
at lucee.runtime.tag.Admin.doStartTag(Admin.java:353)
at update_cfm$cf.call(/admin/update.cfm:78)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1127)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1073)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
…”

I just found the following line in lucee-server.xml and I see “114yic6o1sm8f.lex” as filename there for the com.mysql.jdbc.Driver, which comes also in the deploy.log as an error (file not found).
has this something to do with it? probably lucee can not (re)find the file on startup?
also the com.mysql.jdbc.Driver comes twice, once in the very beginning of the line and a second entry near the end of the line. just maybe interesting.

<datasource/><extensions><rhextension categories="Datasource" file-name="114yic6o1sm8f.lex" id="7E673D15-D87C-41A6-8B5F1956528C605F" jdbc="[{'label':'MySQL','id':'mysql','connectionString':'jdbc:mysql://{host}:{port}/{database}','class':'com.mysql.jdbc.Driver','bundleName':'com.mysql.jdbc','bundleVersion':'5.1.40'}]" lucee-core-version="5.0.0.019-" name="MySQL" release-type="all" start-bundles="false" trial="false" version="5.1.40"/><rhextension file-name="wnakxokve7b0.lex" id="CED6227E-0F49-6367-A68D21AACA6B07E8" lucee-core-version="5.0.0.050-" mapping="[{'virtual':'/lucee/admin','physical':'{lucee-config}/context/admin','archive':'{lucee-config}/context/lucee-admin.lar','primary':'physical ','inspect':'once ','toplevel':'true','readonly':'true','listenermode':'modern','listenertype':'curr2root '}]" name="Lucee Administrator" release-type="all" start-bundles="false" trial="false" version="1.0.0.3"/><rhextension file-name="18buz1m6kzx2m.lex" id="D46D49C3-EB85-8D97-30BEC2F38561E985" lucee-core-version="5.0.0.050-" mapping="[{'virtual':'/lucee/doc','physical':'','archive':'{lucee-config}/context/lucee-doc.lar','primary':'archive ','inspect':'once ','toplevel':'true','readonly':'true','listenermode':'modern','listenertype':'curr2root '}]" name="Lucee Documentation" release-type="all" start-bundles="false" trial="false" version="1.0.0.2"/><rhextension file-name="dfa30cy1s8av.lex" id="17AB52DE-B300-A94B-E058BD978511E39E" lucee-core-version="-" name="S3 Resource Extension" release-type="server" resource="[{'class':'org.lucee.extension.resource.s3.S3ResourceProvider','bundleName':'s3.extension','bundleVersion':'0.9.4.122','scheme':'s3','lock-timeout':'10000'}]" start-bundles="false" trial="false" version="0.9.4.122"/><rhextension cache="[{'class':'org.lucee.extension.cache.eh.EHCache','bundleName':'ehcache.extension','bundleVersion':'2.10.0.31'}]" file-name="1apdrbs8iaisw.lex" id="87FE44E5-179C-43A3-A87B3D38BEF4652E" lucee-core-version="5.0.0.230-" name="EHCache" release-type="server" start-bundles="false" trial="false" version="2.10.0.31"/><rhextension file-name="1d925hoxusnre.lex" id="D46B46A9-A0E3-44E1-D972A04AC3A8DC10" lucee-core-version="5.0.0.244-" name="Chart Extension" release-type="server" start-bundles="false" trial="false" version="1.0.19.24"/><rhextension file-name="18ozxgf5709c8.lex" id="FAD1E8CB-4F45-4184-86359145767C29DE" lucee-core-version="5.0.0.157-" name="Hibernate ORM Engine" orm="[{'class':'org.lucee.extension.orm.hibernate.HibernateORMEngine','name':'hibernate.extension','version':'3.5.5.75'}]" release-type="server" start-bundles="false" trial="false" version="3.5.5.75"/><rhextension file-name="1caill1y2wst3.lex" id="EFDEB172-F52E-4D84-9CD1A1F561B3DFC8" lucee-core-version="-" name="Lucene Search Engine" release-type="server" search="[{'class':'org.lucee.extension.search.lucene.LuceneSearchEngine','bundleName':'lucene.search.extension','bundleVersion':'2.4.1.32'}]" start-bundles="false" trial="false" version="2.4.1.32"/><rhextension file-name="gbobprnpmaik.lex" id="66E312DD-D083-27C0-64189D16753FD6F0" lucee-core-version="5.0.0.244-" name="PDF Extension" release-type="server" start-bundles="false" trial="false" version="1.0.0.80"/><rhextension file-name="w1ofxxm9quan.lex" id="FAD67145-E3AE-30F8-1C11A6CCF544F0B7" lucee-core-version="5.1.0.19-" name="Form Tags" release-type="all" start-bundles="false" trial="false" version="1.0.0.10"/><rhextension file-name="1ffxjcpru0bdb.lex" id="DF28D0A4-6748-44B9-A2FDC12E4E2E4D38" lucee-core-version="5.3.0.20-" name="Axis 1 Webservices" release-type="server" start-bundles="false" trial="false" version="1.4.0.26-SNAPSHOT" webservice="{'class':'org.lucee.extension.axis.Axis1Handler','name':'org.lucee.axis.extension','version':'1.4.0.26-SNAPSHOT'}"/><rhextension file-name="141eaesat51i5.lex" id="B737ABC4-D43F-4D91-8E8E973E37C40D1B" lucee-core-version="5.3.0.35-" name="Image extension" release-type="all" start-bundles="false" trial="false" version="1.0.0.35"/><rhextension file-name="dkpkijs58ry1.lex" id="37C61C0A-5D7E-4256-8572639BE0CF5838" lucee-core-version="5.3.0.36-" name="ESAPI extension" release-type="all" start-bundles="false" trial="false" version="2.2.0.0-SNAPSHOT"/><rhextension file-name="1v8soc8s1efxq.lex" id="8D7FB0DF-08BB-1589-FE3975678F07DB17" lucee-core-version="5.0.0.252-" name="Compress Tags" release-type="all" start-bundles="false" trial="false" version="1.0.0.2"/><rhextension file-name="18amu3rvjgk9q.lex" id="6E2CB28F-98FB-4B51-B6BE6C64ADF35473" name="Ajax Extension" release-type="server" start-bundles="true" trial="false" version="1.0.0.3"/><rhextension categories="Application" file-name="jedjbpy6jjq3.lex" id="037A27FF-0B80-4CBA-B954BEBD790B460E" loader-version="5.9" lucee-core-version="5.0.0.252-" name="cfspreadsheet" release-type="all" start-bundles="false" trial="false" version="3.0.3"/></extensions><jdbc><driver bundle-name="com.mysql.jdbc" bundle-version="5.1.40" class="com.mysql.jdbc.Driver" id="mysql" label="MySQL"/></jdbc><caches><cache bundle-name="ehcache.extension" bundle-version="2.10.0.31" class="org.lucee.extension.cache.eh.EHCache"/></caches><search engine-bundle-name="lucene.search.extension" engine-bundle-version="2.4.1.32" engine-class="org.lucee.extension.search.lucene.LuceneSearchEngine"/><webservice bundle-name="org.lucee.axis.extension" bundle-version="1.4.0.26-SNAPSHOT" class="org.lucee.extension.axis.Axis1Handler"/></cfLuceeConfiguration>

Can you try the latest 5.3.7-RC?

1 Like

Dear Zac
I did as suggested and upgraded lucee to 5.3.7 RC and the problem has not been evolving again. So, hope things stay like this… do you know why that could have been? I red about some fixes in 5.3.7 RC related to upgrade / extensions topics but did not understand profoundly, although seems that these did the trick.
thank you so much for your superb help, very quick, very competent, thanks so much! The problem was productive for us, and now, sleep is deeper :wink:

1 Like