Hi Will,This issue has been recreated, reported to development and a fix will be in the next VOS release.
In the meantime you can use the "user_set_password" function which does not exhibit this problem. Detail on it usage can be found at:
http://docs.openlinksw.com/virtuoso/fn_user_set_password.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 25 May 2009, at 02:01, Will Daniels wrote:
Hi,I just observed the following odd behaviour in 5.0.11 running on Ubuntu9.04 (amd64), which looks certain to be a bug...If SET PASSWORD is used to change the dba (or presumably any other user) password, butthen the server is shutdown before a checkpoint, the changeis lost, showing the following error in the daemon log file when ittries to Roll Forward to persist the password change on the next start:03:33:06 Roll forward started 03:33:06 SQL Error: 22023 : SR005: Function set_user_struct needs a string or NULL as argument 5, not an arg of type INTEGER (189) 03:33:06 5 transactions, 248 bytes replayed (100 %) 03:33:06 Roll forward complete If a checkpoint is manually issued before restarting the server, thepassword change seems to be written correctly to the database without error.Please let me know if this behaviour is in some way correct, or if there is any further information/assistance I can provide to help fix the problem.Regards, Will---------------------------------------------------------------------- --------Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaTis a gathering of tech-side developers & brand creativity professionals. Meetthe minds behind Google Creative Lab, Visual Complexity, Processing, &iPhoneDevCamp asthey present alongside digital heavyweights like BarbarianGroup, R/GA, & Big Spaceship. http://www.creativitycat.com _______________________________________________ Virtuoso-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
