• Documentation Update

    From Blue White@21:4/134 to apam on Sat Nov 9 14:03:56 2019
    FYI, for when you get back and have a chance.

    ==== Changing a user's Security Level ====

    At present this must be done with an sqlite utility, for the sqlite3
    command line utility:

    update users set seclevel=99 where loginname LIKE "apam";


    Should read:

    ==== Changing a user's Security Level ====

    At present this must be done with an sqlite utility, for the sqlite3
    command line utility:

    update users set sec_level=99 where loginname LIKE "apam";

    sec_level has an underscore in it.

    Might also want to include a note about issuing an ".open users.sq3"
    first, or sqlite3 won't be able to find the "users" table. :)

    Hope you are enjoying your trip!




    --- MagickaBBS v0.13alpha (Linux/armv7l)
    * Origin: Possum Lodge South * possumso.fsxnet.nz:7636/SSH:2122 (21:4/134)
  • From Al@21:4/106 to Blue White on Sat Nov 9 14:50:44 2019
    update users set seclevel=99 where loginname LIKE "apam";

    Should read:

    update users set sec_level=99 where loginname LIKE "apam";

    Ah, good catch. I've tried adjusting sec_level with no success. I don't remember why it failed but I'll try again with sec_level.

    Might also want to include a note about issuing an ".open users.sq3" first, or sqlite3 won't be able to find the "users" table. :)

    That might be part of my problem too.. thanks for the update.. :)

    Ttyl :-),
    Al

    --- MagickaBBS v0.13alpha (Linux/x86_64)
    * Origin: The Rusty MailBox - Penticton, BC Canada (21:4/106)
  • From Blue White@21:4/134 to Al on Sat Nov 9 19:56:00 2019
    Al wrote to Blue White <=-

    update users set seclevel=99 where loginname LIKE "apam";

    Should read:

    update users set sec_level=99 where loginname LIKE "apam";

    Ah, good catch. I've tried adjusting sec_level with no success. I don't remember why it failed but I'll try again with sec_level.

    Actually, I don't know if it is required or not but, when I had success, I
    also put a space before and after the equal sign, i.e. sec_level = 99. I forgot to add the spaces when I copied and changed the line from the docs.

    Might also want to include a note about issuing an ".open users.sq3" first, or sqlite3 won't be able to find the "users" table. :)

    That might be part of my problem too.. thanks for the update.. :)

    It is possible that .open statement is not required, but I sure needed it
    here to get sqlite3 to find the table.



    ... Computer Hacker wanted. Must have own axe.
    --- MultiMail
    * Origin: Possum Lodge South * possumso.fsxnet.nz:7636/SSH:2122 (21:4/134)
  • From apam@21:1/126 to Blue White on Sun Nov 10 20:52:09 2019

    sec_level has an underscore in it.

    Thanks for that catch.

    Might also want to include a note about issuing an ".open users.sq3" first, or sqlite3 won't be able to find the "users" table. :)

    That's only necessary if you don't open it from the command line. Ie
    sqlite3 users.sq3 rather than just sqlite3. At any rate I hope to have a utility for seclevels soon.

    Hope you are enjoying your trip!

    Yep thanks spent today in Adelaide with sister nephew and mum. Tomorrow
    going to mum's house which is about 4 and a half hour drive.

    Andrew




    --- MagickaBBS v0.13alpha (Linux/x86_64)
    * Origin: HappyLand - telnet://magickabbs.com:2023/ (21:1/126)
  • From Blue White@21:4/134 to apam on Sun Nov 10 08:55:47 2019
    apam wrote to Blue White <=-

    Might also want to include a note about issuing an ".open users.sq3" first, or sqlite3 won't be able to find the "users" table. :)

    That's only necessary if you don't open it from the command line. Ie sqlite3 users.sq3 rather than just sqlite3. At any rate I hope to have
    a utility for seclevels soon.

    Ahhhhh... lol, that would have helped! :)

    Hope you are enjoying your trip!

    Yep thanks spent today in Adelaide with sister nephew and mum. Tomorrow going to mum's house which is about 4 and a half hour drive.

    Sounds like a good time so far.

    I am looking forward to a much shorter trip than that, in a couple of
    weeks, to see family. It is a "food" holiday so it should be nice. :D


    ... 2 + 2 = 5 for extremely large values of 2.
    --- MultiMail
    * Origin: Possum Lodge South * possumso.fsxnet.nz:7636/SSH:2122 (21:4/134)