These settings define the generic settings for the myDBR installation. The installation defines an instance of myDBR
connected to a defined database.
These settings define the connection info for the myDBR installation and are stored in
mydbr_config.php on the server.
In order to change these re-run the installation. Installation will check that the required objects exist in the selected database.
- Database type
MySQL is accessed through mysqli, Sybase ASE and Sybase Anywhere
are accessed through FreeTDS and MS SQL Server can be accessed through FreeTDS or on Windows server using Microsoft's sqlsrv-driver.
The computer where the reporting database is located. Hostname or an IP address.
If connection is using TCP/IP port, it is defined here.
Name of the database containing the mydbr objects.
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.
Password for the admin user.
Determines which authentication module is used.
- myDBR user authentication
User logins and passwords are defined inside myDBR. See Users.
- Database login
A user is authenticated through the database's own user / password procedure. The user must have access to the database containing
the reported data.
- Single Sign-On (SSO)
The user is authenticated by an external web-site which then redirects the user back to myDBR. See SSO for more information.
- Active Directory
The user is authenticated using Active directory.
Custom authentication allows using external authentication, while still keeping the simplicity of login process. See Custom authentication for more information.
- Session lifetime
Session duration allowing user to stay connected even when browser is closed. When returning to myDBR a previous session is restored. Please note that yoy may need to change PHP's gc_maxlifetime-directive in order to have longer lifetime.
- URL hash seed
myDBR's report URL's will be protected by a hash value. By defining this value, admin can change the seed of the
hash making URL unique to server. Changing this value will change the URL's to reports. If value is empty,
a predefined value is used.
Password settings when using myDBR authentication
Defines password rules.
Single Sign-On (SSO) settings
- SSO secret token
The token used to verify that SSO redirects are coming from the authenticated SSO server. This token is known only to the myDBR server and SSO server
- SSO Server URL
The URL to which the user is redirected for login. myDBR will add a random token and a return URL as parameters to this URL. See
SSO for more information.
Active Directory settings
- Domain Controller
List of Domain Controllers. If you want to balance the queries over multiple controllers, you can specify multiple controllers by
separating them with comma. Example dc01.mydomain.local
- Account Suffix
The full account suffix for your domain. Example mydomain.local
- Base DN
The base dn for your domain. This is generally the same as your account suffix, but broken up and prefixed with DC=. Your base dn can be located in the extended attributes in Active Directory Users and Computers MMC.
- Username / Password
An AD username with access rights to read the AD structure.
Password reset allows user's to reset their own passsword via email request when using myDBR authentication. User request a password reset request and receives via email a password reset link. The link is valid for the defined period. In order to use this functionality, the mail settings need to be set and user's myDBR account needs to have a valid email address. New reset link request reset the old ones. The link can be used only once.
Defines if the feature is enabled
- Username / Email / Username or email
Defines which information is asked from the user when (s)he requests a password reset link
- Admin user's password can be changed
If this is set user can request a password reset link for admin user. if unchecked, admin logins are protected from password change
- Reset link valid for XX minutes
User can use the link sent only for XX minutes. After that the link expires and cannot be used.
- Show reset link only after login failure
If this is set, the link to password reset functionality is shown only after unsuccessful login attempt. If option is not set, the link is always visible.
Customizing the password reset email
You can customize the password reset email templates defined in mydbr/interface/languages/templates-folder.
By creating a template with same name in mydbr/user/templates/-folder. A template can contain HTML code
and supports following predefined template variables:
The server URL
Password reset link
How many minutes the password reset link is active
Page title defined in Environment settings
With automatic login enabled, no user login is required. All users accessing the reports will use the same login info.
This option is used in cases where myDBR is used as an public reporting source (intranets, public extranets). Username and
password here should in normal cases be set to non-admin username (not allowing everyone to change the content).
Admin access can be gained by pointing the browser to
login.php instead of the usual
The username to be used as a shared username
The password to be used as a shared password
These settings are shared between the users.
Default date format
Default time format
- Thousand separator
Default thousand separator
- Decimal separator
Default decimal separator
- Sum prefix, Min prefix, Max prefix, Average prefix, Count prefix
Prefixes to be used in summary rows when aggregate functions are used in reports
- myDBR report prefix
By default myDBR will search for unused reports based on this prefix. Any stored procedure that starts with this prefix
is offered to be added into the myDBR reporting structure
The UI style to be used in the application
Languages available under myDBR installation. This selection will allow admin to translate the system to selected
languages and users to set these languages as default
Mail is used by dbr.mail extension and the password reset feature.
SMTP mail host name
TCP/IP port used by the SMTP mail server (25 is the default for non-encrypted mail)
The mail can use TLS / SSL encryption
- Username / Password
Username / password for protected mail server access
- From Name/Email
Defaults to be used for "From:"
- ReplyTo Name/Email
Defaults to be used for "ReplyTo:". Optional. If not set no separate ReplyTo header is used in mail.
If separate "From Name/Email" and "ReplyTo Name/Email" is wanted for password resets, these can be set by overriding the defaults.php's 'password_reset' values in user/defaults.php.
The password reset instructions are sent to user's mail address. The mail templates are stored in mydbr/interface/languages/templates. If your language template is not there, you can create one by copying the existing templates and modifying them. If you want to override the existing templates and create your own ones, you can place one with same name into mydbr/user/templates.
OEM customization options are shown if you have an OEM license.
The OEM license holder. Shown in the About-dialog.
- Application name
When defined, replaces the 'myDBR'-text in upper left corner in non-report screens.
- Disable header
When selected, no header is shown. Suitable for installations where myDBR is used just for the reports, navigation is done elsewhere.
- Disable footer
When selected, no footer is shown.
When defined, replaces the standard footer text
- About info
Additional info to the About-dialog
- Login image CSS
An example of the CSS which defines the logo shown in the login screen
myDBR supports multiple charting modules. myDBR comes with Flash chart support preinstalled and can be enhanced with Image chart support
(PNG-charts) and with Graphviz-charts.
In order to take advantage of image charts and Graphviz-charts, you need to install the support for these.
See Optional installations on how to install these modules.
wkhtmltopdf allows you to export myDBR reports at full quality.
- Flash-charts (preinstalled)
Default charting module
ChartDirector image support. ChartDirector is an optional install to myDBR. ChartDirector is a commercial application
whose license is included with myDBR.
Graphviz support is enabled in the environment.
wkhtmltopdf support for better PDF output
- Preferred chart
Image- and Flash-charts can both draw similar charts. When both Flash-chart and Image-chart support is enabled in the environment,
this determines the default charting module (you can still specify the module used case-by-case in the report). myDBD automatically detects
supported charting in the client and uses theappropriate module.
- Default chart format
Choose between SVG and PNG charts. SVG charts are rendered in the client and make full use of client browsers native font subsystem producing crisp charts. PNG charts are images generated in the server.
- Use embedded charts
When checked, the chart data is embedded in the report.
- PHP include path
Enables you to specify the PHP include path in environments where some of the modules are not in default path.
- Proxy server
If your server is behind a proxy, the automatic update may not work until the proxy server is defined. Format is host:port (no http:// prefix).