Jump to content

installing MDM error

vanroy

By vanroy
in Remote Management

 Share
Go to solution Solved by vanroy,

Recommended Posts

vanroy

vanroy 0

Posted
  • Author
Posted

Hello

 

MSI (s) (68:DC) [15:29:24:098]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI7DE4.tmp, Entrypoint: ActionConfigInsertMDMSettings
INFO: Custom action 'ConfigInsertMDMSettings' successfully initialized.
INFO: Successful GET property 'P_MODULES_DIR' with value - C:\Users\Soporte\AppData\Local\Temp\EsetRemoteAdminMDMCore\
INFO: Successful GET property 'P_DB_TYPE' with value - MS SQL Server via Windows Authentication
INFO: Successful GET property 'P_DB_CONNECTORS_DIR' with value - C:\Users\Soporte\AppData\Local\Temp\EsetRemoteAdminMDMCore\
INFO: Successful GET property 'P_PRODUCT_NAME' with value - MDMCore
INFO: Successful GET property 'P_DB_DRIVER' with value - SQL Server
INFO: Successful GET property 'P_DB_HOSTNAME' with value - localhost
INFO: Successful GET property 'P_DB_PORT' with value - 1433
INFO: Successful GET property 'P_DB_USER_USERNAME' with value - **********
INFO: Successful GET property 'P_DB_USER_PASSWORD' with value - **********
INFO: Successful GET property 'P_DB_NAME' with value - era_mdm_db
INFO: (GetDatabaseServerConnectionStringWithoutEscape) Created connection string: 'Driver=SQL Server;Server=localhost,1433;Uid=******;Pwd={******};CharSet=utf8;'
INFO: Successful GET property 'P_MDM_HOSTNAME' with value - localhost
INFO: Successful GET property 'P_MDM_PORT' with value - 9981
INFO: Successful GET property 'P_MDM_ENROLLMENT_PORT' with value - 9980
INFO: Successful GET property 'P_CERT_AUTH_PATH' with value - C:\Users\Soporte\AppData\Local\Temp\EsetRemoteAdminMDMCore\ca.der
INFO: Successful GET property 'P_MULTIAGENT_HTTPS_CERT_PATH' with value - C:\Users\Soporte\AppData\Local\Temp\EsetRemoteAdminMDMCore\httpscert.cer
INFO: Successful GET property 'P_MULTIAGENT_HTTPS_PASSWORD' with value - **********
INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetConfigEngineData(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetConfigEngineData(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseWrapper::SetConfigEngineData(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseWrapper::SetConfigEngineData(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseWrapper::SetConfigEngineData(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseWrapper::SetConfigEngineData(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Custom action 'ConfigInsertMDMSettings' ended.
MSI (s) (68:40) [15:29:39:770]: Executing op: ActionStart(Name=CA_DbInsertCertAuthFile,,)
Action 15:29:39: CA_DbInsertCertAuthFile. 
MSI (s) (68:40) [15:29:39:801]: Executing op: CustomActionSchedule(Action=CA_DbInsertCertAuthFile,ActionType=11265,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (68:08) [15:29:39:973]: Invoking remote custom action. DLL: C:\Windows\Installer\MSIBB9A.tmp, Entrypoint: DbInsertCertAuthFile
INFO: Custom action 'DbInsertCertAuthFile' successfully initialized.
INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CCAMultiAgentDbInsertCertAuthFile::CustomActionExecution(void)
INFO: Successful GET property 'P_CERT_AUTH_PATH' with value - C:\Users\Soporte\AppData\Local\Temp\EsetRemoteAdminMDMCore\ca.der
INFO: Successful GET property 'P_LOAD_CERTS_FROM_FILE_AS_BASE64' with value - 
INFO: Successful GET property 'P_DB_TYPE' with value - MS SQL Server via Windows Authentication
INFO: Successful GET property 'P_DB_DRIVER' with value - SQL Server
INFO: Successful GET property 'P_DB_HOSTNAME' with value - localhost
INFO: Successful GET property 'P_DB_PORT' with value - 1433
INFO: Successful GET property 'P_DB_NAME' with value - era_mdm_db
INFO: Successful GET property 'P_DB_USER_USERNAME' with value - **********
INFO: Successful GET property 'P_DB_USER_PASSWORD' with value - **********
INFO: Successful GET property 'P_UPGRADE' with value - 
INFO: Successful GET property 'P_DB_TYPE' with value - MS SQL Server via Windows Authentication
INFO: Entering function: class Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase *__cdecl Era::Setup::Common::CustomActions::MultiAgentSetupDbManagerCreator(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Leaving function: class Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase *__cdecl Era::Setup::Common::CustomActions::MultiAgentSetupDbManagerCreator(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)
INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::Connect(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,unsigned short,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,bool)
INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::Disconnect(void)
INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::Disconnect(void)
INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::Connect(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,unsigned short,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,bool)
ERROR: !!! In function Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::InsertCertificateAuthorityIntoDatabase, caught an exception: ODBC handle exception; msg: SQLExecute()
Requested SQL statement: EXECUTE [dbo].[usp_setup_store_ca_certificate] '00000000-0000-0000-7008-000000000001', 1, 30, 0, 0x080112260A2430303030303030302D303030302D303030302D373030322D3030303030303030303030321A260A2430303030303030302D303030302D303030302D373030382D30303030303030303030303120012801320D08D00F100118012001280130013A0D08D00F100118012001280130014001481E, 0x0A5F0A1F4365727469666963617465417574686F726974792066726F6D205345545550123C436572746966696361746520617574686F72697479206173207061697220746F20706565722063657274696669636174652066726F6D205345545550121E0A0D08D00F10011801200128013001120D08D00F100118012001280130011A002286073082038130820269A00302010202101F6A0CEC253278A5415FDFCE01275C29300D06092A864886F70D010105050030593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F0072301E170D3135303731343030303030305A170D3235303731353030303030305A30593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F007230820122300D06092A864886F70D01010105000382010F003082010A0282010100A8D6C73BF0D8DF2FA88B7634981005AD76C1CEDA0672AF86A73966136D9AE0B802336D25F658B34ECEF36DA693DFC5A6E3FD43CDA27DECC81EC4DC96148A888D2D69823847E7092CD9D7B08DBA95BFA69618086BA418CB641C00912E5C1AB6D964090F9BC5F321B8A093EFB19D342B017B2BE70EAC7E9A2F2916A6904DB052707177975E25957AD84DA4870B4B739C342895BF1DEFA6038C0A72D57CF0708F62C3E7D3335F2296A1B791BC9BB613C4A9F6E9AF1DC51D36323B1B9B856FE97B3A129C2A7831769CB9F10C37E70B4F728CBE5632E3AF9F80F1AEE3BE16B69B040FC44F896AFB4D59C60797218AB4BE7DA31D67634328EFA66099417ADE4647E1D90203010001A3453043300E0603551D0F0101FF04040302010630120603551D130101FF040830060101FF020100301D0603551D0E041604146970D712CEA52531B9471D4F0BD10133C75C44CD300D06092A864886F70D010105050003820101005B310BA7544DE3F93E2BF19CEBC9EFC41CEBCB7F1D0E689C734B2FA3A3E41444721D26FBEFB3BA0FA573256DC4B99EA07DE46FEB6FC00AE4AEB366DB5442975E334050F5DEA7DF9A4EC2E7709788C90E8BC2656ACD9F4E932C5A57FB4193BB66409779FFA1D1850BC67DAB56D0A7A59154FC9BFC3073A599AE0580DC58C496DE41FAF9FB573B9349DD7045E3EDFB11322793DA394A70ADBFBE858CFCDCBFE7855F8F8D58A23E7C35C08307A78ED4B15E0F5F5FB37B51131AA98F9404C60B328B96146A2746287F52E38F9BE9D5FBED1E356CC57CC68F07D0828E9DB271E66978B44A5B168D682649193227058702F4A5EF959179B4D22C525D6C6827AAE70FAF0A;
 
Native SQL statement: EXECUTE [dbo].[usp_setup_store_ca_certificate] '00000000-0000-0000-7008-000000000001', 1, 30, 0, 0x080112260A2430303030303030302D303030302D303030302D373030322D3030303030303030303030321A260A2430303030303030302D303030302D303030302D373030382D30303030303030303030303120012801320D08D00F100118012001280130013A0D08D00F100118012001280130014001481E, 0x0A5F0A1F4365727469666963617465417574686F726974792066726F6D205345545550123C436572746966696361746520617574686F72697479206173207061697220746F20706565722063657274696669636174652066726F6D205345545550121E0A0D08D00F10011801200128013001120D08D00F100118012001280130011A002286073082038130820269A00302010202101F6A0CEC253278A5415FDFCE01275C29300D06092A864886F70D010105050030593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F0072301E170D3135303731343030303030305A170D3235303731353030303030305A30593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F007230820122300D06092A864886F70D01010105000382010F003082010A0282010100A8D6C73BF0D8DF2FA88B7634981005AD76C1CEDA0672AF86A73966136D9AE0B802336D25F658B34ECEF36DA693DFC5A6E3FD43CDA27DECC81EC4DC96148A888D2D69823847E7092CD9D7B08DBA95BFA69618086BA418CB641C00912E5C1AB6D964090F9BC5F321B8A093EFB19D342B017B2BE70EAC7E9A2F2916A6904DB052707177975E25957AD84DA4870B4B739C342895BF1DEFA6038C0A72D57CF0708F62C3E7D3335F2296A1B791BC9BB613C4A9F6E9AF1DC51D36323B1B9B856FE97B3A129C2A7831769CB9F10C37E70B4F728CBE5632E3AF9F80F1AEE3BE16B69B040FC44F896AFB4D59C60797218AB4BE7DA31D67634328EFA66099417ADE4647E1D90203010001A3453043300E0603551D0F0101FF04040302010630120603551D130101FF040830060101FF020100301D0603551D0E041604146970D712CEA52531B9471D4F0BD10133C75C44CD300D06092A864886F70D010105050003820101005B310BA7544DE3F93E2BF19CEBC9EFC41CEBCB7F1D0E689C734B2FA3A3E41444721D26FBEFB3BA0FA573256DC4B99EA07DE46FEB6FC00AE4AEB366DB5442975E334050F5DEA7DF9A4EC2E7709788C90E8BC2656ACD9F4E932C5A57FB4193BB66409779FFA1D1850BC67DAB56D0A7A59154FC9BFC3073A599AE0580DC58C496DE41FAF9FB573B9349DD7045E3EDFB11322793DA394A70ADBFBE858CFCDCBFE7855F8F8D58A23E7C35C08307A78ED4B15E0F5F5FB37B51131AA98F9404C60B328B96146A2746287F52E38F9BE9D5FBED1E356CC57CC68F07D0828E9DB271E66978B44A5B168D682649193227058702F4A5EF959179B4D22C525D6C6827AAE70FAF0A;
 
: Connection:NetConn: 0000000A5F179D20
Server:Not applicable
===========================
ODBC Diagnostic record #1:
===========================
SQLSTATE = 42000
Native Error Code = 2812
[Microsoft][ODBC SQL Server Driver]
Could not find stored procedure 'dbo.usp_setup_store_ca_certificate'.
 
 
INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::Disconnect(void)
INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CMultiAgentSetupDbManagerBase::Disconnect(void)
INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CCAMultiAgentDbInsertCertAuthFile::CustomActionExecution(void)
ERROR: (DbInsertCertAuthFile) Caught a Poco exception: ODBC handle exception; msg SQLExecute()
Requested SQL statement: EXECUTE [dbo].[usp_setup_store_ca_certificate] '00000000-0000-0000-7008-000000000001', 1, 30, 0, 0x080112260A2430303030303030302D303030302D303030302D373030322D3030303030303030303030321A260A2430303030303030302D303030302D303030302D373030382D30303030303030303030303120012801320D08D00F100118012001280130013A0D08D00F100118012001280130014001481E, 0x0A5F0A1F4365727469666963617465417574686F726974792066726F6D205345545550123C436572746966696361746520617574686F72697479206173207061697220746F20706565722063657274696669636174652066726F6D205345545550121E0A0D08D00F10011801200128013001120D08D00F100118012001280130011A002286073082038130820269A00302010202101F6A0CEC253278A5415FDFCE01275C29300D06092A864886F70D010105050030593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F0072301E170D3135303731343030303030305A170D3235303731353030303030305A30593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F007230820122300D06092A864886F70D01010105000382010F003082010A0282010100A8D6C73BF0D8DF2FA88B7634981005AD76C1CEDA0672AF86A73966136D9AE0B802336D25F658B34ECEF36DA693DFC5A6E3FD43CDA27DECC81EC4DC96148A888D2D69823847E7092CD9D7B08DBA95BFA69618086BA418CB641C00912E5C1AB6D964090F9BC5F321B8A093EFB19D342B017B2BE70EAC7E9A2F2916A6904DB052707177975E25957AD84DA4870B4B739C342895BF1DEFA6038C0A72D57CF0708F62C3E7D3335F2296A1B791BC9BB613C4A9F6E9AF1DC51D36323B1B9B856FE97B3A129C2A7831769CB9F10C37E70B4F728CBE5632E3AF9F80F1AEE3BE16B69B040FC44F896AFB4D59C60797218AB4BE7DA31D67634328EFA66099417ADE4647E1D90203010001A3453043300E0603551D0F0101FF04040302010630120603551D130101FF040830060101FF020100301D0603551D0E041604146970D712CEA52531B9471D4F0BD10133C75C44CD300D06092A864886F70D010105050003820101005B310BA7544DE3F93E2BF19CEBC9EFC41CEBCB7F1D0E689C734B2FA3A3E41444721D26FBEFB3BA0FA573256DC4B99EA07DE46FEB6FC00AE4AEB366DB5442975E334050F5DEA7DF9A4EC2E7709788C90E8BC2656ACD9F4E932C5A57FB4193BB66409779FFA1D1850BC67DAB56D0A7A59154FC9BFC3073A599AE0580DC58C496DE41FAF9FB573B9349DD7045E3EDFB11322793DA394A70ADBFBE858CFCDCBFE7855F8F8D58A23E7C35C08307A78ED4B15E0F5F5FB37B51131AA98F9404C60B328B96146A2746287F52E38F9BE9D5FBED1E356CC57CC68F07D0828E9DB271E66978B44A5B168D682649193227058702F4A5EF959179B4D22C525D6C6827AAE70FAF0A;
 
Native SQL statement: EXECUTE [dbo].[usp_setup_store_ca_certificate] '00000000-0000-0000-7008-000000000001', 1, 30, 0, 0x080112260A2430303030303030302D303030302D303030302D373030322D3030303030303030303030321A260A2430303030303030302D303030302D303030302D373030382D30303030303030303030303120012801320D08D00F100118012001280130013A0D08D00F100118012001280130014001481E, 0x0A5F0A1F4365727469666963617465417574686F726974792066726F6D205345545550123C436572746966696361746520617574686F72697479206173207061697220746F20706565722063657274696669636174652066726F6D205345545550121E0A0D08D00F10011801200128013001120D08D00F100118012001280130011A002286073082038130820269A00302010202101F6A0CEC253278A5415FDFCE01275C29300D06092A864886F70D010105050030593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F0072301E170D3135303731343030303030305A170D3235303731353030303030305A30593157305506035504031E4E004100750074006F0072006900640061006400200064006500200063006500720074006900660069006300610063006900F3006E002000640065006C0020007300650072007600690064006F007230820122300D06092A864886F70D01010105000382010F003082010A0282010100A8D6C73BF0D8DF2FA88B7634981005AD76C1CEDA0672AF86A73966136D9AE0B802336D25F658B34ECEF36DA693DFC5A6E3FD43CDA27DECC81EC4DC96148A888D2D69823847E7092CD9D7B08DBA95BFA69618086BA418CB641C00912E5C1AB6D964090F9BC5F321B8A093EFB19D342B017B2BE70EAC7E9A2F2916A6904DB052707177975E25957AD84DA4870B4B739C342895BF1DEFA6038C0A72D57CF0708F62C3E7D3335F2296A1B791BC9BB613C4A9F6E9AF1DC51D36323B1B9B856FE97B3A129C2A7831769CB9F10C37E70B4F728CBE5632E3AF9F80F1AEE3BE16B69B040FC44F896AFB4D59C60797218AB4BE7DA31D67634328EFA66099417ADE4647E1D90203010001A3453043300E0603551D0F0101FF04040302010630120603551D130101FF040830060101FF020100301D0603551D0E041604146970D712CEA52531B9471D4F0BD10133C75C44CD300D06092A864886F70D010105050003820101005B310BA7544DE3F93E2BF19CEBC9EFC41CEBCB7F1D0E689C734B2FA3A3E41444721D26FBEFB3BA0FA573256DC4B99EA07DE46FEB6FC00AE4AEB366DB5442975E334050F5DEA7DF9A4EC2E7709788C90E8BC2656ACD9F4E932C5A57FB4193BB66409779FFA1D1850BC67DAB56D0A7A59154FC9BFC3073A599AE0580DC58C496DE41FAF9FB573B9349DD7045E3EDFB11322793DA394A70ADBFBE858CFCDCBFE7855F8F8D58A23E7C35C08307A78ED4B15E0F5F5FB37B51131AA98F9404C60B328B96146A2746287F52E38F9BE9D5FBED1E356CC57CC68F07D0828E9DB271E66978B44A5B168D682649193227058702F4A5EF959179B4D22C525D6C6827AAE70FAF0A;
 
: Connection:NetConn: 0000000A5F179D20
Server:Not applicable
===========================
ODBC Diagnostic record #1:
===========================
SQLSTATE = 42000
Native Error Code = 2812
[Microsoft][ODBC SQL Server Driver][sql Server]Could not find stored procedure 'dbo.usp_setup_store_ca_certificate'.
 
 
INFO: Successful GET property 'P_SILENT' with value - 
Error 30000. A critical error occurred. Please see the installation log for more information. Enabling the log is described at the ESET knowledge base website:
kb.eset.com
 
Issue ID: SOLN406
    
MSI (s) (68!A0) [15:39:55:646]: Product: ESET Remote Administrator Mobile Device Connector -- Error 30000. A critical error occurred. Please see the installation log for more information. Enabling the log is described at the ESET knowledge base website:
kb.eset.com
 
Issue ID: SOLN406
    

 

Link to comment
Share on other sites
  • ESET Moderators
TomasP

TomasP 311

Posted
  • ESET Moderators
Posted

Hi, please see this part from your message:

Please see the installation log for more information. Enabling the log is described at the ESET knowledge base website:

kb.eset.com
Issue ID: SOLN406

That is the log I was asking about, not the one you posted.

Link to comment
Share on other sites
  • ESET Moderators
TomasP

TomasP 311

Posted
  • ESET Moderators
Posted

Thank you.

Upon further inspection, I'd suggest contacting your local ESET support office as further information will be needed and the case will need to be tracked.

When contacting them, you can already pinpoint to the error in the log "SQLSTATE = 42000 Native Error Code = 2812 [Microsoft][ODBC SQL Server Driver]

Could not find stored procedure 'dbo.usp_setup_store_ca_certificate'."
Link to comment
Share on other sites
  • Solution
vanroy

vanroy 0

Posted
  • Author
  • Solution
Posted (edited)

Solved.

Change database name era_mdm_db2 or Drop existing and create new database.

Edited by vanroy
Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...