Occasional access errors
I've developed a CMS using PHP and MySQL 4.1 alpha. It ran just fine with the standard MySQL 4.1a binaries both on my Powerbook running Mac OS X as well in a production environment on my FreeBSD server. However, after having installed everything on a clean Debian Linux system, there are some occasional glitches. Approximately once in every 100th request from the PHP code, MySQL responds with a... Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ...error message. It seems very strange to me that this error message occurs so very seldom and it makes no sense to me. Also, it's difficult to figure out what's causing it since it's difficult to provoke it. Does anyone share this experience? /M Michael Edlund - Journalist and Content Management Consultant http://www.edlund.se - http://www.helloworld.se Unix - PHP - MySQL - PostgreSQL - XML - QuickTime VR Authoring -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Entity Relationship Diagram tools?
Hi, I can only find Windows software for modelling of Entity Relationship Diagrams. Surely, there have to be someone out there that have made a general Java app dealing with this and with MySQL support? Does anyone know? Michael Helloworld Media Box 13085, 103 02 Stockholm, Sweden Visitors: Nytorgsgatan 15, Stockholm Email: [EMAIL PROTECTED] Web: http://helloworld.se Mobile: +46-(0)70-370 19 99 Phone: +46-(0)8-644 10 23 Fax: +46-(0)8-643 96 76 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Soon?
http://www.mysql.com/downloads/mysql-4.1.html Binaries will be available soon. Soon has in this context shown to be very relative... :-) What milestones have yet to be reached before binaries for MySQL 4.1 are being made available? Michael Helloworld Media Box 13085, 103 02 Stockholm, Sweden Visitors: Nytorgsgatan 15, Stockholm Email: [EMAIL PROTECTED] Web: http://helloworld.se Mobile: +46-(0)70-370 19 99 Phone: +46-(0)8-644 10 23 Fax: +46-(0)8-643 96 76 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Storing of media files/data in MySQL
Are there any special performance considerations I should have in mind when making the decision of whether to store a large number of browser uploaded media files (images, audio and video) in BLOB-fields in MySQL or whether I should choose to store them in the file directory of the web server with only references to them in the database? Michael Helloworld Media Box 13085, 103 02 Stockholm, Sweden Visitors: Nytorgsgatan 15, Stockholm Email: [EMAIL PROTECTED] Web: http://helloworld.se Mobile: +46-(0)70-370 19 99 Phone: +46-(0)8-644 10 23 Fax: +46-(0)8-643 96 76 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 for OS X compiling problems
Thanks for reporting this - it should now be fixed. Bye, LenZ Yes, the compilation passed that point now. However, unfortunately it got stuck in another place: --- snip --- mkdir .libs g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DFN_NO_CASE_SENCE -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../cmd-line-utils/libedit/liblibedit.a -lncurses -L../libmysql/.libs -lmysqlclient -lz -lm ld: Undefined symbols: _rnd make[2]: *** [mysql] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 sh-2.05a$ --- snip --- My environment is set-up like this: GNU Make version 3.79 autoconf (GNU Autoconf) 2.52 automake (GNU automake) 1.6.1 libtool GNU m4 1.4 GNU Bison version 1.28 (however I'm not trying to do any configuration) Michael - hoping for the best Helloworld Media Box 13085, 103 02 Stockholm, Sweden Visitors: Nytorgsgatan 15, Stockholm Email: [EMAIL PROTECTED] Web: http://helloworld.se Mobile: +46-(0)70-370 19 99 Phone: +46-(0)8-644 10 23 Fax: +46-(0)8-643 96 76 - 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 4.1 for OS X compiling problems
I'm trying to compile MySQL 4.1 on Mac OS 10.2.4 (Darwin Kernel Version 6.4) but run into some problems. When following the general compilation guidelines... cd mysql-4.0 bk -r get -Sq aclocal; autoheader; autoconf; automake (cd innobase ; aclocal; autoheader; autoconf; automake) (cd bdb/dist ; sh s_all ) ./configure make ...the make process exits with these lines: --- snip --- ctype-utf8.c:2001: `my_wildcmp_mb' undeclared here (not in a function) ctype-utf8.c:2001: initializer element is not constant ctype-utf8.c:2001: (near initialization for `my_charset_utf8.wildcmp') ctype-utf8.c:2006: `my_numchars_mb' undeclared here (not in a function) ctype-utf8.c:2006: initializer element is not constant ctype-utf8.c:2006: (near initialization for `my_charset_utf8.numchars') ctype-utf8.c:2007: `my_charpos_mb' undeclared here (not in a function) ctype-utf8.c:2007: initializer element is not constant ctype-utf8.c:2007: (near initialization for `my_charset_utf8.charpos') make[2]: *** [ctype-utf8.lo] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 sh-2.05a$ --- snip --- My environment is set-up like this: GNU Make version 3.79 autoconf (GNU Autoconf) 2.52 automake (GNU automake) 1.6.1 libtool GNU m4 1.4 GNU Bison version 1.28 (however I'm not trying to do any configuration) I'd be very happy if someone had an idea about what might cause this. Best regards, Michael Edlund Helloworld Media Box 13085, 103 02 Stockholm, Sweden Visitors: Nytorgsgatan 15, Stockholm Email: [EMAIL PROTECTED] Web: http://helloworld.se Mobile: +46-(0)70-370 19 99 Phone: +46-(0)8-644 10 23 Fax: +46-(0)8-643 96 76 - 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