To install the myDBR application manually, you need to complete the following steps. (Please note that myDBR also provides an automated installation wizard. Launch the wizard by simply pointing your browser at the mydbr-directory):
Download the myDBR application from the myDBR website. You will receive a zip package containing the application. Extract the files from the zip package and place them under your web root.
When you launch myDBR for the first time, you will be asked for the username and password under which myDBR operates. The username and the password provided need to have the following:
$ mysql -uroot -p --default-character-set=utf8mb4 Enter password: ****** mysql> create user 'mydbr'@'localhost' identified by 'mydbr_password'; mysql> exit;
In SQL Server and Sybase, create the database with owner 'mydbr' (or db_owner role). Then grant read access to the actual database containing the data you wish to read from (either directly or via db_datareader-role).
If you do not have permissions to create new users, you can use an existing user and assign the required privileges (see later steps).
myDBR stores all the reporting information (reports, internal objects, etc.) in a database. You can install them into a separate database (recommended). Alternatively, install the items directly to the database you will be reporting from if you only have access to one database. All items in myDBR are named with '*mydbr*' to separate them from the user's data and objects.
myDBR requires full access to the myDBR reporting database and select access to the database you are reporting from. See the image above. You can either use an existing database user or create a new one. In this example installation, we have created a user with the name 'mydbr'.
Change to the db_creation directory (we'll use the database creation scripts):
$ cd install/db_creation
$ mysql -uroot -p --default-character-set=utf8mb4 Enter password: ****** mysql> create database mydbr character set = 'utf8mb4'; mysql> exit
$ mysql -uroot -p --default-character-set=utf8mb4 Enter password: ****** mysql> grant all on mydbr.* to 'mydbr'@'localhost'; mysql> grant select on mydatabase.* to 'mydbr'@'localhost'; mysql> exit
$ mysql -umydbr -p --default-character-set=utf8mb4 mydbr < mydbr_create_mysql.sql Enter password: ******If the creation script finishes without errors, you are ready to move to the next step
C:\>osql -n -U mydbr -P password -d mydbr < mydbr_create_mssql.sqlIf you do encounter problems during the database creation, please check that you have sufficient privileges for creating database objects.
isql -Umydbr -Ppasssword -Dmydbr < mydbr_create_sybase.sqlIf you do encounter problems during the database creation, please check that you have sufficient privileges for creating database objects.
isql -Umydbr -Ppasssword -Dmydb < mydbr_create_sybase.sqlIf you do encounter problems during the database creation, please check that you have sufficient privileges for creating database objects.
The install script will create a myDBR admin (user inside myDBR) with a username/password dba/dba. You should change the username/password as soon as you have installed the application.
The last thing to be done is to move the unpacked mydbr-directory to your server root and change its permissions.
config.phpis writable to the web server. This allows the admin to change myDBR's settings via the browser. Also, make sure that it is not readable to other users.
Example permissions on Linux (check your document directory and apache user). On MacOS X the apache user is by default "_www".
$ sudo mv mydbr /var/www/html $ cd /var/www/html/mydbr $ sudo chown -R apache:apache * . $ sudo chmod -R go-r * $ sudo chmod -R u+w *
Point your browser to http://localhost/mydbr/. If your installation is complete, you are greeted with the setup screen.
If you ever need to reset the install to this point, in the
config.php contains a key 'SETUPDONE' which will determine if the myDBR application will present the install screen or the standard login screen.
The first time you use the application, you will be greeted by the install wizard. By this point, you should be able to enter the connection details into your reporting database. myDBR also checks the setup to see that your environment is in working order. If you see error messages on the screen, please fix the configuration errors before proceeding.
The admin user's username. This user must have privileges to the mydbr database object,
including the right to execute stored routines. In the example installation, we created user
mydbr for this purpose.
If myDBR will be configured in MySQL (at a later stage), to use database authentication, root access is needed. No root access is required if the authentication is myDBR or external application authentication.
Complete the setup and you should be ready to log in with the default username dba and password dba. You should change this after the setup is done.