Troubleshooting

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

You can always update to the newer myDBR version. You 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 login 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 acces 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 internaly use MD5 hashes, but does understand one). The MD5 hash will be upated 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

"I'm moving the myDBR installation to new server, what do I do?"

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

  • Tun 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)
  • Reload the myDBR database to new server
  • Copy the /mydbr/user-directory from old server to the new one
  • Access myDBR installation with the browser to finish the installation