equal
deleted
inserted
replaced
406 function to convert the string to varbinary(255). The SQL query is |
406 function to convert the string to varbinary(255). The SQL query is |
407 therefore:: |
407 therefore:: |
408 |
408 |
409 update cw_cwuser set cw_upassword=CONVERT(varbinary(255), 'qHO8282QN5Utg') where cw_login='joe'; |
409 update cw_cwuser set cw_upassword=CONVERT(varbinary(255), 'qHO8282QN5Utg') where cw_login='joe'; |
410 |
410 |
|
411 Be careful, the encryption algorithm is different on Windows and on |
|
412 Unix. You cannot therefore use a hash generated on Unix to fill in a |
|
413 Windows database, nor the other way round. |
|
414 |
|
415 |
411 You can prefer use a migration script similar to this shell invocation instead:: |
416 You can prefer use a migration script similar to this shell invocation instead:: |
412 |
417 |
413 $ cubicweb-ctl shell <instance> |
418 $ cubicweb-ctl shell <instance> |
414 >>> from cubicweb.server.utils import crypt_password |
419 >>> from cubicweb.server.utils import crypt_password |
415 >>> crypted = crypt_password('joepass') |
420 >>> crypted = crypt_password('joepass') |