Troubleshooting

"My myDBR license is for older version than the version offered from myDBR.com"

You can always update to the newer myDBR version. Your license is valid from myDBR version stated in the license and for all newer versions. See Update instructions.

"My myDBR license is expired and the installation uses Active Directory/Single Sign-On/Custom-authentication and I cannot log in to enter the license"

When an installation does not have a valid license, the extra authentication methods are not available and you need to log in as admin using myDBR authentication. To do this add &local=1 to the login URL to access the myDBR (local) authentication. If you do not know the username/password for local login, see the next question.

"I've forgotten myDBR admin's username/password"

When you have forgotten the username/password for the local myDBR admin user, you need to look the username up from the database/reset password from there.

To see the admin users in MySQL use:

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

To see the admin users in Microsoft SQL Server / Sybase ASE / Sybase Anywhere use:

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

To reset the admin's password set the password to MD5 hash (myDBR does not internally use MD5 hashes, but does understand one). The MD5 hash will be updated to more secure one once you update the password within myDBR.

Reset the admin password in MySQL command line:

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

...where the 'dba' is the username given from the previous query.

Reset the admin password in 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';

Reset the admin password in Sybase command line:

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

"Texts are missing from PNG charts"

Make sure you have installed the fonts included in the ChartDirector package. See Installing ChartDirector for PHP

Error "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection"

On SQL Server (usually when Linked Servers are being used) the database connection requires specifig flags to be set. If you get this error when executing a report add following line to mydbr/user/defaults.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 still using old 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'm moving the myDBR installation to the new server, what do I do?"

myDBR consists of two parts: the ionCube encrypted PHP application and the myDBR database. To move the installation do the following:

  • Run the automatic updater to make sure you are running the latest version
  • Dump the myDBR database from old server. In case you are using MySQL, make sure to do include the routines to the dump (use --routines flag in mysqldump)
  • In case you are using MySQL, remove the DEFINER definitions from the SQL dump file so that the objects are created under correct user in the new server. You can use a text editor or use commands like sed:
          cat mydbr.sql | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | sed -e 's/DEFINER[ ]*=[ ]*[^*]*PROCEDURE/PROCEDURE/' | sed -e 's/DEFINER[ ]*=[ ]*[^*]*FUNCTION/FUNCTION/' > mydbr_clean.sql
        
  • Reload the myDBR database to the new server
  • Copy the /mydbr/user-directory from old server to the new one
  • Access myDBR installation with the browser to finish the installation