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
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.
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 Replies View Relatedmy 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 RelatedCan anyone here point me to a walk-through or discussion of how to use Webmin to set up port forwarding/NAT on a dual-NIC Centos 5.3 box? The layout will be simple:
Internet --- NIC1 [CentOS Box] NIC2 --- Switch to other PCs
We have a BUNCH of exposed services that are on special ports -- for example, to connect to one machine, you go in with [IP_Address]:12000, and to connect to another, [IP_Address]:12002, etc., etc. We're currently using OpenSuse 10.3 on this box, and YaST makes this criminally easy (you give it the incoming port number and the destination IP/port numbers and it just works). But OpenSuse 10.3 is nearing EOL, we're buying a new machine, and I'd like to use CentOS on the new one.
I've read the sparse Webmin documentation in their Wiki, and it leads one to believe that you simply insert a "NAT" rule. But there's obviously something they're leaving out. I *am* opening the ports in the firewall. But when I log in to [IP_Address]:port, it just times out. The port forwarding never occurs. The test in this case is SSH, and I know that SSHD is working properly because I can log into that machine just fine from another PC on the same internal subnet.
i am not able to port 8080 on my CentOS VPS server.I have followed all the instuctions as mentioned on iptables wiki page.Also I am able to telnet my ip address and port number, But can not access from browser.
View 6 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
Pl can anyone guide me to connect centos 5.5 using ethernet port to ADSL Broadband modem which is configured in PPPoe mode?
View 19 Replies View Related1. 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
Can 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 RelatedIt 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.
we are going to install ASTERISK remotely, hence the port 22 in the server has to be open ,Can somebody reply me with exact commands?I tried these commands and got these results
Command : cat /etc/services | grep xxx
Result : No Such file or directory
Command :netstat -nan | grep 22
[code]....
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 RelatedI want to do a simple port redirect, i.e. whatever comes trough whatever interface on port AAAA will get redirected to port BBBBI thought that iptables -t nat -I PREROUTING --source 0/0 --destination 0/0 -p tcp --dport AAAA -j REDIRECT --to-ports BBBBhowever it doesn't work, e.g. nc -v -w2 -z localhost AAAA gives:
nc: connect to localhost port AAAA (tcp) failed: Connection refused
while
nc -v -w2 -z localhost BBBB
[code]....
Does anyone have a simple to use bash script or some such that will convert MSSQL dump files to MySQL formatted dump files?
View 6 Replies View RelatedI have a mail server i need it to send message via port 587 not port 25, i make some changes to my postfix server which i use and it is already successed making a telnet to 587 port like it :
[Code]....
On our server port 25 is open for sending email. I want to open port 587 too in our firewall.If I have open tow ports 25 and 587 for out going email it is not going to make any problem? my server is Centos 5 I am using webmin to access to our server.
View 1 Replies View RelatedI did local apache server at internal ip 192.168.1.2 and i wanna to do port forwarding to enter to it by my external ip address ?
View 4 Replies View RelatedI go in using nano /etc/ssh/sshd_config I change the port number.. I then restart ssh service restart.. I then run netstat -tupln and it still shows ssh as port 22!i am not sure what I am doing that is incorrect.Do I have to remove the # < ? I go to redit it and its still showing 2222 nano /etc/ssh/sshd_config ?
View 18 Replies View RelatedThe /dev directory on my system shows the following entries:
/dev/tty
/dev/tty0
/dev/tty1
[code]....
I would like to be able to ssh to a TCP port on my server and be directly connected to the serial port @ 115200 Null modem config. Does any body know how one can do this?
View 4 Replies View RelatedI keep getting this email
httpd failed @ Sat Mar 13 15:26:03 2010. A restart was attempted automagically. Service Check Method: [tcp connect]
Failure Reason: Unable to connect to port 80
Is there anyone who know why this would Happen?
My config :
Dell PowerEdge 2900III
16Gb RAM
2 arrays RAID1 (2*(2*500Gb))
CentOS5.5
VMWare 2.0.2 (with workaround of downgrade glibc to CentOS5.3)
Since the upgrade from CentOS5.4 to CentOS5.5, it seems the sshd is crashing every other day.I can access to the VMWare webserver, but no way to connect through ssh port 22.The only "workaround" is a hard reboot of the server, and with luck, I can access to the server through ssh.I checked /var/log/secure, it looks like time to time when the server start, it does not start the sshd service, there is no entry at all for the time the server started up. For instance today, the server has been started early this morning, but the first entry was found after a hard reboot this evening : Jun 3 18:19:14 hercules sshd[3617]: Server listening on 0.0.0.0 port 22.
I am new to Linux, moreso to CentOS, but I can definitely follow walk-throughs and tutorials easily enough.
I am installing a webserver for our small business and decided to go the postfix/dovecot route.
I installed everything based on the walkthrough on linuxmailcom and eve put squirrelmail on top, so users can access via webmail. I am able to send mail just fine, users/folders are setup and working as they should for sending, but I am unable to receive any mail. MX records have been updated to direct mail @mydomain to this mailserver machine. The problem I am having is with port 25... If I do 'telnet x.x.x.x 25' I get no response, just a timeout then back to command prompt. My other ports are fine, and I get the banner for each 110, 143, etc... all ports but 25 work internally and externally, forwarded.
I tried turning off firewall rules, and still, nothing from port 25. Should I try to have postfix listen on another port by editing its' master.cf, or is this is problem with my centOS/Linux instead. I didn't know where to go with this, so I thought the best place to start was here.
I have reinstalled CentOS 5.5 on my un-managed VPS. Everything is fine except port 80
I am trying to access IP address in Internet Explorer but seems port 80 is not accessible.
I have checked by changing Listen 80 to Listen 90 in httpd.conf
and accessed the ipaddress with port 90 i.e. 208.89.213.70:90 and apache page was displayed
I need help on how to resolve this issue
