Installations Manual
Contents
1.2. Der angeforderte Net Framework Datenprovider kann nicht gefunden werden Er ist ggf nicht ins Windows Internet Explorer A EY E 5 localhost v mal itti XK CE Datei Bearbeiten Ansicht Favoriten Extras sly Favoriten 5 vores Kostenlose Hotmail Der angeforderte Net Framework Datenprovider kan Mr E 3 me v Seite Sicherheit Extras r Serverfehler in der Anwendung Megalog Der angeforderte Net Framework Datenprovider kann nicht gefunden werden Er ist ggf nicht installiert Beschreibung Unbehandelte Ausnahme beim Ausf hren der aktuellen Webanforderung berpr fen Sie die Stapel berwachung um weitere Informationen ber diesen Fehler anzuzeigen und festzustellen wo der Fehler im Code verursacht wurde Ausnahmedetails System ArgumentException Der angeforderte Met Framework Datenprovider kann nicht gefunden werden Er ist ggf nicht installiert Quellfehler Der Quellcode der diese unbehandelte Ausnahme verursacht hat kann nur angezeigt werden wenn im Debugmodus kompiliert wird Um dies zu aktivieren m ssen Sie einen der folgenden Schritte ausf hren und die URL anfordern 1 F gen Sie eine Debug true Direktive am Anfang der Datei hinzu die den Fehler generiert hat Beispiel lt Page Language C Debug true gt oder 2 F gen Sie der Konfigurationsdatei Ihrer Anwendung folgenden Konfigurationsabschnitt hinzu lt configuration gt lt system web gt lt compilation deb
3. IP Address 192 168 100 1 TCP Dynamic Ports 0 TCP Port 1433 El mz Active Yes Enabled No After applying the setting you have to IP Address 127 0 0 1 TCP Dynamic Ports 0 restart the SQL server service TCP Port 1433 El mai TCP Dynamic Ports 4330 TCP Port 1433 Cancel Apply Help MySQL MegaLog Secure IP GmbH If you decided to use the free MySQL server then you have to check if the server service is listening on TCP port 3306 If the MegaLog installation is not on the same server as the MySQL service you have to allow the user root to be connected from other workstations At least one user with sufficient rights to create a database is needed Open the MySQL Workbench 5 2 CE navigate to user accounts and double check D SET H BR 9 ER user root if from host is set Running to 9o To finish the MySQL database preparation you have to install the mysal connector net 6 3 6 zip This is needed on the server were TM TP or DBM will be installed MegaLog Secure IP GmbH MegaLog Installation Short Description MegaLog Syslog Suite needs three Windows services a SQL database and a IIS The installation can be split into steps SQL Server Preparation Database Maintenance Service DBM Main Service TM Web Frontend TP see IIS Preparation Syslog Agent Service TLPP Syslog Tools optional MegaLog Documentation optional System Requirements
4. Net 4 0 don t register themselves in IIS Most likely you will see then an error after trying to open the MegaLog web page TP see picture below To solve this please open a administrative CMD windows navigate to WINDOR Microsoft NET Framework v4 0 30319 and start the program aspnet regiis exe This will do the needed registration Konfigurationsfehler Windows Internet Explorer Selle E http localhost Megal GH HE b ot Datei Bearbeiten Ansicht Favoriten Extras gly Favoriten s vorgeschlagene Sites E Kostenlose Hotmail E we e D n Konfigurationsfehler Ze E e v Seite Sicherheit Extras ir Serverfehler in der Anwendung Megalog Konfigurationsfehler Beschreibung Fehler beim Verarbeiten einer Konfigurationsdatei die f r diese Anforderung erforderlich ist berpr fen Sie die unten angegebenen Fehlerinformationen und ndern Sie die Konfigurationsdatei entsprechend Parserfehlermeldung Unbekanntes targetFramework Attribut Beachten Sie bei Attributnamen die Gro Kleinschreibung Quellfehler Zeile 10 Zeile 11 lt system web gt Zeile 12 compilation debug false defaultLanguage c targetFramework 4 0 gt Zeile 13 assemblies Zeile 14 add assembly System Design Version 4 0 0 0 Culture neutral PublicKeyToken BO3F5F7F11D50A3A Quelldatei C Programme MegaLog TPiweb config Zeile 12 Versionsinformationen Microsoft NET
5. BL sounds AnalyseTypeHost aspx E Gg aspnet lient AnalyseTypeHost aspx cs Fl Default SMTP Virtual Server AnalyseTypeSyslog aspx 4nalyseTypesyslog aspx cs Windows XP Windows Server 2003 fg io Jtermereeroation erate Reeg Dri 1 Ge Ir SO Stes Dua is ie gt Mog cg m Z i Autkentifizierung d kW FERNE IHT ANTSRITATISESTERT Gruppen nach Eent Goupchermg I Anmerusqipesli p Am 9 a Sim Hara Statin Anbwnrityp a die Dotsck Web Site Anonyme Authechilgieung J cis ert J ng cient AD NET L ani ragchtel EET a 5 Messi og Feira laeacthenfinerueq Deak ret HTTP 302 Arrieta eal etary E Ein Sindwdsuttentitemung Anker HTTP SL Abfrsje mager mto D wurd T Ansicht Features 17 Angcht nhs Kenliquntizrc Deiseh Web Sriecfeteguln3 webconfig Windows Vista Windows 7 Check if the MegaLog application s properties Net 4 x is selected Check if the MegaLog application s authentication is set as expected Check if the MegaLog application s default page is Default aspx MegaLog Secure IP GmbH SQL Database Preparation Short Description MegaLog Database needs to be installed on a SQL service You can choose between MSSQL Express 2003 2008 and MySQL newer than V 5 1 Additionally install a SQL management tool e g Microsoft SQL Server Management Studio Express or MySQL Workbench 5 2 CE System Requirements The system requirements for MegaLog Database is described in Syste
6. Dienste Google Earth 7 Allgemeine HTTP Features E CN Anwendungsentwicklungsfeatures Setz Sg T NET Erweiterbarkeit NL Asp V jj ASP NET mE ca amp jJava TM 6 Up V ISAPI Erweiterungen amp jJava TM 6 Up V ISAPI Filter MegaLog Secure IP GmbH Windows Server 2008 Start the server manager and Add Roles Wizard start the wizard to add a server ic role Before You Begin Select one or more roles to install on this server Roles Description Pedes Directory Certificate Services fe erento t dede Active Directory Domain Services performance distributed business Codfirmabon Active Directory Federation Services applications such as those built with Active Directory Lightweight Directory Services Enterprise Services and NET d n d p re S S x N ext Progress Active Directory Rights Management Services Framework 3 0 Results Application Server DHCP Server DNS Server Fax Server File Services Hyper V Network Policy and Access Services Print Services Terminal Services UDDI Services Web Server IIS Windows Deployment Services Web Server IIS Choose Web Server IIS role Role Services III BEEE OOO More about server roles Next gt Install Cancel Add Roles Wizard xi Select ASP NET and IIS is Select Role Services Management Compatibility This TENE TEE egin Select the role services to install For
7. Web Server IIS is vital for the installer process ade reg eegen Web Server IIS B web Server ASP NET provides a server side object only fe oriented programming environment Common HTTP Features for building Web sites and web See V Static Content applications using managed code V Default Document ASP NET is not simply a new version Progress V Directory Browsing of nd ae T architected to provide a hi E Management Tools Installed Results SI HEROS productive ceu on IIS Management Console Installed L HTTP Redirection based on the NET Framework gt Management Console Installed B Application Development ASP NET provides a robust IIS Management Scripts and Tools Installed V ASP NET infrastructure For building web Management Service Installed Abe EE 7 z asp IIS 6 Management Compatibility Installed cal IIS 6 Metabase Compatibility Installed V ISAPI Extensions Ka is V ISAPI Filters IS 6 WMI Compatibility Installed F I MI compatibility Installed E Serene de Indies II5 6 Scripting Tools Installed E Health and Diagnostics IIS 6 Management Console Installed V HTTP Logging _ Logging Tools V Request Monitor L Tracing LI Custom Logging zi NND Iannimn More about role services press Next Previous Let gt Install Cancel After the wizard Ke has finish ed its COL
8. database You can reach the web application TP of MegaLog with the URL http localhost MegaLog 18 MegaLog Secure IP GmbH MegaLog Event Receiver TLPP The MegaLog TLPP configuration file contains 6 parameters and is stored in the file TLPPService exe config This configuration file is in XML format and needs to be in the same directory as the service executable TLPPService exe The service needs no access to the database it communicates only with the service module TM All other configuration of this service will be done with the web service MegaLog TP Presentation in your favourite browser Menu Config Icon TLPP Agent lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSettings gt lt add key TMDestinationIP value 127 0 0 1 gt lt add key TMConfigPort value 1119 gt lt add key TLPPId value 1 gt lt add key TLPPCommunicationPassword value tlppsecret gt lt add key InterfaceBindTo value 0 0 0 0 gt lt add key Debug value 45 gt lt appSettings gt lt configuration gt Table 6 Example shows configuration for TLPP No 1 If you change the configuration xml file you have to restart the service to apply the new settings 19 MegaLog Secure IP GmbH Registry Settings The MegaLog TLPP service needs zero registry settings to run Of course there are service depended registry settings for Windows maintaining the s
9. gt NB VISTA Sites Default WebSite aspnet dent system web 4030319 gt Datei Ansicht starts the IIS ass M m er aspnet client system web 4 0 30319 Startseite Pe j o a n a g e r S d 93 eios ifi Gruppieren nach Bereich SS T Berechtigungen bearbeiten 1B u BS ASP NET Ordner verwalten 4 E Default Web Site i 4 e Ordner durchsuchen If yO u Ca n n ot See 4 aspnet client e A i 2 1 9 80 http durchsuchen did stem web NET Globalisierung NET Kompilierung NET Profil NET Vertrauense e Hie t h e 403 0 3 1 9 zm iR Onlinehilfe l e n t ry yo u h d V e to Anwendungseinst Computerschl ssel Seiten und Sitzungszustand Steuerelemente prepare your IIS o installation for m mg aspnet clients manually Microsoft provides the aspnet regiis exe to do this f Ansicht Features 3 Ansicht Inhalt WINDIR Microsoft NET Framework v4 0 30319 aspnet_regiis exe i MegaLog Secure IP GmbH Check settings after MegaLog TP installation Open Internet Information Service Manager and search for MegaLog web application amp Internet Informationsdienste File Action View Help ig ox gs 8 ES E EE ET Internet Informatiansdienste Gl Server local computer Ec web Sites Default Web site Z IISHelp ActionFilkerDef aspx ActionFilkerDef aspx cs Actions aspx GL Info Actions aspx cs
10. EE Program startup parameter found SQL test will be done with connection string Data Source 1 0 0 1 Integrated Secunty SSPI Connect gt Timeout 5 Start testing now ERROR can not establish a SQL connection to the requested server The exception code System Data SalClient SqlException Netzwerkbezogener oder instanzspezifischer Fehler beim Herstellen einer Verbindung mit SQL Server Der Server wurde nicht gefunden oder auf ihn kann nicht zugegriffen werden berpr fen Sie ob der Instanzname richtig ist und ob SQL Server Remoteverbindungen zul sst Select Installation Folder This is the folder where MegaLog Suite will be installed To install in this folder click Next To install to a different folder enter it below or click Browse Folder c Program Files x86 MegaLog Advanced Installer Ready to Install The Setup Wizard is ready to begin the Typical installation Click Install to begin the installation If you want to review or change any of your installation settings dick Back Click Cancel to exit the wizard Advanced Installer MegaLog Secure IP GmbH Expert Installer Please download the installer MegaLogExpertInstaller exe from http www secureip de store it on a temporary folder and start it The ZIP archive will unpack all installers and starts Install hta The following MegaLog Installer should start CH E ka With the Expert Install
11. Framework Version 2 0 50727 3615 ASP NET Version 2 0 50727 3618 Fertig 4 Lokales Intranet g e 100 25 MegaLog Secure IP GmbH Directory access rights for service IIS service user MegaLog O DB C3 DBM CO TLPP C3 App Code C3 App Data 3 C3 Bin B images C3 animations C3 border C3 dataflow B icons O logo O menue 20 CO tab C3 Info C3 sounds After the msi installation you have to grand access rights to the directory TP images speedmeter for the service user of your local IIS If not you will see the statistics like this Background Some graphics on the MegaLog TP web pages are dynamically created during runtime The IIS service needs write access to store the graphics into this directory Because windows use for every language and version different user names as service user for IIS it is not possible to script this installation step into the installer process Add full access read write delete for the service user of IIS to the directory MegaLog TP images speedmeter Here some examples for the IIS service user Windows XP IUSR pcname Windows Vista IUSR Windows 7 IUSR Windows 2003 Server nt_authority Network Service Windows 2008 Server nt_authority Network Service Hint 1 If you cannot find the correct user add first Group Everyone to this directory and all subdirectories then cre
12. MegaLog Secure IP GmbH Installation and Configuration Documentation Version 1 3a 12 12 2010 Juge ele WE 2 MS FRC ae E 3 Windows XP Windows Server 2007 3 Windows Vista WindOws nennen nennen nnne nnne nnn 4 Mute e 6 m 5 Check settings after MegaLog TP installation cccccccccceececeeeeeceeeeseeeeeseeeeseeeesseeeeseeeesaeeeas 6 SQL Database Preparation enne nnn ennnn nnn nnnai nnns snna rines ssa rns e aan ens 7 MSSGOL EXPFEES Seiver 2905 20 0 ee een ona E Rd ee 7 jo 9 MegaLog Installation 1 eeeseeeseeeseeeeeeeeeeeeeeeen nennen nnnm nnn nnn nnne nnne nnne nnne nnne nenn nennen 10 Sa UE 11 eil E 13 Manual Configuration optional u002240002nnennennenennn nenn nenne nenne nenn nenne nnne nene nnn nnns nnns 16 Miser Beie MAINE RR EE 16 MegaLog Presentation TP susanne 18 MegaLog Event Receiver TRB 19 M gaLog DE Maintenance COB IV EE 21 Common instalation moo E 23 Server not member of same domain uusssssseennennnnnennnennennn nennen nennen nennen nennnnnnnnnenennnnnnnnnnn 23 MySQL Provider not installed or wrong version 24 eh Eed 25 Directory access rights for service IIS service user 26 ADDEN de Q 27 APPENA DEBUG KEE 27 MegaLog Secure IP GmbH Introduction M
13. The system requirements for MegaLog are described in System Requirements MegaLog pdf In short words running MS SQL Server SQL Server Preparation NET 4 0 IIS IIS Preparation Before You Begin 1 You need administrative rights to install these services 2 IIS needs to be installed In case of Windows Vista 7 and 2008 IIS Management Compatibility modules are needed for the install process 3 SQL server must be up and running a listening on TCP port 1433 in case of MSSQL b listening on TCP port 3306 in case of MySQL 10 Mega og Start MegaLog Installation Secure IP GmbH First please decide between MySQL or MSSQL and the installation procedure you need Easy Installer Please download the installer MegaLogSuite msi from http www secureip de store it on a temporary folder and start it The Easy Installer expect to install all services and modules to a single machine The SQL database can be on the same or on a other server Easy Installer Installation Process After starting the Easy Installer we will welcome you Please insert here the IP address or DNS name of your SQL server In case of MySQL provide a valid SQL user id pw with sufficient rights to install a database After pressing Next this the installer tries to contact the SQL database In case the SQL connection test was successful you will see this message By pressing Install you can go ahead with the i
14. ate some statistics on the web page in TP After this you are able to see the owner of this file Last add this user only and remove Everyone Hint 2 Try first to connect to the new installed MegaLog TP web page on the local host http localhost MegaLog After this try it from another workstation If this doesn t work please have a look to your firewall settings on the machine were you installed MegaLog TP 26 MegaLog Appendix Secure IP GmbH Appendix 1 Debug Value The debug parameter contains two parameter in one number This is used in the services TM TLPP and DBM A logging to the local event log file bits 0 3 0 1 2 3 4 7 represents event log severity Information represents event log severity Warning represents event log severity Error B logging to the MegaLog error database bits 3 5 7 e N U A Ui O 0 represents log severity Debug represents log severity Info represents log severity Notice represents log severity Warning represents log severity Error represents log severity Critical represents log severity Alert represents log severity Emergency The default value is 45 Examples 0 00 000 000 45 00 101 101 no logging at all up to warning will be sent to A and B 63 00 111 111 up to debug will be sent to A and B 7 00 000 111 up to debug will be sent to A only 56 00 111 000 up to debug will be sent to B only 27
15. egaLog consists of three windows services one web application and use one SQL database Please read the document System Requirements MegaLog doc to prepare your environment for these parts Additionally we documented information to prepare your e IIS Service e SQL Server on the following chapters Please go thru it it will perhaps save your time during installation At the end of this document we summarized several common problems In general this are not MegaLog issues but you have to resolve it in your operating system before everything fits together MegaLog Secure IP GmbH IIS Preparation Windows XP Windows Server 2003 If you did install IIS after the Net framework you have to prepare your IIS installation for aspnet clients manually Microsoft provides the aspnet regiis exe to do this WINDIR Microsoft NET Framework v4 0 30319 aspnet_regiis exe i When you have prepared your IIS correctly your configuration should look like in this picture Internet Information Services File Action View Help e BE X EDB 33 Internet Information Services amp Web 87 local computer Web Sites There are no items to show in this view c e Default web Site a Z rrsHelp E Printers MegaLog aspnet_client ES 2_0_50727 4 0 30319 Status Path E 7 a LI Printer gt Default SMTP Virtual Server MegaLog Secure IP GmbH Windows Vista Windows 7 Prepare your IIS i
16. er you can install every single module separately You should have some experience with the MegaLog configuration files and the concept behind You can choose your own installation order but the best practice installation order is show Click on the module s to start the installer process es Expert Installer Installation Process After starting one of the Expert Installer modules we will welcome you Welcome to MegaLog Database DB Setup Wizard The Setup Wizard will install MegaLog Database DB on your computer Click Next to continue or Cancel to exit the Setup Wizard 13 MegaLog Secure IP GmbH Please insert here the IP m address or DNS name of your Test SQL Server Comecton SQL server In case of gem QL server connectivity will be tested M S L r OV d e a V a i d S L Ss your MS SQL Express or MS SQL uns EES Ss y Q p Q SQL Server BE user id pw with sufficient rights to install a database SQL server connectivity will be tested here Please insert the valid IP address or DNS name from your MySQL server SQL Server localhost MySQL ID After pressing Next this the on Aen zm installer tries to contact the SQL database Advanced Installer In case of the service TLPP 1 Megalog Event Receiver Service TIPP Setup you have to insert several Parameter p aram et ers m or e Insert Startup Parameter For Service TLPP TM IP Address 127 0 0 1 TM Configura
17. ervice thru control panel If you enabled debug mode you will find under HKLM Software MegaLog TLPP several registry entries for troubleshooting These entries are only copies from the configuration stored in the MegaLog DB SQL database Parameter key TMDestinationIP Please insert here the IP address where the MegaLog TM module is listening for requests If MegaLog TLPP and MegaLog TM run on the same machine insert 127 0 0 1 there Parameter key TMConfigPort Per default MegaLog TM config port is 1119 tcp If you did not change it insert here 1119 Parameter key TLPPId Every MegaLog TLPP needs its unique number The number 1 is already preconfigured listening to interfaces see InterfaceBindTo at port 514 syslog protocol udp If you want to add more TLPPs insert it first in MegaLog TP Menu Config Icon Agents and then in the config file Parameter key TLPPCommunicationPassword The module MegaLog TLPP needs this password to connect to MegaLog TM module and retrieves its configuration The default password is tlppsecret and can be changed in MegaLog TP Menu Config Icon Agents When you change the password in MegaLog TM you have to change it as well here in the configuration file Please don t forget to restart the service immediately Parameter key InterfaceBindTo With this parameter you can set where MegaLog TLPP starts to listen The default
18. ey Debug The debug parameter are descript for all services in the Appendix 1 in this document 17 MegaLog Secure IP GmbH MegaLog Presentation TP The configuration is stored in the root of the MegaLog TP directory in the file Web Config Search for the parameter connectionStrings and change it to your connection string The MegaLog modules TM TP and DBM needs identical connection strings Except user id and password lt connectionStrings gt lt add name MegaLogDB connectionString Server 127 0 0 1 Database MegaLog Vid mgu_TP Pwd salsecrettp Connect Timeout 150 providerName MySaql Data MySqlClient gt lt connectionStrings gt lt system web gt lt compilation debug false defaultLanguage c targetFramework 4 0 gt Table 4 Example shows configuration for TM with MySQL database on the same machines TP uses a database user id and password to authenticate to the MegaLog database lt connectionStrings gt lt add name MegaLogDB connectionString Data Source 127 0 0 1 Initial Catalog MegaLog Integrated Security false User ID mgu_TP Password sqlsecrettp Connect Timeout 150 providerName System Data SqlClient gt lt connectionStrings gt lt system web gt compilation debug false defaultLanguage c targetFramework 4 0 gt Table 5 Example shows configuration for TM with MSSQL database on the same machines TP uses a database user id and password to authenticate to the MegaLog
19. l be tested here Please insert the valid IP address or DNS name From your MS SQL Express or MS SQL server SOL Server 192 168 178 29 SOL Connection Tester Program startup parameter found SQL test will be done with connection string Data Source 192 168 178 29 Integrated Security SSPI Connect Timeout 15 Start testing now ERROR can not establish a SQL connection to the requested server Advanced Installe The exception code System Data SqlClient SglException Login failed The login is from an untrusted domain and cannot be used with Windows authentication bei System Data SqlClient S gllntemalConnection O nE rror S glE ception exception Boolean vw J 23 MegaLog Secure IP GmbH MySQL Provider not installed or wrong version After you finished a MegaLog installation running together with a MySQL server and you forgot to install the Net database connector for MySQL mysgl connector net 6 3 6 most likely you will see an error after trying to open the MegaLog web page TP see picture below To solve this download and install the Net database connector mysal connector net 6 3 6 on the server workstation were TP TM and DBM is installed Please do not install a other version then 6 3 4 of the connector In the services TM and DBM has compiler references to this dedicated MySQL connector type In case you cannot use the requested version please get in contact with our support
20. m Requirements MegaLog pdf MS SQL Express Server 2005 2008 If you decided to use the free MS SQL Express 2005 2008 Server then you have to check if the server service is listening on TCP port 1433 Per default SQL Express 2005 2008 uses only Shared Memory to communicate First open the SQL Server Configuration manager This application will be installed during the MS SQL Express installation Then navigate to SQL Server 2005 2008 Network Configuration Protocols for SQLEXPRESS fr SQL Server Configuration Manager E File Action View Help etm B SQL Server Configuration Manager Local Protocol Name SQL Server 2005 Services Shared Memory Enabled wg SQL Server 2005 Network Configuration i Named Pipes Enabled d Protocols For SQLEXPRESS 3 TCP IP Enabled 23 vIA Enabled Ss SQL Native Client Configuration MegaLog Secure IP GmbH 2ixi There change the settings for Named Protocol 1p Addresses Pipes TCP IP and VIA to Enabled and El General Enabled Yes open the properties for the TCP IP settings Keep Alive 30000 Listen All Yes No Delay No It should look like on the picture on the left side Enabled Enable or disable TCP IP protocol For this server instance Zi Important Please have a look as well under Protocol IP Addresses IP Addresses Insert there for all wanted keij IP addresses the TCP port 1433 Yes Enabled No
21. ngs gt add key MegaLogConnectionString value Data Source192 168 199 199 Integrated Security false User ID mgu_dbm Password sqlsecretdbm Initial Catalog MegaLog gt lt add key Debug value 45 gt lt appSettings gt lt configuration gt Table 8 Example shows configuration for service DBM with MSSQL database on different machines DBM uses a database user id and password to authenticate to the MegaLog database lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSettings gt add key MegaLogConnectionString value Server 192 168 199 199 Database MegaLog Vid mgu_dbm Pwd saqlsecrettm Connect Timeout 150 gt lt add key Debug value 45 gt lt appSettings gt lt configuration gt 21 MegaLog Secure IP GmbH Table 9 Example shows configuration for service DBM with MySQL database on different machines DBM uses a database user id and password to authenticate to the MegaLog database If you change the configuration xml file you have to restart the service to apply the new settings Registry Settings The MegaLog DBM service needs zero registry settings to run Of course there are service depended registry settings for Windows maintaining the service thru control panel If you enabled debug mode you will find under HKLM Software MegaLog DBMaintenance several registry entries for troubleshooting These entries are only copies from the configurati
22. nstallation E iy Megalog Suite Setup Welcome to Megalog Suite Setup Wizard The Setup Wizard will install MegaLog Suite on your computer Click Next to continue or Cancel to exit the Setup Wizard SQL Database Test SQL Server Connection SQL Database Test SQL Server Connection SQL server connectivity will be tes from your MS SQL Express or MS Si 127 0 0 1 SQL Server SQL server connectivity will be tested here Please insert the valid IP address or DNS name from your MySQL server ocsihost root MySQL PW SQL Server MySQL ID Advanced Installer Advanced Installer Program startup parameter found SQL test will be done with connection string Data Source 127 0 0 1 Integrated Security SSPl Connect Timeout 5 Start testing now Test finished Looks fine Go ahead with the installation process Mega og In case the SQL connection test fails you will see this message or similar The installer process needs to be cancelled and restarted again Here you can insert the installation directory then press Next The installer is now ready to install all three services documentation tools and the presentation module The database will be created automatically after the first start of service DBMaintenance after one minute 12 Secure IP GmbH
23. nstallation for aspnet clients Open Control Panel Software and then Windows Components Install all components of NET ASP and ASP NET under the section WWW Services Ecka JAE gt Systemsteuerung Programme und Funktionen Datei Bearbeiten Ansicht Extras Aufgaben m m Programm deinstallieren oder ndern Installierte Updates anzeigen Wahlen Sie ein Programm aus der Liste aus und klicken Sie auf Deinstallieren ndern oder Reparieren um es zu deinstallieren Neue Programme online auf Windows Marketplace erwerben F Windows Funktionen E b Sofi Organisieren rworbene Software anzeigen Pi e SE Windows Funktionen ein oder ausschalten digitales Schlie fach Name 5 Windows Furktionen ein oder Verwenden Sie die Kontrollk stchen um die entsprechenden Funktionen ein oder auszuschalten Ein ausgef lltes Kontrollk stchen ausschalten bedeutet dass eine Funktion nur teilweise aktiviert ist amp m S Druckdienste 2 w EL Einfache TCPIP Dienste z B Echo Daytime usw p _ AnyDVD E Indexdienst S Avanquest upd c i Internetinformationsdienste Sj Cisco ASDM Lz E EP Webverwaltungstools 7 amp Cisco Systems V IIS Verwaltungsdienst 7 MS Cisco TFTP Sell V IS Verwaltungskonsole 5 eToken PKI CI vii IS Verwaltungsskripts und tools dB eToken SSO Te vi Kompatibilit t mit der IIS 6 Verwaltung FileZilla remoy SR WWW
24. on stored in the MegaLog DB sql database Parameter key MegaLogConnectionString The connection string is the most important configuration part The service MegaLog DBM needs a connection to MegaLog DB The MegaLog modules TM TP and DBM should have identical connection strings If you want to have enhanced security you can define several SQL users with minimum access rights For help to set the correct access rights please read User Manual MegaLog Access Security SQL Database Parameter key Debug The debug parameter are descript for all services in the Appendix 1 in this document 22 MegaLog Secure IP GmbH Common Installation Problems Server not member of same domain If the installation of MegaLog should be on one server workstation and the MSSQL is on another server then both server workstation needs to be in one domain The approach to solve this installation problem is to add the designated MegaLog server to the domain and restart the installation In case this is not a option install first MegaLog with a local MSSQL database After the basic installation is finished to can change the settings in TP DBM and TM to point to the new MSSQL server Please change the connection strings from Integrated Security SSPI to Integrated Security false and add a valid user ID and password for the MSSQL server i Megal og Suite Setup SQL Database Test SQL Server Connection SQL server connectivity wil
25. rvice TM with MSSQL database on different machines TM uses a database user id and password to authenticate to the MegaLog database lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSettings gt add key MegaLogConnectionString value2 Server 192 168 199 199 Database MegaLog Uid mgu tm Pwd sglsecrettm Connect Timeout 150 gt add key Debug value 45 gt lt appSettings gt lt configuration gt Table 3 Example shows configuration for service TM with MySQL database on different machines TM uses a database user id and password to authenticate to the MegaLog database 16 MegaLog Secure IP GmbH If you change the configuration xml file you have to restart the service to apply the new settings Registry Settings The MegaLog TM service needs zero registry settings to run Of course there are service depended registry settings for Windows maintaining the service thru control panel If you enabled debug mode you will find under HKLM Software MegaLog TM several registry entries for troubleshooting These entries are only copies from the configuration stored in the MegaLog DB SQL database Parameter key MegaLogConnectionString The connection string is the most important configuration part The service MegaLog TM needs a connection to MegaLog DB The MegaLog modules TM TP and DBM needs identical connection strings Except user id and password Parameter k
26. tion Port fi 19 TLPP ID i 1 TLPP Password seet SS Services bind to local IP 0 0 0 0 All parameters will be stored in the file MegaLog TLPP TLPP exe config If you want to change it later do it there and restart the service Advanced Installer For all installation modules D Megalog Database DB Se you have then to decide the Select Installation Folder n sta a ti on d re ct O ri es This is the folder where MegaLog Database DB will be installed To install in this folder dick Next To install to a different folder enter it below or click Browse Folder c Program Files x86 MegaLog DB Advanced Installer 14 MegaLog Secure IP GmbH Here press Install to start MegaLog Database DB Setu with the installation of a Ready to Install SI ng e mod u e The Setup Wizard is ready to begin the Typical installation Click Install to begin the installation If you want to review or change any of your installation settings dick Back Click Cancel to exit the wizard Advanced Installer Installing MegaLog Database DB Please wait while the Setup Wizard installs MegaLog Database DB This may take several minutes Status Executing install SQL scripts ww Advanced Installer Here you can close the single installation process and start Completing the MegaLog a other one from the Expert Database DB Setup Wizard Installer Click the Finish but
27. ton to exit the Setup Wizard 15 MegaLog Secure IP GmbH Manual Configuration optional MegaLog Main TM The MegaLog TM configuration file contains only two parameters and is stored in the file TMService exe config This configuration file is in XML format and needs to be in the same directory as the service executable TMService exe All other configuration of this service will be done with the web service MegaLog TP Presentation in your favourite browser Menu Config Icon TM Config lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSettings gt add key MegaLogConnectionString value Data Source 127 0 0 1 Integrated Security true Initial Catalog MegaLog Connect Timeout 150 gt lt add key Debug value 45 gt lt appSettings gt lt configuration gt Table 1 Example shows configuration for service TM with MSSQL database on the same machine Database and network services trust each other using Microsoft integrated security feature lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSettings gt add key MegaLogConnectionString value Data Source192 168 199 199 Integrated Security false User ID mgu tm Password salsecrettm Initial Catalog MegaLog Connect Timeout 150 gt lt add key Debug value 45 gt lt appSettings gt lt configuration gt Table 2 Example shows configuration for se
28. ug true gt lt system web gt lt configuration gt Hinweis Die zweite Option hat zur Folge das alle Dateien in der Anwendung im Debugmodus kompiliert werden Mit der ersten Option wird nur die angegebene Datei im Debugmodus kompiliert Wichtig Das Ausf hren von Anwendungen im Debugmodus belegt zus tzlichen Arbeitsspeicher Stellen Sie daher sicher dass das Debuggen f r eine Anwendung deaktiviert wird bevor sie f r die Produktion bereitgestellt wird Stapel berwachung ArgumentException Der angeforderte Net Framework Datenprovider kann nicht gefunden werden Er ist ggf nicht installiert System Data Common DbProviderFactories GetFactory String providerInvariantName 1402071 System Web UI WebControls SqiDataSource GetDbProviderFactory 65 System Web UI WebControls SqiDataSource GetDbProviderFactorySecure 22 System Web UI WebControls SqlDataSource CreateConnection String connectionString 12 System Web UI WebControls SqlDataSourceView ExecuteSelect DataSourceSelectArguments arguments 118 System Web UI DataSourceView Select DataSourceSelectArguments arguments DataSourceViewSelectCallback callback 17 System Web UI WebControls DataBoundControl PerformSelect 144 System Web UI WebControls BaseDataBoundControl DataBind 472 Svstem Web UI WebControls GridView DataBind 5 Lokales Intranet fg 100 24 MegaLog Secure IP GmbH NET not register in IIS In many cases Microsoft
29. value is 0 0 0 0 then the service is listening to all local IP addresses If you plan to in run several TLPPs listening on the same port e g 514 udp on one machine then add more IP addresses to this machine and distinguish exactly what TLPP should listen where 20 MegaLog Secure IP GmbH Parameter key Debug The debug parameter are descript for all services in the Appendix 1 in this document MegaLog DB Maintenance DBM The MegaLog DBM configuration file contains only two parameters and is stored in the file DBMaintenance exe config This configuration file is in XML format and needs to be in the same directory as the service executable DBMService exe All other configuration of this service will be done with the web service MegaLog TP Presentation in your favourite browser Menu Config Icon DB Config lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSettings gt add key MegaLogConnectionString value Data Source 127 0 0 1 Integrated Security true Initial Catalog MegaLog gt lt add key Debug value 45 gt lt appSettings gt lt configuration gt Table 7 Example shows configuration for service DBM with MSSQL database on the same machine Database and network services trust each other using Microsoft integrated security feature lt xml version 1 0 encoding UTF 8 standalone yes gt lt configuration gt lt appSetti
Download Pdf Manuals
Related Search