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: 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