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

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

Re: MySQL mail servers

, 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

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

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.

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

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

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

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

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 IP_ADDRESS -p DATABASE I get