Depending on your answer, that was going to be my next question..... is the user an actual system user, or just a user in the Maria user database that is used internally? :) Because I tried adding an "adminer" user and couldn't get it to work, but I didn't give it a password and I didn't use the MYSQL command to grant it privileges, I was just hoping adding the user through Webmin and letting it do the "create in other modules" was going to do the trick. I was wondering myself how many people have used this and not reported anything back. I'm guessing they didn't go elsewhere, they're just not as ignorant as I am and they quickly figured out how to fix it. :)
As far as naming the user, maybe name it Maria? Personally for me when the users perform different functions but named the same thing..... well, you know what I mean, that leads to confusion for a slow guy like me. If it's a hassle to have an extra user that requires additional work on the site admin, I'd say throw those tasks onto the same admin user or mysql user or whatever. But to me, when I run into errors it's helpful to have a distinct user when reading through logs that I'm not well versed in to begin with. That was one of the problems I was having, the socket user was root and everything looked ok. A lot of stuff the user was mysql and everything looked ok. All the dir rights were set to mysql and all that looked ok. If all the other V18 appliances are using the adminer user, I'd just stay with that if it was me with maybe a blog note saying why and fix it with V19 if necessary. Did I just make your eyes cross mentioning V19? LOL BTW, you might want to check the other appliances, just in case..... That was my next step, to download something like Mantis or Gitea and see how Maria was set up with those to match my Redmine to. I really don't like that they use root with no password for socket access or anything at all. I know I'm not familiar enough with it to see that it's more secure, etc but it doesn't seem like a long stretch to user error or a hacker's short trip to user mis-configuration for a serious security issue. I remember several serious discussions "back in the day" when I ran the WAN for the local school system and tech specialists out in the schools couldn't get something to work so they'd just give full rights to the app directory to get it to work, half the time giving full rights to the entire server. Speaking of making your eyes cross!
I definitely wouldn't add Adminer, the module, requiring PHP unless there's a specific benefit to it. To me that's one of the biggest benefits to TKL, having you guys wade through all that stuff for me. I can set up a server, install Ruby, Redmine & whatever and get it all going. I'm not even a stranger to the command line. But seems like every time PHP or Python or Ruby or Maria or whatever releases their "latest and greatest" all hell breaks loose. LOL I'm not knocking Adminer, but when I've used it in the past it seems like most of that stuff can be done through Webmin and the stuff you couldn't, most of those guys are going to go to the command line and use MYSQL commands directly. I just don't use the command line enough to remember all my commands so I have to do a quick search on how to do that, so Webmin is where it's at for me.
As far as a fix to RM v18, wouldn't the simplest thing for you to do be to just add the adminer user, execute that MYSQL command above and repackage the ISO? Easy peasy..... maybe throw in a note in the readme as to why you're still using that user and then make everything uniform later down the road? But if I understood the whole socket thing, doesn't that cause other issues having the password? If it was me, I'd pick the flat out easiest way to fix it for you guys regardless of any confusion because I know you're still working on finishing up V18 and it's nothing that can't be fixed with a readme or posted on the web in the Learn More > section. If us slow guys can't figure it out with that heads up, I guess you'll just have to help us one at a time. :D
Jeremy, you are DA MAN! Whatever they pay you isn't enough. The amount of time you spend helping folks in the forum seems like a full time job on top of all the coding you do to roll these things out. Your instructions are clear and you're always patient with folks. TKL is the model other vendors should use on how to deal with their end users. I had a math teacher back in high school who would always ask "What do you not understand?" when you said you didn't understand something. If I don't understand, I'm not sure I can answer the question as to what. :) I can't count how many times I've asked what I thought was a legitimate question in a support forum elsewhere only to be berated about reading the manual, that question has been asked and answered, did I do a search for it, etc. My first computer was a Commodore 64, but my first PC was an 8088 processor with 256K (yes K, not MB or GB) RAM running DOS 2.0. As I get older, I realize I get confused more easily and I don't grasp concepts as quickly as I used to but as "they" say, "this is not my first rodeo." If I'm asking a question it's because I've tried to figure things out and for whatever reason I couldn't. All of you at TKL go above and beyond to help folks with their problems without chewing on them as to why they're asking it and it is greatly appreciated. No one or no organization is perfect and I'm sure y'all have a white board somewhere or whatever it is "the kids are using now" to figure out how you can make your product/support/profit or whatever better, but TKL is the mark other companies should be aiming for.... Just sayin'. :)
Depending on your answer,
Depending on your answer, that was going to be my next question..... is the user an actual system user, or just a user in the Maria user database that is used internally? :) Because I tried adding an "adminer" user and couldn't get it to work, but I didn't give it a password and I didn't use the MYSQL command to grant it privileges, I was just hoping adding the user through Webmin and letting it do the "create in other modules" was going to do the trick. I was wondering myself how many people have used this and not reported anything back. I'm guessing they didn't go elsewhere, they're just not as ignorant as I am and they quickly figured out how to fix it. :)
As far as naming the user, maybe name it Maria? Personally for me when the users perform different functions but named the same thing..... well, you know what I mean, that leads to confusion for a slow guy like me. If it's a hassle to have an extra user that requires additional work on the site admin, I'd say throw those tasks onto the same admin user or mysql user or whatever. But to me, when I run into errors it's helpful to have a distinct user when reading through logs that I'm not well versed in to begin with. That was one of the problems I was having, the socket user was root and everything looked ok. A lot of stuff the user was mysql and everything looked ok. All the dir rights were set to mysql and all that looked ok. If all the other V18 appliances are using the adminer user, I'd just stay with that if it was me with maybe a blog note saying why and fix it with V19 if necessary. Did I just make your eyes cross mentioning V19? LOL BTW, you might want to check the other appliances, just in case..... That was my next step, to download something like Mantis or Gitea and see how Maria was set up with those to match my Redmine to. I really don't like that they use root with no password for socket access or anything at all. I know I'm not familiar enough with it to see that it's more secure, etc but it doesn't seem like a long stretch to user error or a hacker's short trip to user mis-configuration for a serious security issue. I remember several serious discussions "back in the day" when I ran the WAN for the local school system and tech specialists out in the schools couldn't get something to work so they'd just give full rights to the app directory to get it to work, half the time giving full rights to the entire server. Speaking of making your eyes cross!
I definitely wouldn't add Adminer, the module, requiring PHP unless there's a specific benefit to it. To me that's one of the biggest benefits to TKL, having you guys wade through all that stuff for me. I can set up a server, install Ruby, Redmine & whatever and get it all going. I'm not even a stranger to the command line. But seems like every time PHP or Python or Ruby or Maria or whatever releases their "latest and greatest" all hell breaks loose. LOL I'm not knocking Adminer, but when I've used it in the past it seems like most of that stuff can be done through Webmin and the stuff you couldn't, most of those guys are going to go to the command line and use MYSQL commands directly. I just don't use the command line enough to remember all my commands so I have to do a quick search on how to do that, so Webmin is where it's at for me.
As far as a fix to RM v18, wouldn't the simplest thing for you to do be to just add the adminer user, execute that MYSQL command above and repackage the ISO? Easy peasy..... maybe throw in a note in the readme as to why you're still using that user and then make everything uniform later down the road? But if I understood the whole socket thing, doesn't that cause other issues having the password? If it was me, I'd pick the flat out easiest way to fix it for you guys regardless of any confusion because I know you're still working on finishing up V18 and it's nothing that can't be fixed with a readme or posted on the web in the Learn More > section. If us slow guys can't figure it out with that heads up, I guess you'll just have to help us one at a time. :D
Jeremy, you are DA MAN! Whatever they pay you isn't enough. The amount of time you spend helping folks in the forum seems like a full time job on top of all the coding you do to roll these things out. Your instructions are clear and you're always patient with folks. TKL is the model other vendors should use on how to deal with their end users. I had a math teacher back in high school who would always ask "What do you not understand?" when you said you didn't understand something. If I don't understand, I'm not sure I can answer the question as to what. :) I can't count how many times I've asked what I thought was a legitimate question in a support forum elsewhere only to be berated about reading the manual, that question has been asked and answered, did I do a search for it, etc. My first computer was a Commodore 64, but my first PC was an 8088 processor with 256K (yes K, not MB or GB) RAM running DOS 2.0. As I get older, I realize I get confused more easily and I don't grasp concepts as quickly as I used to but as "they" say, "this is not my first rodeo." If I'm asking a question it's because I've tried to figure things out and for whatever reason I couldn't. All of you at TKL go above and beyond to help folks with their problems without chewing on them as to why they're asking it and it is greatly appreciated. No one or no organization is perfect and I'm sure y'all have a white board somewhere or whatever it is "the kids are using now" to figure out how you can make your product/support/profit or whatever better, but TKL is the mark other companies should be aiming for.... Just sayin'. :)