CentOS 5 :: FreeTDS Error Connecting To Remote SQL Server Db?
Nov 21, 2010
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.
View 1 Replies
ADVERTISEMENT
Mar 9, 2010
I'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]...
View 3 Replies
View Related
Sep 8, 2009
I follow instruction on how to install ISPConfig2 in CentOS 5.3. CentOS 5.3 ISPConfig 2 At part 10. MySQL(5.0), I stuck with an error. Said that "Host is not allowed to connect to this MySQL server. What is the problem? Why not allowed?
View 1 Replies
View Related
Jan 12, 2010
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 Related
Jun 7, 2010
I am fresh out the box to linux I am using mysql for the 1st time also, my question is what is the correct command to run on a mysql command line to connect to remote server.
View 5 Replies
View Related
Feb 13, 2011
I am not able to connect to remote server through secureCRT . my local team has said that server is working fine . but I am not able to connect it remotely . what more i can do to connect it to server
View 10 Replies
View Related
Aug 8, 2011
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 2 Replies
View Related
Mar 1, 2010
I'm using Postgresql 8.4.2-2. I'm trying to remote into my server securely. I figure I could do so with ssh. Apparently I figured correctly, as per, [URL] and [URL] I setup the ssh tunnel. ssh -L 5432:serverip:5432 Then I setup pgadmin3 to connect as follows:
host: localhost
port: 5432
user: postgres
maintenance db: postgres
And I receive the following error:
An error has occurred: Quote: An error has occurred: Error connecting to the server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
I'm not sure what the problem is. I can connect with Code: psql from the cli after connecting to the terminal via ssh. So I know that I'm using the correct password.
View 3 Replies
View Related
Dec 20, 2009
I'm still learning my way around CentOS and linux in general... Using CentOS 5.4
BUT, I used the scripts from HowTo/Chroot Vsftpd and it did not work with the non-TLS script config, but the with TSL worked great. I wasn't sure where to put the vsftpd_virtualuser_config.tpl file but I copied it over when the script failed to find it... to where it was looking.
So I think it's working but my question is, TLS doesn't use port 21 but the script defaults to that port. I'm using FileZilla from an XP machine at work and I'm forwarding all the ports given in the HowTo. So I'm forcing the client to use TLS on port 21 but it hangs on the connection. If I use non TLS I get in but it tells me it requires TSL. I've had no luck with vsftpd in the past and this is my next attempt.
Quote:anon_world_readable_only=NO
anonymous_enable=NO
chroot_local_user=YES
guest_enable=NO
[Code]....
View 1 Replies
View Related
Dec 1, 2010
Whenever i try to create a account either then the root and login as it i get a error Access is Denied if though the password is correct.
View 3 Replies
View Related
Sep 3, 2009
I want to use centos as a developer server on my desktop before deploying my stuff to the internet.
I have a netgear DG834G router. It's IP address on my local network is 192.168.0.1 and connected to the adsl line. The router is set up to act as an dhcp server too. On the router I have reserved ip address for the nics per their mac addresses.
My server is on a dual boot desktop. The other boot is XP and works fine, picks up dhcp.
I don't know how to connect Centos to the router.
I have tried to play with the network manager but to no avail.
I can ping localhost, interface eth0 is there, but i can't ping to the router.
I have set the manager system/administration/network to get dhcp automatically.
I can't activate the eth0 although the hardware device says it is OK.
I've looked at firewall and iptalbes.
View 2 Replies
View Related
Jul 29, 2010
I'm currently in the last steps of migrating a CentOS mailserver to the x64 version.However, under the old 32 bit version, I was using XRDP to access the Centos box from my Windows boxes.However I can't seem to find the XRDP package in the standard repos so this is prompting me to look at possible alternatives (XRDP was incompatible with my windows 7 box anyway soI had to RDP to another server of ours running 2003 to RDP into the mailserver which was far from ideal).Basically, I'd like to be able to seamlessly access the Centos box with a standard RDP client.
I know VNC Server/Clients would be an option but RDP gives me the freedom of any windows box being able to access the server on the same adress/port without installing software on any windows box I encounter.Are there any viable alternatives to XRDP ?There's no "add-on" to VNC server that could enable it to accept RDP connections ?
View 5 Replies
View Related
May 4, 2009
I have just installed CentOS 5. I have set mysql database to access from remote machines. But now the problem is it is not connecting from the local machine now.
View 5 Replies
View Related
Dec 11, 2010
installed mySQL-server on the Ubuntu and configured it(i've made this lots of times). After that I installed mySQL-Admin and connected successfuly to the server. Tried some queries and worked fine. So, then I opened tcp 3306 for incoming and outgoing from anywhare. Went to my XP station and install mysql odbc driver, allowed tcp 3306 and tried to connect but I got an error 10061. So I decided to telnet my server with 3306 port and I got "connection failed".
View 2 Replies
View Related
Oct 25, 2010
Im using CentOs on a remote server. I've recently installed phpmyadmin but cant access from [URL] I checked the files and found only 3 folders in /var/lib/phpmyadmin -config / save / upload - all of them empty. Whenever I try intstall phpmyadmin again it just says its already installed and up to day.
View 2 Replies
View Related
Jun 15, 2010
How to setup my server to use it remotely from my Home from a WindowsXP PC.I want to access my CentOS server. Please help me installing GUI or Remote desktop on my server.I have installed FREENX client on my WIndows XP PC now what next to do. what configuration do i need to do.If you have any link to tutorial please let me know.
View 3 Replies
View Related
Jan 24, 2011
I recently bought a VPS with CentOS installed, 512 MB RAM and 80 GB ram, but I have a problem, I want to get VNC Desktop with it but I couldn't.
I installed KDE, GNOME but no one works.
This is my log from vncserver:
Code:
Code:
PC Specs:
OS: CentOS 5.5 32bit
RAM: 512 MB
HDD: 80 GB
Company: VPS-Hosting.ca
100mbps Connection.
View 1 Replies
View Related
Jun 13, 2009
I setup mysql v5 on centos, follow all the instruction i was able to google for to enable remote access, I am able to log in to -h localhost and -h (external IP address) from same server, I am able to telnet to 3306 using localhost and external ip address, BUT when I try to connect from deferent server i get host unreachable error H3000 (113) and telnet also is not able to connect via port 3306 I covered all the bases but stii no luck. same setup works for slackware no problem and there is no issue with client.
View 1 Replies
View Related
Jul 13, 2010
I'm having a bizarre problem with FTP transfers from my CentOS 5.3 boxes, All of my CentOS boxes appear to be limited at ~10kb/s when connecting to any FTP server outside of our network. We have no network infrastructure which would cause this, however when I use a windows based machine it is able to connect fine.
I took my laptop running Vista, and rebooted it onto a CentOS 5.3 LiveCD, and same issue.
I have checked our iptables, cleared the rules, removed the kernel modules, checked CBQ/TC it looks like nothing is limiting this. Also, other protocols work fine. Both the windows and linux boxes used passive transfers for it.
Is there anything other than iptables/CBQ which would be on a out of the box install of CentOS I should check? Is there any kernel settings for NAT connections which may cause this?
View 5 Replies
View Related
Sep 25, 2010
I have a white slate centos 5.5 installation on a virtual box at Media Temple (one of their new VE servers). I am trying to create a development environment where I can have Bind9 serve up one set of zone files to me and other developers on the internal network and another set of zone files to external requests (ie... using the views feature). I would like to be able to develop for sites for which the dns is not yet pointed at my server. The network is created by having the VE server be an OpenVPN server, and connecting my client box to the server (my mac - 10.8.0.6 / my ve server 10.8.0.1).
I have the connections working fine, I have also been able to route all network traffic from my mac through the vpn to the server. For some reason, I cannot get the DNS server on the ve server to serve me an internal view zone file. When my vpn is on, I cannot ping or navigate to any web pages from my mac. I think this is because my ve server is not setup as a dhcp server and the ip tables are not setup to allow all internal requests to use the server to go get web pages.
I cannot view-ping anything else from my mac/client when on the vpn, I can successfully ping any website my ve is authoritative for. This tells me that my ping is obviously going over the vpn, and thus an internal request, but the external zone file is still served up. The following is my named config.
acl "lan_hosts" {
10.8.0.0/24;
127.0.0.1;
};
[code]....
View 3 Replies
View Related
Jul 28, 2011
I have a lot of problems with the server and I want to reinstall the Centos in order to have a clean system. The problem is that I have access only via ssh console (with putty aplication)
View 1 Replies
View Related
Jun 9, 2009
I have minor problem. I am used to windows and netware environments. New to CentOS.
How do I remotely access the server for administration with a Graphical interface similar to Remote desktop in windows..
"Start-> Run -> MSTSC"
View 19 Replies
View Related
Sep 14, 2011
I have installed CENTOS 5.0 .. IM new to this centos linux..
-->regarding the remote connection
how can i connect the server through remote from windows 7 ..graphical interface ?
how to install lamp or apache , php , mysql
can u guys provide me any link or book for as a beginner for centos ?.
View 3 Replies
View Related
Dec 29, 2010
I have been using Ubuntu for almost one year or so. I use to have a good experience with it. But, since last few days I have been experiencing something nuance with my Ubuntu and most particularly the Exaile player. It use to connect to the Shoutcast server fine. But, these days I can't connect it. Everytime I try to connect it; it shows the message, "Error connecting shoutcast server". I have tried reinstalling it along with the normal plugins that use to work fine. But nothing seems working.
View 7 Replies
View Related
Mar 17, 2009
I'm an OS X user that's just acquired a CentOS 5.2 server. The server contains a basic installation of CentOS 5.2 with OpenSSH already installed, which I use to connect to the server using OS X terminal. I have no physical access to the machine and if I somehow cripple OpenSSH I will need to pay a technician to fix the problem for me. So I'd like to get the instructions straight before I go in and mess around with the system.
I want to install a package that will allow me to add additional users so that they can upload files but not mess around with the system configuration. From searching on google rssh seems to be a viable path. So I'd like to go with that unless there's a better option.
I came across these tutorials: SFTP Setup for CentOS 4.5-5.x and How to: Restrict Users to SFTP and Block SSH Shell Access with rssh. But I haven't followed the instructions in either yet. I'm unsure if I'll be able to execute all of the steps remotely without compromising my root account's SSH access.
View 5 Replies
View Related
Jul 14, 2009
Newbie on the block with Centos 5.3 on a test server and and Ubuntu on a test workstation Note the wiki on VNC for a windows workstation but presume I could do this more easily from "Jaunty" (Ubuntu v 9.04)
View 10 Replies
View Related
Nov 4, 2009
I have a remote CentOS server (5.4 Final) to which I need to add remote access to a GUI front end. I have SSH access to this box (no physical access, I rent it and it is housed in a DC) and I think I have managed to install Gnome correctly:
[root@box ~]# yum grouplist
[snip]
Installed Groups:
[snip]
[Code]....
View 3 Replies
View Related
Sep 28, 2010
I have a cent 5.5 server that I only have remote access to. I was wondering if there was a way to view potential updates before I issue the yum update command. I know that there is a notification in X that you can click on and will show you the updates before you actually perform the operation.
View 2 Replies
View Related
Apr 11, 2010
To configure webmail in linux5, I�ve followed below procedures:
-Squirrelmail-1.4.2.tar.gz and unzipped under the folder /var/www/html
-cd squirrelmail-1.4.2
-cd config
-within this directory, ./conf.pl
-From main menu, I did choose 2 for domain (i.e. arafapparels.com). This is my official domain
-Then save and exit
-For IMAP setting, I did choose D
-Selected uw and save, then exit
-Then from command line, I wrote chown �R apache.apache /var/www/html/data (I created folder data in the above path)
-I created a folder named as attach to keep attachment in /var/www/html i.e. /var/www/html/attach
-Then typed grep �R apache /var/www/html/attach
-Then typed chmod 730 /var/www/html/mail/attach (Here squirrelmail-1.4.2 directory has been moved to mail directory)
-Then from web browser/Internet explorer, I typed http://localhost/mail/
-Here Username & Password appears. Previously I have created username.
-But when put Username & Password, below error message displays
Error connecting to IMAP server: localhost
13: Permission denied
But I gave permission by chmod 777 /var/www/html/mail and by using 555 but no result.
View 2 Replies
View Related
Feb 11, 2009
I'm trying to connect with my server via telnet, but when i sent the command (telnet xxx.xxx.xxx.xxx Port) doesn't works and shows then follow error: Unable to connect to remote host: Connection refused, It happens with any port. Is strange but my telnet services works (telnet xxx.xxx.xxx.xxx), In addition, i tried with firewall enabled and disabled and the problem still happens. My centOS run on virtualbox.
View 3 Replies
View Related
