Elastic Search JDBC River Plugin SQL Server Integrated Security -


so i've been working on implementing elastic search using jdbc river plugin data our sql server db elastic search.

i've got working fine using sql server credentials, trying use integrated security doesn't work. create index, doesn't have data in it. parameters i've been using are: 

  put /_river/test_river/_meta      {          "type":"jdbc",        "jdbc":              {                 "driver":"com.microsoft.sqlserver.jdbc.sqlserverdriver",                  "url":"jdbc:sqlserver://testserver:1433;databasename=testdb;                 integratedsecurity=true;",                 "user":"",                 "password":"",                 "sql": "select * users",                 "poll":"30s",                 "index":"testindex",                 "type":"testusers"              }      }

i've tried quite few things, including removing user , password fields completely, removing integratedsecurity=true, gave same result. i've checked on github river plugin , says issue fixed in january, still doesn't seem working.

also i'm using elastic search version: 1.5.1 , jdbc river plugin version : 1.4.0.10

any appreciated

get rid of user , password options. you're not gonna need them.

check console when running elasticserch.bat, should see error message when tries update river. i'm going go out on limb , assume you're seeing error stating file sqljdbc_auth.dll can't found. if case, can download file here , copy x64 version of sqljdbc_auth.dll java lib folder. me, folder c:\programdata\oracle\java\javapath can type echo %path% in console window find yours.

once have followed these steps, restart elasticsearch.bat, , should start processing river. if not, post output you're seeing when running elasticsearch.bat.


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more