In order to install the myDBR application manually you need to complete following steps. (Please note that myDBR provides also 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:
$ mysql -uroot -p --default-character-set=utf8mb4 Enter password: ****** mysql> create user 'mydbr'@'localhost' identified by 'mydbr_password'; mysql> exit;
In SQL Server and in Sybase, create the database with owner 'mydbr' (or db_owner role) and grant users 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.) into a database. You can either install them into a separate database (recommended) or if you only have access to one database, you can install the items directly to the database you will be reporting from. 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 picture above. You can either use an existing database user or create a new one. In this example installation we have created a user with 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 any errors, you are ready to move to 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 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 you'll find a key 'SETUPDONE' which will
determine if the myDBR application will present the install screen or the normal 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 to your reporting database. myDBR also makes system checks to see that your environment is in working order. If you see error messages on screen, please fix the configuration errors before proceeding.
The admin user's username. This user must have the privileges to 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 later stage), to use database authentication, root access is needed. If the authentication is myDBR or external application authentication, no root access is required.
Complete the setup and you should be ready log in with the default username dba and password dba. You might want to change this after the setup is done.