Amiga.org
Amiga computer related discussion => Amiga Software Issues and Discussion => Topic started by: sim085 on September 30, 2009, 11:50:10 AM
-
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
-
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?
-
Is there an assign set up for mSQL:? It might want one of those.
-
Is there an assign set up for mSQL:? It might want one of those.
How do you do that?
-
Assign: Amiga Shell command that allow to create logical names for drives or directory.
Example: assign FONTS: wb3.1:fonts
Generally used at CLI.
-
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?
-
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.
-
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.
-
Rebooting your machine would also undo the assign, they aren't persistent unless you put them in your startup-sequence.
-
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!
-
The startup-sequence file is in S:
You can edit it with ed.
-
The startup-sequence file is in S:
You can edit it with ed.
Thanks :) I found it in user-startup file.
-
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?
-
uhh.. create a database directly in mySQL instead of using mysql admin. use google to search for tips on how to create using sql.
-
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.
-
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).
-
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.
-
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.
-
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. :)
-
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 :)
-
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!
-
Hm, tricky one.
Back the days it was quite common to installed "MUFS", or MultiUser File System (http://aminet.net/package/util/misc/MultiUser18bin), 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 (http://aminet.net/package/util/misc/MultiUserFix) 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.
-
Hm, tricky one.
Back the days it was quite common to installed "MUFS", or MultiUser File System (http://aminet.net/package/util/misc/MultiUser18bin), 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 (http://aminet.net/package/util/misc/MultiUserFix) 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.
-
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 :)