Koozali.org: home of the SME Server

rtu care2002 distr. based on SME

Erik de Wild

rtu care2002 distr. based on SME
« on: May 05, 2003, 05:30:47 AM »
I'm a member of the projectteam of care2002. (see www.care2x.com/foundry/ for an online demoversion and www.care2x for background information) This is an OSI-certified application to support all kind of processes in hospitals and carecenters. It is based on php and MySql.  Care2002 is a critical application when it is used in a hospital and  the security needs are very high.

My idea is to built a ready to use (rtu) care2002 distribution based on SME. The network services not needed to run care2002 should not run or be stripped from the sme-distribution and  care2002 should be part of the installation (html and php files and the MySql databases needed to run care2002 with the users and accesrights needed to go on from there).

I have knowledge about Linux above user level but I don't have the skills to this on my own. If you know how to modify SME in the way I have in mind will you please post a message and give me some direction, hints or point me to usefull info. You are also more then welcome to join this effort.  

With friendly regards


Erik de Wild

Paul

Re: rtu care2002 distr. based on SME
« Reply #1 on: May 05, 2003, 06:50:54 AM »
Your proposed implimentation should be fairly straight forward.  The SME server can be set up a local server with local access only.  E-smith can be set up to be VERY secure.

It appears to work similar to phpBB, a php and mysql based forum.

What versions of apache, php and mysql are required for care2002?

I have a test server that I can use to help and there are plenty of more experienced members to help solve problems.

I have downloaded the zip and tar.gz files of beta 1.0.4 beta.  Is there any difference between the 2 archives?  They seem to have a different number of files in them.

If I can help, drop me an email and let me know.

Paul

Michiel

Re: rtu care2002 distr. based on SME
« Reply #2 on: May 05, 2003, 03:12:34 PM »
I guess the safest way is to install the e-smith-service-control package and to turn off the services you don't need. You could start removing rpm's, tinker with the rc.d files etc, but that might get you into serious problems and is probably not worth the effort. Services that are not started do not pose a security risk and only take a bit of disk space.

Have a look at http://www.e-smith.org/contrib/rpm-index/RPM-e-smith-service-control-1.1.0-01.src.html

regards,
Michiel

Erik de Wild

Re: rtu care2002 distr. based on SME
« Reply #3 on: May 06, 2003, 03:51:17 AM »
Paul,

Thank you for your reaction and the help you offer. I have had contact with the projectleader of care2002 and he also think a rtu-care2002 would be great.

>What versions of apache, php and mysql are required for care2002?

The advise on the care2002 website is to install the most recent stable version of mysql, php and apache. I understand that the latest release of SME is from recent days so I guess that will be OK. I will ask other developers for a more specific answer

>I have a test server that I can use to help and there are plenty of more >experienced members to help solve problems.

Thanks for the offer,  this is more then I hoped for when I post the message. I hope others will join the challenge. I think we first have to make a kind of roadmap for the work to be done and the steps to be taken.

>I have downloaded the zip and tar.gz files of beta 1.0.4 beta. Is there >any difference between the 2 archives? They seem to have a >different number of files in them.

They should be the same. A part of the projectteam is working around the clock to finish the stable version as soon as possible. So maybe the two archives run out of phase at the moment you downloaded them both.  The best idea is to download care2002 from the cvs on sourceforge. If you download the newest version you have to rerun the mysql install scripts to rebuilt the database.

I think Michel (see the second reply) is right  not to strip e-smith because of update problems.  Not starting the services not needed to run care2002 or killing them as part of the startup procedure will do I think.

It would be great if SME is installed and after that an additional script takes care of the installation of care2002. I don't know if it is possible to put ready to use mysql databases with the minimum accesrights and users needed to go on from there on the cd-rom and use the installation script to copy the databases in the proper directory. That would be a real straigforward way of making a rtu care2002 distribution.

Do you think this a good approach. Can you judge the feasibility.
Is it possible to add additional features like an update option for care 2002 or, during installation,a choice between using the care2002 files on the cd or the files of the stable version on the cfs. Will you please give your view of the work to be done and the steps to be taken to make the idea work.

With friendly regards,


Erik de Wild

Paul

Re: rtu care2002 distr. based on SME
« Reply #4 on: May 06, 2003, 04:31:05 AM »
I have been playing with the beta on my test server today.  Got the whole thing installed and the database scripts run but encountered an error in the PHP scripts.  I am making sure that Apache is configured to run PHP as CGI at the moment.  This might have something to do with it.

The phpmyadmin program that is built into care2002 is useless because it doesn't have anyway of inputing a username and password to configure MySQL.  It just gives access denied errors because in SME root access with no password in not allowed for security reasons.

I had some trouble getting this far because of how MySQL permissions are set up and the care2002 instructions are quite vague about what exactly the permissions need to be.  It just says "Configure its access properly.  Please refer to the documentation of MySQL" but never elaborates on what permissions it requires.

We need to find out if care2002 will work on a "stock" SME server and then go from there.

My opinion is to Install and upgrade SME and then compile an RPM or install.sh script to simplify installation.

I think the database scripts can also be automated, I'll check on that.

Paul

Paul

Re: rtu care2002 distr. based on SME
« Reply #5 on: May 06, 2003, 06:12:24 AM »
BTW, the tar.gz and the zip files are not the same.  The zip file has 29 more files in it.  Which one is correct?

The tar.gz file also has some crc errors in it.

Paul

Erik de Wild

Re: rtu care2002 distr. based on SME
« Reply #6 on: May 08, 2003, 04:32:50 AM »
They both (tar.gz and zip) should work. My suggestion is to try the .zip file. Be aware of the fact that the program is stil in progress so you might find some bugs. The problems you face are probably caused by the extremely safety precoutions of sme. That's just what the we are looking for but will give innitianal challanges that has to be solved. mysqladmin.php will has to be installed separately from care2002 because the standard runs under "root' wich is not allowed under sme.  

I hope some of the forum members, especially paul,  will help me and the care2002 team with the effort to built a rtu (ready to use) sme based care 20002 distriubion.

with friendly regards,


Erik de Wild