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.
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.
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';
'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';
Make sure you have installed the fonts included in the ChartDirector package. See Installing ChartDirector for PHP
myDBR consists of two parts: the ionCube encrypted PHP appllication and the myDBR database. To move the installation do following: