Skip to main content

Troubleshooting

"My myDBR license is for an older version than the version offered on myDBR.com"​

You can always update to the latest version of myDBR. Your license is valid for the version specified in the license and all subsequent versions. See the Update instructions for more details.

"My license has expired and I cannot log in via AD/SSO/Custom authentication to renew it"​

When an installation lacks a valid license, advanced authentication methods (Active Directory, SSO, etc.) are unavailable. In this case, you must log in as an administrator using local myDBR authentication. To access the local login, append &local=1 to your login URL. If you do not have the local administrator credentials, refer to the next section.

"I have forgotten the myDBR administrator username or password"​

If you have forgotten the credentials for the local myDBR administrator, you can retrieve the username or reset the password directly in the database.

To identify administrator users in MySQL:

select user from mydbr_userlogin where authentication=2 and admin=1;

To identify administrator users in Microsoft SQL Server or SAP ASE:

select username from mydbr_userlogin where authentication=2 and admin=1;

To reset the administrator's password, you can set it to an MD5 hash (while myDBR uses more secure hashes internally, it will accept and automatically upgrade an MD5 hash upon the next password change within the application).

To reset the password via the MySQL command line:

update mydbr_userlogin 
set password=md5('secret'), passworddate=now() 
where authentication=2 and admin=1 and user='dba';

(Replace 'dba' with the username retrieved from the previous query.)

To reset the password via the Microsoft SQL Server command line:

update mydbr_userlogin 
set password=lower(convert(varchar(32), HashBytes('MD5', 'secret'), 2)), passworddate=getdate() 
where authentication=2 and admin=1 and username='dba';

To reset the password via the SAP ASE command line:

update mydbr_userlogin 
set password=hash('secret', 'md5'), passworddate=getdate() 
where authentication=2 and admin=1 and username='dba';

"Labels are missing from PNG charts"​

Ensure that the fonts included with the ChartDirector package are installed on your server. Refer to the ChartDirector installation documentation for more details.

Error: "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set"​

On SQL Server (typically when using Linked Servers), the database connection requires specific flags. If you encounter this error, add the following configuration to mydbr/user/extension_init.php:

$mydbr_defaults['db_connection']['sqlsrv_server_init'] = 'SET ANSI_WARNINGS ON;SET ARITHABORT OFF;SET ANSI_NULLS ON;SET QUOTED_IDENTIFIER OFF;';

If you are using an older FreeTDS-based installation (mssql-PHP driver), the setting is:

$mydbr_defaults['db_connection']['sql_server_init'] = 'SET ANSI_WARNINGS ON;SET ARITHABORT OFF;SET ANSI_NULLS ON;SET QUOTED_IDENTIFIER OFF;';

"I cannot export to PDF, or the generated PDF is invalid"​

If you encounter issues with PDF exports after installing wkhtmltopdf, follow these troubleshooting steps:

  1. Verify that myDBR can locate the wkhtmltopdf executable by visiting: https://[yourserver.com]/mydbr/tools/troubleshoot/wkhtmltopdf.php. If it is not found, verify the path in $mydbr_defaults['export']['wkhtmltopdf']['command'].
  2. Enable PDF debugging by adding the following command to the beginning of your report:
select 'dbr.export.options', 'debug', 1;

Then, run the PDF export and follow the provided instructions.

"I am moving my myDBR installation to a new server; how do I proceed?"​

A myDBR installation consists of the PHP application files (encoded with SourceGuardian or ionCube) and the myDBR database. To move the installation:

  1. Run the automatic updater on the original server to ensure you are using the latest version.
  2. Perform a database dump of the myDBR database. If using MySQL, ensure that stored routines are included (use the --routines flag with mysqldump).
  3. If moving between servers with different database user permissions, remove any DEFINER statements from the SQL dump. This ensures objects are created under the new administrator account. You can use a text editor or a command line tool like sed:
cat mydbr.sql | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | sed -e 's/DEFINER[ ]*=[ ]*[^*]*PROCEDURE/PROCEDURE/' | sed -e 's/DEFINER[ ]*=[ ]*[^*]*FUNCTION/FUNCTION/' > mydbr_clean.sql
  1. Import the cleaned database dump into the new server.
  2. Copy the mydbr/user directory from the old server to the new one.
  3. Access the myDBR installation via a web browser to complete the setup process.

"Fatal error: SourceGuardian Loader - For security reasons this protected script cannot run in the current PHP environment"​

SourceGuardian-encoded scripts cannot run when the Xdebug PHP extension is enabled. To resolve this, disable Xdebug for your myDBR installation.

How to get support from myDBR.com​

If you have a general question that may benefit others, please visit the myDBR forums. For direct assistance, you can email myDBR Support at support@mydbr.com. When reporting an issue related to report code, please include a SQL export of the report by appending &export=sql to the report URL.

© 2007 - 2026 myDBR.com. All Rights Reserved.