URL encoding

2002-01-28 Thread Andrei B.
Is there a function for URL encoding a value ? Here's what I mean : select x from y returns 'word1 word2 %word3' If I were to put this into a URL, some browsers will not handle the URL correctly, especially at the space character, also the same happens with some proxy servers (like squid at

MySQL and SSL

2001-08-08 Thread Andrei B.
I think it would be possible to use MySQL with SSL in the following way: I know of a program called sslwrap, based on openssl. It can be found at sourceforge.net. It is a wrapper that will act like a tunnel end of a ssl connection and then forward the unencrypted data to another port on

perl modules

2001-08-01 Thread Andrei B.
Given a Linux system without MySQL and without installing either the source+compile or the binary ditribution on it, how can I install the PERL modules on this system, so it can act as a client ? Thank you. = ing. Andrei Boros Centrul pt. Tehnologia Informatiei Societatea Romana de

perl API

2001-08-01 Thread Andrei B.
Excerpt from MySQL manual : === NAME Returns a reference to an array of column names. Example: $names = $sth-{NAME}; === $names contains nothing. I suppose this is not normal behaviour.

grant FILE privilege SECURITY hole

2001-07-12 Thread Andrei B.
I give file access to a user on tables in a database : GRANT INSERT,SELECT,FILE ON LOGS.* TO www@localhost identified by 'hidden'; then : SHOW GRANTS www@localhost; +---+ | Grants for www@localhost

perl module for MySQL

2001-06-04 Thread Andrei B.
How can I install the perl MySQL module (along with DBI) on a system that will only be used as a client without installing the MySQL source tree ? Thank you. = ing. Andrei Boros Centrul pt. Tehnologia Informatiei Societatea Romana de Radiodifuziune

MySQL and StarOffice

2001-04-26 Thread Andrei B.
I know this is a bit StarOffice specific, still, I already know of a similarity of functionality with M$ Access when talking to MySQL server. (table is required to have a primary key for inserts to work). Maybe it is a similar answer this time too. Is it possible to create a form for

Berkeley DB and Slackware

2001-04-10 Thread Andrei B.
Did anybody succeed in compiling MySQL and Berkeley DB on a Slackware 7.x system and not get a SIGSEGV? Please let me know how you did it. Thank you. = ing. Andrei Boros Centrul pt. Tehnologia Informatiei Societatea Romana de Radiodifuziune

MySQL and StarOffice database via ODBC

2001-03-28 Thread Andrei B.
Hi, I am trying to link a MySQL database (linux) with a StarOffice client on Windows, with MyODBC installed. I created the database, tables, set up select,update,delete,insert privileges on all tables in it from the host running StarOffice. I can list tables, can insert data into them via

mysql 3.23.32 compiled only works without BDB!!!

2001-03-07 Thread Andrei B.
I have mysql 3.23.32 source tarball and Berkely DB 3.2.3h source tarball. BDB : configure --enable-static --enable-cxx; make ; make install MySQL : configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --enable-thread-safe-client ; make ; make install.

Segmentation fault.

2001-02-06 Thread Andrei B.
If someone could give me some suggestions, please, I am getting desperate. I have a Slackware 7.0 system on which I am trying to install MySQL. Kernel is 2.2.13 glibc was 2.1.2 upgraded to 2.1.3 compiler is egcs 1.1.2 (i think) Any binary distribution works perfectly. MySQL 3.22.23 and