Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
14 replies
Subscribers
9 subscribers
Views
3204 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Hi, I am trying to install Appian 7.11 on a windows environment. I ha
aswinb93
over 8 years ago
Hi,
I am trying to install Appian 7.11 on a windows environment. I have granted all privileges to my user who is using the MySQL primary database. but I keep getting an error saying that could not modify foreign key constraint on a table called client_cert_chains. I am attaching the server.log file...any help would be deeply appreciated.
server.log
OriginalPostID-174465
OriginalPostID-174465
Discussion posts and replies are publicly visible
0
Former Member
over 8 years ago
Hi Aswin,
As shown in the screenshot attached, as well as the documentation link below, MySQL 5.6.x with InnoDB engine is currently supported.
forum.appian.com/.../System_Requirements.html
Next steps: Uninstall MySQL 5.7.x first, then reinstall MySQL 5.6.x to resolve the issue.
For clarity, review the screenshots attached so that you can see how to navigate to the 5.6.x version of MySQL even though the download will send you to the 5.7.x version.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Former Member
over 8 years ago
Hi Aswin,
Sorry, one of my images was incorrect. Here are the ones you can review for clarity.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aswinb93
over 8 years ago
I already have MySQL 5.6.24 installed...attaching screenshot..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aswinb93
over 8 years ago
Can you specify what is the correct version of ODBC driver to use....i am using 5.3....mysql server is 5.6....connector java is 5.1.37.....it still doesn't work...foriegn key on update on client_cert table is not happening.....i have granted full access to root user whom i am using.....any help would be deeply appreciated...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<