Installing mSQL version 2.0.10.1 (found on aminet)

[sim085]

Hi

I have installed mSQL and mSQL-administrator. However when I run the latter I get the following error:

"Could not find cando.library"

Does anyone know why I am getting this error? From where I can get cando.library and where I have to put it?

Regards,
Sim085

[sim085]

Ok, I managed to make it work. However when I try to create a new database the admin tools gives me an error telling me:

"Could not found >>msqladmin<Executable belongs to >> mSQL:bin<
Does anyone know what this means?

[sim085]

Is there an assign set up for mSQL:? It might want one of those.

How do you do that?

[sim085]

Example: assign FONTS: wb3.1:fonts  

Is there a way to remove the assign after I do it? Also is there some place I can find all these command?

[sim085]

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.

Well for sure I am learning to become one Thanks for the help. I can't get the thing working and do not wish to leave unwanted stuff on my environment.

[sim085]

Rebooting your machine would also undo the assign, they aren't persistent unless you put them in your startup-sequence.

... and where is that? I am asking because when booting I am getting an error so I think the installer might have edited that!

[sim085]

The startup-sequence file is in S:

You can edit it with ed.

Thanks I found it in user-startup file.

[sim085]

I managed to make things work. However still have problems to manage the msql database from the administration tool.

Each time I am trying to create a new database (or do any other action) I get an error that the administration tool is not connected to the database!

I was thinking to try and use the database from the command line interface. Does anyone has experience on this and therefore knows how this is done?

[sim085]

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.

[sim085]

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.

[sim085]

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.

[sim085]

Wow! SnoopDOS is great 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

[sim085]

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!

[sim085]

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.

[sim085]

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