LOAD DATA INFILE failing on OS X Server
Let me preface this by saying I am not a MySQL guru myself, but more of a general sys admin... ! One of our users is trying to execute the LOAD DATA INFILE command (using PHP to talk to MySQL). It is failing for some reason... Everything I believe is set properly, i.e: - the user has the file priv enabled - the file they are reading is world readable - they are specifing absolute path (also tried relative path as well) System specifics is MySQL 3.23.53 on OS X Server 10.2.4, this is Apple's standard build. PHP is at 4.3.1 The user has a pretty much identical test environment he claims it works there (and works even without the file priv enabled) So there is something fundamental I am not seeing... Any pointers would be appreciated! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
jdbc-Driver - foreignkeys - OOo
Hi, I'm a teacher in germany and searching for a database, wich supports foreign-keys and is supported from OOo. (Well I found the HSQLD-Database (Hermann Kienlein was helping) which is working, but with MySQL I could do all my jobs in schools with only _one_ database). Till now, I thought mysql can't work with foreign keys, but I read, that tables in the innodb-format can do this. But if I work with the jdbc-driver and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the jdbc-Driver) Does anybody know, if a future version of the jdbc-Driver will support this foreignkeys-feature of innodb-format? Perhaps this is the wrong mailinglist (sorry), can you tell me, where is the better place I could ask for? Kind regards Dieter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hostname
Hi all, is there a way to find out which host I am connected from? My CGI script checks privileges of users based on host names they came from. But their hosts some times are detected as IP. E.g. when the script asks: SHOW GRANTS FOR 'user'@'127.0.0.1' Mysql replies that there is no such grants, because it knows 'user'@'localhost' instead. Thanks, Alex G. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
corrupt odbc connection in MS Access
Has anyone seen something like this before: We have an Access database (about 9 megs in size) with linked tables in it. The machine DSN shows that the information for the connection is correct. But when you try to open the table in Access, a dialog pops up to connect to the mysql server and the information is wrong. It has the wrong database name. We correct the information in the odbc dialog box so that it matches the DSN information and the table opens. We have triple checked the odbc connections for windows; they are all correct. There's nothing in Access that references the wrong database. There's nothing in the registry. Deleting the linked tables and re-linking them and repairing the access database appears to fix the problem. Has any one else experienced this or know what might be causing it? My only guess so far was that the mdb itself had become corrupt, which was why deleting and relinking the tables then repairing the database fixed the problem. I'd appreciate any information you have. Thanks, bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RADIUS is a Wh*%@
Jeff, I am affraid your question has nothing to do with MySQL internals. It is all about MySQL usage. Stout, Jeff wrote: I am using MySQL 4.0.15 on Win2K (not by choice, vendor chose this platform) I user the Database to store user information to Allow RADIUS to authenticate users against the tables. I have to encrypt the password fields, If I use MD5 it is a one way algorithm, enable for me to user MD5 I have to compare the hashes if hashes match then I'm golden and user is granted access, however the flavor of RADIUS the Vendor has chosen to use can not by it's self do a hash comparison thus all Hash encrypted passwords can't be read by Radius and users are denied access. Doesn't matter. You only need to define what RADIUS has to match and do it within SQL query. For an example if you store MD5 hashes of passwords into table you can just use: SELECT MD5(plaintextpasswd) = password WHERE userid=userid; In case hashes match above query will return 1 (true) Please don't crospost such kind of questions in internals@ It is dedicated to MySQL source, algorithms etc. Use general list [EMAIL PROTECTED] or consider purchasing Support. You can read more about Support MySQL AB provides at http://www.mysql.com/support/ Has any one had experience with this and know of a way to fix this My other thought was to use: INSERT INTO user_profile (userid, password) VALUES ('sam', AES_ENCRYPT(sam,password)); this will allow me to encrypt the password field, but I still need to get RADIUS to do the AES_DECRYPT any thoughts. ugh Jeff Stout CSG Systems, Inc. 303-200-3204 Best regards -- Are you MySQL certified? -- http://www.mysql.com/certification For technical support contracts, visit https://order.mysql.com/?ref=msal __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation of MySQL
Hi All ! I have allready installed the MySql on my server. How do I start the Mysql ? best regards, Eduardo F. Melo PRO-IT Informatic _ MSN Messenger: converse com os seus amigos online. http://messenger.msn.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hostname
127.0.0.1 is always localhost, perhaps you could make this change in your scripts - hcir use MySQL is there a way to find out which host I am connected from? My CGI script checks privileges of users based on host names they came from. But their hosts some times are detected as IP. E.g. when the script asks: SHOW GRANTS FOR 'user'@'127.0.0.1' Mysql replies that there is no such grants, because it knows 'user'@'localhost' instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA INFILE failing on OS X Server
The only thing I would suggest is to look in the mysqllog and look at the command that is specifically being issued, and then try it from the mysql command line interface, and see if it works there, it should give you a good enough reason if it doesn't, and if it does, it more than likely is some sort of permission problem. KL Bill Leonard wrote: Let me preface this by saying I am not a MySQL guru myself, but more of a general sys admin... ! One of our users is trying to execute the LOAD DATA INFILE command (using PHP to talk to MySQL). It is failing for some reason... Everything I believe is set properly, i.e: - the user has the file priv enabled - the file they are reading is world readable - they are specifing absolute path (also tried relative path as well) System specifics is MySQL 3.23.53 on OS X Server 10.2.4, this is Apple's standard build. PHP is at 4.3.1 The user has a pretty much identical test environment he claims it works there (and works even without the file priv enabled) So there is something fundamental I am not seeing... Any pointers would be appreciated! Bill -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 -- 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]
utf8 collations with national symbol's grouping
Hallo, Is there any UTF8 collation which groups national simbols by it's base symbol.. For example: if in case-insensitive a = A, is there any solution for A = A (a-umlaut) or A ?? it would have sense in search'ing national text's, for example selecting all people in phone book which first surname letter are A-based ... -- Thanks, Ilja Polivanov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: jdbc-Driver - foreignkeys - OOo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dieter Kroemer wrote: Hi, I'm a teacher in germany and searching for a database, wich supports foreign-keys and is supported from OOo. (Well I found the HSQLD-Database (Hermann Kienlein was helping) which is working, but with MySQL I could do all my jobs in schools with only _one_ database). Till now, I thought mysql can't work with foreign keys, but I read, that tables in the innodb-format can do this. But if I work with the jdbc-driver and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the jdbc-Driver) Does anybody know, if a future version of the jdbc-Driver will support this foreignkeys-feature of innodb-format? It does (and has for quite some time). What version of MySQL are you using? The most recent two releases (4.0.14 and 4.0.15) have changed the output format for the metadata that the JDBC driver uses to parse foreign keys, so the JDBC driver had to be updated (but hasn't been rolled up into a release). Please try a nightly build of Connector/J from http://mmmysql.sourceforge.net/snapshots/stable/ Regards, -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/bdHGtvXNTca6JD8RAqykAKCGofe+Hho8prh5PiIVSK+GwSJb9wCdFfo6 LHEP/PIKllo2B7s0Agt00a4= =1FRI -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hostname
is there a way to find out which host I am connected from? Does the solution have to be a function called within mySQL or would you accept a function called by PHP or Perl? -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: jdbc-Driver - foreignkeys - OOo
Hello Mark, Am Sonntag, 21. September 2003 18:28 schrieb Mark Matthews: first of all - I'm very new to databases, so there could be any mistakes I made, without knowing it :-(( So ask me, if I made the simplest things which I have to make if they are important for working. It does (and has for quite some time). What version of MySQL are you using? I installed yesterday mysql 4.0.15 (and if I start phpMyAdmin I see this number in the Browser) The most recent two releases (4.0.14 and 4.0.15) have changed the output format for the metadata that the JDBC driver uses to parse foreign keys, so the JDBC driver had to be updated (but hasn't been rolled up into a release). Please try a nightly build of Connector/J from http://mmmysql.sourceforge.net/snapshots/stable/ I downloaded now the last driver and in OpenOffice I told the path from mysql-connector-java-3.0-nightly-20030921-bin.jar to the secrity-entrance. I created a new database with a table in the inno db-format, but I can't get the foreign-key-gui :-(( (The gui only appears, if OOo knows the database supports the foreign-keys. I know it can appears, because with hsqldb it works.) Btw. do you know somebody, who is working with MySQL and the gui for foreignkeys in OOo - I don't know anybody till know :-(( Kind regards and thanks for helping Dieter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: explain
On Fri, Sep 19, 2003 at 10:20:34PM -0700, Hsiu-Hui Tseng wrote: These 2 are the queries explain select * from user where user_id = 123; - where user_id is the primary key of user table with 2178576 rows. Is there a user with user_id 123? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 7 days, processed 282,280,624 queries (421/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to update/set a default value for field via delete statement
I have my schema set so that a field in a table has a default value of 16. I also have a script that initializes the database, but I don't want to delete the record since I want the other fields' data preserved. Is there a way to find out what the default schema value is so that I can issue an UPDATE and set it back? Daevid Vincent http://daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Design Suggestion
I have several fields in which I will be strong text. Various categories, and for each category, its related subcategories. Each subcategory then contains various items. My question is, for performance, would it be better to assign each category/subcategory pair a unique ID number and then anytime I need to lookup something in a subcategory, look up the ID number and search off of that? Or, would it be about the same to just search the entire list of items on the text of the category subcategory? Ex: First way: Two tables: Categories - Category (text), Subcategory (text), CatID (unique integer) Items - CatID (integer relating to id in categories table), Other item info I would do something like: SELECT CatID FROM Categories WHERE Category=desired category AND Subcategory=desired subcategory Then for example to retrieve all items in that subcategory: SELECT * FROM Items WHERE CatID=(the id found in previous select) OR: One table: Items - Category (text), Subcategory (text), ... Other item info And to find all items in a subcategory, do: SELECT * FROM Items WHERE Category=desired category AND Subcategory=desired subcategory It seems to me the second way would be slower, because it has to do many more string tests. But does it make a difference? Is testing integer equality actually faster than string equality? Adam Clauss [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation of MySQL
Well you could: (assuming an installation in /usr/local/mysql) # /usr/local/mysql/bin/mysqld --user=mysql /usr/local/mysql/daemonlog /usr/local/mysql/daemonerrorlog But you should probably consult the manual under the installation for an explanation of exactly what the above does. -Dan On Sun, 2003-09-21 at 10:43, Eduardo Melo wrote: Hi All ! I have allready installed the MySql on my server. How do I start the Mysql ? best regards, Eduardo F. Melo PRO-IT Informatic _ MSN Messenger: converse com os seus amigos online. http://messenger.msn.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
open_files_limit issue
Im running mysql 4.0.15 on mac osx and am having trouble while doing performance/load testing. On startup I get the following error message in the error log: Warning: setrlimit returned ok, but didn't change limits. Max open files is 12288 (request: 25010) Im not sure where this request is coming from. In my my.cnf file, I tweaked the open_files_limit but even though I make changes, the exact message with the exact paramters spits out. Ultimately the problem is that I get an error message telling me that there are too many open files. I suspect I need to increase the number of open files, but it doesnt seem to change. Any suggestions?? = __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hostname
In order to avoid errors it is better to call this within mysql. I tried already SELECT USER(). It seems to work for me. --- Dan Anderson [EMAIL PROTECTED] wrote: is there a way to find out which host I am connected from? Does the solution have to be a function called within mySQL or would you accept a function called by PHP or Perl? -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installation of MySQL
On 9/21/03 9:43 AM, Eduardo Melo [EMAIL PROTECTED] wrote: I have allready installed the MySql on my server. How do I start the Mysql ? best regards, Eduardo F. Melo PRO-IT Informatic on osx... If you are using Explorer 5.2 or better, or Netscape 7.1 or thereabouts http://mac-specialist.com/r/ascript_launch_mysqld_osx.html Or if you are using safari (due to its problems with javascript redirects) http://mac-specialist.com/test/applescript/mysql/ Hope it's useful... Bill Hernandez Plano, Texas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Privileges are disappearing...
Hi, I have a strange problem with priviledges. They just stop working. The tables have the data in them. But they don't work. So I do another GRANT And then they work fine, until the next day (not sure about the timing) when they have to be GRANT'ed all over again. There doesn't seem to be any pattern to this. It happens more often on some dBs than others. This is something that's be going on for a while now. It even caused me to get un-lazy and upgrade to 4.0.13 which didn't seem to help. The dBs are all dumped every night. I connect via DSL so I have a different IP, but I don't think that's an issue, here is the GRANT: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON DbNAME.* TO YYY@'%.t-dialin.net' -- To catch the different IPs. IDENTIFIED BY 'XXX'; I thought it may be a MyODBC issue, but it also doesn't work in PERL/DBI until I do the GRANT again. flush priviledges doesn't seem to have any effect. Only another run of the GRANT. I should specify that it doesn't lose all GRANT info as everything connecting from localhost (but not localhost) is fine, just my connections from outside the server. Any ideas? Thanks!! Tosh -- Tosh Cooey Twelve Hundred Group http://www.1200group.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just a small newbie question
G'Evening, Im extremely new to MySQL. Im sitting here using a self teach book to try to guide my way through it. Anyways, the book is discussing adding users and setting priveledges. Now the book is vague on how to do so, but I believe I use the bin/mysql.exe file (Im on windows obviously). Problem is when I go to it, all it does and open and close real fast. Am I doing something wrong? Thanks, sorry for the noob question. _ Proud member of www.Dragonmount.com The Largest -Wheel of Time- Community on the Internet! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]