Welcome, Guest. Please login or register.

Author Topic: Installing mSQL version 2.0.10.1 (found on aminet)  (Read 3650 times)

Description:

0 Members and 1 Guest are viewing this topic.

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« on: September 30, 2009, 06:42:48 PM »
Quote from: sim085;524363
Is there a way to remove the assign after I do it? Also is there some place I can find all these command?

Are you sure you're really a cult member? :roflmao:

Sorry, that was perhaps a bit rude :)

Anyways, yes, you can remove assigns "assign msql: remove" for example (or just "assign msql:")
In general you can type "command ?" (followed by enter) to see what flags/options they support, and then just continue to type them in, maybe press "?" and enter again etc. till you're done. Properly written commands also accept ctrl-C (and enter) at the ?-prompt to break the command before it's even really run.
« Last Edit: September 30, 2009, 06:54:19 PM by kolla »
B5D6A1D019D5D45BCC56F4782AC220D8B3E2A6CC
---
A3000/060CSPPC+CVPPC/128MB + 256MB BigRAM/Deneb USB
A4000/CS060/Mediator4000Di/Voodoo5/128MB
A1200/Blz1260/IndyAGA/192MB
A1200/Blz1260/64MB
A1200/Blz1230III/32MB
A1200/ACA1221
A600/V600v2/Subway USB
A600/Apollo630/32MB
A600/A6095
CD32/SX32/32MB/Plipbox
CD32/TF328
A500/V500v2
A500/MTec520
CDTV
MiSTer, MiST, FleaFPGAs and original Minimig
Peg1, SAM440 and Mac minis with MorphOS
 

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #1 on: October 01, 2009, 05:27:39 PM »
Quote from: TheMagicM;524409
uhh.. create a database directly in mySQL instead of using mysql admin.

This thread is not about mySQL, but about its distant "father", mSQL ("miniSQL" iirc). mySQL started off as a set of patches against mSQL (again, iirc).
B5D6A1D019D5D45BCC56F4782AC220D8B3E2A6CC
---
A3000/060CSPPC+CVPPC/128MB + 256MB BigRAM/Deneb USB
A4000/CS060/Mediator4000Di/Voodoo5/128MB
A1200/Blz1260/IndyAGA/192MB
A1200/Blz1260/64MB
A1200/Blz1230III/32MB
A1200/ACA1221
A600/V600v2/Subway USB
A600/Apollo630/32MB
A600/A6095
CD32/SX32/32MB/Plipbox
CD32/TF328
A500/V500v2
A500/MTec520
CDTV
MiSTer, MiST, FleaFPGAs and original Minimig
Peg1, SAM440 and Mac minis with MorphOS
 

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #2 on: October 05, 2009, 11:35:17 PM »
Well, there is sort of, if you have a tcp-stack it will have a user database, also Envoy operated with user and groups, and even the amiga fast filesystem supports user and group flags.

But, first... try to just set a variabel USER to the username you want to use, for example in the shell "set USER blabla", you can see what USER is already by typing "echo $USER", or "get USER", or just type "set" to see all local shell variables and their content.

Notice that variables you set with the "set" command only exists within the shell they are set, if you want system wide variables you can use the command "setenv" instead, the resulting variable will be stored as a file in ENV:. For example "setenv USER blabla" will create the file ENV:USER which will contain "blabla", and if you then open a different  shell and type "echo $USER" there, it will say "blabla".

Sometimes you even want such variables to survive boot, so you just copy them over to ENVARC: which normally is pointing to SYS:Prefs/Env-Archive. You do so simply with a "copy env:USER envarc:", newer setenv commands even have a "save" option that will create a variable and save it to envarc: in one go. With these global variables you can also use the command "getenv", f.ex "getent USER", and just running "setenv" will list out all global variables, but not their content (mostly because env:/envarc: is also used for system/program prefs as well).

If you havent already, you should get SnoopDOS from aminet to help you find out what mSQL is trying to do, what variables it looks for etc. :)
B5D6A1D019D5D45BCC56F4782AC220D8B3E2A6CC
---
A3000/060CSPPC+CVPPC/128MB + 256MB BigRAM/Deneb USB
A4000/CS060/Mediator4000Di/Voodoo5/128MB
A1200/Blz1260/IndyAGA/192MB
A1200/Blz1260/64MB
A1200/Blz1230III/32MB
A1200/ACA1221
A600/V600v2/Subway USB
A600/Apollo630/32MB
A600/A6095
CD32/SX32/32MB/Plipbox
CD32/TF328
A500/V500v2
A500/MTec520
CDTV
MiSTer, MiST, FleaFPGAs and original Minimig
Peg1, SAM440 and Mac minis with MorphOS
 

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #3 on: October 06, 2009, 11:29:50 PM »
Hm, tricky one.

Back the days it was quite common to installed "MUFS", or MultiUser File  System, which is a patch to the OS3.1 FastFileSystem that ads user/group rights (pluss some more), it can very well be that mSQL requires this.

Installing MUFS is not exactly a walk in the park, and if you wan to try it out, it makes sense to try it on a seperate partition. There are also an update to it and also a patch for newer FFS from OS3.5 and 3.9.

In addition to MUFS, the was also the far more official Envoy package that also had multiuser abilities. Both, I think, came with the commands SetOwner and SetGroup.
B5D6A1D019D5D45BCC56F4782AC220D8B3E2A6CC
---
A3000/060CSPPC+CVPPC/128MB + 256MB BigRAM/Deneb USB
A4000/CS060/Mediator4000Di/Voodoo5/128MB
A1200/Blz1260/IndyAGA/192MB
A1200/Blz1260/64MB
A1200/Blz1230III/32MB
A1200/ACA1221
A600/V600v2/Subway USB
A600/Apollo630/32MB
A600/A6095
CD32/SX32/32MB/Plipbox
CD32/TF328
A500/V500v2
A500/MTec520
CDTV
MiSTer, MiST, FleaFPGAs and original Minimig
Peg1, SAM440 and Mac minis with MorphOS