I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client.Okay my set up looks like thisOn the server /etc/odbc.ini is[MySQL-scopus2008]Description = MySQL citation databaseDriver = MySQLServer = localhostDatabase = scopus2008Por
View 4 Replieswhat is the correct command on a mysql command line to alllow mysql to alllow remote connection on a server
View 1 Replies View RelatedWe have 2 servers, 1 is the webserver and the other is the Mysql server.
When transfering a 2GB file from the webserver to the Mysql server.
The webserver's connection to the mysql DB server dies completely.
Need to restart the MYSQL process in order for it to come back online.
During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.
I have cpanel running and working with mysql. I need to add ODBC so I can get server side action script to connect to mysql also. Will adding ODBC affect anything else? I don't want to affect the way anything else connects?
View 1 Replies View RelatedI use ubuntu lucid lynx, LAMP (mysql 5.1 and last php) and tried to install the package from mysql web page (mysql-connector-odbc-5.1.7-linux-glibc2.3-x86-32bit.tar.gz) through alien. Terminal output is as follows:p { margin-bottom: 0.21cm; }
sudo alien -d -c -k -i mysql-connector-odbc-5.1.7-linux-glibc2.3-x86-32bit.tar
dpkg --no-force-overwrite -i mysql-connector-odbc_5.1.7-1_all.deb
(Lendo banco de dados ... 147517 arquivos e diretios atualmente instalados).
[code]....
My desktop is running 'buntu 9.10 and I have recently aquired a couple of half decent servers running Windows server 2003. I have a few windows app's that I use regularly for work that I have had limited success in running with wine or in vm's. I stumbled upon a how to to call apps in a vm to run seamlessly on the host desktop and did some playing and have succeeded in calling app's on my servers from my 'buntu desktop, the command I have set in my launcher for one of them (DIALux)
My question is, can I change the default application/file association in 'buntu with a custom command so I can double click on a file and have it open in one of these remote app's??If I can, what is the correct custom command to be using as using the above doesn't work at all, it just tries to open the file with rdesktop not the remote app.
Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
View 1 Replies View RelatedI would like to connect to a separate mysql server, yet I can't find any documentation on how to do this.How would one achieve this? I am running qmail on centos4.
View 3 Replies View RelatedI 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 Relatedi want to know how to configure my sql server and clients in debian 5. what should be the server host name and root password
View 1 Replies View RelatedIn linuix how is it possible to access obdc? and how am i able to create new odbc links?
View 5 Replies View RelatedI'm using slackware 13.1 and I have a problem to accept remote access to mysql server.The steps I have followed to do that thing are:vi /etc/my.cnfline skip-networking is commented
bind-address my_ipaddressI opened the port 3306 of my firewallAlthough I can connect locally, i.e. mysql -u a_user -h localhost -pI can't do it remotely i.e. mysql -u same_user -h my_ipaddress -pI have also turned off my firewall, but nothing.telent 3306 my_ipaddress results in: telnet: connect to address my_ipaddress: Connection refusedMy my.cnf file is:
Code:
[client]
port= 3306
[code]....
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
View 3 Replies View RelatedI must connect my apache server to a SQL Server 2008 and use the native instructions (mssql_connect)...in ubuntu this is provided by php5-sybase but in centos this rpm does't exists. How I can connect to SQL Server? I must compile php from source? Is There a way to use the freetds driver?
View 1 Replies View RelatedI have recently installed centos 5.6an app i have needs to run php 5.3 so i upgraded by adding a repo and using yum install php53*a php -v gives me this.PHP 5.3.3 (cli) (built: Mar 30 2011 13:51:41) Copyright (c) 1997-2010 The PHP GroupZend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologiesi also need mysql 5.1 so i picked a repo that had the 5.1 version of mysql in it and um install mysql*which gives me this.[root@localhost var]# mysql -Vmysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (i686) using readline 5.1and then tri to run my app and it failsthe only difference i see between the server that is current working and the new one is in the phpinfo file.in the mysql section of the working one it says Client API version. 5.1.xin the new server install it says the following which is still point to the client api or 5.0
mysql
MySQL Supportenabled
Active Persistent Links 0
[code]....
I am trying to push some data from LINUX system to SQL Server using perl scripts. To do this I need ODBC SQL Driver for linux system. Right now I am using easysoft ODBC driver. But it is trail version. Do any one have a idea is there any free ODBC SQL driver that I can install on linux system??
View 3 Replies View RelatedI am looking for a client/server application that can allow me to have remote GUI access (eg: VNC) but with the ability to use sound.
I see that TeamViewer has a linux application out now but for my company, it would compromise security protocol because it reaches out to the TeamViewer servers to do any work.
Basically, we have applications that require a GUI and we need to hear sounds from them if they throw an alert (the app is a monitoring tool).
We are running a VNC server on it currently and when our monitoring machine was on Windows, TightVNC was able to get the sound...that is not the case with any Linux client so I am wondering if there is actually one that exists.
I have yum installed mysql 5 on Centos5 and I can successfully run queries through shell.However, I want to now allow external access to mysql via some mysql tools (Mysql Administrator/Mysql Query Browser) which is on some windows machines on the same network.Mysql is running on port 3006.When i try connecting through mysql Admin i get the following:Could not connect to the specified instance.MySQL Error Number 2003Can't connect to MySQL server on 'ipaddress' (10065)If you want to check the network connection, please click the Ping button.Googling this I get the impression its something port related, but I have tried what I have found and still no go.When I ping the server I get:
Start Pinging:
Reply from ipaddress: Time=0ms TTL=64
Reply from ipaddress: Time=0ms TTL=64
[code]....
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 RelatedI have one headless squeeze and two notebooks (one squeeze, one lenny).
When I have X (on headless squeeze) on lenny notebook, it is unacceptably slow. Something like it takes 3-10 seconds to redraw window (acroread, iceweasel, possibly xterm.)
It is not so slow when I use squeeze notebook. Yesterday, I upgraded lenny one to squeeze. Then, it is not slow any more!
Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1
View 1 Replies View RelatedSummary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
MySQL-client-community-5.1.50-1.rhel5.i386.rpm
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
MySQL-server-community-5.1.50-1.rhel5.i386.rpm
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm
error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
I am trying to Setup citrix ICA client 9 on Ubuntu 9.04 Server. I installed it very easily and I am not getting any lib error also. But when I try to connect to the citrix server, it fails with a pop up saying "Error in Network Connection Network or Dialup connection may be preventing ......" This is driving me crazy from 3 days. My project is to check the feasiblity of a Linux desktop
View 1 Replies View RelatedI have a fast computer in my office and I want the person using the slow computer in the same office to boot up and see the login window (gdm) and log-in from there into the fast computer and be able to use their session on the fast computer the same time I am locally logged in to the fast computer as a different user and session.Is this best done through XDMCP? Where is a good tutorial on how to set this up?
View 9 Replies View RelatedI have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. how to keep the firewall running and allow the remote mysql incoming requests?
I'd love a hint or two on the following problem. I've set up iptables rules to forward all connections to port 3306 to a non-standard mysql port on a remote server. This works, except that I need to deal with the loopback interface in a special way and I'm stuck.
Code:
iptables -t nat -A PREROUTING -p tcp --dport 3306 -j DNAT --to 128.XXX.XXX.XXX:3197
iptables -A FORWARD -p tcp -d 128.XXX.XXX.XXX --dport 3197 -j ACCEPT
iptables -t nat -A POSTROUTING -j MASQUERADE
Since locally-generated packets will never hit the PREROUTING rule, you'll need to setup a near identical rule using OUTPUT to make it work. Here is what I've tried:
[Code]...
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. Do you guys have any idea how to keep the firewall running and allow the remote mysql incoming requests?
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedI actually have a server and a client.The client must connect to the server (via internet) to access to external websites. (You can see the attachment, maybe it's more clear )My actual problem is, I have configure Squid on my server, but I want to force SSL for the connection between the client and the server.I didn't really find nice tutorials about on that, maybe someone have an idea ? Or maybe some indications ?
View 1 Replies View Relatedi was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....