Windows 2003 To Windows XP Pro Secure Communications...
I have a Windows 2003 Server running a Coldfusion app that needs to constantly update a MySQL database on a Windows XP Pro machine.
These machines are not on a LAN and are physically separate. I'm trying to find a way to establish secure communications between them since I do not want port 3306 open to the entire internet.
What I've Tried
So far I tried CopSSH with Putty but this did not work because I need to manually initiate all sessions and enter passwords by hand.
Since there aren't any SSH solutions that allow persistent, automatic connections, it appears I need to go with VPN.
The VPN Dilemma
I tried creating a VPN server on the WinXP MySQL machine but I cannot get ODBC to work remotely. How do you get the ODBC on the local (Win 2003) machine to recognize the MySQL database on the remote (WinXP Pro) server?
Note: I also understand that getting SSL working on Windows is a pain in the butt. I'm trying to steer completely clear of that. I don't have the tools to recompile, etc.
View Complete Forum Thread with Replies
Related Forum Messages:
Connecting On Windows 2003
i have just installed mysql on my windows 2003 server and nwo i have a question, 1: after installing it. how do i connect to it to make tables etc? 2: i use IIS 6 and i have my webroot folder on q:/webroot and wonder if i can set the mysql database to be in q:/webroot/database and how i would do that
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
MySQL & Windows 2003 Server
I have a windows 2003 server running a MySQL server on it presently. This is a Test Box. Is it possible that I can also have an instance of Microsoft SQL Server 2000 running along side the MySQL Server at the same time?
View Replies !
MySQL On Windows Server 2003
Is it a good idea to use MySQL on Windows Server 2003 as a good alternate than Microsoft's SQL Server? I've never used MySQL before, could someone tell me how close it is to SQL?
View Replies !
BLOBS Not Working On Windows Server 2003
I have been using Windows Server 2003 to host my own websites, last weekend I finally gathered courage enough to install linux mandrake 10.1 instead. After tow painfull but rewarding days I finally installed everything and was up and running in a LAMP config, sice I developed all of my sites in WAMP everything was ok... BUT BLOBS ARE NOT WORKING AS THEY ARE SUPOSSED TO...
View Replies !
Mysql Windows Connect Error 2003
i installed mysql 4 on windows xp. everything is working quite well except to one thing: connecting to the server using "mysql administrator" works with any computer on the lan, but using the wan ip (or trying to connect from a remote computer) doens't work . the client prompts "connection error 2003". i already checked the complete network parameter and port forwarding works normally. so you can see the mysql server from outside but it seems to deny the connections.
View Replies !
Remotely Connecting On Windows Server 2003
This is probably answered somewhere but I can't find it. I have MySql 5.0 installed on a Windows Server 2003 box and it's working fine. I can connect to it via MySqlAdministrator, MySqlFront and Helm Control Panel which are all installed on the same box. When I try to connect via a remote machine I get an access denied error. What can I do to connect remotely?
View Replies !
Installing Mysql On Windows Server 2003
i have installed mysql 5 on windows server 2003 and when i want to connect to the database throgh my script it gave me this error Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Inetpubwwwroot estdefault.php on line 9 Couldn't connect to server. why it is like this. what i have to do and also i can access the database from Mysql command line client....
View Replies !
Trouble Connecting To MySQL On Windows Server 2003
Fatal error: Call to undefined function mysql_pconnect() <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connMySQL = "localhost"; $database_connMySQL = "database"; $username_connMySQL = "root"; $password_connMySQL = "mypassword"; $connMySQL = mysql_pconnect($hostname_connMySQL, $username_connMySQL, $password_connMySQL) or trigger_error(mysql_error(),E_USER_ERROR); ?> I installed the ODBC drivers as an optional solution, and that appears to be working when I test it within the program, but I don't know how to get my .php website to connect to it. .php files are working correctly on the server, but it's just not connecting to the database.
View Replies !
Lower Case MySQL Table Names On Windows Server 2003....
I currently administer our MySQL db version 3.23.56 on a Linux Cobalt Qube server via an external fron-end piece of software. My Table Names have capital letters at the beginning, i.e. StockMovements, OrderLines..... We are now implementing a cross-over to a Windows Server 2003 machine. I have installed MySQL version 4.0.20a and initially it was stated as 4.0.20a-debug. I managed to find another piece of software to take it out of debug mode as I thought this would help with the table names. The version is now 4.0.20a-max. If I rename the imported tables say from orderlines to OrderLines, it stays, but if I refresh or close/re-open my fron-end, all the table names have reverted back to lower case ? I have lots of .asp apps which are currently working of my Linux MySQL db using Capitals in the table names and fields. Obviously I do not wish to start re-coding all my web pages once I move accross to Windoes Server 2003 ...
View Replies !
UDF On Windows
Does anyone have a windows version of MyXML? Or hints to compile it? Quote: About MyXML is an UDF extension to the MySQL database. It provides a set of utilities to make generating XML from the database a simple task. It provides routines to encode XML, create tags and return entire queries in XML.
View Replies !
Windows UDF
Just a warning - there is currently a worm doing the rounds attacking MySQL servers running on Windows. Linux / *BSD / OSX are not affected. It doesn't exploit any MySQL security holes, but attempts to brute force the password. Once in it installs a bot (W00t bot), and connects to a number of IRC channels, advertises it's presence and recieves IP subnets to attack. Solution: 1) Use a STRONG root password. 'root', 'mysql' or 'secret' doesn't cut it. 2) Limit root connects to certain IP addresses (ONLY 'localhost' is the best). Don't let root connect from '%'. 3) MySQL should RARELY be exposed to the network. Use a firewall and MySQL's skip-networking command.
View Replies !
Windows Box
I am trying to connect from a windows box to a mysql database that is on a unix box and it's coming back with an error. this is via a migration wizard. I decided to install mysql client on the windows box and start mysql and see if I will be able to connect to the database. I have downloaded the code but I don't know how to go from there
View Replies !
QNX To Windows
I have a MySQL database configured on a Windows machine and I need to connect into that machine from a QNX machine. Does anyone know if there is available a MySQL connection driver for QNX? I haven't found anything in the web site.
View Replies !
Windows XP
I just installed MySQL on Windows XP. I have the most basic questions: 1] How do I start and stop MySQL. 2] How do I connect. 3] How do I create a user, set password and privaledges. 4] How do I create a table, set column, set column attributes. Basically, is their any tutorial for the absolute beginner in MySQL on Windows XP.
View Replies !
Windows Date
How can I convert a windows date stored in Mysql (ie 38397 for today) to something I can use in a where clause?
View Replies !
Utf8 In 4.1 For Windows
------=_NextPart_000_008D_01C355F5.DA1B8150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have read in past postings that UTF8 is not yet working with MySQL 4.1 = on the Windows build. Can anyone verify this? If it is not yet working, can anyone give an estimate when a build will = be available that should work?
View Replies !
Windows 98 Shutdown
Recently I installed mysql on a win98. Some 2 days after the installation the system started experiencing a problem shutting down. When shutting down the hard-disk kept spinning sometimes as long as 10 minutes. The same problem was encountered on another win98 computer. The system is working well with win2000 though..edu.tw
View Replies !
Setup Under Windows Xp Sp1
I need to upgrade my current mysql installation . But now there is a problem to run the setup.exe of installshield 5.x under windows xp sp1 or sp2. The program hung after few seconds. In the memory remain active woexec, ntvdm and setup, but the process is freezed. It is possibile to convert the current setup mode of mysql4.014 in other install system, as for in mysqlcc092 ?
View Replies !
MySQL4 And Windows XP
I am having problems running mysql 4 on windows xp. Mysql 3 works fine. However version 4 won't run. Even if I start the server with the admin panel it shuts down again after a couple of seconds. This has only been a problem since I wiped my hard drive and did a clean install of everything.
View Replies !
Install On Windows XP
I cant get mysql to run on my winXP computer. I have downloaded it and installed , unzipped and run setup.exe and placed it in c:mysql. I type the command to start the mysql server c:mysqli mysqld --console It opens the console and then the console shows some inoDB commands and the console hangs. I followed the mysql manual and i cant find the answer there is no command prompt and nothing...how do I run mysql?
View Replies !
Versions Of AMP On Windows?
I am somewhat concerned that i have the right versions of AMP on my Win XP system so it will all work together... Is there some link that (in simple terms!) tells which versions are safe together? I currently have MySQL version 4.0.20d, with Apache 2.0.52 and php 4.3.10. Is this the best combination?
View Replies !
Backing Up On Windows
How do I back up files on Windows? I know how to do it on the *NIX platform. Whenever I run mysqldump, it doesn't export them in sql files to a place that I designate. It goes somewhere else, and I have no clue where that is.
View Replies !
Encryption On Windows
Can anyone advise whether its possible to use the Encode/Decode functions on Windows (Win2K) platform in Mysql & PHP. A book i'm using says they cannot be used in windows yet i've managed to get my application successfully Encoding a password at the time of using an, 'Insert INTO' qry - its stored ok as a BLOB (field was set-up as a BLOB). Problem is i cannot use the DECODE() to reverese things. When tried i get a 'cannot excecute query' type mssg. Looked at MD5 and SHA1 but they are one-way funcs only. I like the look of AES and DES ENCRYPT/DECRYPT but can't get them to work either.
View Replies !
Windows Service
cofiguring the MySQL Server 4.1 on my XP based system im getting this error message "Cannot create windows service for MySQL. Error:0" I've searched the forums and most suggestions were that I remove all instances of MySQL server. I even downloaded a tool to do this. Still no luck. I also have firewalls disabled, etc.
View Replies !
Replication On Windows
I want an urgent help for mysql replication running on 4.16 version does replication works on windows or linux only if it is pls give me minimal steps just first to start it replicatiing.i want it on windows box.
View Replies !
Version For Windows
which i suppose allows one to download the mysql 4.1 file for windows.i have windows xp pro on my pc.but under this heading "Windows downloads (platform notes)" on this page, there are 3 files for windows namely Windows Essentials (x86),Windows (x86)and Without installer (unzip in C:).i was wondering which one to download for a starter like me.
View Replies !
Windows Remote Gui
I'm looking for a software: - for Windows - that would allow me to do everything that phpMyAdmin allows to do - To connect to a remote MySQL server - Secure - FREE!
View Replies !
4.0.22standard For Windows
I am looking for version 4.0.22standard for windows. The web server that I am developing on is 4.0.22standard and I would like to upgrade my local version which is currently 4.0.14 to the same version as the remote web server. Or is there a way that I can upgrade my current version.
View Replies !
Windows XP Servicepack2
i installed mysql 4.1 under windowsxp sp2, installation works, i also can log in using root passwrd, but i can not add new users (neither in shell nor in admintool).
View Replies !
Windows Authentication
I would like to a Windows Authentication with MySQL (similar to the Windows Authentication available for SQL Server). Does anyone knows how it can be done?
View Replies !
Windows Crash
I have one computer where I cannot startup the windows operating system. In that computer I had installed the MySQL Server. Putting the hard drive has a slave on a computer with MySQL Server installed, how can I access the databases?
View Replies !
Two Windows Problems
When I try to transfer data to the sampdb by using the < sign i.e mysql> sampdb < insert_student.sql I get an error. Question one, what am i doing wong, source insert_student.sql works. The windows dos window is only a few inches wide and I cannot read the entire error message. How do I get te dos window open all the way? The little square button in the upper right doesn't do anything at all.
View Replies !
OpenOffice In Windows
I have just installed MySQL 5 for Windows in my (Windows Vista) Desktop. How do I (in Windows) access a database in this local server from the Database module of OpenOffice 3?
View Replies !
Limitations On Windows
I try to find some informations about MySQL installed on Windows: how many CPU's it can use, how much RAM memory etc. but I can't find this information on MySQL page.
View Replies !
Myisamchk On Windows Xp
When I execute "myisamchk roles" I do get warning message like "2 clients are using or haven't closed the table properly" on DOS prompt. If I redirect the command out put to a *.txt file I do not see this warning in the file.
View Replies !
Windows Essentials
i installed the mysql-essential-4.1.12a-win32 and after installation i went to the mysql application which should open a black window (monitor), but it doesnt, it opens the window and quickly closes it. im running winxp sp2 version 2002
View Replies !
Getting Started With 4.1 On Windows Xp Sp2
Has anyone had a problem trying to start the service ?? for some reason it will not let me start up the service and gives me an error message of " server could not be started ". I am running this on my desktop which is a fairly high end machine with a gig of ram P4 3.4, 40 gigs of free space.
View Replies !
Problem With Windows XP
I have just installed MySQL4.1 and the querry browser. I am using windows XP (home adition). I chose to run MySQL as a service so it is running automatically each time windows is on. However, I have trouble to log in mysql and the querry browser. The strange thing is that the problem is on and off for no reason. Sometime everything is fine.
View Replies !
|
TRACKER
