Dmitry Posted June 11, 2019 Report Posted June 11, 2019 (edited) Hello World! I'm trying to follow Installation of Revive Adserver, yet running into following error: Installation failed to create the core tables ./var/debug.log: Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_account_preference_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table account_preference_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_account_user_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table account_user_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_account_user_permission_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table account_user_permission_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_accounts Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table accounts Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_acls Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table acls Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_acls_channel Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table acls_channel Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_ad_category_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table ad_category_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_ad_zone_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table ad_zone_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_affiliates Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table affiliates Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_affiliates_extra Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table affiliates_extra Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_agency Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table agency Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_application_variable Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table application_variable Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_audit Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table audit Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_banners Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table banners Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_campaigns Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table campaigns Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_campaigns_trackers Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table campaigns_trackers Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_category Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table category Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_channel Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table channel Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_clients Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table clients Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_intermediate_ad Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_intermediate_ad Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_intermediate_ad_connection Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_intermediate_ad_connection Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_intermediate_ad_variable_value Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_intermediate_ad_variable_value Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_raw_ad_click Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_raw_ad_click Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_raw_ad_impression Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_raw_ad_impression Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_raw_ad_request Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_raw_ad_request Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_raw_tracker_impression Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_raw_tracker_impression Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_raw_tracker_variable_value Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_raw_tracker_variable_value Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_summary_ad_hourly Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_summary_ad_hourly Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_summary_ad_zone_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_summary_ad_zone_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_summary_channel_daily Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_summary_channel_daily Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_data_summary_zone_impression_history Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table data_summary_zone_impression_history Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_images Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table images Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_log_maintenance_forecasting Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table log_maintenance_forecasting Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_log_maintenance_priority Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table log_maintenance_priority Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_log_maintenance_statistics Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table log_maintenance_statistics Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_password_recovery Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table password_recovery Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_placement_zone_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table placement_zone_assoc Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_preferences Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table preferences Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_session Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table session Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_targetstats Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table targetstats Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_tracker_append Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table tracker_append Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_trackers Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table trackers Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_userlog Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table userlog Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_users Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table users Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_variable_publisher Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table variable_publisher Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_variables Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table variables Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop table rv_zones Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to drop the table zones Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] Unable to create the table application_variable Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ error] _doQuery: [Error message: Could not execute statement] [Last executed query: CREATE TABLE `rv_application_variable` (`name` VARCHAR(255) DEFAULT '' NOT NULL, `value` TEXT NOT NULL, PRIMARY KEY (name)) ENGINE = MYISAM] [Native code: 1071] [Native message: Specified key was too long; max key length is 1000 bytes] Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ warning] count(): Parameter must be an array or an object that implements Countable Jun 11 16:50:43 +0000 OX-5cffdbe30efaf [ warning] count(): Parameter must be an array or an object that implements Countable I also tried to follow https://github.com/revive-adserver/revive-adserver/issues/740#issuecomment-407480288 , without any luck( Please advise. Thank you in advance. Edited June 11, 2019 by Dmitry Quote
andrewatfornax Posted June 17, 2019 Report Posted June 17, 2019 The issue is that the user you are using to connect to the database with does not have all of the required permissions to create the database and tables... See your database documentation for details on how to do that! Quote
Dmitry Posted June 17, 2019 Author Report Posted June 17, 2019 (edited) 20 hours ago, andrewatfornax said: The issue is that the user you are using to connect to the database with does not have all of the required permissions to create the database and tables... See your database documentation for details on how to do that! may I ask what made you think that? and/or which database documentation are you referring too? I followed https://www.revive-adserver.com/support/installation/ (part 3) # mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 100 Server version: 8.0.13 Source distribution Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE USER 'revive_adserver'@'localhost' IDENTIFIED BY 'XXX'; Query OK, 0 rows affected (0.06 sec) mysql> GRANT ALL ON revive_adserver_3.* TO 'revive_adserver'@'localhost'; Query OK, 0 rows affected (0.03 sec) mysql> USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT * FROM user WHERE User='revive_adserver'\G; *************************** 1. row *************************** Host: localhost User: revive_adserver Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N Create_view_priv: N Show_view_priv: N Create_routine_priv: N Alter_routine_priv: N Create_user_priv: N Event_priv: N Trigger_priv: N Create_tablespace_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 plugin: mysql_native_password authentication_string: XXX password_expired: N password_last_changed: 2019-06-17 17:21:40 password_lifetime: NULL account_locked: N Create_role_priv: N Drop_role_priv: N Password_reuse_history: NULL Password_reuse_time: NULL Password_require_current: NULL 1 row in set (0.00 sec) ERROR: No query specified mysql> SELECT * FROM db WHERE User='revive_adserver'\G; *************************** 1. row *************************** Host: localhost Db: revive_adserver_3 User: revive_adserver Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Grant_priv: N References_priv: Y Index_priv: Y Alter_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Execute_priv: Y Event_priv: Y Trigger_priv: Y 1 row in set (0.00 sec) ERROR: No query specified mysql> CREATE DATABASE revive_adserver_3; Query OK, 1 row affected (0.02 sec) mysql> ^DBye # even though following message appears: Installation failed to create the core tables database IS created along with few tables: # mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 103 Server version: 8.0.13 Source distribution Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> USE revive_adserver_3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SHOW TABLES; +-----------------------------+ | Tables_in_revive_adserver_3 | +-----------------------------+ | rv_database_action | | rv_upgrade_action | +-----------------------------+ 2 rows in set (0.00 sec) mysql> ^DBye # Edited June 17, 2019 by Dmitry Quote
andrewatfornax Posted June 29, 2019 Report Posted June 29, 2019 Hi @Dmitry, Ah, all the messages about unable to do things made me think that the most common cause of this is that the user that you're connecting as doesn't have sufficient permissions. It would be worth trying with the root database account, just to be sure. Potentially, it's treating the connection as not from "localhost" for example. Otherwise, it might be an issue with strict mode being enabled in the database? Quote
Dmitry Posted July 10, 2019 Author Report Posted July 10, 2019 (edited) On 6/29/2019 at 5:56 AM, andrewatfornax said: Hi @Dmitry, Ah, all the messages about unable to do things made me think that the most common cause of this is that the user that you're connecting as doesn't have sufficient permissions. It would be worth trying with the root database account, just to be sure. Potentially, it's treating the connection as not from "localhost" for example. Otherwise, it might be an issue with strict mode being enabled in the database? As I stated in my earlier posts, user has sufficient privileges for specific database, I also did try with root with same results( regards to strict mode: I'm using mysql database out of the box (w/ default values): mysql> SHOW VARIABLES LIKE 'sql_mode'\G; *************************** 1. row *************************** Variable_name: sql_mode Value: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION 1 row in set (0.00 sec) ERROR: No query specified mysql> I also tried to remove "STRICT_TRANS_TABLES", yet still no luck( Edited July 10, 2019 by Dmitry Quote
Dmitry Posted July 10, 2019 Author Report Posted July 10, 2019 I also tried to remove all modes from sql_mode, still same thing... in fact it kind of made it even worse... as database wouldn't get created, but even if I create database manually, I end up with same 2 tables as before and "Installation failed to create the core tables " message on screen... Quote
andrewatfornax Posted August 23, 2019 Report Posted August 23, 2019 Sorry, I have no idea. If you have replicate steps that we could use to repeat the issue, then you could raise a ticket - but I'm afraid I don't have this issue myself when setting up Revive Adserver on MySQL 8. Quote
andrewatfornax Posted September 17, 2019 Report Posted September 17, 2019 Actually, I take that back. I set up a new development environment recently, and ran into the issue with MySQL 8. I spent some time looking into the issues, and there is no simple solution, so I am afraid that for now, we have updated the requirements to note that MySQL 8 is not currently supported. Quote
Dmitry Posted September 20, 2019 Author Report Posted September 20, 2019 (edited) Andrew, I tried to reinstall it, but using MySQL 5.7.x instead of 8.x and got further this time, but not quite just yet... > Your Revive Adserver installation is complete. Please check the highlighted issues. > > An error occurred when performing installation tasks. Please check the error list and install log at \'/var/www/html/revive-adserver-4.2.1/var/install.log\' for details. You will still be able to login to your Revive Adserver instance. # cat ./var/install.log Installation started 2019-09-20 20:19:34 Attempting to connect to database ra with user root Database created ra Connected to database ra Database settings and permissions are OK creating upgrade_action audit table successfully created upgrade_action audit table creating database_action audit table successfully created database_action audit table schema definition from cache TRUE Installation created the core tables Installation updated the schema version to 623 Installation updated the application version to 4.2.1 Preparing to set timezone preference... Found timezone preference ID of 16 Found the admin account's timezone association, updating preference... Updated the admin account timezone preference to: 'UTC' # Edited September 20, 2019 by Dmitry Quote
andrewatfornax Posted September 28, 2019 Report Posted September 28, 2019 Not sure what that is, but can you log in? If you can, then you can recover from this and manually install the default plugins - see our troubleshooting guide for info on this! Quote
Ravi Patel Posted June 17, 2020 Report Posted June 17, 2020 Hey Guys, Very late here to answer this, I also got into this same error, And Here are my findings for this error : I was selecting "MyIsam" in Table type Instead of InnoDB. Check the below screenshots : First Click : "See More Database Details" Then Select "InnoDB" from Table Type. And Done ? andrewatfornax 1 Quote
Gius00 Posted August 17, 2020 Report Posted August 17, 2020 On 9/17/2019 at 1:38 PM, andrewatfornax said: Actually, I take that back. I set up a new development environment recently, and ran into the issue with MySQL 8. I spent some time looking into the issues, and there is no simple solution, so I am afraid that for now, we have updated the requirements to note that MySQL 8 is not currently supported. Hi, any news? I've the same issue Quote
Vipul Agarwal Posted February 3, 2021 Report Posted February 3, 2021 On 9/17/2019 at 5:08 PM, andrewatfornax said: Actually, I take that back. I set up a new development environment recently, and ran into the issue with MySQL 8. I spent some time looking into the issues, and there is no simple solution, so I am afraid that for now, we have updated the requirements to note that MySQL 8 is not currently supported. Is there any update on this? is this linked default character set utf8mb4 while revive requirement is (CHARACTER SET utf8 COLLATE utf8_general_ci). referring to this Installation failed to create the core tables · Issue #740 · revive-adserver/revive-adserver · GitHub It did not help me even after changing this. Quote
SoboL Posted December 15, 2021 Report Posted December 15, 2021 Hi I had same issue. The plugin installation failure is related in my case to revive being behind ALB which was only listening and forwarding via https://. For the plugin installation and overall functioning of revive it has to be available via http:// and https://. My solution was to make ALB listeners for 80 and 443 with both target groups pointing( but not redirecting ) to revive instances. Additionally in config of revive i have specified that admin panel is available only via SSL:admin/account-settings-user-interface.php Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.