{"action":"created","issue":{"url":"https://api.github.com/repos/kaltura/platform-install-packages/issues/384","labels_url":"https://api.github.com/repos/kaltura/platform-install-packages/issues/384/labels{/name}","comments_url":"https://api.github.com/repos/kaltura/platform-install-packages/issues/384/comments","events_url":"https://api.github.com/repos/kaltura/platform-install-packages/issues/384/events","html_url":"https://github.com/kaltura/platform-install-packages/issues/384","id":69866311,"number":384,"title":"kmc internal server error without mysql root privileges","user":{"login":"fxpz","id":9901052,"avatar_url":"https://avatars.githubusercontent.com/u/9901052?v=3","gravatar_id":"","url":"https://api.github.com/users/fxpz","html_url":"https://github.com/fxpz","followers_url":"https://api.github.com/users/fxpz/followers","following_url":"https://api.github.com/users/fxpz/following{/other_user}","gists_url":"https://api.github.com/users/fxpz/gists{/gist_id}","starred_url":"https://api.github.com/users/fxpz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxpz/subscriptions","organizations_url":"https://api.github.com/users/fxpz/orgs","repos_url":"https://api.github.com/users/fxpz/repos","events_url":"https://api.github.com/users/fxpz/events{/privacy}","received_events_url":"https://api.github.com/users/fxpz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-04-21T14:45:47Z","updated_at":"2015-04-21T16:00:00Z","closed_at":null,"body":"Hi All,\r\n\r\nI've configured my KalturaCE in a single machine with external mysql and SSL Offloading on load balancer.\r\nAs reported in documentation, after installation finished I removed user root@% from mysql.\r\n\r\nEverything seems works fine but when I go to kmc console I'm getting an \"internal server error\". From kaltlog:\r\n\r\n    2015-04-21 14:35:14 [0.002586] [192.168.10.8] [779312001] [API] [myReportsMgr::executeQuery]     NOTICE: Reports query using database host: [dev-mysql01] user [etl]\r\n    2015-04-21 14:35:14 [0.001050] [192.168.10.8] [779312001] [API] [myReportsMgr::executeQuery] ERR: exception 'Exception' with message 'Invalid query: The user specified as a definer ('root'@'%') does not exist' in /opt/kaltura/app/infra/log/KalturaLog.php:82\r\n    Stack trace:\r\n    #0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1320): KalturaLog::err('Invalid query: ...')\r\n    --\r\n    #11 {main}\r\n    2015-04-21 14:35:14 [0.001282] [192.168.10.8] [779312001] [API] [kCoreException->__construct] ERR: exception 'kCoreException' with message 'Invalid query' in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1322\r\n    Stack trace:\r\n    #0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(869): myReportsMgr::executeQuery('?CALL kalturadw...')\r\n    --\r\n    2015-04-21 14:35:14 [0.000347] [192.168.10.8] [779312001] [API] [myReportsMgr::executeQueryByType] NOTICE: Invalid query\r\n    2015-04-21 14:35:14 [0.000667] [192.168.10.8] [779312001] [API] [KalturaFrontController->getExceptionObject] CRIT: exception 'kCoreException' with message 'Invalid query' in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1322\r\n    Stack trace:\r\n    #0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(869): myReportsMgr::executeQuery('?CALL kalturadw...')\r\n\r\nI believe the error is\r\n\r\n    I seen `The user specified as a definer ('root'@'%') does not exist'`\r\n\r\nin fact I see that all procedures have as definer root@% or etl@localhost. What I've wrong?\r\n\r\n    mysql> select db,specific_name,definer from proc;\r\n    +--------------+----------------------------------------+---------------+\r\n    | db           | specific_name                          | definer       |\r\n    +--------------+----------------------------------------+---------------+\r\n    | kalturadw    | calc_aggr_day_api_calls                | root@%        |\r\n    | kalturadw    | calc_aggr_day_errors                   | root@%        |\r\n    | kalturadw    | calc_aggr_day_play                     | root@%        |\r\n    | kalturadw    | calc_updated_batch_job                 | etl@localhost |\r\n    | kalturadw    | calc_updated_batch_job_day             | etl@localhost |\r\n    | kalturadw    | calc_aggr_day_ingestion                | etl@localhost |\r\n    | kalturadw    | calc_aggr_day_transcoding_usage        | root@%        |\r\n    | kalturadw    | post_aggregation_widget                | root@%        |\r\n    | kalturadw    | post_aggregation_partner               | root@%        |\r\n    | kalturadw    | post_aggregation_entry                 | root@%        |\r\n    | kalturadw    | pre_aggregation_entry                  | root@%        |\r\n    | kalturadw    | post_aggregation_live_entry            | root@%        |\r\n    | kalturadw    | pre_aggregation_live_entry             | root@%        |\r\n    | kalturadw    | add_plays_views                        | root@%        |\r\n    | kalturadw    | remove_plays_views                     | root@%        |\r\n    | kalturadw    | resolve_aggr_name                      | root@%        |\r\n    | kalturadw    | add_live_plays_views                   | root@%        |\r\n    | kalturadw    | remove_live_plays_views                | root@%        |\r\n    | kalturadw    | calc_month_id                          | root@%        |\r\n    | kalturadw    | calc_partner_storage_data_time_range   | root@%        |\r\n    | kalturadw    | get_overage_charge                     | root@%        |\r\n    | kalturadw    | calc_partner_overage                   | root@%        |\r\n    | kalturadw    | calc_partner_billing_data              | root@%        |\r\n    | kalturadw    | get_data_for_operational               | root@%        |\r\n    | kalturadw    | mark_operational_sync_as_done          | root@%        |\r\n    | kalturadw    | calc_partner_usage_data                | root@%        |\r\n    | kalturadw    | calc_median_ff_convert_job_wait_time   | etl@localhost |\r\n    | kalturadw    | calc_entries_sizes                     | root@%        |\r\n    | kalturadw    | add_daily_partition_for_table          | root@%        |\r\n    | kalturadw    | add_monthly_partition_for_table        | root@%        |\r\n    | kalturadw    | add_partitions                         | root@%        |\r\n    | kalturadw    | move_innodb_to_archive                 | root@%        |\r\n    | kalturadw    | do_tables_to_new                       | root@%        |\r\n    | kalturadw    | all_tables_to_new                      | root@%        |\r\n    | kalturadw    | apply_table_partitions_to_target_table | root@%        |\r\n    | kalturadw    | calc_time_shift                        | root@%        |\r\n    | kalturadw    | calc_partner_monthly_storage           | root@%        |\r\n    | kalturadw    | calc_aggr_day                          | root@%        |\r\n    | kalturadw    | populate_time_dim                      | root@%        |\r\n    | kalturadw    | calc_aggr_day_partner_storage          | root@%        |\r\n    | kalturadw    | calc_aggr_day_user_usage               | root@%        |\r\n    | kalturadw    | calc_aggr_day_bandwidth                | root@%        |\r\n    | kalturadw    | generate_daily_usage_report            | root@%        |\r\n    | kalturadw_ds | register_file                          | root@%        |\r\n    | kalturadw_ds | get_ip_country_location                | root@%        |\r\n    | kalturadw_ds | restore_file_status                    | root@%        |\r\n    | kalturadw_ds | set_file_status_full                   | root@%        |\r\n    | kalturadw_ds | set_file_status                        | root@%        |\r\n    | kalturadw_ds | fms_sessionize                         | root@%        |\r\n    | kalturadw_ds | fms_sessionize_by_date_id              | root@%        |\r\n    | kalturadw_ds | get_error_code                         | root@%        |\r\n    | kalturadw_ds | insert_invalid_ds_line                 | root@%        |\r\n    | kalturadw_ds | set_cycle_status                       | root@%        |\r\n    | kalturadw_ds | unify_incomplete_api_calls             | root@%        |\r\n    | kaltura      | update_entries                         | root@%        |\r\n    | kaltura      | update_kusers                          | root@%        |\r\n    | kalturadw_ds | empty_cycle_partition                  | root@%        |\r\n    | kalturadw_ds | add_cycle_partition                    | root@%        |\r\n    | kalturadw_ds | drop_cycle_partition                   | root@%        |\r\n    | kalturadw_ds | transfer_cycle_partition               | root@%        |\r\n    +--------------+----------------------------------------+---------------+\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/kaltura/platform-install-packages/issues/comments/94852437","html_url":"https://github.com/kaltura/platform-install-packages/issues/384#issuecomment-94852437","issue_url":"https://api.github.com/repos/kaltura/platform-install-packages/issues/384","id":94852437,"user":{"login":"KalturaCommunity","id":2227038,"avatar_url":"https://avatars.githubusercontent.com/u/2227038?v=3","gravatar_id":"","url":"https://api.github.com/users/KalturaCommunity","html_url":"https://github.com/KalturaCommunity","followers_url":"https://api.github.com/users/KalturaCommunity/followers","following_url":"https://api.github.com/users/KalturaCommunity/following{/other_user}","gists_url":"https://api.github.com/users/KalturaCommunity/gists{/gist_id}","starred_url":"https://api.github.com/users/KalturaCommunity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KalturaCommunity/subscriptions","organizations_url":"https://api.github.com/users/KalturaCommunity/orgs","repos_url":"https://api.github.com/users/KalturaCommunity/repos","events_url":"https://api.github.com/users/KalturaCommunity/events{/privacy}","received_events_url":"https://api.github.com/users/KalturaCommunity/received_events","type":"User","site_admin":false},"created_at":"2015-04-21T16:00:00Z","updated_at":"2015-04-21T16:00:00Z","body":"Welcome. What should really be done is changing the proc definition in the \nSQLs to run as etl and make sure that works, then, a pull request to dwh \nwould be great.\nI am closing this issue though, since we know the cause is not \ninstallation related, in the sense that it is not something the RPM \npackages do wrong.\n\nMay the source be with you,\n\nJess Portnoy\n\nJoin us for the Kaltura Connect Virtual Summits 2015 - Register now!\nconnect.kaltura.com\n\n\n\nOn Tue, 21 Apr 2015, fxpz wrote:\n\n> \n> Ok, changing definer as etl@% it works, but I don't believe it's the correct way...\n> update proc SET definer='etl@%';\n> \n> I'll try to\n>\n>  *  drop-dwh-data.sh\n>  *  kaltura-dwh-config\n>      +  check logs\n> \n> Thanks for your support!\n> \n> —\n> Reply to this email directly or view it on GitHub.[ACH7Xu04vc3ZtZQn6tMzqfrI9dV16GFwks5oBmrvgaJpZM4EFOTX.gif]\n> \n> \n>"}}