MySQL + ODBC + palm + security?
Hey everyone, Has anyone had any experience establishing a secure connection between a palm device and MySQL database that's on the net? I've setup secure web pages on our webserver that are visible on the web and viewable by wireless palms (securely). Scripts on that interface provide a way to get data into the DB securely. What I'm hoping to find is an alternative for when wireless access is not available. I've got a working form on Pendragon forms that can synch with the MySQL database using the MyODBC driver and a local DSN for the MySQL database. As I understand ODBC has no inherent security but there are secure drivers that talk with some RDBMSs. Is anyone aware of a secure version ODBC driver for MySQL? Or is there any other way that people are aware of to accomplish this weird goal? Thanks, -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ideas?: ERROR 1030: Got error 127 from table handler
Is there a common cause to the following problem?: mysql select parent_referral from referral; ERROR 1030: Got error 127 from table handler I can run a describe on the table and I can sucessfully run: select count(*) from referral but if I try to actually query the data in the table I get the above problem. Our system is running 3.22.23b and we're only having the problem with the largest table in our database (it's got about 75k records in it with 13 fields total file size of the ISD is about 65 megs) -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replacing Special / Foreign characters
I need to write a replace statement in a query that will replace the lower case e with an accent over it and the uppercase A with an accent over it. Anyone have any suggestions? I'm having trouble with those characters ending up in HTML forms. Thanks, -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL FullText improvements in V4.0
I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris On Mon, 14 May 2001, David Simmons - EliteUKServe.Net wrote: Hi, I've heard that there are plans to improve the database fulltext capabilities such as the ability to search for words less than 4 characters in length and searches such as +word1 -word2 and that these changes are to come in version 4.0. Can anyone confirm this and also if so can you give a time for release? I heard spring 2001 Many Thanks David Simmons EliteUKServe.Net [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Looking for info on Fuzzy Searching with MySQL
Here's the approach I used for searching through a table that needed to search 7 different fields in the table and weight them differently: I run through this expression for each word that's split from the searchstring and through each field with different weights given to each field. Then there are actual several varitions on this that account for words that are partial matches or words containing the search term (all just deal with varrying the spaces before and after the field name. I add all of those expressions up as the relevance and then sort by relevance desc. Works very well because it takes the following things into consideration: The location at which the search string appears in the searched field (So a higher number is returned if the search string appears right at the beginning of the field, a lower amount to zero if the string appears further into the searched field, zero if it doesn't exist. $exact_match_weight = 3; $SQL .= if(instr(UPPER(concat(' ',field_name,' ')) , UPPER(' $string ')),(length(field_name)*2 - instr( UPPER(concat(' ',field_name,' ')), UPPER(' $string ') ) +1)/ length(field_name) * $weight[$field_name] * $exact_match_weight , 0) ; Or basically this is what the query returns: if ($string is in field){ # the following is returned as a weighted (length of field * 2) - position string starts in field + 1 --- total length of field * weight of field } else{ 0 is returned } as relevance Hmm... I hope that made sense... -Chris On Mon, 14 May 2001, Bill Marrs wrote: I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are there other MySQL features that help with Fuzzy searching? Soundex seems very useful, but I'm not sure how to apply it to multi-word strings. I'd also be interested in pointers to general info on writing fuzzy searches. A Perl example would be great. I think what I want it a kind of combination of SOUNDEX and the relevance value from MATCH/AGAINST. Is something like this possible? Thanks in advance. -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANSI SQL or MySQL Functions?
Can anyone help point me to a good resource for finding out if particular functions supported by MySQL are ANSI SQL standard functions or if they are MySQL specific? I'm particularly wondering about: concat() if() length() Thanks, -Chris --- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Removing Bad Characters from Database
You can also condense this into one statement if you nest the replace statements: UPDATE table_name SET field_name1=replace(replace(field_name1, '', ''), '', '') etc. -Chris At 01:49 PM 5/9/2001, Eric Fitzgerald wrote: http://www.mysql.com/doc/S/t/String_functions.html REPLACE(str,from_str,to_str) Returns the string str with all all occurrences of the string from_str replaced by the string to_str: mysql select REPLACE('www.mysql.com', 'w', 'Ww'); - 'WwWwWw.mysql.com' This function is multi-byte safe Your exact form would be something like this (do this in your CODE from now on, this is 2 one time queries to run to fix it historicly) UPDATE table SET field = REPLACE(field,'',''); UPDATE table SET field = REPLACE(field,'',''); - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 10:45 AM Subject: Removing Bad Characters from Database I was wondering if anyone knows of a way i can strip bad characters out of a mysql database field namely the charators. These charactors are causing havok for me when I try and post data to the web. Thanks Alot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FILE Permission Security Question
Hello everyone, I was wondering if anyone could help me out and explain a bit about the FILE permissions and how they relate to two particular scenarios: In both cases MySQL is running on SunOS 5.7 and running MySQL client version 3.22.23b MySQL UserA has permissions only on DatabaseA and is granted FILE permissions to all tables in that database Scenario 1: If UserA connects to the database using the MySQL client What are the restrictions on what files that user can access using a LOAD DATA command? Are they dependent at all on the UNIX file permissions for the user who is logged in and actually connects to the database using the mysql -u... etc command? Do the UNIX permissions for the user that started the MySQL server have any effect on this? Is there anything configuration wise that might allow LOADing in other DBs or system files? What defines where outfiles can be written? Scenario 2: If UserA's credentials are used to connect to the MySQL database using the Perl DBI Same question, what factors influence what files can be read in using a LOAD DATA command? What defines where outfiles can be written? In both scenarios is there anything that can compromise this security such as the MySQL server running as root? (I know that's a big no-no) Also, I know I'm running an ancient version of MySQL, can anyone help me find out when that version was released? 3.22.23b? It will help me convince the right people that it's time for an upgrade! I've checked in the release notes section but I can't find anything about when particular releases were made... Thanks, -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php