Welcome, Guest. Please login or register.

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

Description:

0 Members and 1 Guest are viewing this topic.

Offline sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #14 from previous page: October 01, 2009, 08:10:45 AM »
Quote from: TheMagicM;524409
uhh.. create a database directly in mySQL instead of using mysql admin.  use google to search for tips on how to create using sql.

I know how to create a database using SQL but can't understand how to interact with mSQL from Shell (if that is how it is done). Also tried to read the readme files on Aminet and did not find much there.
« Last Edit: October 05, 2009, 03:29:36 PM by sim085 »
 

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #15 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 sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #16 on: October 05, 2009, 03:27:27 PM »
Does anyone know the command to start msql from CLI?

I tried to start it from CLI but I am getting an error telling me that I have to pass the 'host' and 'configuration'. However I cannot understand what these refer to on an Amiga! I have used PriMan from Aminet to see what is running on startup and Msql does not seem to be running.
« Last Edit: October 05, 2009, 03:30:59 PM by sim085 »
 

Offline sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #17 on: October 05, 2009, 10:39:48 PM »
Ok I managed to get somewhere when I run msql2d from CLI.

The problem is that this is giving me an error "Unknown Username!" and I cannot understand for what username this is refering to. In msql.conf there is a username but as much as I know there is no way in Workbench 3.1 to have users like on a linux system.
 

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #18 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 sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #19 on: October 06, 2009, 12:30:32 PM »
Wow! SnoopDOS is great :D I will do as you suggested and try to find what environment variables mSQL requires and then set them accordingly! However once again SnoopDOS looks like a very nice tool to have on my system :)
 

Offline sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #20 on: October 06, 2009, 05:53:46 PM »
Ok SnoopDog played the trick but I still have some errors to resolve. Basically it seems that msql2d is searching for the file passwd in etc: I have created this file accordingly and the user is now being recognised. However I get the following error;

Error! '/msql/msql2d.pid' is not owned by 'msql'

So my (obvious) next question is; how on Workbench 3.1 I can own a file by a particular user ... considering that these users only exist in the linux world I guess!
« Last Edit: October 06, 2009, 07:00:57 PM by sim085 »
 

Offline kolla

Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #21 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
 

Offline sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #22 on: October 06, 2009, 11:45:52 PM »
Quote from: kolla;524910
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.


I do have that one running mUFS. I downloaded it and installed it because it was listed as required. I can see it running from PriMan. I'll see what I can do with it.
 

Offline sim085Topic starter

  • Hero Member
  • *****
  • Join Date: Aug 2008
  • Posts: 958
    • Show only replies by sim085
Re: Installing mSQL version 2.0.10.1 (found on aminet)
« Reply #23 on: October 07, 2009, 12:20:39 AM »
Quote from: sim085;524913
I do have that one running mUFS. I downloaded it and installed it because it was listed as required. I can see it running from PriMan. I'll see what I can do with it.

Ups. I have mUSD not MultiUser File System. I'll download it and test a bit with it. Thanks a lot for the help :)
« Last Edit: October 07, 2009, 08:16:40 AM by sim085 »