Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8482

mysql-test - main.func_encrypt fails if FIPS=1

    XMLWordPrintable

    Details

    • Sprint:
      10.0.25

      Description

      mariadb-10.0.20-18.1.x86_64

      With FIPS enabled this test case is failing.

      ./mysql-test-run.pl main.func_encrypt

      main.func_encrypt                        [ fail ]
              Test ended at 2015-07-13 13:09:55
       
      CURRENT_TEST: main.func_encrypt
      --- /usr/share/mysql-test/r/func_encrypt.result	2015-06-17 16:54:11.000000000 +0200
      +++ /usr/share/mysql-test/r/func_encrypt.reject	2015-07-13 13:09:54.951169666 +0200
      @@ -42,84 +42,67 @@
       insert into t1 values (des_encrypt('jumped over the lazy brown dog','sabakala'));
       select hex(x), hex(des_decrypt(x,'sabakala')) from t1;
       hex(x)	hex(des_decrypt(x,'sabakala'))
      -FFA185A4656D113445E31D7A5B31BB57671A4CA9E21E63FE5D9C801E0CC7AA6190C13E269C2AE8D8060D3FB3FEA94FEC7FB006B9DCAC3E3E41	NULL
      -FFC620C3B84E926A54	NULL
      -FFA4F77D4220A16C980AF7CB576F8DC0A864F357825C16F329F24F66EBA775765B7C1538B90970740F853B556AEBD35AC31B962EA9B12B5AD4	NULL
      -FFACFF5921BB876A90	NULL
      -FFA6F18760E7CC5A4C325244B8486F692AAA11D229AF9ED4E4C9D56D7C0278C0DDA58F73E15E2B5F6C1DDD19B22B8071C454C930585449AAEB	NULL
      -FF3736DFEDC4B765F4	NULL
      -FF598681EA5F03CD6D6AEA2B118DF4885DD78BECDFB012BBB05386E436DC403D3CB9DE3BE8D5D3BB7FD90A1F9F9A3E055BB3B4FD3F6A869473	NULL
      -FF15B8B5952D630CAE	NULL
      -FF11EE3A400685226B76D5EC567681FA90247CE3C9DBE43341311C22F74562B1199957D80E300737791F6345BBC61AE03F28F52E5A6DCC78B2	NULL
      -FF0A832AE10DC85483	NULL
      -FF6F5C0BF4C5F899B4E7C091D9B1F1E92A7623B651B150CA3E7F420B4DD316D2C1BF76FCF9F9A046C000A9E21C106591E8C1930201B1750269	NULL
      -FFA08D5FB849A9FC90	NULL
      -FFF7331312FE153A39B1EC0D65BC1D3A0B6FCD49DA8C95D6161F53B11D297BAE142BCA6B9492DAE9A02AF455F16CA2C1CF4E1AD17297E947E2	NULL
      -FFDEE60A938478E059	NULL
      -FF95A729E73D5D87416A53055029E8CAA95B4F7B49F3D2D821A95D1FCE70F4B7A3226077176723F3DCC0A44D3B2EE9EFBC4D31AA87C948916C	NULL
      -FF1C78557F542A1FDC91943761B2EED14F	NULL
      -FF1E35B0775EEE512544A75BDAF58EA1655F5C899D3C5191A47263E2D11C3E688F662AB79F66D3B1DF9C75BD869EB8E04FDAE85719CB573A43	NULL
      -FF1C78557F542A1FDCDC4182B5314185E5	NULL
      -FF783123DCB36F98A51C39A560C92E129F1DDEEAB170825406A61260FBFBBFB0F2E48DB3282588A975C9C71E0EACA71A2B642A8C9C2E921A9F	NULL
      -FF1C78557F542A1FDCAC4B1B6B47206306	NULL
      -FF6D9B450837017D06CA1F1C9A0E700D03DEF06A4F954527A961CA805F70320E9F3F0007636B80768A253A5F7ADABC18B78F1A2FA560CC0B21	NULL
      -FF1C78557F542A1FDCE9038BD99DD43F2E	NULL
      -FF23FD03BA7548DD0957EBA7A8FBF7A18589762F3913E9A935BDA72F6F28202DC64572E0D633A54EA55BFD2C749E408C8632CCE36A7AE00619	NULL
      -FFD8DD3C4ABCB02FCDFE1383ECC0F61E7D02CD3BA72BBAEA26384D14835796501B3DC9A2F7EC2FC1633BDA6D56464536FE12010049C53A1991	54686520717569636B2072656420666F78206A756D706564206F76657220746865206C617A792062726F776E20646F67
      -FFACC5C5479575CBCA518B05778139B1BFC10F07299C98D04F580BC2F816828722D65A89C1831BD29DA626D319813BD374	717569636B2072656420666F78206A756D706564206F76657220746865206C617A792062726F776E20646F67
      -FF128D5517241DEEC631ABD2A47FA66E57930001417F18204328B0B2CB13F7AD2F50B8336EFAE7DE21	72656420666F78206A756D706564206F76657220746865206C617A792062726F776E20646F67
      -FF7CF971283B4DC2D050B3DB22684737B74B5B1CF12CF2FAC5A5995A298505F56D82BBFB9FC3E70059	666F78206A756D706564206F76657220746865206C617A792062726F776E20646F67
      -FF8333F3DD21E4488F967E03DD12394813A49F72848BB49473D3CB1C8A1AACF220	6A756D706564206F76657220746865206C617A792062726F776E20646F67
      -FFE8CB7FD80E6262C5FEB042A2DCC73B699CEEDCA6DC4458A0	6F76657220746865206C617A792062726F776E20646F67
      -FFA29334D7CDB1B403DF3EB992067DD524C7D568E8D98EBFE5	746865206C617A792062726F776E20646F67
      -FF4F0C5858FE2358D400E38831D5577C85	6C617A792062726F776E20646F67
      -FFB370CD6BAFD1CB95974D21DCCA2DD9D7	62726F776E20646F67
      -FF8F7777B28C7A459A	646F67
      -FF75213A4D7D01D715	646F6721
      -FF2DCAF574B173FB4D	646F672121
      -FFFA775787BE776B15	646F67212121
      -FF3FC2E42D7C840905	646F6721212121
      -FF9723312D26D9E6DA01D01A784A64DB9D	646F672121212121
      -FF8333F3DD21E4488F967E03DD12394813A49F72848BB49473D3CB1C8A1AACF220	6A756D706564206F76657220746865206C617A792062726F776E20646F67
      -FF8333F3DD21E4488F967E03DD12394813A49F72848BB49473D3CB1C8A1AACF220	6A756D706564206F76657220746865206C617A792062726F776E20646F67
      +FF2E24A52D912A8F567E265C218F6F7304257E6B727378695B79297A112F3A2987FE6C8116F28F4DE5D845526E9F1ED950180277AAE194D068	NULL
      +FFCA8A42DBAE694D6C	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FF73A63991729F91C0	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FFD4BBB4B187AE3DB2	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FF5A123DBFE250795E	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FF20066DEA5858C636	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FF77E98D0F025D4D90	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FFE64EDAAB942A0782	NULL
      +FF949C139588E564889E36F59DB7188E2928380572654A768E92C53B8E06898CB2EA796F56894F2E8EDB86721A6F96F9FED87C34504ABCEF09	NULL
      +FF7807364E767B1024EE9D5E4B4C64B8E6	NULL
      +FFD7CCD3981F35911D1CEB92464654E8842C5D9E19F50CAB556B2776490B7DCAF815205CFBAA9F69262CFD5C82308B3A31267C64A52CF7252C	NULL
      +FF7807364E767B10242A17053A3773EBA8	NULL
      +FFD7CCD3981F35911D1CEB92464654E8842C5D9E19F50CAB556B2776490B7DCAF815205CFBAA9F69262CFD5C82308B3A31267C64A52CF7252C	NULL
      +FF7807364E767B1024A56136C04A3ABAFB	NULL
      +FFD7CCD3981F35911D1CEB92464654E8842C5D9E19F50CAB556B2776490B7DCAF815205CFBAA9F69262CFD5C82308B3A31267C64A52CF7252C	NULL
      +FF7807364E767B10246AC252B6EF79234F	NULL
      +FFD7CCD3981F35911D1CEB92464654E8842C5D9E19F50CAB556B2776490B7DCAF815205CFBAA9F69262CFD5C82308B3A31267C64A52CF7252C	NULL
      +FFD7CCD3981F35911D1CEB92464654E8842C5D9E19F50CAB556B2776490B7DCAF815205CFBAA9F69262CFD5C82308B3A31267C64A52CF7252C	NULL
      +FFA87DE3DFD7435E9ADE93345C7B986F82B702CB401FB31FE87F342494FDC392F4B2B283D5DFDBA7D1B50F4F1EEB007B1B	NULL
      +FFAFC30E6E24D729CEEB11D85C5B3EE44AFBBCD9EDE327C7714A01EA468AAF3290BDF04CA1B9F73118	NULL
      +FFF6892DC50BAED89882B89AF7DBD70FB6BAFDD5E109F7A7281451C1959565017ED7C87840B802B0D5	NULL
      +FF28348E7AA6ED8D54D796EB962ABB7A2FD8E2D53E36A483A9C4E9CB02EFF5701D	NULL
      +FF423B172F79C691D5C71E7BFC72129E1C1ECD75C9329443E6	NULL
      +FF2556DE57AD76881D8FD19381BDCE6DEB76FED2C9CCAB40AC	NULL
      +FFF7AF690D016452A5B3FB4BD61D20D44A	NULL
      +FF5E0AFE1559D586F3A216CC7C94789EF9	NULL
      +FF908AD39B77108830	NULL
      +FF1411A4AE1E15C0AB	NULL
      +FFBE9880ADF93748BD	NULL
      +FF5FCA0C9D2D90B468	NULL
      +FF6D0E79054BA12115	NULL
      +FF45855CB865EBB9AC65B61B7CD2048E9C	NULL
      +FF28348E7AA6ED8D54D796EB962ABB7A2FD8E2D53E36A483A9C4E9CB02EFF5701D	NULL
      +FF28348E7AA6ED8D54D796EB962ABB7A2FD8E2D53E36A483A9C4E9CB02EFF5701D	NULL
       select des_decrypt(x,'sabakala') as s from t1 having s like '%dog%';
       s
      -The quick red fox jumped over the lazy brown dog
      -quick red fox jumped over the lazy brown dog
      -red fox jumped over the lazy brown dog
      -fox jumped over the lazy brown dog
      -jumped over the lazy brown dog
      -over the lazy brown dog
      -the lazy brown dog
      -lazy brown dog
      -brown dog
      -dog
      -dog!
      -dog!!
      -dog!!!
      -dog!!!!
      -dog!!!!!
      -jumped over the lazy brown dog
      -jumped over the lazy brown dog
       drop table t1;
       select hex(des_encrypt("hello")),des_decrypt(des_encrypt("hello"));
       hex(des_encrypt("hello"))	des_decrypt(des_encrypt("hello"))
      -85D6DC8859F9759BBB	hello
      +85D613326E5693D87D	hello
       select des_decrypt(des_encrypt("hello",4));
       des_decrypt(des_encrypt("hello",4))
       hello
       select des_decrypt(des_encrypt("hello",'test'),'test');
       des_decrypt(des_encrypt("hello",'test'),'test')
      -hello
      +NULL
       select hex(des_encrypt("hello")),hex(des_encrypt("hello",5)),hex(des_encrypt("hello",'default_password'));
       hex(des_encrypt("hello"))	hex(des_encrypt("hello",5))	hex(des_encrypt("hello",'default_password'))
      -85D6DC8859F9759BBB	85D6DC8859F9759BBB	FFD6DC8859F9759BBB
      +85D613326E5693D87D	85D613326E5693D87D	FF2B8F8B16D76FE459
       select des_decrypt(des_encrypt("hello"),'default_password');
       des_decrypt(des_encrypt("hello"),'default_password')
      -hello
      +NULL
       select des_decrypt(des_encrypt("hello",4),'password4');
       des_decrypt(des_encrypt("hello",4),'password4')
      -hello
      +NULL
       select des_encrypt("hello",10);
       des_encrypt("hello",10)
       NULL
       
      mysqltest: Result length mismatch
       
       - saving '/usr/share/mysql-test/var/log/main.func_encrypt/' to '/usr/share/mysql-test/var/log/main.func_encrypt/'

      https://bugzilla.suse.com/show_bug.cgi?id=937843

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            nirbhay_c Nirbhay Choubey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: