LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-28-2006, 03:51 PM   #1
sugar2
Member
 
Registered: Feb 2006
Distribution: Debian 40r0
Posts: 103

Rep: Reputation: 15
question before moving from windows2003 to Linux+apache+php+iodbc+FreeTDS


hi, i would like to have opinions or an advice before moving my php pages from a windows 2003 server to a Linux (slackware) box, this is my goal:

To have access to my MSSQL database and my MSACCESS database from web pages (i think php its a good option for the user interface)

My question its the folow: What do you recommend me in order to have performance and security, i know linux its natively more secure than windows, but im not sure if have mssql and msaccess access from linux will compromise the database's server stability, or what if its released a freeTDS (i read it here http://odbcrouter.com/FAQfreetds.shtml) or another php bulnerability hole... im not sure probably i feel like unsure

Thanks in advance.

Aldo
 
Old 06-28-2006, 07:39 PM   #2
JimBass
Senior Member
 
Registered: Oct 2003
Location: New York City
Distribution: Debian Sid 2.6.32
Posts: 2,100

Rep: Reputation: 49
Well to begin with, you have to do some migrating. Linux doesn't do mssql, it does mysql, and it doesn't do access. There are some attempts at drivers to read .mdb files for open office, but most seem to be old and don't allow you to write to an .mdb file, just read from it.

So I would start by copying all your data into mysql databases, and bring those across.

Security is both a property of an OS, but also how it is used. If you allow things to work on your linux system with root permissions, and select craptacular passwords, you aren't that much safer. You'd get past the first round of script kiddies attacks, but when round 2 comes around, and sees you have ssh running and allow root to log in through ssh, you'll be hacked. Yes linux tends to be more secure, but if you don't configure things well, it won't be any safer than windows. Choose good passwords, don't run unneeded services, don't allow root access through ssh, and certainly don't run processes like apache or php with more permissions than they need.

Peace,
JimBass
 
Old 06-28-2006, 07:54 PM   #3
sugar2
Member
 
Registered: Feb 2006
Distribution: Debian 40r0
Posts: 103

Original Poster
Rep: Reputation: 15
well, i think linux can do mssql using this combo: apache+php+iodbc+FreeTDS (as says the title of this post)
That combo can handle mssql, and mssql can handle msaccess by itself with OPENROWSET and OPENQUERY.
There are more methods, you can have UnixODBC+MSSQL_drivers, or you can have "ODBC ROUTER"+LinuxDriver....

I cannot move my data to other plattaform just because my headquarter sofware its MSsql based.

Last edited by sugar2; 06-28-2006 at 07:56 PM.
 
Old 06-29-2006, 03:59 AM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
I think he meant you can't run MS SQLServer on Linux, but there's no reason you can't run it on another box and access it from the Linux box.
Similarly Access, although I'd only use that for the client.
 
Old 06-29-2006, 12:41 PM   #5
sugar2
Member
 
Registered: Feb 2006
Distribution: Debian 40r0
Posts: 103

Original Poster
Rep: Reputation: 15
well, excuseme for my misstyping, what i waht to have its a webserver client for the mssql server, and at this point im not sure if choose a windows or a linux box for having the webserver as a client of mssql and msaccess (wich are in 2 separated machines).
In your opinion what can be more handle to maintain secure and in a good performance?
The linux or the windows box? (having in mind that linux machine has envolved many open sofware wich can be more bulnerable but there are many patches too..). Im a newby and im not sure at this point.

Thanks again.

Last edited by sugar2; 06-29-2006 at 12:59 PM.
 
Old 06-29-2006, 10:34 PM   #6
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
So I think you mean normal desktop clients that pt to Linux-Webserver, with MS SQL & Access servers behind the webserver?
 
Old 06-30-2006, 01:00 PM   #7
sugar2
Member
 
Registered: Feb 2006
Distribution: Debian 40r0
Posts: 103

Original Poster
Rep: Reputation: 15
yes i do...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
this combo: php on a windows2003 + ms access on a samba share sugar2 Linux - Software 8 05-23-2006 02:24 PM
freetds to access SQL server from linux client sailu_mvn Linux - Software 2 12-06-2005 11:19 PM
Convert Windows2003 ftp server to linux platform with user and password hitesh187 Linux - Networking 1 03-07-2005 07:50 AM
Apache Qs: Moving Document Root and PHP with Apache2 larsenmtl Linux - Networking 3 09-29-2004 09:31 AM
freetds-perl-linux-m$sql hrc Linux - Software 0 03-08-2004 09:35 AM


All times are GMT -5. The time now is 06:31 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration