Re: MySQL secure access
If I am your customer and the data related to my web contents and/or services stored(this is more than likely if the hosting service is used) in the database at your site, I would definitely claim that the access to data will be appropriate. Ex, You have Web services using a hosting service. And the Web services collect the customers' info. Shouldn't you need to access the database which stored all your customers' info. In addition, it's a trust-based relationship. But the hosting service should not have access to the customers' data even though the customers' databases reside at the hosting site. That's more appropriate in the business process and prevent the possible legal matter. Because the customers can simply claim that It's my data and not yours! The right practice will be to seperate your company's database and customer's databases on different hosts. And your company can provide the proper access to your customers to their databases. Otherwise, they will move on to somewhere else who can do for their needs. Pae Hi, all, I am now using MySQL with MySQL Front, where i knew that it can access ALL the databases that store remotely. My company is doing hosting services. And we are using MySQL as our database system. Currently, we have our own databases + customer's databases store in our hosting server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. regards, alice /--- \ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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
Re: converting from foxpro to mysql ???????
On Wed, 2002-11-27 at 17:05, toby z wrote: ok guyz i need some inside info . plz help me with: 2. if i ve to conver a db in foxpro to mysql or sql which one should i preffer and y pz do nt use thz hax0r w0rdz It is really hard to read. Many people here do not speak english natively and even just using plain english is complicated. I am not going to read further about your problem. Sorry. Tonu - 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
Need help to connect MySQL which is on Linux thru win32 PC
Keys: sql, query Hi Steve, I got your email from the MYSQL list, and I undertood that you have some experience about using Mysql tables in an application developed by Delphi. I am just at the begining of the way. Still I am dying to get any response or see the already existing defined tables of the MySQL which is running on a Linux server. For testing I installed the MYSQL win32 version both on the same PC and into another PC whicha are on the same local NET. I can reach both the local databases, and the win32 MySql server (on the PC2) with the same programs, but still I did'n see the databases of the MySQL which is on the Linux Server. Do you have anything to advise me to solve this problem? Sincerely. Cem Yagli - 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
DBI: error 12 from table handler , Can't allocate memory, temp tables, WHY?
Hi. I have a perl script that uses many temporary tables (HEAP mostly) and when running the script many times in parallel some of the script instances fail. The query uses temporary tables and recently I discovered that some of the queries uses filesort (disk access) due to GROUP BY making the response time for every concurrent script longer than expected. Here is the error I get: DBD::mysql::db do failed: Got error 12 from table handler at /home/travis/tr.pl ... Looking at the log files for MySQL I cant figure out what queries cause the failure but generally speaking I assume that the problem is the temporary tables. Looking up the error code received by DBI/DBD I get: 'perror 12' Error code 12: Cannot allocate memory Can't allocate memory? Why is that? Below is my server info and my default my-huge.cnf settings. I have tried to set the SET SQL_BIG_RESULT=1 resulting in all temp tables getting written to disk, but the error still exists. I have tried to modify the parameters in my.cnf, primarily adjusting key_buffer and sort_buffer, but the default my-huge.cnf configuration seems to work the best. Could someone please tell me what is wrong? SERVER INFO: - * MySQL v 3.23.52 on FreeBSD 4.7, dual 1200 MHz Intel CPU, 1Gb RAM, 10Gb Free swap space * and lots of free space on all partitions, especially in /var * no limits on CPU, Memory, open files etc. in FreeBSD kernel * No errors shown in /var/messages * No errors shown in /var/db/mysql/host.err * The queries involve the use of temporary tables and a lot of READ queries on regular tables. * No locks have been issued and no locks are needed. * No other processes on the server uses MySQL while the program runs. MySQL info: - Compiled with static, no innodb, no BDB for full performance /etc/my.cnf - copied 100% from my-huge.cnf --- [client] #password = your_password port= 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-innodb skip-bdb set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 #set-variable = join_buffer_size=512000 set-variable= myisam_sort_buffer_size=64M #log-bin server-id = 1 - 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: converting from foxpro to mysql ???????
thnx fo takin the time to reply anyways . :( toby .. From: Tonu Samuel [EMAIL PROTECTED] To: toby z [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: converting from foxpro to mysql ??? Date: 28 Nov 2002 11:47:45 +0200 On Wed, 2002-11-27 at 17:05, toby z wrote: ok guyz i need some inside info . plz help me with: 2. if i ve to conver a db in foxpro to mysql or sql which one should i preffer and y pz do nt use thz hax0r w0rdz It is really hard to read. Many people here do not speak english natively and even just using plain english is complicated. I am not going to read further about your problem. Sorry. Tonu - 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 _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: converting from foxpro to mysql ???????
I do speak English natively, and I haven't a clue what you're talking about either. Andy mysql query -Original Message- From: Tonu Samuel [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 09:48 To: toby z Cc: [EMAIL PROTECTED] Subject: Re: converting from foxpro to mysql ??? On Wed, 2002-11-27 at 17:05, toby z wrote: ok guyz i need some inside info . plz help me with: 2. if i ve to conver a db in foxpro to mysql or sql which one should i preffer and y pz do nt use thz hax0r w0rdz It is really hard to read. Many people here do not speak english natively and even just using plain english is complicated. I am not going to read further about your problem. Sorry. Tonu - 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
Bug Report: Replication in 4.0.5beta
The environment info was copied from the mysqlbug command by our external hosting company who truncated the lines therefore the last couple of characters from each line is not there however it was a Solaris 2.8 binary download of 4.0.5beta so you would have all of the info anyway. Description: I am using MySQL 4.0.5beta on Solaris 2.8 from a binary version downloaded from www.mysql.com on the 19th of November 2002. I have one database set up as the master database and 2 databases set up as slave databases. Each database is on a separate SUN server. I am performing intense load testing on MySQL replicated databases using InnoDB tables and transactions and I have come across what is most likely a bug. The replication is failing on the slaves with the following error (this appears both slaves error logs at the same time) :- 021127 13:48:28 Error in Log_event::read_log_event(): 'Event too big', data_len=1397639424,event_type=111 021127 13:55:36 Error in Log_event::read_log_event(): 'Event too big', data_len=1397639424,event_type=111 As you can see the data_len is 1.3G. The master log position at this time was less than 300Meg so a single event, even if I did about 500,000 inserts in a transaction block, could not be larger than 300Meg. I have MAX_BINLOG_SIZE set to 2Meg on the master database and the slaves. As it is I know that the transactions were small as the records were being inserted on the slave machines which only happens after the commit takes place on the master. I have run this test several times and it falls over after a different number of records have been replicated each time (I performed reset master and reset slave on the databases between tests to ensure a clean run) but the reported error is the same i.e. data_len being 1.3G. I feel the master log file switching has somehow corrupted the binary log file. I had previously loaded 1,000,000 records on this replicated server and it worked fine. However the binary log files were never switched because the server was under too much load. I then changed my method of allocating sequential keys which slowed things down enough for the log switching to occur at the size specified in MAX_BINLOG_SIZE and I got the error. How-To-Repeat: Re-run the test after performing a reset master and reset slave on the appropriate databases. Fix: If I take out the setting of MAX_BINLOG_SIZE to let it use the default size of 1Gig and re-run my test it works OK. Submitter-Id: [EMAIL PROTECTED] Originator:MySQL owner Organization: BBC MySQL support: none (until we go live) Synopsis: Bug in binary log and/or replication Severity: serious Priority: Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.5-beta-standard (Official MySQL-standard binary) Environment: machine, os, target, libraries (multiple lines) System: SunOS db1.mh.bbc.co.uk 5.8 Generic_108528-15 sun4u sparc SUNW,Sun-Fire-480R Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-om structors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Nov 15 15:21 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146204 Jun 3 08:46 /lib/libc.so.1 lrwxrwxrwx 1 root root 11 Nov 15 15:21 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146204 Jun 3 08:46 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-standard b =complex --with-server-suffix=-standard --enable-thread-safe-client --enable-local-infile --enable bs=no --disable-shared --with-innodb CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fn -constructors -fno-exceptions -fno-rtti' CXX=gcc Perl: This is perl, version 5.005_03 built for sun4-solaris BBCi at http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system, do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this. - 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
replication and if not exists temporary tables
Description: A website we recently built contains a highscore table. People play a game, and can then submit their name and score to the table. When viewing the table, I then need to rank the scores using an order by... However since I want to be able to only select arbitrary intervals in the ranks (I want to ask the question show me position 200-300), I figured I needed to use a temporary table. All my tables are innodb tables. I'm doing this in Java using the mm.mysql-2.0.14 driver. I'm using MySQL 3.23.53. The SQL I then got is: 1. create temporary table if not exists Highscores_result ( position int, name varchar(255), country varchar(255), score int ) type=innodb; 2. delete from Highscores_result; 3. set @n=0; 4. insert into Highscores_result select @n:=@n+1 as rownum, name, country, score from Highscores order by score desc; I grab a connection, set autocommit to false, create a statement (not prepared) and then do stmt.addBatch() for each of the statements, execute, and then commit(). And then I can read out say position 200-300 from the temporary table. The MySQL instance that runs this have got two replication slaves. One which is constantly connected, and one which connects every night for nightly backups. The one which is constantly connected works fine and keeps replicating. However the one connecting every night always stops the slave thread with a: ERROR: 1146 Table 'foo.Highscores_result' doesn't exist 021127 20:00:03 Slave: error running query 'delete from Highscores_result' 021127 20:00:03 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'master-bin.018' position 566235 021127 20:00:03 Slave thread exiting, replication stopped in log 'master-bin.018' at position 566235 Hypothesis: Could this be down to that temporary tables are connection unique and I'm killing my connection every now and then, and that the slave does not actually create a table on create table if not exists if the master didn't create it. E.g. master log looks something like: - CREATE TABLE IF NOT EXISTS (Creates table on master since it doesn't exist) - DELETE FROM - SET - INSERT -- I disconnect my slave -- I reconnect my slave - CREATE TABLE IF NOT EXISTS (Doesn' create on slave since it existed on the master) - DELETE FROM - SET - INSERT How-To-Repeat: Set up a replication slave that disconnects and reconnects using cron. Run the above kind of SQL. Fix: If the hypothesis is correct, perhaps the slave must honor create table if not exists regardless if this was a success on the master or not. Submitter-Id: Martin Algesten Originator: Organization: Taglab Limited MySQL support: none Synopsis: replication and if not exists temporary tables Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.53 (Source distribution) Environment: System: Linux 2.4.19-taglab-2002-10-29 #2 Tue Oct 29 17:16:43 GMT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/gcc-2.95.3/bin/gcc GCC: Reading specs from /usr/local/gcc-2.95.3/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='/usr/local/gcc-2.95.3/bin/gcc' CFLAGS='' CXX='/usr/local/gcc-2.95.3/bin/g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jan 8 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.53/ --with-gnu-ld --without-berkeley-db --with-innodb --with-charset=latin1 --with-extra-charsets=complex --with-mysqld-user=mysql --enable-assembler CC=/usr/local/gcc-2.95.3/bin/gcc CPP=/usr/local/gcc-2.95.3/bin/cpp CXX=/usr/local/gcc-2.95.3/bin/g++ - 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
Application level security
Hi All, I'm writing a application that needs row level security in it so that only certain users can view/change etc. certain records. I know that MySQL currently does not have row level security, and when I've asked this list before I've been given some helpfull suggestions (although none of them would actually work for me). So I've decided that the only way to go is to put the security logic into the application I am building. This works fine for my application, but means that if anyone connects directly to the server using the MySQL client etc, then they'll be able to see/update everything - making it a pretty weak security system. I've had two thoughts about this, but am willing to hear of any other thoughts people might have. One that I could do right now is to get my program to add something to the password of every user (users are created using the program and passwords can be changed using it too). This way if they try to connect to the server directly they won't have the extra bit on their passwords and it won't let them connect. The program could take care of adding this extra bit each time anything password related was needed so it shouldn't be a problem in this respect, however if anyone discovered the extra bit then it would be imposible to change the extra bit without giving everyone new passwords (which would be a real pain). A second way would be if there was like an application password in the security area that could be set and would be needed for connection - sort of like the ssl extra stuff that's been added recently. The downside of this is it isn't currently there and I'd need to convince someone at MySQL that it was worth adding and then wait for it to be added, the upside is that it would be easier to change if the application password was discovered. I've looked a little at the ssl/encryption stuff to see if I could use that but I don't think it can really help me achieve what I'm trying to achieve but if someone thinks it can I'd love to hear how. If anyone has any other ideas, can see problems that I haven't seen in the above ideas then I'd appreciate knowing. Are there any others having this problem (or is it just me!)? Thanks for your thoughts, cheers, noel - 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: Recovery with binary logs.
Hi Manuel, On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote: Hi, I have a few questions regarding recovery of a database using binary logs. 1) If you have a set of binary logs in your directory mylog-bin.001 to mylog-bin.nmp, is there an easy way to find out which logs you need to run since the last backup? In other words, when according to the instructions, after replacing the database files with the backup ones, you run the command: mysqlbinlog mylog-bin.[0-9]* | mysql does it know automatically which set to include so as to not incorporate logs that are too old? Or do we have to manually perform a selection? If so, is there a way to figure out easily the subset if one has not been watching it? At the time of backup, you need to record the master position of the server you are backing up - or perform reset master, but this might threaten your recovery if you have a failure during the current backup process and have to roll-forward from your previous dump (requiring the binary logs that reset master have just deleted). If you record the master position (file name, offset) during your dump, you need to ensure all tables involved in the dump are locked. mysqlhotcopy can do all this for you, see the --record_log_pos option. Unfortunately, mysqlhotcopy only works on Unix-like OSes, and so you will need to roll your own if your OS is not supported. 2) If a loss of data has been caused by an unwanted statement like DROP DATABASE... or DROP TABLE VeryImportantOne, how can one delete that statement from the bin-log before using it for recovery and repeat the mistake? You could write the output of mysqlbinlog to file, edit the file, and then pipe the file into the mysql monitor: mysqlbinlog mylog-bin.[0-9]* file.sql edit file.sql mysql file.sql good luck, Martin - 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: Bug Report: Replication in 4.0.5beta
Michael, - Original Message - From: Michael Ryan [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, November 28, 2002 12:34 PM Subject: Bug Report: Replication in 4.0.5beta The environment info was copied from the mysqlbug command by our external hosting company who truncated the lines therefore the last couple of characters from each line is not there however it was a Solaris 2.8 binary download of 4.0.5beta so you would have all of the info anyway. Description: I am using MySQL 4.0.5beta on Solaris 2.8 from a binary version downloaded from www.mysql.com on the 19th of November 2002. I have one database set up as the master database and 2 databases set up as slave databases. Each database is on a separate SUN server. I am performing intense load testing on MySQL replicated databases using InnoDB tables and transactions and I have come across what is most likely a bug. The replication is failing on the slaves with the following error (this appears both slaves error logs at the same time) :- 021127 13:48:28 Error in Log_event::read_log_event(): 'Event too big', data_len=1397639424,event_type=111 021127 13:55:36 Error in Log_event::read_log_event(): 'Event too big', data_len=1397639424,event_type=111 this definitely looks like a bug in replication. From New Zealand we got the following bug report, which might be connected to this: 02 18:32:54 Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (server_errno=2000) Above errors might happen if the pointer to the binlog becomes displaced. It will then read garbage from the event length field. I think a transaction can consist of many log events. I will run tests on our SunOS-5.8 computer to see if I can repeat this bug. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query ... BBCi at http://www.bbc.co.uk/ - 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: Application level security
Noel, I'm sorry if this is obvious, but have you considered putting a firewall in the way? If your application is on the same machine as the database, block all connections except to the port your application runs on (ie probably 80 if it's a web application)? The firewall will block connections from any machine to the database, and only local connections can be made to it. If your database is on another machine, protect the database server with the firewall so that only your application server can connect to the mysql server (or configure it so only certain other trusted hosts can too). Andy -Original Message- From: Noel Clarkson [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 11:10 To: [EMAIL PROTECTED] Subject: Application level security Hi All, I'm writing a application that needs row level security in it so that only certain users can view/change etc. certain records. I know that MySQL currently does not have row level security, and when I've asked this list before I've been given some helpfull suggestions (although none of them would actually work for me). So I've decided that the only way to go is to put the security logic into the application I am building. This works fine for my application, but means that if anyone connects directly to the server using the MySQL client etc, then they'll be able to see/update everything - making it a pretty weak security system. I've had two thoughts about this, but am willing to hear of any other thoughts people might have. One that I could do right now is to get my program to add something to the password of every user (users are created using the program and passwords can be changed using it too). This way if they try to connect to the server directly they won't have the extra bit on their passwords and it won't let them connect. The program could take care of adding this extra bit each time anything password related was needed so it shouldn't be a problem in this respect, however if anyone discovered the extra bit then it would be imposible to change the extra bit without giving everyone new passwords (which would be a real pain). A second way would be if there was like an application password in the security area that could be set and would be needed for connection - sort of like the ssl extra stuff that's been added recently. The downside of this is it isn't currently there and I'd need to convince someone at MySQL that it was worth adding and then wait for it to be added, the upside is that it would be easier to change if the application password was discovered. I've looked a little at the ssl/encryption stuff to see if I could use that but I don't think it can really help me achieve what I'm trying to achieve but if someone thinks it can I'd love to hear how. If anyone has any other ideas, can see problems that I haven't seen in the above ideas then I'd appreciate knowing. Are there any others having this problem (or is it just me!)? Thanks for your thoughts, cheers, noel - 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
adding values together
Hi, doeas anyone know if it's possible to add 2 or more numeric values together that are in the same cell in Mysql: IE: i have a cloumn called price that for any entry may contain more than one value, lets say £1.00 and £2.00 Is there a way that i can get these values added together ? I know it's easy if they are in separate rows but unfortunately they're not. see the example iditemprice 1 apple 1.00 2 apple 1.00 pear2.00 3 banana 1.00 I need to get the sum for price for id 2. Regards, Steve Mansfield Head of Development [EMAIL PROTECTED] http://www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford Essex RM7 8AP [Office] 0870 757 7900 [Fax] 0870 757 8900 http://www.be-an-isp.comhttp://www.isdn4free.co.ukhttp://signup.getreal.co.uk For our email disclaimer please see the url below. http://www.getreal.co.uk/disclaimer.htm - 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: adding values together
On Thu, Nov 28, 2002 at 12:48:29PM +, Steve Mansfield wrote: Hi, doeas anyone know if it's possible to add 2 or more numeric values together that are in the same cell in Mysql: IE: i have a cloumn called price that for any entry may contain more than one value, lets say £1.00 and £2.00 Is there a way that i can get these values added together ? I know it's easy if they are in separate rows but unfortunately they're not. see the example iditemprice 1 apple 1.00 2 apple 1.00 pear2.00 3 banana 1.00 I need to get the sum for price for id 2. It looks like your 'id' column is not unique, but is used to group several rows (apples and pears) together. In that case, you can use: SELECT id, SUM(price) FROM mytable WHERE id = 2 GROUP BY id; Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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: adding values together
You appear to be violating the repeating value rules of relational database. Multivalue databases (Pick and Pick like) support this concept but they are rather uncommon now. You probably need to create a related table. Actually, you might want to do a little study on the general idea of relational databases. Not meaning to be negative here because nobody is born with the knowledge. BobJ Mentioning MySQL to avoid being filtered. - Original Message - From: Steve Mansfield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 7:48 AM Subject: adding values together Hi, doeas anyone know if it's possible to add 2 or more numeric values together that are in the same cell in Mysql: IE: i have a cloumn called price that for any entry may contain more than one value, lets say £1.00 and £2.00 Is there a way that i can get these values added together ? I know it's easy if they are in separate rows but unfortunately they're not. see the example iditemprice 1 apple 1.00 2 apple 1.00 pear2.00 3 banana 1.00 I need to get the sum for price for id 2. Regards, Steve Mansfield Head of Development [EMAIL PROTECTED] http://www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford Essex RM7 8AP [Office] 0870 757 7900 [Fax] 0870 757 8900 http://www.be-an-isp.comhttp://www.isdn4free.co.uk http://signup.getreal.co.uk For our email disclaimer please see the url below. http://www.getreal.co.uk/disclaimer.htm - 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
Error No: 2013. Lost Connection MySQL server during query
Hi all, I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru win2000 with using any Front End applications (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am getting the same error message: Error No: 2013 Lost Connection MySQL server during query. I am being crazy. On the server side each connection try is leaving a paragraph in the /var/log/mysqld.log just like: Number of processes running now:1 mysqld process hanging, pid 2 - killed 022323 15:02:24 mysqld restarted /user/libexec/mysqld: ready for connection I am dying to see any database or table with establishing this connection. Is there anybody will help me? Sincerely. Cem Yagli key words: sql, query - 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
info about an old version (v. 3.22.32)
Hi. One of my friend, with MySQL v. 3.22.32 and with this commands : CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) have this error: MySQL complains: Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Can someone tell me from which version is it true? thank you in advance! bye bye! MAS! -- Marco Andriolo-Stagno (MAS!) [EMAIL PROTECTED] PROSA - free software - http://www.prosa.it FreeGO! - free software news - http://www.freego.it - 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
MysqlGui Crash
Dear Mr. / Mrs, After we installed MySQL Server 3.23.51 for Windows and MySQL Gui 1.7.5-2. We used a ODBC driver to write data into the database on the MySQL Server. When there are more then 250.000 records in the table the MySQL Gui crashed. Our Question now is there a solution for our problem? We hope you can help us. Sincerely, Kees de Vries Wim Klomp Koldijk B.V Zwolle (Sorry for the bad English) - 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
LOAD DATA LOCAL INFILE
Hello all --- I posted this yesterday, perhaps before my subscription took effect, and so I am not sure that it got distributed. So, forgive the repetition in sending, if that's the case. Anyway . . . Here's the question, as succinctly as I can formulate it: The documentation seems to say that one can load a tab-delimited text file located in the current directory of the client host into a database by running the client mysql and executing the following command: mysql LOAD DATA LOCAL INFILE absence.txt into table absence; When absence.txt is located in /Users/jack/Desktop/SQL_stuff/samp_db/, then the command: mysql LOAD DATA LOCAL INFILE /Users/jack/Desktop/SQL_stuff/samp_db/ absence.txt into table absence; does work. But the command: mysql LOAD DATA LOCAL INFILE absence.txt into table absence; does not work. Rather, it produces the error: ERROR: File 'absence.txt' not found (Errcode: 2) That is, absolute pathnames work, but relative pathnames do not. I have been careful to be sure that, when invoking the mysql client, I am in the correct directory, and that when I invoke mysql, that I include the --local-infile option, as the following printout shows: [Jacks-G4:~/Desktop/SQL_stuff/samp_db] jack% mysql --local-infile samp_db Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 3.23.52-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql LOAD DATA LOCAL INFILE absence.txt into table absence; ERROR: File 'absence.txt' not found (Errcode: 2) I have concluded that one cannot use the relative pathname of a file in the LOAD DATA LOCAL INFILE command. I hope I am wrong, as it would be nice to use the simpler, relative, pathname. With thanks for your replies, am I wrong or right? If wrong, what am I missing? Jack Connolly Hanover, MA [EMAIL PROTECTED] Running, on Mac OS 10.2, server and client on same machine: ++ | version() | ++ | 3.23.52-entropy.ch | ++ - 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
[Fwd: possible problems with FLUSH TABLES WITH READ LOCK]
Sorry to insist, but nobody has any clues about this ? I can supply further info if needed. Is the FLUSH TABLES WITH READ LOCK functionality well tested ? Having corrupted backups is annoying, and I can't really take the system down for a 4-hour tape backup... ;( Message original Sujet: possible problems with FLUSH TABLES WITH READ LOCK De: Antoine [EMAIL PROTECTED] Date: Mar, 26 Novembre 2002, 17:27 A: [EMAIL PROTECTED] Hi, I am using FLUSH TABLES WITH READ LOCK to get consistent snapshots of my database without shutting it down. The setup is : - bi-P4 Xeon with Redhat 7.3 - 2.4.19 kernel with properly patched LVM (compiled from source) - MySQL server 4.0.4 (compiled from source) - ext3 filesystem on a 44 GB LVM logical volume named /dev/vgdata/data - the whole database is 20 GB in size - all tables are MYISAM ; some with dynamic records, some fixed, some compressed - some tables - not all - are created with DELAYED_KEY_WRITE=1 to get more speed (30% faster thanks to this) The backup sequence is : - FLUSH TABLES WITH READ LOCK - lvcreate -L 5G -c 256k -s -n backup /dev/vgdata/data (this creates a 5GB snapshot volume named backup from the logical volume containing the database) - UNLOCK TABLES - mount /dev/vgdata/backup /backup -oro,noatime - cd /backup/ ; tar cvf /dev/st0 * Today I've tried restoring a backup on a test partition just to see (you're never too careful). Restoring is OK (of course) but when I run myisamchk -c *.MYI, just to be sure, I get various kinds of errors, on some tables but not all. Common errors include : 1 clients is using or hasn't closed the table properly error: Size of indexfile is: 17404928Should be: 17507328 warning: Size of datafile is: 24922872Should be: 24896378 error: Found 185731 keys of 186676 error: Found key at page 1024 that points to record outside datafile In fact, all kind of errors that you'd expect to find if you copy your files without doing a FLUSH TABLES WITH READ LOCK first. Thus I was wondering if the latter command does work properly. Is it likeky to be due to : - SMP problems ? (it has hyperthreading enabled, BTW, but this shouldn't make any further difference : it just sees 4 logical CPUs instead of 2) - DELAYED_KEY_WRITE ? (but some tables that aren't created as such have problems too, so this shouldn't be the _only_ problem) - specific Linux locking behaviour wrt flushing locking tables ? - Linux LVM bug ? (unlikely in my opinion, it seems heavily used) - other... ? Please note : tables are written to in a continuous way, so it's no surprise many tables get corrupted if the lock is not absolutely consistent and fail-proof ;)) Also, I know the backup volume is large enough (I print the occupied size at the end of the backup procedure). Well, of course, it may just be the backup tape itself that was screwed up, but it doesn't seem very likely, at least in my opinion, otherwise un-tar-ing it should have failed somewhere. What do you think ? Thank you Regards, Antoine. - 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: info about an old version (v. 3.22.32)
* Marco Andriolo-Stagno One of my friend, with MySQL v. 3.22.32 and with this commands : CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) have this error: MySQL complains: Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Yes. Can someone tell me from which version is it true? From 3.23.0: URL: http://www.mysql.com/doc/en/News-3.23.0.html -- Roger - 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: LOAD DATA LOCAL INFILE
The MySQL Manual states the following in the LOAD DATA INFILE section :- If a filename with no leading components is given, the server looks for the file in the database directory of the current database. -Original Message- From: John Connolly [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 14:12 To: [EMAIL PROTECTED] Subject: LOAD DATA LOCAL INFILE Hello all --- I posted this yesterday, perhaps before my subscription took effect, and so I am not sure that it got distributed. So, forgive the repetition in sending, if that's the case. Anyway . . . Here's the question, as succinctly as I can formulate it: The documentation seems to say that one can load a tab-delimited text file located in the current directory of the client host into a database by running the client mysql and executing the following command: mysql LOAD DATA LOCAL INFILE absence.txt into table absence; When absence.txt is located in /Users/jack/Desktop/SQL_stuff/samp_db/, then the command: mysql LOAD DATA LOCAL INFILE /Users/jack/Desktop/SQL_stuff/samp_db/ absence.txt into table absence; does work. But the command: mysql LOAD DATA LOCAL INFILE absence.txt into table absence; does not work. Rather, it produces the error: ERROR: File 'absence.txt' not found (Errcode: 2) That is, absolute pathnames work, but relative pathnames do not. I have been careful to be sure that, when invoking the mysql client, I am in the correct directory, and that when I invoke mysql, that I include the --local-infile option, as the following printout shows: [Jacks-G4:~/Desktop/SQL_stuff/samp_db] jack% mysql --local-infile samp_db Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 3.23.52-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql LOAD DATA LOCAL INFILE absence.txt into table absence; ERROR: File 'absence.txt' not found (Errcode: 2) I have concluded that one cannot use the relative pathname of a file in the LOAD DATA LOCAL INFILE command. I hope I am wrong, as it would be nice to use the simpler, relative, pathname. With thanks for your replies, am I wrong or right? If wrong, what am I missing? Jack Connolly Hanover, MA [EMAIL PROTECTED] Running, on Mac OS 10.2, server and client on same machine: ++ | version() | ++ | 3.23.52-entropy.ch | ++ - 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 BBCi at http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system, do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this. - 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 crashed
mysql 4.0.5a binary crashed with following error messages. What's the problem? :( 021128 11:06:23 Slave I/O thread: connected to master 'austin@atis1:3306', replication started in log 'FIRST' at position 4 021128 17:35:52 Slave: received 0 length packet from server, apparent master shutdown: 021128 17:35:52 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'atis1-bin.036' position 754 021128 17:35:52 Slave I/O thread: error reconnecting to master 'austin@atis1:3306': Error: 'Can't connect to MySQL server on 'atis1' (111)' errno: 2003 retry-time: 60 retries: 86400 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268431360 read_buffer_size=1044480 sort_buffer_size=1048568 max_used_connections=1 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 466539 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x86efad0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe3f2d8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80ad5a5 0x80ae086 0x80e234a 0x80e2e4a 0x82657cc New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=4 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 4 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 2 -- Chung Ha-nyung alita@[neowiz.com|kldp.org] SayClub http://www.sayclub.com NeoWiz http://www.neowiz.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
ANN: EMS MySQL Utils 1.1 released!
EMS HiTech Company is announcing the next version (1.1) of MySQL Utils -- Powerful Windows/Linix Data Management Utilities for MySQL Server. You can download the latest version from http://www.mysqlutils.com/download.phtml What's new in version 1.1? 1. MySQL Import: possibility of defining scripts (for each used database) to execute before and after import added. 2. MySQL Export/Import: Possibility of entering the database name manually added. 3. MySQL Import: now history of opened templates is being saved and you can quickly load the needed template by selecting it from the list. 4. MySQL Import: some new preferences are now available for customization. 5. MySQL Export: wizard interface improved. 6. MySQL Export: some export algorithms were optimized. 7. MySQL Export/Import: Several improvements and small bugfixes. What are EMS MySQL Utils? EMS MySQL Utils are powerful cross-platform data management utilities for MySQL Server, which make your work with the server much easier and faster. Currently MySQL Utils include MySQL Export - a powerful tool for MySQL data export, and MySQL Import - an utility for quick importing data to MySQL tables. What is EMS MySQL Export? EMS MySQL Export is a cross-platform (Windows and Linux) program to export your data quickly from MySQL databases to any of 12 available formats, including MS Excel, MS Word, HTML, TXT, and more. MySQL Export includes a wizard, which allows you to set export options for each table visually (destination filename, exported fields, data formats, and many more) and a command line utility to export data from tables and queries in one-touch. What is EMS MySQL Import? EMS MySQL Import is a powerful cross-platform (Windows and Linux) tool to import your data quickly from MS Excel, MS Access, DBF, TXT and CSV files to MySQL tables. MySQL Import includes a wizard, which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch. We hope you'll enjoy working with our software. Thank you for your attention. Best regards, EMS HiTech development team http://www.ems-hitech.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: Re: MySQL secure access
Alice, Thursday, November 28, 2002, 8:29:14 AM, you wrote: AT i did create those databases in different databases directories. AT i saw there r columns_priv, db, host, tables_priv and user tables in the AT mySQL database directory. Is all these tables control the user data access ? Yes. AT and how ? Each of the table contains info about user privileges on different levels: global level, database level, table level etc. For more info check the docs: http://www.mysql.com/doc/en/Privileges_provided.html http://www.mysql.com/doc/en/GRANT.html http://www.mysql.com/doc/en/Privileges.html grant privileges to users on table only within a specific database. AT can u specify more detail on that ?? You can give needed permissions on the certain database. I.e. user will have grants on the all tables in the database. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: replication and if not exists temporary tables
puckman, Thursday, November 28, 2002, 12:46:15 PM, you wrote: patdc A website we recently built contains a highscore table. People play a game, and can then submit their name and score to the table. patdc When viewing the table, I then need to rank the scores using an order by... However since I want to be able to only select arbitrary intervals in the ranks (I want to ask the question show patdc me position 200-300), I figured I needed to use a temporary table. patdc All my tables are innodb tables. patdc I'm doing this in Java using the mm.mysql-2.0.14 driver. patdc I'm using MySQL 3.23.53. patdc The SQL I then got is: patdc 1. create temporary table if not exists patdc Highscores_result ( position int, name varchar(255), patdc country varchar(255), score int ) patdc type=innodb; patdc 2. delete from Highscores_result; patdc 3. set @n=0; patdc 4. insert into Highscores_result patdc select @n:=@n+1 as rownum, name, country, score patdc from Highscores order by score desc; patdc I grab a connection, set autocommit to false, create a statement (not patdc prepared) and then do stmt.addBatch() for each of the statements, execute, and then commit(). patdc And then I can read out say position 200-300 from the temporary table. patdc The MySQL instance that runs this have got two replication slaves. One which is constantly connected, and one which connects every night for nightly backups. The one which is constantly patdc connected works fine and keeps replicating. patdc However the one connecting every night always stops the slave thread with a: patdc ERROR: 1146 Table 'foo.Highscores_result' doesn't exist patdc 021127 20:00:03 Slave: error running query 'delete from Highscores_result' 021127 20:00:03 Error running query, slave aborted. Fix the problem, and re-start the slave thread with patdc mysqladmin start-slave. We stopped at log 'master-bin.018' position 566235 021127 20:00:03 Slave thread exiting, replication stopped in log 'master-bin.018' at position 566235 patdc Hypothesis: patdc Could this be down to that temporary tables are connection unique and I'm killing my connection every now and then, and that the slave does not actually create a table on create table if not patdc exists if the master didn't create it. E.g. master log looks something like: patdc - CREATE TABLE IF NOT EXISTS (Creates table on master since it doesn't patdc exist) patdc - DELETE FROM patdc - SET patdc - INSERT patdc -- I disconnect my slave patdc -- I reconnect my slave patdc - CREATE TABLE IF NOT EXISTS (Doesn' create on slave since it existed on the master) patdc - DELETE FROM patdc - SET patdc - INSERT How-To-Repeat: patdc Set up a replication slave that disconnects and reconnects using cron. Run the patdc above kind of SQL. Sorry, but I was unable to repeat it as you describe. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: info about an old version (v. 3.22.32)
Marco, Thursday, November 28, 2002, 3:36:22 PM, you wrote: MAS One of my friend, with MySQL v. 3.22.32 and with this commands : MAS CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name MAS varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) MAS have this error: MAS MySQL complains: MAS Column 'con' is used with UNIQUE or INDEX but is not defined as NOT MAS NULL MAS I have v. 3.23.53-log and with the same statment I have no error; I MAS guess because the new version add 'not null' automagically. MAS Is it right? Yes, exactly. MAS Can someone tell me from which version is it true? From the change logs: Using AUTO_INCREMENT will now automatically make the column NOT NULL. http://www.mysql.com/doc/en/News-3.23.0.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: LOAD DATA LOCAL INFILE
John, Thursday, November 28, 2002, 2:12:27 AM, you wrote: JC Here's the question, as succinctly as I can formulate it: JC The documentation seems to say that one can load a tab-delimited text JC file located in the current directory of the client host into a JC database by running the client mysql and executing the following JC command: JC mysql LOAD DATA LOCAL INFILE absence.txt into table absence; JC When absence.txt is located in JC /Users/jack/Desktop/SQL_stuff/samp_db/, then the command: JC mysql LOAD DATA LOCAL INFILE /Users/jack/Desktop/SQL_stuff/samp_db/ JC absence.txt into table absence; JC does work. JC But the command: JC mysql LOAD DATA LOCAL INFILE absence.txt into table absence; JC does not work. Rather, it produces the error: JC ERROR: JC File 'absence.txt' not found (Errcode: 2) JC That is, absolute pathnames work, but relative pathnames do not. JC I have been careful to be sure that, when invoking the mysql client, I JC am in the correct directory, and that when I invoke mysql, that I JC include the --local-infile option, as the following printout shows: JC [Jacks-G4:~/Desktop/SQL_stuff/samp_db] jack% mysql --local-infile JC samp_db JC Reading table information for completion of table and column names JC You can turn off this feature to get a quicker startup with -A JC Welcome to the MySQL monitor. Commands end with ; or \g. JC Your MySQL connection id is 14 to server version: 3.23.52-entropy.ch JC Type 'help;' or '\h' for help. Type '\c' to clear the buffer. JC mysql LOAD DATA LOCAL INFILE absence.txt into table absence; JC ERROR: JC File 'absence.txt' not found (Errcode: 2) JC I have concluded that one cannot use the relative pathname of a file JC in the LOAD DATA LOCAL INFILE command. I hope I am wrong, as it would JC be nice to use the simpler, relative, pathname. JC Am I wrong or right? If wrong, what am I missing? If you don't use absolute pathname, your file must be located in the client program/script directory (in your case mysql client program) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
Reversing mysql_fix_privilege_tables ?
I have upgraded from 3.23 to 4.0 and I have read over http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I really want to since I intend to implement query quotas. Since this is a production server I'm concerned about any side effects of this script. Is this a very straightforward operation? Are there any side effects or bugs I should be aware of? Finally, is it possible to reverse the script and go back to the old 3.23 permissions in the event of a problem? (note, I can't just save copies of the tables because new users are added often) Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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
insecure chrooting from mysqld
Hey, The chroot command line option of mysqld is insecure. Databases which are located for instance not in the chroot path can be accessed! More information can be found at http://www.linuxquestions.org/questions/showthread.php?s=threadid=34314 http://www.linuxquestions.org/questions/showthread.php?s=threadid=34338 -- __ Linux From Scratch user www.linuxfromscratch.org __ - 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: Reversing mysql_fix_privilege_tables ?
At 10:50 -0500 11/28/02, Gary Huntress wrote: I have upgraded from 3.23 to 4.0 and I have read over http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I really want to since I intend to implement query quotas. Since this is a production server I'm concerned about any side effects of this script. Is this a very straightforward operation? Are there any side effects or bugs I should be aware of? Finally, is it possible to reverse the script and go back to the old 3.23 permissions in the event of a problem? (note, I can't just save copies of the tables because new users are added often) You should read through the script carefully to see what it does, and assess whether it's actions are likely to cause you problems. Several changes were made in 4.0.2 and after that you should consider. New privileges were added in 4.0.2, but a couple of these weren't added to the db table until 4.0.4, so you should *avoid* using 4.0.2 or 4.0.3. Also, some operations now are handled by different privileges. For example, KILL now requires SUPER rather than PROCESS. If you create new users and give them SUPER, reverting may require shifting SUPER back to PROCESS. Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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
Re: replication, multiple masters
On Mon, Nov 25, 2002 at 06:02:19PM -0600, Andy Bakun wrote: I have successfully configured two mysql instances to replicate to each other (According to /doc/en/Replication_Features.html, it is possible to do it in a A-B-C-A relationship, but I only did it with two servers and I don't have log-slave-updates on (I think if I did, it would immediately stop the slave thread as the updates get caught in a loop). Err, no. MySQL prevents that looping as long as each server has a unique server-id. It's very slick, updates on either server get propagated to the other server. I have not stress tested it yet, and my (simple) application only does updates to a single server at a time. The only problem is the auto_increment columns in the tables. Updates that occur on both machines at the same time, that generate the same auto_increment value, causes the slave threads to die: and rightly so. I can, of course, program my application to generate non-conflicting, server independant key values without the need for the auto_increment, but has anyone had any experience with this? Is this really the only impediment to doing full two-way replication? That's the big limitation, yes. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 8 days, processed 268,724,961 queries (374/sec. avg) - 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: Multi-slave master
On Tue, Nov 26, 2002 at 09:39:04AM -0500, Michael T. Babcock wrote: Is there any plan to be able to have multiple slaves for a master (each for different databases)? You can do that today. I'd like to have a backup site that remotely replicates user data from multiple sites ... any ideas? Oh, that sounds like multiple masters for a single slave. Is that what you're getting at? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 8 days, processed 268,759,523 queries (374/sec. avg) - 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: Application level security
I've done a similar work in 1997 for one of my clients. The password method will be just part of the security system. But you may want to consider to implement the RBAC in the database. In that way, the users whether they are applications, e.g., business objects, DB interactive tool by human user, or so, will only access to the subset of database based on thier privileges by using ACLs which are also based on the defined security policy in the database. In addition, you may want to use the Asymmetric encryption for some data that needs to be considered a higher security. Pae Hi All, I'm writing a application that needs row level security in it so that only certain users can view/change etc. certain records. I know that MySQL currently does not have row level security, and when I've asked this list before I've been given some helpfull suggestions (although none of them would actually work for me). So I've decided that the only way to go is to put the security logic into the application I am building. This works fine for my application, but means that if anyone connects directly to the server using the MySQL client etc, then they'll be able to see/update everything - making it a pretty weak security system. I've had two thoughts about this, but am willing to hear of any other thoughts people might have. One that I could do right now is to get my program to add something to the password of every user (users are created using the program and passwords can be changed using it too). This way if they try to connect to the server directly they won't have the extra bit on their passwords and it won't let them connect. The program could take care of adding this extra bit each time anything password related was needed so it shouldn't be a problem in this respect, however if anyone discovered the extra bit then it would be imposible to change the extra bit without giving everyone new passwords (which would be a real pain). A second way would be if there was like an application password in the security area that could be set and would be needed for connection - sort of like the ssl extra stuff that's been added recently. The downside of this is it isn't currently there and I'd need to convince someone at MySQL that it was worth adding and then wait for it to be added, the upside is that it would be easier to change if the application password was discovered. I've looked a little at the ssl/encryption stuff to see if I could use that but I don't think it can really help me achieve what I'm trying to achieve but if someone thinks it can I'd love to hear how. If anyone has any other ideas, can see problems that I haven't seen in the above ideas then I'd appreciate knowing. Are there any others having this problem (or is it just me!)? Thanks for your thoughts, cheers, noel - 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
LOAD DATA LOCAL INFILE
Victoria and Michael: Thanks very much. Following on your suggestions, I then went ahead and put the text file into my directory: /usr/local/mysql so that the file was then /usr/local/mysql/absence.txt and, with that done, the LOAD DATA LOCAL INFILE absence.txt into table absence; command in the mysql client successfully did load it. (It didn't work when put into the /usr/local/mysql/scripts directory or in the /usr/local/mysql/data directory.) Is there anyway to change the place where the client looks when given the relative pathname of a file to be LOADed, or is one stuck with having to put all text files in that one immutable location? (On the Mac, we aren't allowed to see the contents of /usr/local/mysql/ in the GUI. We have to access it through the UNIX Terminal program, and then fiddle with permissions, which, I am not bashful to say, I am reluctant to start doing without comprehending the implications, which, I also am not bashful to say, I don't.) Thanks again. Best, Jack Connolly Hanover, MA P.S. -- Is this how I am supposed to reply to responses, i.e., by directing them back to the list, as opposed to the individual? Thnx, J. On Thursday, November 28, 2002, at 09:23 AM, Michael Ryan wrote: The MySQL Manual states the following in the LOAD DATA INFILE section :- If a filename with no leading components is given, the server looks for the file in the database directory of the current database. On Thursday, November 28, 2002, at 10:42 AM, Victoria Reznichenko wrote: John, Thursday, November 28, 2002, 2:12:27 AM, you wrote: JC Here's the question, as succinctly as I can formulate it: JC The documentation seems to say that one can load a tab-delimited text JC file located in the current directory of the client host into a JC database by running the client mysql and executing the following JC command: JC mysql LOAD DATA LOCAL INFILE absence.txt into table absence; JC When absence.txt is located in JC /Users/jack/Desktop/SQL_stuff/samp_db/, then the command: JC mysql LOAD DATA LOCAL INFILE /Users/jack/Desktop/SQL_stuff/samp_db/ JC absence.txt into table absence; JC does work. JC But the command: JC mysql LOAD DATA LOCAL INFILE absence.txt into table absence; JC does not work. Rather, it produces the error: JC ERROR: JC File 'absence.txt' not found (Errcode: 2) JC That is, absolute pathnames work, but relative pathnames do not. JC I have been careful to be sure that, when invoking the mysql client, I JC am in the correct directory, and that when I invoke mysql, that I JC include the --local-infile option, as the following printout shows: JC [Jacks-G4:~/Desktop/SQL_stuff/samp_db] jack% mysql --local-infile JC samp_db JC Reading table information for completion of table and column names JC You can turn off this feature to get a quicker startup with -A JC Welcome to the MySQL monitor. Commands end with ; or \g. JC Your MySQL connection id is 14 to server version: 3.23.52-entropy.ch JC Type 'help;' or '\h' for help. Type '\c' to clear the buffer. JC mysql LOAD DATA LOCAL INFILE absence.txt into table absence; JC ERROR: JC File 'absence.txt' not found (Errcode: 2) JC I have concluded that one cannot use the relative pathname of a file JC in the LOAD DATA LOCAL INFILE command. I hope I am wrong, as it would JC be nice to use the simpler, relative, pathname. JC Am I wrong or right? If wrong, what am I missing? If you don't use absolute pathname, your file must be located in the client program/script directory (in your case mysql client program) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 - 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:
numbers of similar rows
Hello! pre I have MySQL database with data like name points a20 b20 c19 d18 e18 is it possible to get with mysql commands ONLY outpt place repeatings name points 1 2 a 20 1 2 b 20 3 1 c 19 4 2 d 18 4 2 e 18 /pre first column shows how many persons have beter points +1 second column shows how many records have same number of points --- Urmas Buhvestov e-mail: [EMAIL PROTECTED] WWW: http://www.tamme.tartu.ee/~urmas/ - 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: insecure chrooting from mysqld
Hi! On Nov 28, Markus wrote: Hey, The chroot command line option of mysqld is insecure. Databases which are located for instance not in the chroot path can be accessed! Fixed, thanks. More information can be found at http://www.linuxquestions.org/questions/showthread.php?s=threadid=34314 http://www.linuxquestions.org/questions/showthread.php?s=threadid=34338 I always wondered why people spend so much time discussing a bug and developing various howto and workarounds, instead of submitting a bugreport and having the bug fixed in one hour. :)) Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: insecure chrooting from mysqld
Hey, Fixed, thanks. Good to know. Anyways I'll check it out in the next release! I always wondered why people spend so much time discussing a bug and developing various howto and workarounds, instead of submitting a bugreport and having the bug fixed in one hour. :)) I submitted the bug once I found it ... maybe my ISP has had some mail problems! Anyways good to know it's fixed and people care about security in MySQL ;) -- __ Linux From Scratch user #6371 May the sources be with you! www.linuxfromscratch.org __ - 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: Multi-slave master
On Thu, Nov 28, 2002 at 08:39:06AM -0800, Jeremy Zawodny wrote: I'd like to have a backup site that remotely replicates user data from multiple sites ... any ideas? Oh, that sounds like multiple masters for a single slave. Is that what you're getting at? Yes, sorry, I rephrased it incorrectly. SQL ... -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - 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: Multi-slave master
On Thu, Nov 28, 2002 at 02:35:15PM -0500, Michael T. Babcock wrote: On Thu, Nov 28, 2002 at 08:39:06AM -0800, Jeremy Zawodny wrote: I'd like to have a backup site that remotely replicates user data from multiple sites ... any ideas? Oh, that sounds like multiple masters for a single slave. Is that what you're getting at? Yes, sorry, I rephrased it incorrectly. Yeah, the only way to do that today is to run multiple *instances* of MySQL on the same physical machine. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 8 days, processed 270,958,224 queries (372/sec. avg) - 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
a little help please
i was trying to install mysqlcc and when i execute setup.exe icon it shows me as follow: windows installer service cannot install the installation package. You must install a windoes service pack with a most recent version of the wimdoes installer service . My OS is windows 98 and i downloaded the respetive file: mysqlcc-0.8.6-win32.zip. thanks for your collaboration. Carlos Daniel - 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
Users and Databases
Hi everyone, Please pardon my extreme case of the NEWBs on this but I need some help please. Ok I just purchased a book to hopefully clear things up for me, but to no avail. So this is my dilemma: I want to know about MySQL administration, specifically the user management portion of the admining. I want to be able to allow users to create whatever DBs they need. One DB for my Multi-media collection, one for an address book, one DB for links for a web site. Whatever the case may be! But it seems like I can't give a user the option to create and/or delete any DBs that only user X made. So I the admin would have to create each DB and assign appropriate privileges to appropriate users? So to sum up my situation into a question: Is it possible for me to give a user the ability to create and/or delete only their DBs? Or do I have to make the DB for them and then Grant appropriate privileges for that user to that DB? Thanx in advance for the help __ 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
Re: adding values together
On Thursday, November 28, 2002, at 08:06 AM, BobJ wrote: You appear to be violating the repeating value rules of relational database. Multivalue databases (Pick and Pick like) support this concept but they are rather uncommon now. You probably need to create a related table. Actually, you might want to do a little study on the general idea of relational databases. Not meaning to be negative here because nobody is born with the knowledge. Not only is it true that not many are born with it, but not many are even aware it exists! I say this only because I used mysql for a couple years before starting college this September, and after just a few weeks in my Relational DB Development 1 class, I found it amazing how much there is in the field that people just don't know about. It feels good to not blindly throw keys and such around, and to be able to understand normalization. -- Chris Garaffa [EMAIL PROTECTED] #exclude windows.h - 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: MySQL 4.0.5(a) is released
Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Lenz Grimmer [EMAIL PROTECTED] To: MySQL announce list [EMAIL PROTECTED] Cc: MySQL mailing list [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 10:41 PM Subject: MySQL 4.0.5(a) is released -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.5, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is a new beta development release, adding new features and fixing recently discovered bugs. This will be the last release labelled as beta - the upcoming MySQL 4.0.6 will be labelled gamma, which emphasizes the fact that the MySQL 4.0 code base has further stabilized and is becoming ready for productive use. To avoid confusion between the product names of the GPL and non-GPL (commercial) binaries, MySQL AB has now further refined the new naming scheme. Starting with MySQL 4.0.5 and onwards, the following binaries will be available: MySQL Standard (GPL) This is the recommended binary for most users that want to use MySQL under the terms of the GNU General Public License (GPL). It includes the InnoDB Storage Engine and all default features that are considered stable and useful enough for general usage. MySQL Max (GPL) This is an enhanced version of the Standard GPL package. In addition to the InnoDB Storage Engine, it includes additional features like the Berkeley DB (BDB) Storage Engine (certain platforms only) as well as other additional features that are either not exhaustively tested yet or not required for most users, e.g. OpenSSL (where available), User defined functions (UDFs), or BIG_TABLE support. When these features have matured and proven to be stable enough, they will be part of future versions of the Standard binaries. Please note, that not all of these features are included in all binaries. MySQL Classic (Commercial License) Similar to MySQL Standard, but *without* InnoDB and only available as a commercial licensed version. MySQL Pro (Commercial License) Similar to MySQL Standard (*including* InnoDB), but only available as a commercial licensed version. - From the 4.0.5 ChangeLog: Functionality added or changed: * Changed handling of last argument in `WEEK()' so that one can get week number according to the ISO 8601 specification. (Old code should still work). * Fixed that `INSERT DELAY' threads doesn't hang on `Waiting for INSERT' when one sends a `SIGHUP' to `mysqld'. * Change that `AND' works according to SQL ANSI99 when it comes to `NULL' handling. In practice, this only affects queries where you do something like `WHERE ... NOT (NULL AND 0)'. * `mysqld' will now resolve `basedir' to its full path (with `realpath()'). This enables one to use relative symlinks to the MySQL installation directory. This will however cause `show variables' to report different directories on systems where there is a symbolic link in the path. * Fixed that MySQL will not use an index scan on an index that has been disabled with `IGNORE INDEX' or `USE INDEX'. * Added `--use-frm' option to `mysqlcheck'. When used with `REPAIR', it gets the table structure from the `.frm' file, so the table can be repaired even if the `.MYI' header is corrupted. * Fixed bug in `MAX()' optimization when used with `JOIN' and `ON' expressions. * Added support for reading of MySQL 4.1 table definition files. * `BETWEEN' behaviour changed (*note Comparison Operators::). Now `datetime_col BETWEEN timestamp AND timespamp' should work as expected. * One can create `TEMPORARY' `MERGE' tables now. * `DELETE FROM myisam_table' now shrinks not only the `.MYD' file but also the `.MYI' file. * When one uses the `--open-files-limit=#' option to `mysqld_safe' it's now passed on to `mysqld'. * Changed output from `EXPLAIN' from `'where used'' to `'Using where'' to make it more in line with other output. * Removed variable `safe_show_database' as it was not used anymore. * Updated source tree to be built using `automake 1.5' and `libtool 1.4'. * Fixed an inadvertently changed option (`--ignore-space') back to the original `--ignore-spaces' in `mysqlclient'. (Both syntaxes will work). * Don't require `UPDATE' privilege when using `REPLACE'. * Allow braces in joins in all positions. Formerly,
Warning: Supplied argument is not a valid MySQL result resource
Hi I wonder if anyone can help or point me in the right direction for this problem. Warning: Supplied argument is not a valid MySQL result resource I get this while running index.php, the site did work then suddenly stopped, the index.php hasnt been changed. Machine : Cobalt RAQ4 _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - 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: Warning: Supplied argument is not a valid MySQL result resource
Hi It means you are refering to/using a result id that does not exist. Maybe the query changed or the database is down? Try echoing the query and the error echo mysql_error ( [resource link_identifier]) if not could you send more details to give us a little more to go on Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mark horn [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 22:41 To: [EMAIL PROTECTED] Subject: Warning: Supplied argument is not a valid MySQL result resource Hi I wonder if anyone can help or point me in the right direction for this problem. Warning: Supplied argument is not a valid MySQL result resource I get this while running index.php, the site did work then suddenly stopped, the index.php hasnt been changed. Machine : Cobalt RAQ4 _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - 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
Any help? SUM of type TIME in Query?
Have MySQL db with hundreds of thousands of event records from geographically dispersed logging devices. The logs are batched and auto loaded/parsed into MySQL on a daily/weekly basis depending on external factors. As an example, during a 7 period, one device provided 128,000 discrete events of 220 Types. The columns of primary interest are shown here. Col4 is generated by the logging devices as a duration/elapsed time in HH:MM:SS format and is the column of interest in this problem. An abbreviated table of the columns (ordered and numbered for example only) and records looks like; Col1(Char), Col2 (DATE),Col4(TIME) EventType1, -MM-DD HH:MM:SS, 09:53:05 EventType1, -MM-DD HH:MM:SS, 05:56:39 EventType1, -MM-DD HH:MM:SS, 05:53:36 EventType1, -MM-DD HH:MM:SS, 01:11:09 EventType1, -MM-DD HH:MM:SS, 22:48:12 EventType2, -MM-DD HH:MM:SS, 01:11:32 EventType2, -MM-DD HH:MM:SS, 22:48:46 ... etc. n+1 The shell query is: select cols, count(xy), (sum(col4)) as t_dura from db where xyz group by Col1 order by col1 The results using the above as an example would be: Col1 Char, xy, t_dura EventType1, 5, 442201 EventType2, 2, 235978 ... ... n+1 Can anyone provide insight into the SQL syntax to perform the sum and return the results as HH:MM:SS? Thanks - 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: Any help? SUM of type TIME in Query?
At 15:18 -0800 11/28/02, [EMAIL PROTECTED] wrote: Have MySQL db with hundreds of thousands of event records from geographically dispersed logging devices. The logs are batched and auto loaded/parsed into MySQL on a daily/weekly basis depending on external factors. As an example, during a 7 period, one device provided 128,000 discrete events of 220 Types. The columns of primary interest are shown here. Col4 is generated by the logging devices as a duration/elapsed time in HH:MM:SS format and is the column of interest in this problem. An abbreviated table of the columns (ordered and numbered for example only) and records looks like; Col1(Char), Col2 (DATE),Col4(TIME) EventType1, -MM-DD HH:MM:SS, 09:53:05 EventType1, -MM-DD HH:MM:SS, 05:56:39 EventType1, -MM-DD HH:MM:SS, 05:53:36 EventType1, -MM-DD HH:MM:SS, 01:11:09 EventType1, -MM-DD HH:MM:SS, 22:48:12 EventType2, -MM-DD HH:MM:SS, 01:11:32 EventType2, -MM-DD HH:MM:SS, 22:48:46 ... etc. n+1 The shell query is: select cols, count(xy), (sum(col4)) as t_dura from db where xyz group by Col1 order by col1 The results using the above as an example would be: Col1 Char, xy, t_dura EventType1, 5, 442201 EventType2, 2, 235978 ... ... n+1 Can anyone provide insight into the SQL syntax to perform the sum and return the results as HH:MM:SS? Sounds like you want: SEC_TO_TIME(SUM(TIME_TO_SEC(Col4))) That is, convert each time to seconds, sum the result, convert back to time. Thanks - 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: MySQL 4.0.5(a) is released
At 22:32 +0100 11/28/02, Stefan Hinz, iConnect (Berlin) wrote: Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? There is now a SHOW DATABASES privilege in the grant tables. Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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: DATETIME function to be used...
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a value of -MM-DD HH:MM:SS. Is this value in a form of string?? If I have a column described as DATETIME data type I should be able to do: INSERT INTO tablename VALUES (id#, 1997-10-10 24:45:32), right? but if I do SELECT * FROM tablename, I got userID DateTime 1 -00-00 00:00:00: DateTime column got the null value?! Please help thank you very much guys. - 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: DATETIME function to be used...
At 15:39 -0800 11/28/02, David Wu wrote: Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a value of -MM-DD HH:MM:SS. Is this value in a form of string?? If I have a column described as DATETIME data type I should be able to do: INSERT INTO tablename VALUES (id#, 1997-10-10 24:45:32), right? but if I do SELECT * FROM tablename, I got userID DateTime 1 -00-00 00:00:00: DateTime column got the null value?! -00-00 00:00:00 is not a null value. But anyway... Perhaps the result you're seeing has something to do with the fact that 24:45:32 is not a legal time in the range from 00:00:00 to 23:59:59. Please help thank you very much guys. - 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: MySQL secure access
of course i will full access on those databases in all the databases store in our server, and i able to view/update all of them. but what i meant is my customer want to have the access on their database. and i don't want them to view those databases that not belongs to the particular customer. customer only access their own database only. - Original Message - From: Pae Choi [EMAIL PROTECTED] To: Alice Tan [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 8:33 PM Subject: Re: MySQL secure access If I am your customer and the data related to my web contents and/or services stored(this is more than likely if the hosting service is used) in the database at your site, I would definitely claim that the access to data will be appropriate. Ex, You have Web services using a hosting service. And the Web services collect the customers' info. Shouldn't you need to access the database which stored all your customers' info. In addition, it's a trust-based relationship. But the hosting service should not have access to the customers' data even though the customers' databases reside at the hosting site. That's more appropriate in the business process and prevent the possible legal matter. Because the customers can simply claim that It's my data and not yours! The right practice will be to seperate your company's database and customer's databases on different hosts. And your company can provide the proper access to your customers to their databases. Otherwise, they will move on to somewhere else who can do for their needs. Pae Hi, all, I am now using MySQL with MySQL Front, where i knew that it can access ALL the databases that store remotely. My company is doing hosting services. And we are using MySQL as our database system. Currently, we have our own databases + customer's databases store in our hosting server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. regards, alice /--- \ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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 /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Isert arecord to database error
Hi I am trying to insert a record to SQLServer database and gettign the following error: Microsoft OLE DB Provider for SQL Server error '80040e14' The name 'Mr' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted Any idea ? - 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
Error compiling a program using mysql++
Hi I'm programming using FLTK Toolkit, mysql 3.23.52 (from source code ) and mysql++ 1.7.9. On win32, i'm using Visual Studio 6.0 and c++ on GNU/Linux. On win32, it's ok, but on GNU/Linux Debian, has these errors. But who can I correct it ? The source academia.cpp compiles ok, but atletas.cpp don't. ---stdout -- c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/mysql++-1.7.9/sqlplusint -I/u sr/local/mysql/include/mysql -g -O2 -c academia.cpp -o obj/academia.o c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/local/mysql++-1.7.9/sqlplusint -I/u sr/local/mysql/include/mysql -g -O2 -c atletas.cpp -o obj/atletas.o In file included from /usr/local/mysql++-1.7.9/sqlplusint/manip1.hh:14, from /usr/local/mysql++-1.7.9/sqlplusint/vallist1.hh:6, from /usr/local/mysql++-1.7.9/sqlplusint/row1.hh:11, from /usr/local/mysql++-1.7.9/sqlplusint/compare1.hh:5, from /usr/local/mysql++-1.7.9/sqlplusint/mysql++:13, from atletas.cpp:3: /usr/local/mysql++-1.7.9/sqlplusint/sql_query1.hh:115: parse error before `0' /usr/local/mysql++-1.7.9/sqlplusint/sql_query1.hh: In method `SQLQuery::SQLQuery()': /usr/local/mysql++-1.7.9/sqlplusint/sql_query1.hh:125: no base initializers given following ':' /usr/local/mysql++-1.7.9/sqlplusint/sql_query1.hh:125: parse error before `0' In file included from /usr/local/mysql++-1.7.9/sqlplusint/connection1.hh:20, from /usr/local/mysql++-1.7.9/sqlplusint/mysql++:14, from atletas.cpp:3: /usr/local/mysql++-1.7.9/sqlplusint/query1.hh: In method `MysqlQuery::MysqlQuery(MysqlConnection *, bool = false)': /usr/local/mysql++-1.7.9/sqlplusint/query1.hh:34: non-lvalue in assignment In file included from /usr/local/mysql++-1.7.9/sqlplusint/mysql++:14, from atletas.cpp:3: /usr/local/mysql++-1.7.9/sqlplusint/connection1.hh: At top level: /usr/local/mysql++-1.7.9/sqlplusint/connection1.hh:34: parse error before `0' /usr/local/mysql++-1.7.9/sqlplusint/connection1.hh: In method `MysqlConnection::MysqlConnection(bool)': /usr/local/mysql++-1.7.9/sqlplusint/connection1.hh:39: parse error before `0' /usr/local/mysql++-1.7.9/sqlplusint/connection1.hh:39: parse error at end of saved function text In file included from /usr/local/mysql++-1.7.9/sqlplusint/mysql++:16, from atletas.cpp:3: /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh: In method `void MysqlConnection::storein(multisetT,less_Key,allocator_Tp1 , const string )': /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:21: explicit specialization in non-namespace scope `MysqlConnection::storein(multisetT,less_Key,allocator_Tp1 , const string )' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh: In method `MysqlConnection::mysql_convert::operator float()':/usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:22: explicit specialization in non-namespace scope `MysqlConnection' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:22: parse error before `;' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:39: explicit specialization in non-namespace scope `MysqlConnection' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:39: parse error before `;' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:40: `operator signed char()' must be a nonstatic member function /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:40: `operator signed char()' must take exactly one argument /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh: In function `operator signed char()': /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:40: `num' undeclared (first use this function) /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:40: (Each undeclared identifier is reported only once /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:40: for each function it appears in.) /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:40: parse error before `}' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:41: explicit specialization in non-namespace scope `operator signed char()' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:41: `mysql_convert' is not a template /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:41: explicit specialization of non-template `operator signed char()::{anonymous struct}' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:41: ANSI C++ forbids declaration `mysql_convert' with no type /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:41: anonymous class type not used to declare any objects /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:42: explicit specialization in non-namespace scope `operator signed char()' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:42: `mysql_convert' is not a template /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:42: explicit specialization of non-template `operator signed char()::{anonymous struct}' /usr/local/mysql++-1.7.9/sqlplusint/convert1.hh:42: ANSI C++ forbids declaration `mysql_convert' with no type
FULLTEXT search against a query result
Okay, here we go ... I would like to do a FULLTEXT search against a query result. There are multiple columns that have a FULLTEXT index. Hopefully I break this down in a manner that can be understood. The fields of interest: Table events: event_id [int(11)] event [varchar(255)] description [text] FULLTEXT (event, description) Table event_times: event_id [int(11)] from events.event_id start_date [date] place [varchar(255)] FULLTEXT (place) I would like to search the fields events.event, events.description, and event_times.place. So hypothetically it would look something like MATCH(events.event, events.description, event_times.place) AGAINST('keywords'). The results I need to use for the search is produced from the query: SELECT events.category_id, events.event_id, events.event, events.description, event_times.start_date, chc_event_times.place FROM events INNER JOIN event_times ON events.event_id = event_times.event_id GROUP BY events.event_id If this makes no sense to you or if you need more information, please let me know. Thanks for your time. Jay Douglas Systems Consultant Fort Collins, CO - 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
Innodb Hash search
hi, I now test Mysql+innodb performance, my platform is Solarise 5.8 1G RAM . I use my-huge.cnf, set the buffer_pool_size = 400M , my bench table is about 100M . I run 10 threads to Query a innodb table. Query 1* 10 thread would cost 30 second . When I look the Innodb monitor , i fund : INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1660247, used cells 0, node heap has 1 buffer(s) 0.00 hash searches/s, 2471.41 non-hash searches/s Why the Hash search = 0? thanks! Tony chen - 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
Fw: Error No: 2013. Lost Connection MySQL server during query
Hi all, I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru win2000 with using any Front End applications (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am getting the same error message: Error No: 2013 Lost Connection MySQL server during query. I am being crazy. On the server side each connection try is leaving a paragraph in the /var/log/mysqld.log just like: Number of processes running now:1 mysqld process hanging, pid 2 - killed 022323 15:02:24 mysqld restarted /user/libexec/mysqld: ready for connection I am dying to see any database or table with establishing this connection. Is there anybody will help me? Sincerely. Cem Yagli key words: sql, query - 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
Can a big transaction cause the error in max_allowed_packet?
My table structure is very simple and does not use big column like text nor blub at all. But when I load several million rows into master server using mysqlimport, on slave I got the error like 021129 13:24:40 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log I have two questions. First, mysqlimport does not commit until the entire data are imported? Second, If the answer to the first question is Yes, it can cause the above error? :query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
Japanese character not displaying correctly
Hi I was working with mysql 3.23.41 on linux. I was able to store and retrieve japanese characters from the db using java code. I am using Shift_JIS encoding. yesterday I took a dump of my database and restored it in another linux machine having mysql 3.23.38. But now my code is outputting only marks on the browser. please tell me how to beat this thing. I heard a piece of info that I can do something in the /etc/my.cnf file to solve this. Is it correct. btw when i did mysql show variables I got this among the other output. | character_set | latin1 character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 Please help me with your valuable advice Thank you Deepak - 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
Error No: 2013. Lost Connection MySQL server during query
Hi all, I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru win2000 with using any Front End applications (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am getting the same error message: Error No: 2013 Lost Connection MySQL server during query. I am being crazy. On the server side each connection try is leaving a paragraph in the /var/log/mysqld.log just like: Number of processes running now:1 mysqld process hanging, pid 2 - killed 022323 15:02:24 mysqld restarted /user/libexec/mysqld: ready for connection I am dying to see any database or table with establishing this connection. Is there anybody will help me? Sincerely. Cem Yagli key words: sql, query - 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