Home

Tips
  Umlauts/UTF-8
  Normalization
  OemToAnsi
  MySQL Import
  Site Search
  City Desk
  DynDNS
  MXLookup
  SPAM

SDT

Support
  Downloads
  Contact Us

Impressum

German

Web Search

English Version > Sqldbu > Installation

Installation The installation requires at least a working internet connection and a valid FTP access (user name and password) to the document and script root of the target HTTP server. For installation from a Windows client the tool setup.exe can be used. From a Linux/Unix or MacOsX box the installation has to be done manually.  Installation using Windows tool setup.exe Download and copy package sqldbu.zip to a separate directories, e.g. c:\temp. Unzip the package within the target directory and leave  the resulting directory structure unchanged:  c:\> cd \temp  c:\temp> unzip sqldbu.zip Launch the installation utility  c:\temp> setup.exe Follow the instructions provided by installation utility. This wizard gathers following information to set up the CGI-Utility properly: General settings: Language, target platform FTP Settings:   User and password for FTP transfer, target system directories  (document root, script root) E-Mail settings:  Mail Server, administrator E-Mail MySQL settings:   User, password and database name needed for the CGI script in order to access MySQL data Manual Installation from Linux/Solaris/MacOsX or Windows Download and copy package sqldbu.zip to a separate directories, e.g. /usr/local/temp or c:\temp. Unzip the package within the target directory and leave the resulting directory structure unchanged:  Windows:  c:\> cd \temp  c:\temp> unzip sqldbu.zip  Linux:  lx:/home/admin # cd /usr/local/temp  lx:/usr/local/temp # unzip sqldbu.zip Change the current directory to the one containing  the platform depending script and start FTP  transfer to the desired target server (e.g. Solaris): Windows:  c:\temp> cd sqldbu-install\platform\SolSparc-2.x  c:\temp\sqldbu-install\platform\SolSparc-2.x> ftp  Linux:  lx:/usr/local/temp # cd sqldbu-install/platform/SolSparc-2.x  lx:/usr/local/temp/sqldbu-install/platform/SolSparc-2.x # ftp FTP transfer:  ftp> open www.my-site.com  ftp> my-user  ftp> my-password  ftp> cd cgi-bin  ftp> binary  ftp> put sqldbu  ftp> bye Note: Values www.my-site.com, my-user, my-password must replaced by appropriate settings of your environment. Change to directory cgi-bin in order to modify sqldbu.ini and transfer all other necessary files afterwards: Windows: c:\temp\sqldbu-install\platform\SolSparc-2.x > cd ..\..\cgi-bin Linux:  lx:/usr/local/temp/sqldbu-install/platform/SolSparc-2.x # cd ../../cgi-bin Modify following settings of sqldbu.ini by your favored editor:  [DIRECTORIES]  DOCUMENTROOT=..  SCRIPTROOT=.  HOME=http://www.my-site.com/cgi-bin/sqldbu.exe  SELF=http://www.my-site.com/cgi-bin/sqldbu.exe  DOMAIN_URL=http://www.my-site.com  [MYSQL]  Host=www.my-site.com  Database=webseller  User=me  Password=mypassword  LIMIT=20  Socket=NULL  Port=0  Flags=0  [EMAIL]  MAILSERVER=mailx.my-site.com  FROMADDRESS=admin@my-site.com  FromName=Administrator  DESTINATION=admin@my-site.com Start FTP transfer: Windows: c:\temp\sqldbu-install\cgi-bin > ftp Linux: lx:/usr/local/temp/sqldbu-install/cgi-bin # ftp FTP transfer:  ftp> open www.my-site.com  ftp> my-user  ftp> my-password  ftp> cd cgi-bin  ftp> binary  ftp> put sqldbu.ini  ftp> put sqldbu.sql  ftp> bye Note: Values www.my-site.com, my-user, my-password must replaced by appropriate settings of your environment. Start SQLDBU basic initialization by appropriate HTTP request via  internet browser with following URL: http://www.my-site.com/cgi-bin/sqldbu?action=dbuimport&batch=sqldbu.sql First regular SQLDBU launch by appropriate HTTP requestv ia  internet browser with following URL: Solaris: http://www.my-site.com/cgi-bin/sqldbu.cgi Linux: http://www.my-site.com/cgi-bin/sqldbu.cgi MacOSX: http://www.my-site.com/cgi-bin/sqldbu Win32: http://www.my-site.com/cgi-bin/sqldbu.exe