Cannot Load Dynamic Library Libmysqldll Sql Manager

Hi Saravana,Could you try to install the MySQL C-API connector on the machine where BOE needs to be installed.Thanks,Vamshidhar\",\"author\":\"username\":\"vamshidhar.mitta\",\"displayName\":\"Vamshidhar Mitta\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":12631539,\"posted\":1552615366000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]},\"body\":\"Please review PAM before installing and make sure you are following SAP note \",\"author\":\"username\":\"denis.konovalov\",\"displayName\":\"Denis Konovalov\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":12631612,\"posted\":1552648853000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi, \\ndid this ever get solved? I am having exactly the same issue at the moment. BI4.2 SP9 patch 5 install pointing to a separate RDS MySql 8.0.28 CMS DB. Looking at the sap note it is supported.\\nWhen I tried to install BI to point to the MySql DB on RDS i got the error for the libmysql. I then installed the C API. This didnt solve it.\\nI then installed BI using the bundled DB, copied the libmysql.dll to the winx64_x64 directory in the business objects install and repointed the CMS to the mysql DB via the Central Console Manager. this worked and recreated the CMSDB in MySql, i can see all the tables in the schema. However when I try to start the CMS via the CCM I get the following error. Basically the install will let me repoint the CMSDB and recreate it yet the application still cant see the dll to use it. \\nWhen I move the install back to the bundled DB that was installed i can login fine and see the CMC ok.\\nAny help will be very much appreciated.\\nthanks\\nDave\\n33007 Database access error. Reason Loading shared object failed. First tried to load library libmysql and failed because of error: [The specified module could not be found.\\n]. Second tried to load library D:\\\\SAP BusinessObjects\\\\SAP BusinessObjects Enterprise XI 4.0\\\\win64_x64\\\\libmysql.dll and failed because of error: [The specified module could not be found.\\n].\\n35101 The root server reported an error Initialization Failure. (Reason: Database access error. Reason Loading shared object failed. First tried to load library libmysql and failed because of error: [The specified module could not be found.\\n]. Second tried to load library D:\\\\SAP BusinessObjects\\\\SAP BusinessObjects Enterprise XI 4.0\\\\win64_x64\\\\libmysql.dll and failed because of error: [The specified module could not be found.\\n].Database access error. Reason Loading shared object failed. First tried to load library libmysql and failed because of error: [The specified module could not be found.\\n]. Second tried to load library D:\\\\SAP BusinessObjects\\\\SAP BusinessObjects Enterprise XI 4.0\\\\win64_x64\\\\libmysql.dll and failed because of error: [The specified module could not be found.\\n]. Error initializing database wrapper environment for DatabaseSubsystem. ).\",\"author\":\"username\":\"gillaspy2005\",\"displayName\":\"Dave Gillaspy\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":13625211,\"posted\":1650559246000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/12630655/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/12630655/answers.rss', answersAndComments: '/feed/12630655/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true }) })(); function readAnnouncementCookie(n)^.*$"),t=document.cookie.replace(e,"$1");if(t)tryvar o=JSON.parse(decodeURIComponent(t))catch(n)console.error(n)return ofunction initAnnouncement(n)const e=typeId:n.typeId,version:parseInt(n.version),startDate:new Date(n.startDate),endDate:new Date(n.endDate),containerId:n.containerId,t=new Date;if(t>=e.startDate&&t=t&&(c[d]=s[d]);const i=new Date;i.setMonth(i.getMonth()+12);const r=document.location.hostname,m=r.lastIndexOf(".sap.com")==r.length-".sap.com".length?".sap.com":document.location.hostname;document.cookie=n+"="+JSON.stringify(c)+";expires="+i+";domain="+m+";path=/"}}}A New Home in New Year for SAP Community: Exciting times ahead for the SAP Community!Not yet a member on the new home? Join today and start participating in the discussions!Read about the migration and join SAP Community Groups!initAnnouncement( typeId: 'global-announcement', containerId: 'global-announcement', version: 118, startDate: '2023-10-23T15:19:04.000Z', endDate: '2023-12-01T05:00:09.000Z' ); Home Community Ask a Question Write a Blog Post Login / Sign-up Search Questions and Answers 0 Saravanakumar Kanniah Mar 14, 2019 at 11:12 PM SAP BO 4.2 SP7 691 Views Last edit Mar 14, 2019 at 11:20 PM 2 rev Follow RSS Feed I am installing SAP BO 4.2 SP7 in a windows 2016 version (EC2 instance) and configuring it to the mysql RDS instance. I get the error

DOWNLOAD

First tried to load library libmysql and failed because of error: [The specified module cannoit be found] second tried to load library libmysql.dlland failed because of error:[The specified module cannoit be found]. (FWB 0090).

I tried loading the library libmysql.dll in various folders but i get the same error. Can anyone please help? Looks like the installation files wants the dll in a specific folder but dont know where it is.

Note: If when starting the web server an error similar to the following occurs: "Unable to load dynamic library './php_mysql.dll'", this is because php_mysql.dll and/or libmysql.dll cannot be found by the system.

When using MySQL 5.x as an Auditing Database for a SAP BusinessObjects Business Intelligence 4.1, following warning is seen on the Auditing page in Central Management Console (CMC) - "Warning: "No connection to Auditing Data Store from CMS xxx_nn.CentralManagementServer".The Event Viewer also shows following error:

"CMS startup: component auditdatabasesubsystem could not be loaded. Reason: Database access error. Reason Loading shared object failed. First tried to load library libmysql and failed because of error: [The specified module could not be found.]. Second tried to load library \SAP BusinessObjects Enterprise XI 4.0\win64_x64\libmysql.dll and failed because of error: [The specified module could not be found.]."

The configure script cannot detect the necessary libraries and include files if they are not in the standard paths, so it may be necessary to specify these paths using either driver-specific include and library path variables or CMAKE_INCLUDE_PATH and CMAKE_LIBRARY_PATH. For example, if your MySQL files are installed in C:\mysql-connector-c-6.1.11-winx64 on Windows, then pass the following parameter to double-dash part of configure line:

You should always use client libraries that have been compiled with the same compiler as you are using for your project. If you cannot get a source distribution to compile the client libraries yourself, you must make sure that the pre-compiled library is compatible with your compiler, otherwise you will get a lot of "undefined symbols" errors. Some compilers have tools to convert libraries, e.g. Borland ships the tool COFF2OMF.EXE to convert libraries that have been generated with Microsoft Visual C++.

b73f46f91f