Hi all, I'm using mysql version 5.7.20. In order to populate userdb and regdb i need to run mysql scripts and i have used the scripts in APIM analytics pack(mysql.sql). When run below issue arises,
ERROR 1067 (42000): Invalid default value for 'REG_CREATED_TIME' ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist ERROR 1067 (42000): Invalid default value for 'REG_LAST_UPDATED_TIME' ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE_HISTORY' doesn't exist ERROR 1146 (42S02): Table 'regdb.REG_RESOURCE' doesn't exist Searching the issue found out i need to run NOT mysql.sql but mysql5.7.sql. So for wt version does the mysql.sql works ? versions other than 5.7 ? IF so we need to mention this clearly in the docs . I found the same issue has been occurred for a customer as well. I followed [1]. [1] - https://docs.wso2.com/display/AM210/Minimum+High+Availability+Deployment+for+WSO2+APIM+Analytics Regards, Damith. -- Senior Software Engineer WSO2 Inc.; http://wso2.com <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg> lean.enterprise.middleware mobile: *+94728671315*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
