ReportServer can't connect to internal DB, VM no changes made

ReportServer virtual machine problem. Hi, my report server virtual machine became unresponsive and I had it restarted. This was the first time since install a few weeks ago. Upon restart the web interface gave me the errors below. the key one being “Connection Test: Failed (Communications link failure”. I have not changed any settings since I initially installed the VM. What would cause the app to now fail to connect to the internal DB?

ReportServer encountered an error
while validating its environment. Please check the server log files for
additional information.


| __ \ | | / |
| |) |
_ __ ___ _ __| |
| (
_ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ | '| |_ \ / _ \ '\ \ / / _ \ '|
| | \ \ / |) | () | | | |_ ___) | __/ | \ V / __/ |
|
| __
| .
/ _/|| _|/ _|| _/ __||
| |
|_|

Version: RS3.0.2-5855 2016-05-29-17-55-24
Code Version: 2016-05-29-17-55-24
Java Version: Oracle Corporation Java HotSpot™ 64-Bit Server VM 25.101-b13 (1.8)
VM Args: -Djava.util.logging.config.file=/opt/bitnami/apache-tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms1024M -Xmx2048M -Drs.configdir=/opt/bitnami/apps/reportserver/reportserver-conf -Dfile.encoding=UTF8 -Djdk.tls.ephemeralDHKeySize=2048 -Djava.endorsed.dirs=/opt/bitnami/apache-tomcat/endorsed -Dcatalina.base=/opt/bitnami/apache-tomcat -Dcatalina.home=/opt/bitnami/apache-tomcat -Djava.io.tmpdir=/opt/bitnami/apache-tomcat/temp
rs.configdir: /opt/bitnami/apps/reportserver/reportserver-conf (OK)

DB Config

hibernate.dialect: net.datenwerke.rs.utils.hibernate.MySQL5Dialect (OK)
hibernate.connection.driver_class: com.mysql.jdbc.Driver (OK)
hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/bitnami_reportserver (OK)
hibernate.connection.username: bn_reportserver
hibernate.connection.password: **********
hibernate.default_schema:

Connection Test: Failed (Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.)

Hi, I’m having exactly the same problem. using the following stack:

  • ReportServer Community 3.0.2-4 (64-bit)
  • Install Type: Installer for Linux

Note: a Bitnami Redmine Stack is running on the same Server without problems. The Reportserver Installation did not interfer with the Redmine Installation.

I have not yet been able to get access to the back end of my VM, but my plan to attack involves that items outlined here: http://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql

Ill let you know if I have success.

Hi @jsteigerwalt @guido_tobler,

I just downloaded the latest version of Bitnami ReportServer Virtual Machine and it worked fine when launching it. After that, I restarted the Virtual Machine and the Bitnami services and the application continued working fine. I could access the application after all these steps.

Please note that the application takes some time to be started and it needs at least 3Gb of RAM to run. If you continue running into issues, could you please share with us the content of the application’s logs to try to know more about the issue? You can find it at /opt/bitnami/apache-tomcat/logs/reportserver.DATE.log.

Could you also please check the status of the services and start them if needed?

https://docs.bitnami.com/?page=apps&name=reportserver&section=how-to-start-or-stop-the-servers

Regards,
Jota

Ah OK, I was not aware of the 3GB RAM. I’ll double check that and I will make the corresponding changes and get back if I still have Problems.

Hi @Jota, I checked the RAM. Also, all Services are started. I also checked most of the Points @jsteigerwalt outlined. However reportserver still can’t connect. Info: I granted all privileges to the mentioned user bn_reportserver, however with no effect.

Fixed, I needed to delete “/opt/bitnami/mysql/data/tc.log” then restart all services (sudo /opt/bitnami/ctlscript.sh restart). As expected, it was exclusively a MySQL startup error.

Once I looked at “/opt/bitnami/mysql/data/mysqld.log” it made sense.

Hi @jsteigerwalt,

Thank you for sharing the solution. @guido_tobler, could you please check the log file of MySQL? In case MySQL shows information about the tc.log file, could you please follow these steps and check they work for you?

https://docs.bitnami.com/?page=components&name=mysql&section=how-to-debug-errors-in-your-database

Let us know if it works for you.

Regards,
Jota

Hi,

I finally got it running; deleting the tc.log file did not do the trick. However, there is still an Issue which could be interesting to investigate.

  • I had to change the username in the persistance file to the database Administration user
  • This enabled the Connection test

I also granted all the rights (all privileges incl. grant) on all Hosts to the user bn_reportserver. Strangely this did not help at all (same error as above).

In the end I am now working with the DB Administration user in the persistance file. In my case this is acceptable, but I assume that it would be safer if the System runs with the pre-defined bn_reportserver user.

Hi @guido_tobler,

The screenshot you shared earlier shows “Access denied for user ‘bn_reportserver’”. Just to err on the safe side, can you confirm the password that ReportServer is using is the right one for the bn_reportserver user?

Best regards,
Alvaro Recio

Hi @arecio,
classic misspelling in my former reply. I always worked with bn_reportserver.
Regards
Guido

Hi @guido_tobler,

Let’s manually check the connection that ReportServer is trying to establish. Could you post the output for the following command?

/home/rmExpertnet/reportserver-3.0.2-4/mysql/bin/mysql/mysql -u bn_reportserver -p -h 127.0.0.1 -P 3308 -e 'show tables;' bitnami_reportserver

You’ll be asked for a password. Please enter the same password that can be found in entry hibernate.connection.password in your /home/rmExpertnet/reportserver-3.0.2-4/apps/reportserver/reportserver-conf/persistence.properties file.

Thank you for your kind cooperation.
Best regards,
Alvaro Recio

Hi Alvaro,

below please find the output:

Tables_in_bitnami_reportserver

rs_ace
rs_ace_2_access_maps
rs_ace_2_access_maps_a
rs_ace_a
rs_ace_access_map
rs_ace_access_map_a
rs_acl
rs_acl_a
rs_add_column_spec
rs_add_column_spec_a
rs_audit_log_entry
rs_audit_log_property
rs_binary_column_filter
rs_binary_column_filter_a
rs_birt_report
rs_birt_report_a
rs_birt_report_datasrc
rs_birt_report_datasrc_a
rs_birt_report_datasrc_cfg
rs_birt_report_datasrc_cfg_a
rs_birt_report_file
rs_birt_report_file_a
rs_birt_report_variant
rs_birt_report_variant_a
rs_blatext_param_def
rs_blatext_param_def_a
rs_blatext_param_inst
rs_blatext_param_inst_a
rs_column
rs_column_a
rs_column_filter
rs_column_filter_a
rs_column_format
rs_column_format_a
rs_column_format_currency
rs_column_format_currency_a
rs_column_format_date
rs_column_format_date_a
rs_column_format_number
rs_column_format_number_a
rs_column_format_template
rs_column_format_template_a
rs_column_format_text
rs_column_format_text_a
rs_column_reference
rs_column_reference_a
rs_compiled_report
rs_computed_column
rs_computed_column_a
rs_condition
rs_crystal_report
rs_crystal_report_a
rs_crystal_report_file
rs_crystal_report_file_a
rs_crystal_report_variant
rs_crystal_report_variant_a
rs_csv_datasource
rs_csv_datasource_a
rs_csv_datasource_conf
rs_csv_datasource_conf_a
rs_dadget
rs_dadget_a
rs_dadget_favorite_list
rs_dadget_library
rs_dadget_parameter
rs_dadget_report
rs_dadget_report_2_param_inst
rs_dadget_static_html
rs_dadget_url
rs_dashboard
rs_dashboard_2_dadget
rs_dashboard_2_dadget_a
rs_dashboard_a
rs_dashboard_cont_2_dashbrd
rs_dashboard_cont_2_dashbrd_a
rs_dashboard_container
rs_dashboard_container_a
rs_dashboard_dadget_node
rs_dashboard_dadget_node_a
rs_dashboard_dashboard_node
rs_dashboard_dashboard_node_a
rs_dashboard_folder
rs_dashboard_folder_a
rs_dashboard_mngr_node
rs_dashboard_mngr_node_a
rs_dashboard_reference
rs_dashboard_reference_a
rs_dashboard_user
rs_dashboard_user_a
rs_database_bundle_entry
rs_database_bundle_entry_a
rs_database_datasource
rs_database_datasource_a
rs_database_datasource_conf
rs_database_datasource_conf_a
rs_datasource_connector
rs_datasource_connector_a
rs_datasource_connector_cfg
rs_datasource_connector_cfg_a
rs_datasource_container
rs_datasource_container_a
rs_datasource_def_config
rs_datasource_def_config_a
rs_datasource_definition
rs_datasource_definition_a
rs_datasource_fbcfg_2_dscc
rs_datasource_folder
rs_datasource_folder_a
rs_datasource_mngr_node
rs_datasource_mngr_node_a
rs_datasource_p_df_2_ml_def
rs_datasource_p_df_2_ml_def_a
rs_datasource_p_ins_2_ml_val
rs_datasource_p_ins_2_ml_val_a
rs_datasource_param_def
rs_datasource_param_def_a
rs_datasource_param_inst
rs_datasource_param_inst_a
rs_datasource_parameter_data
rs_datasource_parameter_data_a
rs_date_trigger_config
rs_datetime_param_def
rs_datetime_param_def_a
rs_datetime_param_inst
rs_datetime_param_inst_a
rs_db_bundle_2_entry
rs_db_bundle_2_entry_a
rs_db_bundle_datasource
rs_db_bundle_datasource_a
rs_exec_report_as_file_ref
rs_exec_report_as_file_ref_a
rs_favorite_list
rs_favorite_list_2_entry
rs_favorite_list_entry
rs_file_server_file
rs_file_server_file_a
rs_file_server_file_data
rs_file_server_file_data_a
rs_file_server_folder
rs_file_server_folder_a
rs_file_server_node
rs_file_server_node_a
rs_filesel_param_def
rs_filesel_param_def_a
rs_filesel_param_in_2_file
rs_filesel_param_in_2_file_a
rs_filesel_param_inst
rs_filesel_param_inst_a
rs_filesel_param_sel_file
rs_filesel_param_sel_file_a
rs_filesel_param_up_file
rs_filesel_param_up_file_a
rs_filter
rs_filter_2_exclude_val
rs_filter_2_exclude_val_a
rs_filter_2_filter_rng_exc
rs_filter_2_filter_rng_exc_a
rs_filter_2_filter_rng_inc
rs_filter_2_filter_rng_inc_a
rs_filter_2_include_val
rs_filter_2_include_val_a
rs_filter_a
rs_filter_block
rs_filter_block_2_child_bl
rs_filter_block_2_child_bl_a
rs_filter_block_2_filters
rs_filter_block_2_filters_a
rs_filter_block_a
rs_filter_range
rs_filter_range_a
rs_filter_spec
rs_filter_spec_a
rs_gen_security_tgt_entity
rs_gen_security_tgt_entity_a
rs_global_constant
rs_global_constant_a
rs_grid_edt_report
rs_grid_edt_report_a
rs_grid_edt_report_variant
rs_grid_edt_report_variant_a
rs_group
rs_group_2_group
rs_group_2_group_a
rs_group_2_ou
rs_group_2_ou_a
rs_group_2_user
rs_group_2_user_a
rs_group_a
rs_headline_param_def
rs_headline_param_def_a
rs_headline_param_inst
rs_headline_param_inst_a
rs_hibernate_sequence
rs_hierarchical_ace
rs_hierarchical_ace_a
rs_hierarchical_acl
rs_hierarchical_acl_a
rs_jasper_report
rs_jasper_report_2_sub_jrxml
rs_jasper_report_2_sub_jrxml_a
rs_jasper_report_a
rs_jasper_report_jrxml
rs_jasper_report_jrxml_a
rs_jasper_report_variant
rs_jasper_report_variant_a
rs_jasper_to_table_config
rs_jasper_to_table_config_a
rs_jxls_report
rs_jxls_report_a
rs_jxls_report_file
rs_jxls_report_file_a
rs_jxls_report_variant
rs_jxls_report_variant_a
rs_list_uservariable_def
rs_list_uservariable_def_a
rs_list_uservariable_inst
rs_list_uservariable_inst_a
rs_list_uservariable_inst_vl
rs_list_uservariable_inst_vl_a
rs_mondrian_datasource
rs_mondrian_datasource_a
rs_mondrian_datasource_cfg
rs_mondrian_datasource_cfg_a
rs_organisational_unit
rs_organisational_unit_a
rs_param_def_2_dependants
rs_param_def_2_dependants_a
rs_parameter_definition
rs_parameter_definition_a
rs_parameter_instance
rs_parameter_instance_a
rs_pre_filter
rs_pre_filter_a
rs_property
rs_report
rs_report_2_metadata
rs_report_2_metadata_a
rs_report_2_param_def
rs_report_2_param_def_a
rs_report_2_param_inst
rs_report_2_param_inst_a
rs_report_2_property
rs_report_2_property_a
rs_report_a
rs_report_byte_property
rs_report_byte_property_a
rs_report_folder
rs_report_folder_a
rs_report_metadata
rs_report_metadata_a
rs_report_mngr_node
rs_report_mngr_node_a
rs_report_preview_image
rs_report_preview_image_a
rs_report_property
rs_report_property_a
rs_report_ss_string_property
rs_report_ss_string_property_a
rs_report_string_property
rs_report_string_property_a
rs_revision
rs_saiku_report
rs_saiku_report_a
rs_saiku_report_variant
rs_saiku_report_variant_a
rs_sched_action
rs_sched_action_as_file
rs_sched_action_ent_2_prop
rs_sched_action_mail_report
rs_sched_action_send_to
rs_sched_action_send_to_v
rs_sched_base_property
rs_sched_execute_report_job
rs_sched_execute_script_job
rs_sched_hist_action_entry
rs_sched_hist_entry_property
rs_sched_hist_exec_entry
rs_sched_hist_job_entry
rs_sched_job
rs_sched_job_2_actions
rs_sched_job_ent_2_prop
rs_sched_rep_exec_job_2_prop
rs_sched_rep_exec_job_2_rcpt
rs_sched_scr_exe_job_2_prop
rs_sched_trig_daily_nthday
rs_sched_trig_daily_workday
rs_sched_trig_date
rs_sched_trig_mon_day_o_mon
rs_sched_trig_month_named_day
rs_sched_trig_weekly
rs_sched_trig_year_named_day
rs_sched_trig_yearly_at_date
rs_sched_trigger
rs_scheduler_job_history
rs_schemainfo
rs_script_datasource
rs_script_datasource_a
rs_script_datasource_config
rs_script_datasource_config_a
rs_script_param_def
rs_script_param_def_a
rs_script_param_inst
rs_script_param_inst_a
rs_script_report
rs_script_report_2_ex_format
rs_script_report_2_ex_format_a
rs_script_report_a
rs_script_report_variant
rs_script_report_variant_a
rs_sep_param_def
rs_sep_param_def_a
rs_sep_param_inst
rs_sep_param_inst_a
rs_str_uservariable_def
rs_str_uservariable_def_a
rs_str_uservariable_inst
rs_str_uservariable_inst_a
rs_tab_rep_tpl_lst_2_tpl
rs_tab_rep_tpl_lst_2_tpl_a
rs_table_report
rs_table_report_2_add_column
rs_table_report_2_add_column_a
rs_table_report_2_column
rs_table_report_2_column_a
rs_table_report_a
rs_table_report_byte_tpl
rs_table_report_byte_tpl_a
rs_table_report_str_template
rs_table_report_str_template_a
rs_table_report_template
rs_table_report_template_a
rs_table_report_template_lst
rs_table_report_template_lst_a
rs_table_report_variant
rs_table_report_variant_a
rs_teamspace
rs_teamspace_2_app
rs_teamspace_2_app_a
rs_teamspace_2_member
rs_teamspace_2_member_a
rs_teamspace_a
rs_teamspace_app
rs_teamspace_app_2_property
rs_teamspace_app_2_property_a
rs_teamspace_app_a
rs_teamspace_app_property
rs_teamspace_app_property_a
rs_teamspace_member
rs_teamspace_member_a
rs_text_param_def
rs_text_param_def_a
rs_text_param_inst
rs_text_param_inst_a
rs_ts_disk_folder
rs_ts_disk_folder_a
rs_ts_disk_general_reference
rs_ts_disk_general_reference_a
rs_ts_disk_node
rs_ts_disk_node_a
rs_ts_disk_report_reference
rs_ts_disk_report_reference_a
rs_ts_disk_root
rs_ts_disk_root_a
rs_user
rs_user_2_property
rs_user_2_property_a
rs_user_a
rs_user_property
rs_user_property_a
rs_usermanager_node
rs_usermanager_node_a
rs_uservar_def
rs_uservar_def_a
rs_uservar_inst
rs_uservar_inst_a
rs_uservar_param_def
rs_uservar_param_def_a
rs_uservar_param_inst
rs_uservar_param_inst_a
rs_weekly_config_2_days

Hi @guido_tobler,

The output of the command looks good, which means that the ReportServer database exists and the user is able to connect with the password. If the Connection Test is still failing, could you share the contents of your /home/rmExpertnet/reportserver-3.0.2-4/apps/reportserver/reportserver-conf/persistence.properties file to double check it’s correct? Please, remove any password before posting the contents of the file.

Thank you.
Best regards,
Alvaro Recio

Just an update. My server was restarted again (been up for 4 months straight); I had to clear the log:
delete or rename “/opt/bitnami/mysql/data/tc.log” then restart all services (sudo /opt/bitnami/ctlscript.sh restart).

I don’t know much about this app’s internal DB, but it does not like abrupt restarts…