Re: MySQL Cluster
Hello Moon's Father, That would be great..if it was in english ;) Hi. Here are some of my tests on Centos 5.0. http://blog.chinaunix.net/u/29134/article_71956.html On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio <[EMAIL PROTECTED]> wrote: Hi, Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5? Is it better from source or can it be from yum? I do prefer yum because it's easier for upgrades, but I don't know if the available package was compiled for that. Thank you, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SqlYog question
I'm trying to get used to visually mapping out my db design using the SqlYog SchemaDesigner. Once I have the PK/FK setup, how can I export that design to SQL code to create the tables, etc?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Primary key / foreign key question
Ok, I'm a little new a this, so be gentle!! :) I was looking into the InnoDB engine for some tables I have, and would like to use the PK/FK on some of the data. It appears that the PK/FK is mainly used for updating/deleting data, correct? I can't use it to retreive data from multiple tables and have them linked, other than a join? Or am I wrong? Is there a good visual tool that I can use to build my tables, create the PK/FK definations, and test how inserts, deletes, updates affect all the tables involved?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql behaving slowly
I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM. It has been running fine for the past year, nice and quick. Now it seems like its running slowly. Is there a tool to test the db and/or install and see if there are any problems??? Or would upgrading help? Anyone have any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems installing MySql...
I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for Windows Server 2003. When I try to use the MySql Administator, and put in the server name, root account and password defined in the my.ini file, it doesn't connect, using 'localhost'. What am I doing incorrectly? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Install MySql 4.0.23???
I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for Windows Server 2003. When I try to use the MySql Administator, and put in the server name, root account and password defined in the my.ini file, it doesn't connect, using 'localhost'. What am I doing incorrectly? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Install MySql 4.0.23???
I already have a version of MySql 4.1.17 running on a different server, but am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's software. I'm finding that 4.0.23 isn't as easy to set up as the later versions. I modified the my.ini file and put it in the \windows directory for Windows Server 2003. When I try to use the MySql Administator, and put in the server name, root account and password defined in the my.ini file, it doesn't connect, using 'localhost'. What am I doing incorrectly? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Strip off leading and trailing spaces once in db?
Is it possible to remove all trailing and leading spaces for selected fields once the data has already been loaded? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Limit of 1000 rows?
I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked. The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000 exactly. Am I missing something to allow more than 1000 rows to be input? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Import Excel data into table
Can anyone tell me a good way to import individual column data into a table? Is there a tool to assist with this? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Strange results - Part 2
This is a follow up message to a earlier threat this week (which is included in the message below) Ok, here's the model table: "Table","Create Table" "model","CREATE TABLE `model` ( `PID` tinyint(3) NOT NULL auto_increment, `VendorID` tinyint(4) NOT NULL default '0', `Model` varchar(15) NOT NULL default '', PRIMARY KEY (`PID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" The vendor table: "Table","Create Table" "vendor","CREATE TABLE `vendor` ( `PID` int(11) NOT NULL auto_increment, `Vendor` varchar(25) NOT NULL default '', PRIMARY KEY (`PID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" And the specs table: "Table","Create Table" "specs","CREATE TABLE `specs` ( `SpecID` int(11) NOT NULL auto_increment, `ProdModel` varchar(15) NOT NULL default '', `ProdImage` text NOT NULL, `ProdPrice` varchar(15) NOT NULL default '', `ProdStroke` varchar(8) NOT NULL default '', `ProdCC` varchar(7) NOT NULL default '', `ProdFuel` varchar(15) NOT NULL default '', `ProdCooling` varchar(40) NOT NULL default '', `ProdStarter` varchar(20) NOT NULL default '', `ProdIgnition` char(3) NOT NULL default '', `ProdTrans` varchar(35) NOT NULL default '', `ProdFSusp` varchar(45) NOT NULL default '', `ProdRSusp` varchar(35) NOT NULL default '', `ProdFBrake` varchar(45) NOT NULL default '', `ProdRBrake` varchar(25) NOT NULL default '', `ProdTireSize` varchar(25) NOT NULL default '', `ProdSpeed` varchar(15) NOT NULL default '', `ProdDimension` varchar(30) NOT NULL default '', `ProdWheelBase` char(3) NOT NULL default '', `ProdSeatHeight` char(3) NOT NULL default '', `ProdGauges` mediumtext NOT NULL, `ProdSafety` mediumtext NOT NULL, `ProdAntiTheft` mediumtext NOT NULL, `ProdWeight` varchar(10) NOT NULL default '', `ProdOption` mediumtext NOT NULL, `ProdPower` varchar(30) NOT NULL default '', `ProdColor` mediumtext NOT NULL, `ProdConsumption` varchar(11) NOT NULL default '', `ProdOilInject` char(3) NOT NULL default '', `ProdLoad` varchar(7) NOT NULL default '', `ProdCargo` varchar(8) NOT NULL default '', `ProdWarranty` varchar(35) NOT NULL default '', `ProdCarb` varchar(35) NOT NULL default '', `ProdCarbManu` varchar(6) NOT NULL default '', `ProdStorage` varchar(30) NOT NULL default '', PRIMARY KEY (`SpecID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" ""Kevin A. Burton"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Steve Grosz wrote: > > > If you can tell me the command to dump the table format, I'm more than > > happy to list it here. > > SHOW CREATE TABLE FOO; > > -- > > Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an > invite! Also see irc.freenode.net #rojo if you want to chat. > > Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html > > If you're interested in RSS, Weblogs, Social Networking, etc... then you > should work for Rojo! If you recommend someone and we hire them you'll > get a free iPod! > > Kevin A. Burton, Location - San Francisco, CA >AIM/YIM - sfburtonator, Web - http://peerfear.org/ > GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 > I am still looking for assistance with the table problem. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange results
Ok, here's the model table: "Table","Create Table" "model","CREATE TABLE `model` ( `PID` tinyint(3) NOT NULL auto_increment, `VendorID` tinyint(4) NOT NULL default '0', `Model` varchar(15) NOT NULL default '', PRIMARY KEY (`PID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" The vendor table: "Table","Create Table" "vendor","CREATE TABLE `vendor` ( `PID` int(11) NOT NULL auto_increment, `Vendor` varchar(25) NOT NULL default '', PRIMARY KEY (`PID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" And the specs table: "Table","Create Table" "specs","CREATE TABLE `specs` ( `SpecID` int(11) NOT NULL auto_increment, `ProdModel` varchar(15) NOT NULL default '', `ProdImage` text NOT NULL, `ProdPrice` varchar(15) NOT NULL default '', `ProdStroke` varchar(8) NOT NULL default '', `ProdCC` varchar(7) NOT NULL default '', `ProdFuel` varchar(15) NOT NULL default '', `ProdCooling` varchar(40) NOT NULL default '', `ProdStarter` varchar(20) NOT NULL default '', `ProdIgnition` char(3) NOT NULL default '', `ProdTrans` varchar(35) NOT NULL default '', `ProdFSusp` varchar(45) NOT NULL default '', `ProdRSusp` varchar(35) NOT NULL default '', `ProdFBrake` varchar(45) NOT NULL default '', `ProdRBrake` varchar(25) NOT NULL default '', `ProdTireSize` varchar(25) NOT NULL default '', `ProdSpeed` varchar(15) NOT NULL default '', `ProdDimension` varchar(30) NOT NULL default '', `ProdWheelBase` char(3) NOT NULL default '', `ProdSeatHeight` char(3) NOT NULL default '', `ProdGauges` mediumtext NOT NULL, `ProdSafety` mediumtext NOT NULL, `ProdAntiTheft` mediumtext NOT NULL, `ProdWeight` varchar(10) NOT NULL default '', `ProdOption` mediumtext NOT NULL, `ProdPower` varchar(30) NOT NULL default '', `ProdColor` mediumtext NOT NULL, `ProdConsumption` varchar(11) NOT NULL default '', `ProdOilInject` char(3) NOT NULL default '', `ProdLoad` varchar(7) NOT NULL default '', `ProdCargo` varchar(8) NOT NULL default '', `ProdWarranty` varchar(35) NOT NULL default '', `ProdCarb` varchar(35) NOT NULL default '', `ProdCarbManu` varchar(6) NOT NULL default '', `ProdStorage` varchar(30) NOT NULL default '', PRIMARY KEY (`SpecID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" ""Kevin A. Burton"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Steve Grosz wrote: > > > If you can tell me the command to dump the table format, I'm more than > > happy to list it here. > > SHOW CREATE TABLE FOO; > > -- > > Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an > invite! Also see irc.freenode.net #rojo if you want to chat. > > Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html > > If you're interested in RSS, Weblogs, Social Networking, etc... then you > should work for Rojo! If you recommend someone and we hire them you'll > get a free iPod! > > Kevin A. Burton, Location - San Francisco, CA >AIM/YIM - sfburtonator, Web - http://peerfear.org/ > GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange results
If you can tell me the command to dump the table format, I'm more than happy to list it here. Steve Rhino wrote: - Original Message - From: "Steve Grosz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 11, 2004 3:57 PM Subject: Strange results I'm curious, why if I enter this code: select * from vendor left outer join model on vendor.PID=model.VendorID left outer join specs on model.Model=specs.ProdModel where vendor.Vendor='#URL.Vendor#' do I get the results like: http://www.scootervilleusa.com/test1.cfm?Vendor=Tank I simply want 1 row for each product to be displayed, not 4 sets of 4 rows. It's hard to say for sure without seeing your table definitions and a sampling of the data in each table but I think there's a very good chance that either one of your tables doesn't have a primary key defined or that you are not joining on the primary key in one of your joins. Joins typically take place between a primary key on one table and a corresponding foreign key on the other table. The syntax of your joins seems fine so I can only suspect the two things I said above. For instance, if Vendor.PID is intended to be unique and you think of it as the primary key but it hasn't actually been defined that way in the table, it's very possible that this is causing your duplicate rows. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Strange results
I'm curious, why if I enter this code: select * from vendor left outer join model on vendor.PID=model.VendorID left outer join specs on model.Model=specs.ProdModel where vendor.Vendor='#URL.Vendor#' do I get the results like: http://www.scootervilleusa.com/test1.cfm?Vendor=Tank I simply want 1 row for each product to be displayed, not 4 sets of 4 rows. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: General Sql question
I am writing this by hand, and is being used within Coldfusion. MySql is v 4.1.7 and I am connecting via ODBC. Steve <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Your sample query is not valid SQL. What tool/language are you using to > run this query? There must be something interpreting what you entered and > mis-representing your query to the MySQL server. Without that piece of the > puzzle I am completely in the dark. > > It would also help to know what version MySQL server you are using and if > you are connecting to your MySQL server through any kind of library > (connector/J, ODBC, etc.) which one and what version is it? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Steve Grosz <[EMAIL PROTECTED]> wrote on 12/03/2004 12:58:30 PM: > > > I am kinda new to SQL, and am having a problem trying to get something > done. > > > > I'm trying to search for usernames in one of my tables. The name is > > stored as firstname lastname. > > > > I wrote my query as > > select Cust_ID, Cust_Name > > from mailings > > where ucase(Name) = ucase(Cust_Name) > > > > When it runs, I get a error: > > You have an error in your SQL syntax; check the manual that corresponds > > to your MySQL server version for the right syntax to use near 'Grosz = > > Cust_Name' at line 3 > > > > It seems that its only searching for the name after the space between > > the first and last name. > > > > How can I correct this in the query? > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
General Sql question
I am kinda new to SQL, and am having a problem trying to get something done. I'm trying to search for usernames in one of my tables. The name is stored as firstname lastname. I wrote my query as select Cust_ID, Cust_Name from mailings where ucase(Name) = ucase(Cust_Name) When it runs, I get a error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Grosz = Cust_Name' at line 3 It seems that its only searching for the name after the space between the first and last name. How can I correct this in the query? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Backup problems
I am using the MySql Administrator tool to schedule weekly backups on my databases. I have defined the databases I want backed up and how often, plus where to store the data. I ran a sample, but it appears that just the structure is being backed up, not the data in the tables as well. How do you define this? What am I missing? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with backup
I am using the MySql Administrator tool to schedule weekly backups on my databases. I have defined the databases I want backed up and how often, plus where to store the data. I ran a sample, but it appears that just the structure is being backed up, not the data in the tables as well. How do you define this? What am I missing? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question after installing 4.1.7
That seems to work fine, but now the problem is that am no longer able to log in to the Admin utility using root and the server name of db1. I can get in using a alternate account I created before I made the change just fine. Jeff Smelser wrote: On Tuesday 30 November 2004 01:36 pm, Steve Grosz wrote: I had installed MySql on Win2003, and when I check the 'server information' page, it shows a IP of 127.0.0.1. The IP of the server has a 192.x.x.x address. Change the line below in my.cnf to what you need.. Its binding to 127 ip. # keep secure by default! bind-address= 127.0.0.1 port= 3306 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question after installing 4.1.7
I had installed MySql on Win2003, and when I check the 'server information' page, it shows a IP of 127.0.0.1. The IP of the server has a 192.x.x.x address. I'm asuming that this might have a problem why I can't telnet to it to make sure the DB is working?? How can I change this, or do I need to? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stored Procedure?
Ok, I'm new to MySql (or SQL in general). I'm curious what exactly a stored procedure in MySql is, and what the benefit would be? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade?
I'm referring to the MySql server v.4.1.5 that I'm using now, as compared to the newer release of v.4.1.7 Paul DuBois wrote: At 20:09 -0700 11/22/04, Steve Grosz wrote: I'm using 4.15 currently, and it seems to be very stable. I noticed that a v4.17 or something has come out recently. Versions 4.15 and 4.17 of what? You're asking us whether it's worth upgrading without specifying what it is you're asking about? Do you mean MySQL 4.1.5 and 4.1.7? Is it worth upgrading? Can I just install the new version without damaging my current databases or are there specified steps? Where would I find them if there are? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade?
I'm using 4.15 currently, and it seems to be very stable. I noticed that a v4.17 or something has come out recently. Is it worth upgrading? Can I just install the new version without damaging my current databases or are there specified steps? Where would I find them if there are? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not returning NULL or 'N/A' fields?
Is there a way to have a select NOT return columns that have either a 'null' or 'n/a' value? I have some shared specs for some products, and some of the fields aren't used for all products, so I have blank entires in those columns for those specific products. I'd like to return all the info that is actually there. Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with date field
This is on a Win2003 server system, and MySql server 4.1 ""Markus Grossrieder"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > What's going on here? > God knows ! > Maybe providing some information (OS, version, host app(if any), code > example, db description, etc.) would permit > some humble humans to take a guess ... > > - Original Message - > From: "Steve Grosz" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, November 05, 2004 8:13 AM > Subject: Problem with date field > > > > Why am I having a problem getting a date field to hold date? I will > store > > 2004-10-15, save the record. Reopen the record, and there is just > > -00-00 > > > > What's going on here? > > > > Thanks > > Steve > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with date field
CREATE TABLE `events` ( `eventID` tinyint(4) NOT NULL auto_increment, `eventDate` date NOT NULL default '-00-00', `eventTitle` tinytext NOT NULL, `eventDesc` mediumtext NOT NULL, PRIMARY KEY (`eventID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | "Gleb Paharenko" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi. > If you send us output of "show create table 'table_with_date_field'", > and queries, which you use to insert and retrieve date, > may be we will be able to help you. > > > "Steve Grosz" <[EMAIL PROTECTED]> wrote: > > Why am I having a problem getting a date field to hold date? I will store > > 2004-10-15, save the record. Reopen the record, and there is just > > -00-00 > > > > What's going on here? > > > > Thanks > > Steve > > > > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with date field
Why am I having a problem getting a date field to hold date? I will store 2004-10-15, save the record. Reopen the record, and there is just -00-00 What's going on here? Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie question on multiple tables
I am just now getting the hang of searching through 2 tables, and getting the corresponding information using a pri & foreign key (ID1=ID1) kinda thing. How is this done with more than 2 tables? I had asked on a different forum, but I got some funky select statement using a left inner join, and lots of other statements that didn't make a lot of sense to me. Is that the way it would need to be done? A inner join? If so why? Thanks! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql basics?
Where would I find a good online tutorial that would step me through understanding setting up seperate tables, and the relationships between then? Thanks so much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Display a blob from Mysql into Coldfusion?
I am trying to store images in the longblob text type in one of my tables, and then display the picture on a Coldfusion MX 6.1 page. When I try to get it to display, I get the following error: ByteArray objects cannot be converted to strings. The error occurred in C:\Web Sites\Scooter2\Scooters\Vform.cfm: line 29 27 : 28 : 29 : #ProdImage# 30 : 31 : Can anyone tell me how I can get this to work? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Blob question
I'm just getting into the whole MySql (was using access). Is it better to create a Blob type and insert a image into it, or to create a char file type and have a directory structure to the specific file? How big of files to the different Blob's hold? And if I'm using Coldfusion, will that support the blob type in the ColdFusion code? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ODBC connection issues
I noticed at the bottom of that page there are some user comments about recompiling and ODBC not working. Any concerns regarding those comments and the issues I'm having? Steve Michael Stassen wrote: No, I'm saying that your client (ODBC from Coldfusion) was built against an earlier version of the mysql client library, so it doesn't understand the new, more secure, authentication protocol introduced in mysql 4.1. Did you read the manual section I suggested? It contains an explanation of your exact error message, along with a link to another page <http://dev.mysql.com/doc/mysql/en/Old_client.html> which offers work-arounds. Michael Steve Grosz wrote: So, you're saying its a problem with the password on the root account? This was a brand new install. I'm a little confused here. Steve Michael Stassen wrote: See the manual <http://dev.mysql.com/doc/mysql/en/Password_hashing.html>. Michael Steve Grosz wrote: I am trying to set up a ODBC connection from a Coldfusion server to a MySql server, both running on Windows2003 Servers. I installed the ODBC 3.51 driver on the Coldfusion server, and am trying to make the connection. When I go to set up the ODBC link and say 'test data source' I get a message that says [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySql client'. What is this refering to??? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ODBC connection issues
So, you're saying its a problem with the password on the root account? This was a brand new install. I'm a little confused here. Steve Michael Stassen wrote: See the manual <http://dev.mysql.com/doc/mysql/en/Password_hashing.html>. Michael Steve Grosz wrote: I am trying to set up a ODBC connection from a Coldfusion server to a MySql server, both running on Windows2003 Servers. I installed the ODBC 3.51 driver on the Coldfusion server, and am trying to make the connection. When I go to set up the ODBC link and say 'test data source' I get a message that says [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySql client'. What is this refering to??? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
I also get the jibberish, and a connection lost error message. Is it something in MySql server that I'm not setting up correctly? Jochem van Dieten wrote: On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote: Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Repeat that telnet test from the machine running ColdFusion. Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ODBC connection issues
I am trying to set up a ODBC connection from a Coldfusion server to a MySql server, both running on Windows2003 Servers. I installed the ODBC 3.51 driver on the Coldfusion server, and am trying to make the connection. When I go to set up the ODBC link and say 'test data source' I get a message that says [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySql client'. What is this refering to??? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
Ok, with leaving the : off the end, and just typing telnet web-server2 3306 I get some jibberish on the screen, and a 'connection lost' message after a few seconds. That's coming from a machine on the same side of the firewall as the Sql server. For the other IIS server and Coldfusion server to the Sql server, still get a 'can't connect message'. I'm pretty sure its not a firewall issue, but I'll have to take another look. Any other ideas? Thanks!! Steve Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote: =>Neither the DOS nor Unix man pages for telnet mention a colon--Why do you =>think you need one? Let me try again, how about 'telnet web-server 3306'? => Sorry for the typo. For your example, that should've been: telnet web-server2 3306 Are you sure you're connecting to the appropriate box? Should your command string be telnet 3306 instead? - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
I have tried telnet web-server2:3306 Didn't work Dwalu Z. Khasu wrote: On Thu, 14 Oct 2004, Steve Grosz wrote: =>If that's the case, its not working, I type a telnet 192.168.x.x:3306 =>and get a "could not open a connection to the host" even though =>Mysql-nt shows as running on the Win2003 server. => =>Steve => Try 'telnet host port'. - Dwalu .peace -- I am an important person in this world - Now is the most important time in my life - My mistakes are my best teachers - So I will be fearless. - Student Creed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
If that's the case, its not working, I type a telnet 192.168.x.x:3306 and get a "could not open a connection to the host" even though Mysql-nt shows as running on the Win2003 server. Steve Eric Bergen wrote: telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz <[EMAIL PROTECTED]> wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding DSN into Coldfusion Admin?
So what, a telnet 192.168.x.x:3306 ? Eric Bergen wrote: telnet to it. MySQL will return a 'hello' packet. -Eric On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz <[EMAIL PROTECTED]> wrote: I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adding DSN into Coldfusion Admin?
I am new to using MySql. I installed it on a seperate server on Win2003. That server has a 192.168.x.x address on my network. I am trying to add a DSN connection from Coldfusion to the database, but every time I try using the MySql driver/connection type, it says there doesn't seem to be a server running at 192.168.x.x:3306 What am I doing wrong? How can I check remotely to see if the server is actually running? Thanks very much!! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]