Tomcat, Connection Pooling, and MySQL
Has anyone managed to setup Tomcat to use MySQL for database connection pooling? I've found this document which gives information on it: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html However, when I try and run it I get messages about not being able to find the hsql driver class. From searching on Google, it seems that this is a common error, but there are no solutions posted. Has anyone managed to get it up and running successfully? I'd really appreciate any advice! Thanks! Steve Nakhla - Do you Yahoo!? The New Yahoo! Shopping - with improved product search
Re: MySQL & mail servers
Why? Well, we have our reasons. Particularly because we want an efficient way to handle millions of messages, plus the ability to search/manipulate/data mine through them using specific applications. SN --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On Tue, Apr 01, 2003 at 01:04:59PM -0800, Steven > Nakhla wrote: > > > > Are there currently any open-source mail servers > that utilize MySQL? > > Yes, many. > > > I know that there are some that will authenticate > against accounts > > stored in a MySQL database, but I am looking for a > mail server that > > actually stores the messages in the database. > > Why, exactly? > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux > Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.8: up 57 days, processed 1,928,444,836 > queries (388/sec. avg) __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL & mail servers
Are there currently any open-source mail servers that utilize MySQL? I know that there are some that will authenticate against accounts stored in a MySQL database, but I am looking for a mail server that actually stores the messages in the database. Ideally, I'd like to be able to setup an IMAP server that stores everything via a MySQL backend. Any thoughts? Recommendations? Or is this not possible? Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Application security advice
I am writing an application that will store information in a MySQL database. I would like to encrypt the data being stored in the database using the AES_ENCRYPT/DECRYPT functions. My question is, how can I securely contain the password in memory within the application? For example, the application allows the user to login using a username and password that will be stored in the database. I would like to use that password to encrypt the information. However, I would like the user to be able to decrypt the information on the fly as long as they are logged into the application. I am worried, however, about storing the password in memory. How can I do this securely? If my application crashes, the password could be stored within the core file. Can anyone provide advice on how to securely contain the password in memory so that the information can be decrypted and accessed transparently? Steve Nakhla __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ - 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: Row value uniqueness?
Aside from designating a row as a primary key, is their any SQL syntax to force that entries within a row are unique (such as a string value)? Thanks! Steve Nakhla __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
Access control lists on rows?
I know I can restrict a user's access to a table with the GRANT command. However, is there any way to restrict a user's access to individual rows within a table? For example, if I were using a SQL table to hold binary data (utilizing it like a filesystem, for example) could I restrict a user from reading or writing to or from certain rows within the table? Has anyone implemented something like this before and could give me some insight? Thanks much! Steve Nakhla __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
MySQL, OpenLDAP for Authentication
I need to setup a Unix authentication scheme using OpenLDAP with MySQL on the backend storing all of the account data. (Yes, I know that the folks behind OpenLDAP don't recommend using SQL...We have our reasons) I've setup unixODBC so my LDAP server can at least talk to my MySQL server. Has anyone out there done something similar? Do you know how I can go about storing the account information within the database, etc.? I'd really appreciate any insight you can give. Thanks! Steve Nakhla __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - 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
MySQL and binary data
I am using Qt 3.0.5's QSql database classes to store information in a MySQL database. MySQL is at version 3.23.49. I am trying to store binary data into a column marked as MEDIUMBLOB (or even LONGBLOB) but am having difficulties. Whenever I insert data that is around 1 Megabyte in size, I get an error saying "MySQL server has gone away". It doesn't happen with smaller data, and even if I change the column type to LONGBLOB I still have this problem. The data I am trying to insert is an exectuable application, although I have tried it with a normal text file and have run into the same problems. Can anyone shed some light onto what could be causing this problem? Thanks!! Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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
MySQL and OpenLDAP for Unix accounts
I currently have an authentication server on my home network setup to do LDAP authentication. However, I would like to modify the LDAP server to use MySQL to store the information on the backend. I know that OpenLDAP supports SQL back-ends (I believe through ODBC, but I could be wrong) but I can't find any information on how to setup such a system. Ideally, I would eventually like to modify my Samba PDC to use OpenLDAP (and, hence, MySQL as well). Can anyone give me any guidance on setting this up? Can you point me to any useful documentation? I'd really appreciate it!! (Yes, I know that the folks at OpenLDAP recommend that you not use SQL to store information for performance reasons. This is more for my own benefit, and is strictly an educational exercise to get me more familiar with MySQL) Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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
Connection problems
I recently installed Red Hat 7.3 on a box, and have been having difficulty connecting to my MySQL server. I can connect locally. That is, on the same machine as the server. However, if I try and connect from a remote machine with the following command: mysql -h -p I get the following error message: ERROR 2013: Lost connection to MySQL server during query I've poked around on the net and in the documentation, but I can't find anything that explains this. Aside from creating a database and using the GRANT ALL command on it to setup privileges, I haven't mucked with the configuration at all. I've tried reinstalling the RPMs for MySQL and still no luck. Any idea what could be causing this? How can I fix it? Thanks!!! Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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
