Re: Problem with Password Decryption in Data Import Handler

2016-11-03 Thread William Bell
OK it was echo -n "${encrypt_key}" > encrypt.key On Thu, Nov 3, 2016 at 12:20 PM, William Bell wrote: > I cannot get it to work either. > > Here are my steps. I took the key from the Patch in > https://issues.apache.org/jira/secure/attachment/12730862/SOLR-4392.patch. > > echo U2FsdGVkX19Gz7q

Re: Problem with Password Decryption in Data Import Handler

2016-11-03 Thread William Bell
I cannot get it to work either. Here are my steps. I took the key from the Patch in https://issues.apache.org/jira/secure/attachment/12730862/SOLR-4392.patch. echo U2FsdGVkX19Gz7q7/4jj3Wsin7801TlFbob1PBT2YEacbPEUARDiuV5zGSAwU4Sz7upXDEPIQPU48oY1fBWM6Q== > pass.enc openssl aes-128-cbc -d -a -salt

Re: Problem with Password Decryption in Data Import Handler

2016-11-03 Thread Jamie Jackson
You were right, Fuad. There was a flaw in my script (inconsistent naming of the `plain_db_pwd` variable. Thanks for figuring that out. For posterity, here's the fixed script: encrypt_key=your_encryption_key plain_db

Re: Problem with Password Decryption in Data Import Handler

2016-11-02 Thread Fuad Efendi
Then I can only guess that in current configuration decrypted password is empty string. Try to manually replace some characters in encpwd.txt file to see if you get different errors; try to delete this file completely to see if you get different errors. Try to add new line in this file; try to

Re: Problem with Password Decryption in Data Import Handler

2016-11-02 Thread Jamie Jackson
I should have mentioned that I verified connectivity with plain passwords: >From the same machine that Solr's running on: solr@000650cbdd5e:/opt/solr$ mysql -uroot -pOakton153 -h local.mysite.com mysite -e "select 'foo' as bar;" +-+ | bar | +-+ | foo | +-+ Also, if I add the plain-te

Re: Problem with Password Decryption in Data Import Handler

2016-11-02 Thread Fuad Efendi
In MySQL, this command will explicitly allow to connect from remote ICZ2002912  host, check MySQL documentation: GRANT ALL ON mysite.* TO 'root’@'ICZ2002912' IDENTIFIED BY ‘Oakton123’; On November 2, 2016 at 4:41:48 PM, Fuad Efendi (f...@efendi.ca) wrote: This is the root of the problem: "Acce

Re: Problem with Password Decryption in Data Import Handler

2016-11-02 Thread Fuad Efendi
This is the root of the problem: "Access denied for user 'root'@'ICZ2002912' (using password: NO) “ First of all, ensure that plain (non-encrypted) password settings work for you. Check that you can connect using MySQL client from ICZ2002912 to your MySQL & Co. instance I suspect you need to a

Re: Problem with Password Decryption in Data Import Handler

2016-11-02 Thread Jamie Jackson
I'm at a brick wall. Here's the latest status: Here are some sample commands that I'm using: *Create the encryptKeyFile and encrypted password:* encrypter_password='this_is_my_encrypter_password' plain_db_pw='Oakton153' cd /var/docker/solr_stage2/credentials/ echo -n "${encrypter_password}" >

Re: Problem with Password Decryption in Data Import Handler

2016-10-06 Thread Jamie Jackson
It happens to be ten characters. On Thu, Oct 6, 2016 at 12:44 PM, Alexandre Rafalovitch wrote: > How long is the encryption key (file content)? Because the code I am > looking at seems to expect it to be at most 100 characters. > > Regards, >Alex. > > Newsletter and resources for Solr b

Re: Problem with Password Decryption in Data Import Handler

2016-10-06 Thread Jamie Jackson
I tried it both ways yesterday--with a newline and without. On Thu, Oct 6, 2016 at 12:26 PM, Kevin Risden wrote: > I haven't tried this but is it possible there is a new line at the end in > the file? > > If you did something like echo "" > file.txt then there would be a new > line. Use echo -n

Re: Problem with Password Decryption in Data Import Handler

2016-10-06 Thread Alexandre Rafalovitch
How long is the encryption key (file content)? Because the code I am looking at seems to expect it to be at most 100 characters. Regards, Alex. Newsletter and resources for Solr beginners and intermediates: http://www.solr-start.com/ On 6 October 2016 at 23:26, Kevin Risden wrote: > I h

Re: Problem with Password Decryption in Data Import Handler

2016-10-06 Thread Kevin Risden
I haven't tried this but is it possible there is a new line at the end in the file? If you did something like echo "" > file.txt then there would be a new line. Use echo -n "" > file.txt Also you should be able to check how many characters are in the file. Kevin Risden On Wed, Oct 5, 2016 at 5:

Problem with Password Decryption in Data Import Handler

2016-10-05 Thread Jamie Jackson
Hi Folks, (Using Solr 5.5.3.) As far as I know, the only place where encrypted password use is documented is in https://cwiki.apache.org/confluence/display/solr/Uploading+Structured+Data+Store+Data+with+the+Data+Import+Handler, under the "Configuring the DIH Configuration File", in a comment in t