equal
deleted
inserted
replaced
400 |
400 |
401 $ psql mydb |
401 $ psql mydb |
402 mydb=> update cw_cwuser set cw_upassword='qHO8282QN5Utg' where cw_login='joe'; |
402 mydb=> update cw_cwuser set cw_upassword='qHO8282QN5Utg' where cw_login='joe'; |
403 UPDATE 1 |
403 UPDATE 1 |
404 |
404 |
|
405 if you're running over SQL Server, you need to use the CONVERT |
|
406 function to convert the string to varbinary(255). The SQL query is |
|
407 therefore:: |
|
408 |
|
409 update cw_cwuser set cw_upassword=CONVERT(varbinary(255), 'qHO8282QN5Utg') where cw_login='joe'; |
|
410 |
405 You can prefer use a migration script similar to this shell invocation instead:: |
411 You can prefer use a migration script similar to this shell invocation instead:: |
406 |
412 |
407 $ cubicweb-ctl shell <instance> |
413 $ cubicweb-ctl shell <instance> |
408 >>> from cubicweb.server.utils import crypt_password |
414 >>> from cubicweb.server.utils import crypt_password |
409 >>> crypted = crypt_password('joepass') |
415 >>> crypted = crypt_password('joepass') |