I need CentOS to communicate with an MS SQL Server 2000.I have installed FreeTDS and PHP and the following work:TSQL (using and selecting from the SQL Server)PHP from Shell (running a script from the shell)
View 5 RepliesCan we get this built into the distribution? This would really set it apart from other distributions that don't have this included. And it would most likely make a lot of PHP developer lives a bit easier.
View 7 Replies View RelatedI'm attempting to get freetds and sybase up and running on my centos server, mainly for nagios - MSSQL checks. I've installed freetds freetds-devel ok but am having issues getting SYBASE installed. I've had a go via cpan but get a failure on the sybase environment variable. I've set it to /etc where the conf file is located as well as trying /urr/lib64 for the tds libs, but no joy. Has anyone had much luck with this on centos?
export SYBASE=/etc
[root@nagios ~]# echo $SYBASE
/etc
cpan DBD::Sybase
CPAN: Storable loaded ok (v2.15)
[Code]...
I am working on a project where I need to connect to a remote MS SQL Server database with PHP from a CentOS 5.5 server. I was able to get it installed and working on my Mac OS X 10.6 laptop with unixODBC and FreeTDS. However, I am unable to get it configured on my CentOS server. unixODBC and FreeTDS were installed, but when I try to connect, I get the following error message:
Connection Failed:[unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: wrong ELF class: ELFCLASS32
From what I could find by scouring the internets,it appears that I have 32 bit unixODBC (or FreeTDS, I'm not sure) installed (libtdsodbc.so.0 is symlinked to libtdsodbc.so.0.0.0) and it needs to be 64 bit. However, when I try to install the 64 bit version with
yum install freetds.x86_64
I get a message that it is already installed.Is there something else I need to do to get around this error? I'm a developer and not a server, so I'm not sure where else to go.
On my LAMP server (recently installed, latest CentOS) i want to use php-mssql to connect to a remote MSSQL server. Therefore i need php-mssql. If i run "yum install php-mssql" it tells me "No package php-mssql available.".
On a older installation (2 years old, but up2date) i had no problem installing php-mssql. I cant tell the difference. I've read this tread:
[URL]
Also "yum install --enablerepo=extras php-mssql" didnt helped me.
I just succesfully installed Centos 5.5 64bit with following package:
- httpd 2.2.3-43
- php-mysql 5.1.6-27
- mysql 5.0.77-4
and all these packages are running ok.
My question is how do i connect from Centos to another MSSQL server using PHP? I had read several article but cannot find the best way to achieve this because most of the instruction seems to be quite complicated. I found somewhere in this forum that all it need just this simple command: "yum --enablerepo=extras install php-mssql freetds". While others article said that i need to install "FreeTDS" and some ODBC driver. I'm a little bit curious since most of that article are using an older version of Centos and PHP.
How to add port of MSSQL(1433) to httpd_can_network_connect_db or add some changes in apache policy? I know about httpd_can_network_connect but this is not my way.
View 6 Replies View RelatedU have spent 4 days trying to configure my router thinking that it is my router that is not working but when I go to my dynamic dns or my static ip address it takes me to my admin router on the local computers.when I type httpd it says it cannot bind to port 0.0.0.0:80 i checked it is set up to listen to port 80 this is really confusing me i am beginning to think the people who built my server did not set it up properly if i go to localhost or 0.0.0.127 it goes to the apache default page fine.I have not changed anything since it wad installed except the centos 5 updates any ideas?When i login my password is root and the password is the default I have changed nothing else on the system as I still have no clue about it.Just to clarify on my router I have port 80 and port 443 set to my static ip address is this correct or should it be the eth0 Bcast ip address?Can anyone give me an idea of what i need to check? On my router I have set up port 80 and port 443 and dynamic dns and static ip address.Sorry I am totally new to linux never used it before would be nice if anyone has any ideas how i can proceed with this.
View 1 Replies View RelatedI've installed Apache Tomcat--6 and even jdk1.6.I've even created a tomcat.sh file to start the serverautomatically and it includes the Environment variables also ($CATALINA_HOME & JAVA_HOME) for automatic startup.Next when i'm using http://localhost:8080 to call the server it shows unable to connect.I've tried changing the port no of tomcat in server.xml file. but still its not working.
-->Then i tried using--telnet localhost comand--it shows Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host: Connection refused
Here I'[m stuck i don't understand how do i make the localhost work.
-->If I'm giving telnet localhost 25 the sendmail server is working.But the 80 and 8080 ports are not getting configured.
-->I've tried adding the port and its name in /etc/services file but still its not working.
-->When I'm giving the command--/sbin/chkconfig --list--->Its shows: xinetd based services:
...
...
telnet on.what should i do to get my tomcat server work properly.
I run mysqld on another server. I just switched to another dedicated server now, and i'm having trouble connecting to the mysqld server. If i run the php script from the bash console( php connect.php ) it works perfectly and connects to the mysqld server. However, if i run the script from apache ( http://localhost/connect.php ) it returns this: Can't connect to MySQL server on '(mysqld real ip)' (13) Mysql connection from another server(old httpd server) works perfectly, so it's not from the database server.
View 4 Replies View RelatedThe other day there were a number of updated needed on my server which I installed with yum (the software updater GUI). Now my websites are not coming up even on the server using http://localhost
I reviewed the info and found that httpd was updated to 2.2.3-45 and am suspecting that this is the cause of the issue. So my silly little question is how do I roll back this update?
my company's current server is running on windows... so i want to change it to centos linux.. but my problem is they want mssql running on it..Is it possible to run MSSQL in centos 5?I want to run MySQL and MSSQL in centos 5, both DB.
View 4 Replies View RelatedI am running a quad core centos 5.4 box that is having a strange problem with dovecot. The administration panel is able to send emails through dovecot but not any of the user accounts (ie with webmail). I've done a bit of research with what could be wrong but haven't had any luck so far I am also having a weird problem with apache: on a c++/php bittorrent application I was going to be running on a subdomain of my main site I get a 500 error every time I try to log in. The only way to get rid of the 500 error is to clear the chache (so its horribly broken somehow). The error generated in the log whenever I try to log in is that "ffmpeg is already loaded" (which I am running on the main site and is critical). Is there a way of either repairing my apache install or excluding ffmpeg on the subdomain in the conf or something?
View 2 Replies View RelatedMy freetds.conf
Code:
# /usr/local/etc/freetds.conf
# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
[Code]...
About apache security. How to protect web-server from programms like phpshell [url]?
View 8 Replies View Relatedwhether I should encounter a problem relating to output redirection when using sed from a shell script which is ran by apache? I have given apache privileges in sudoers to run the shell script and the commands within it. However the problem is that when I check auth.log all commands are listed except the sed ones, yet if I run the shell script directly from the command line they work fine and are logged.
So although I realise I probably have some permission issues to solve, I think its strange how sed commands are not being logged at all. would also appreciate any advice on apache and sudoers, am I playing with fire here? Im on lucid 10.04 server
Ok, so I have a few web apps that need to run shell commands. Heres a great example of one:
Code:
This is a PHP script getting my system volume. Herein lies the problem... www-data doesn't have permission to do this!
I changed my apache config to use MY account as the web user, and it does in fact work the way I want it to.
Obviously, I dont want to leave apache running as me, and want it to keep using www-data.... heres my question... how can I give permission for www-data to execute certain programs?
1-Can I have the shell command which allows me to have the number of reques ts/seconds under the Apache server?
2-And the number of sons threads in service/wait?
I am installing Big Brother on a CentOS 5.2 running the default Apache 2.2.3. When I try to access any web page I get the following error: Forbidden You don't have permission to access /bb/ on this server. Apache/2.2.3 (CentOS) Server at fmsubbnix Port 80 So far I have:
1) Set the Directory options to FollowSymLinks
2) Verified all directory and file permissions are at 755
3) Set permissions temporarily to 777 and received same error so I am assuming the issue is in a config file somewhere
4) in hhtpd.conf verified <Files ~ "^.ht"> is correct
5) verified the "default" directory is correct (/var/www/html)
I have read and tried several ideas in posts listed on the web but to no avail and am at a loss as to what to look for next..
I am trying to solve a problem where Apache stats aren't displaying correctly in Munin. I've ran through quite a bit of checks and tests regarding Munin setup, but I think my issue is related to Apache, but my skill set there is lacking.
first, system info:
monitored server:
CentOS 5.3 2.6.18-128.1.1.el5
[code]....
I want to run a linux command with apache through web browser and that's is not working. and it's working properly when I execute this command through terminal, where is the problem?
NOTE: apache have the privileges to execute the command
i opened up my browser to surf the web and a page popped up i had never seen before.Apache 2 Test page powered by centos. Any address i put into my firefox browser won't come up and i'm stuck on this test page and,i can't locate it on my computer to remove it.How do i get rid of it and more importantly how did it get on my computer in the first place?
View 10 Replies View RelatedI am running openSUSE 11.2 and would like to connect to MsSQL using PHP5.3.0 (I do connect to MySQL 5.1.45). Lots of info is available on the Google but nothing on SUSE. I installed "freeTDS" and "PHP5-PDO" objects but am not sure which way to go. Is ODBC another option? speed/functions?
View 9 Replies View RelatedI have been using Suse since version 6, now I installed 11.4 64bit - great distro, but still have no PHP5-MSSQL support. Why is that? FC supports it, why not Suse?
Is there, maybe, a current 64bit PHP5-MSSQL RPM from custom repository?
Workaround: Is there another way (or even different ways?) to connect to MSSQL server from PHP and if yes
1. Am i able to host a MSSQL DB and use it on MySQL?
2. Where is the download link for MySQL server on Linuix (CentOS) as i can't seem to find it for linuix and is it possible to have a gui for MySQL on it if so which program would you recommend?
I am relatively new to the world of linux and PHP. I need to set up my PHP to work with the extension mssql as I have a mssql DB on another server that my websites connects to. I have followed this guide [URL] but get the following error when I run the command isql -v mstest satest satest which is under step 5.
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
It took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies View RelatedI want to import data from MySQL to MSSQL. I've been searching in the web, and I can't find a good and straight answer. How can I do it?
View 2 Replies View RelatedI get this error when running my program under linux; under windows it works as expected:
Code:
$ ./mssql_test
("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
qGetStringData: Error while fetching data ("[FreeTDS][SQL Server]Program type out of range")
QVariant(int, 1) QVariant(QString, "")
I can retrieve int's just fine, but not nvarchar's. I'm using unixODBC 2.2.12 and FreeTDS 0.82. The funny thing is, that I can use isql and tsql with no problem. The mssql_test program:
Code:
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QDateTime>
#include <QDebug>
#include <QVariant>
#include <QStringList>
#include <QSqlRecord> .....
The same error and output continue for the next records. These have cut out. I've been looking for a solution of a couple of days now, with no luck.
I am migrating SugarCRM from windows server to a linux server. But the main problem is the database. How will I import the data from MSSQL of windows to MYSQL of Linux ?
View 5 Replies View Related