ID: 000001 – Web Portal – PHP.ini configuration
Q:
In the DR Web portal I’m getting strange messages: “Notice…”
A:
During DR installation we are installing PHP component, it requires distribution of
php.ini into Windows directory. If on the computer PHP was already installed php.ini
won’t be overwritten. So in order to resolve that problem you have to modify php.ini
manually:
Go to Window directory, find and open it. In side you’ll find “Error handling and
logging” section. As a parameter put:
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
Then save it and restart DR web portal.
ID: 000002 – Configuration of Remote DSN
Q:
How to configure the DSN for remote SQL server?
A:
1. You have to ensure that TCP/IP connection is enabled on SQL server and remote
access to SQL server configured well. For Example port 1433 is open in firewall
and router properly set. (See your System Administrator for more details)
2. See movie “DR_To_SQL_Tutorial” located in the same directory as FAQ
ID: 000003 – Schedule Backup of MS SQL server DB
Q:
How to schedule backups for my SQL 2005 Express DR Data Base?
A:
1. You have to ensure that you have administrative rights to access SQL 2005
Express server
2. Import the “expressmaint.sql” sql script which is located in the same directory as
FAQ to SQL server.
3. user script is following:
ｅｘｅｃexpressmaint
@database = 'ALL_USER',
@optype = 'DB',
@backupfldr = '<path>\backups',
@reportfldr = '<path>\BackupReport',
@verify = 1,
@dbretainunit = 'days',
@dbretainval = 1,
Ocean Data Systems Ltd
The Art of Industrial Intelligence
Page 3 of 20
@rptretainunit = 'days',
@rptretainval = 1,
@report = 1
Save this script with sql extension
4. Create bat file which launch user script as follow:
SQLCMD.EXE -S . -i "<path>\userfullbackup.sql"
5. Create fake report in DR, schedule execution time of it according your needs and
in Report Settings define macro that executes bat file from p.4.
ID: 000004 – Setup proper permission for Web folder in DR.
Q:
How to set permission for Web folder in order to ensure proper report generation from
Dream Report Web portal?
A:
In case of generation problem using the web portal, you have to make sure the
web folder of the project has read/write permissions for everyone.
So, if you right click the web folder of the project, then choose properties from
context menu. The folder properties dialog will be opened; you should have a
security tab. If you don't, it means that you are either using a FAT32 partition, or
that you are using Simple Sharing mode. To switch from simple sharing mode to
regular one, from Windows Explorer, go to the tools menu, then Folder options,
go to the second tab (View), then uncheck the last check box of the advanced
properties as shown in the screen shot below:

  未完待续