MySQL (mysql-5.0.54)
Hi I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I see the below information in the mysqld.err file ## 06 6:30:13 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem. 080506 6:30:13 - mysqld got signal 4; 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=0 read_buffer_size=262144 max_used_connections=0 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 = 76800 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) 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... frame pointer is NULL, did you compile with -fomit-frame-pointer? Aborting backtrace! The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. ## Any ideas Thanks and Regards Kaushal
Re: MySQL (mysql-5.0.54)
Hi, Please, you must set up the log-bin for enable replication : Example ( in your my.cnf ) --log-bin=mysqld-bin The mysql signal 4 error appear when you install erroneus your environment. I recommed reinstall your MySQL in your OS. Regards, Juan On 5/6/08, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I see the below information in the mysqld.err file ## 06 6:30:13 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem. 080506 6:30:13 - mysqld got signal 4; 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=0 read_buffer_size=262144 max_used_connections=0 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 = 76800 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) 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... frame pointer is NULL, did you compile with -fomit-frame-pointer? Aborting backtrace! The manual page at http://dev.mysql.com/doc/mysql/en/crashing.htmlcontains information that should help you find out what is causing the crash. ## Any ideas Thanks and Regards Kaushal
RE: Sun to buy Mysql - mysql press release
http://mysql.com/news-and-events/sun-to-acquire-mysql.html -- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz); /Lasso Professional Alliance Member ID #LPA135259 (www.lassosoft.com); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Is it possible to give more memory to the client when running on the command line? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Hi Tom, Use -q option on mysqldump ;) -q Won't buffer query, It will dump directly to stdout. --Praj On Tue, 14 Mar 2006 11:56:42 + Tom Brown [EMAIL PROTECTED] wrote: Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Is it possible to give more memory to the client when running on the command line? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Hi Tom, Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. From the manual at page http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Tom Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, 14 March 2006 10:27 PM To: mysql@lists.mysql.com Subject: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory Hi Trying to dump a complete db where 1 of the tables contains about 88 million rows - When the dump runs on the command line the following error is thrown mysqldump: Out of memory (Needed 3543176 bytes) mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server Is it possible to give more memory to the client when running on the command line? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mysql-max-4.0.20 - Error 2008 - MySQL client out of Memory
Are you using the --quick option? --quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out. thanks both - that did the trick cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Possble broken Debian MySQL (mysql-dfsg-4.1 4.1.10a-2)?
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I'm pretty sure this is more of a Debian package probem rather than a MySQL issue, but for any Debian MySQL users out there here goes: PROBLEM: The problem I'm getting trying to apt-build source mysql-server-4.1 after running the ./configure script is: config.status: creating Docs/Makefile config.status: error: cannot find input file: Docs/Makefile.in ENVIRONMENT: Running Sarge on x86 eeyore:/var/cache/apt-build/build/mysql4# uname -a Linux eeyore 2.4.27-1-386 #1 Fri Sep 3 06:24:46 UTC 2004 i686 GNU/Linux STEPS TO REPRODUCE: 1) apt-build source mysql-server-4.1 2) ./configure WORKAROUND: Copying the Docs directory from a tarball obtained from MySQL website allows the ./configure to proceed. - -- Cheers! J. Wren Hunt Cambridge, MA. USA - In theory, there is no difference between theory and practice. But, in practice, there is. - Jan L.A. van de Snepscheut +--+ | v-card http://wrenhunt.homelinux.org/data/wren.vcf | | x.509http://wrenhunt.homelinux.org/data/thawte_wren_hunt.cer | | OpenPGP ADF5 1432 A59E 8F4D 4AE7 4DFE 03FA 91E1 4A24 D6F4 | +--+ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (Darwin) iD8DBQFCWBA1A/qR4Uok1vQRA6BUAKDG612WxklITf1PBIb9lzMaNCPGbACfcVgv pVpsRC2KJ5R/K1jv9A2obuw= =LMJ8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] mysql/snort/webmin/permissions
Mark Sargent wrote: Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path dir..? Why is this so, when I followed the install steps from mysql's site. Hmm, damn annoying. Cheers. I followed the below from their install page, If you run into problems, /please always use *mysqlbug*/ when posting questions to a MySQL mailing list. Even if the problem isn't a bug, *mysqlbug* gathers system information that helps others solve your problem. By not using *mysqlbug*, you lessen the likelihood of getting a solution to your problem. You can find *mysqlbug* in the |bin| directory after you unpack the distribution. See Section 1.4.1.3, How to Report Bugs or Problems http://dev.mysql.com/doc/mysql/en/bug-reports.html. The basic commands you must execute to install and use a MySQL binary distribution are: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /|/path/to/mysql-VERSION-OS|/.tar.gz | tar xvf - shell ln -s /|full-path-to-mysql-VERSION-OS|/ mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql For versions of MySQL older than 4.0, substitute *bin/safe_mysqld* for *bin/mysqld_safe* in the final command. Mark Sargent. Hi All, guys, my sincere apologies, I just didn't do enuff research on things. I do have a Fedora book, and took a better look at it last night. I now understand what is required, and have successfully got things running. I appreciate your pateince with me. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] mysql/snort/webmin/permissions
Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path dir..? Why is this so, when I followed the install steps from mysql's site. Hmm, damn annoying. Cheers. I followed the below from their install page, If you run into problems, /please always use *mysqlbug*/ when posting questions to a MySQL mailing list. Even if the problem isn't a bug, *mysqlbug* gathers system information that helps others solve your problem. By not using *mysqlbug*, you lessen the likelihood of getting a solution to your problem. You can find *mysqlbug* in the |bin| directory after you unpack the distribution. See Section 1.4.1.3, How to Report Bugs or Problems http://dev.mysql.com/doc/mysql/en/bug-reports.html. The basic commands you must execute to install and use a MySQL binary distribution are: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /|/path/to/mysql-VERSION-OS|/.tar.gz | tar xvf - shell ln -s /|full-path-to-mysql-VERSION-OS|/ mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql For versions of MySQL older than 4.0, substitute *bin/safe_mysqld* for *bin/mysqld_safe* in the final command. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] mysql/snort/webmin/permissions
Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. -- H | I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave. #6 http://www.pcraft.com . . .. Boulder, CO 80303, U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL, mySQL Max and stored procedure support (version problem?)
I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? but this fail create procedure pippo begin select 1 end as well as create procedure 'pippo' begin select 1 end and many other combination Is my syntax wrong? am I using the wrong version of mySQL to have SP support? Should I configure anything to have SP support? If I'm using the wrong version of mySQL which one has SP support and is considered the most stable? thx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
Hi, I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
On Tue, 9 Mar 2004 10:52:38 +0100 Martijn Tonies [EMAIL PROTECTED] wrote: I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them but it is not clear from which version. It is even not that clear from which source package should I start from to have Max or plain mySQL. I gave a look to SUSE source package of release 4 and it seems that Max and plain are built from the same tarball. Since I'm not sure if I have a version that support SP it is difficult to see if my syntax is wrong or it is a problem of version. Could anyone post a correct 5 line example of working stored procedure to test? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote: On Tue, 9 Mar 2004 10:52:38 +0100 Martijn Tonies [EMAIL PROTECTED] wrote: I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them but it is not clear from which version. 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. It is even not that clear from which source package should I start from to have Max or plain mySQL. I gave a look to SUSE source package of release 4 and it seems that Max and plain are built from the same tarball. Since I'm not sure if I have a version that support SP it is difficult to see if my syntax is wrong or it is a problem of version. Could anyone post a correct 5 line example of working stored procedure to test? For example: mysql delimiter | mysql create procedure pippo () - begin - select 1; - end | Query OK, 0 rows affected (0.07 sec) Syntax of stored procedures is described at: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL, mySQL Max and stored procedure support (version problem?)
On Tue, 09 Mar 2004 12:36:30 +0200 Victoria Reznichenko [EMAIL PROTECTED] wrote: 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. So this make MaxDB another product Could anyone post a correct 5 line example of working stored procedure to test? For example: mysql delimiter | mysql create procedure pippo () - begin - select 1; - end | Query OK, 0 rows affected (0.07 sec) Syntax of stored procedures is described at: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html Yep but without being sure you've the right software you're always in doubt if you missed something. Anyway result was the same. So I've to upgrade. Any suggestion about which is the way to go to have stored procedure on mySQL. I was compiling 5.0 right now and I had trouble with relayrotate test. First passed, second didn't. Installation script suggest to use --force... Google doesn't offer any page for relayrotate mysql. spasiba -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Backup MYSQL MYSQL 4.1
How to install Mysql 4.1, I always failed to do that ? pls help me and how to backup database in mysql ? thank you - Do you Yahoo!? The New Yahoo! Shopping - with improved product search
Re: Backup MYSQL MYSQL 4.1
Timotius Alfa [EMAIL PROTECTED] wrote: How to install Mysql 4.1, I always failed to do that ? pls help me If you have any problem with installation, describe it more detailed. and how to backup database in mysql ? You can use mysqldump, mysqlhotcopy programs, BACKUP TABLE and SELECT .. INTO OUTFILE statements: http://www.mysql.com/doc/en/Backup.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [mysql] MYSQL
Here are some hard examples to help: It is certainly usable on an old PC eg 200MHz Pentium 2 with linux and 32Mb RAM. Obviously the performance will be proportional to the hardware, but MySql is designed to be able to run on low level hardware. If you just want to play around with the database, or run a moderate database with only a few tens of thousands of rows in a few tables, this would be fine. You can get excellent good performance from a 500MHz Pentium 3, if you're prepared to spend a small amount of money on extra memory. I've got a database with 55 million rows in one table and it runs fine on my P3 833MHz laptop with 512Mb RAM when I'm doing development. If you were buying new hardware for a commercial deployment, I'd recommend linux on a server style machine with more than one disk, 3GHz Pentium 4/Xeon and 1Gb RAM. I've just bought such a machine for 1200 UKP from Dell, which is a serious machine for the money, such that it's hardly worth buying anything less for most commercial deployments. Move down the list according to your budget! Hope this helps, Andy -Original Message- From: Bill Kendrick [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 00:25 To: [EMAIL PROTECTED] Subject: Re: [mysql] MYSQL On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote: PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE CONFIGURATION TO RUN MYSQL SERVER. THANKS. I think this depends on how big the database will be, how much it will be hit, etc!!! I've heard of MySQL being run on the 200MHz StrongARM based Sharp Zaurus with only 32MB of RAM and 32MB of 'disk' space. :^) I doubt that could handle a popular e-commerce site, though. Let us know what you think the strain might be on the database itself, and folks here will no doubt have some suggestions of the kind of iron that can handle it. Good luck! -bill! -- [EMAIL PROTECTED] Got kids? Get Tux Paint! http://newbreedsoftware.com/bill/ http://newbreedsoftware.com/tuxpaint/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] MYSQL
On Thu, Oct 09, 2003 at 12:00:51PM -0300, [EMAIL PROTECTED] wrote: PLEASE, I'M A STUDENT AND I?D LIKE TO KNOW WHAT IS THE RECOMMENDED HARDWARE CONFIGURATION TO RUN MYSQL SERVER. THANKS. I think this depends on how big the database will be, how much it will be hit, etc!!! I've heard of MySQL being run on the 200MHz StrongARM based Sharp Zaurus with only 32MB of RAM and 32MB of 'disk' space. :^) I doubt that could handle a popular e-commerce site, though. Let us know what you think the strain might be on the database itself, and folks here will no doubt have some suggestions of the kind of iron that can handle it. Good luck! -bill! -- [EMAIL PROTECTED] Got kids? Get Tux Paint! http://newbreedsoftware.com/bill/ http://newbreedsoftware.com/tuxpaint/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200: I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) SELECT VERSION(); -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity
Hello, I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) Are foreign keys and referencial integrity supported by MySQL Version 3.23.42. ? If yes - why is the second insert into command allowed? (see below) -- Thanks in Advance and Best regards, Vince mailto:[EMAIL PROTECTED] drop table FremdeNLTB; drop table FNL_ErkennungTB; create table FremdeNLTB ( FN_ID int unsigned not null, Topic varchar(255), Name varchar(255), KatIK int unsigned, Primary Key (FN_ID), Index (FN_ID) ) Type=InnoDB ; create table FNL_ErkennungTB ( FNLE_ID int unsigned not null, FN_ID int unsigned not null, receivedFrom varchar(255), originFrom varchar(255), receivedBy varchar (255), originSentTo varchar (255), Primary Key (FNLE_ID), Index (FN_ID), Foreign Key (FN_ID) References FremdeNLTB(FN_ID) On Delete Cascade On Update Cascade ) Type=InnoDB ; insert into FremdeNLTB values (11,'lost+found','lost+found',999), (21,'MS/Windows','lost+found',999), (22,'MS/Windows','Cluster',999), (23,'MS/Windows','Plattform-Migration',999), (31,'MPE','lost+found',999), (41,'LINUX','lost+found',999), (51,'OpenView','lost+found',999), (52,'OpenView','SAM',999), (53,'OpenView','Omniback2',999), (61,'Storage/SAN','lost+found',999), (62,'Storage/SAN','XP',999), (63,'Storage/SAN','EMC',999), (64,'Storage/SAN','VA',999), (71,'Applications','lost+found',999), (72,'Applications','SAP',999), (73,'Applications','ORACLE',999) ; insert into FNL_ErkennungTB values (1,11,'','','','') ; insert into FNL_ErkennungTB values (123,123,'this','should','not be','possible!!!') ; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: running mysql (mysql users)
TR, Ok first I would like to say that I have just recently started using MySQL so I feel your pain and I hope my explination helps you out. The mysql user your referring to is probably the user that is should be used to run the mysql daemon. Which would b e a seperate *nix/Windows(?) user, I'm not sure how the windows version works with users. The MySQL root user is just a built in user that is used for, generally, administrative stuff... i.e. making users, backing up DBs, etc ,etc. The built in root user has all of the priviledges it already need but in short it has ALL of the priviledges. Making yourself a mysql superuser is neither a good thing or a bad thing... It sounds to me like you are a home user just messing around with MySQL (like myself) that is why it isn't a good thing nor a bad thing. But as a general rule it you have control over the root user and you make a normal user I would say that it doesn't need to be a super user. A nice set of priviledges, I think, for a normal user... which give them creative freedom is the folowing grant statement run as the mysql root user after you do # mysql -u root -p: GRANT SELECT,ALTER,DROP,CREATE,INSERT,DELETE,INDEX,UPDATE ON `username%`.* TO 'username'@'%' IDENTIFIED BY password; Ok the `username%`.* is what give the user creative freedom... It allows the user with the username to create whatever DBs it needs BUT the DB needs to have the prefix username on the front of it. Those are back ticks not sigle quotes too by the way. This grant statement also allows the user to connect from ANYWHERE so if you want to restrict where that user logs in from apply the appropriate end to the TO 'username'@ portion... and those are single quotes. Just replace every instance of username with whatever user you are setting up. Hope that helps and sorry if it was too elementary, I had a REAL hard time getting this and this was the way I finally got it. L8R, Ryan --- [EMAIL PROTECTED] wrote: I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also, why is a mysql root user needed and what mysql privileges does that user need? I do not know how this fits in with the above users (root mysql) but I usually make myself a mysql superuser, should I do that? Thanks, TR - 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 __ 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: running mysql (mysql users)
Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Correct Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? No, this is a unix/linux user that is used to run the daemon like you mentioned above. Also, why is a mysql root user needed and what mysql privileges does that user need? This is the Super User for mysql. It is set up as root so you can login to mysql after the initial install and immediately get to work. The root user is only set up for localhost privileges though, so you could not connect from another computer through TCPIP and login to mysql. One thing you need to remember is that Users in mysql, really have no connection to unix/linux users except that if you don't use any username directive (mysql -u uname) it will use the unix/linux username to log you in with. I usually make myself a mysql superuser, should I do that? usually a good idea, that way you can add mysql users to the list of people that can use the databases. Hope this helps. Roger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 8:12 PM To: MySQL List Subject: running mysql (mysql users) I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also, why is a mysql root user needed and what mysql privileges does that user need? I do not know how this fits in with the above users (root mysql) but I usually make myself a mysql superuser, should I do that? Thanks, TR - 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: running mysql (mysql users)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TR --
...and then [EMAIL PROTECTED] said...
%
% I wish to attempt to clarify one of my earlier questions:
That's always helpful :-)
%
% Most things I've read say to establish a mysql user -I take it this
% is to run the daemon(mysqld?) under?
No; that's a UNIX (or Windows or whatever) user who is running the
daemon.
% Is the above user one that will be created in the users table of the
Yep. On a *NIX machine you have users, one (or at least few) of whom are
root and the rest of which are pretty ordinary. Similarly, inside a
database you have users with various designations.
The users on the machine have nothing to do with the users in the
database. The two sets are completely separate, even if some of them
('root', 'david', 'guest') may have similar names (and even similar
passwords, if you care to have it that way).
% mysql db? What mysql privileges does such a user need?
It depends on what the user needs to do. You might have a user who can
only select from and update in one table of one database, or you might
have a user (like a backup job user) who can select from any table in any
database.
%
% Also, why is a mysql root user needed and what mysql privileges does
% that user need?
It's good to have at least one user who can do anything in the database;
that user not only creates new databases and new users (sometimes delegated
to other accounts with certain limited create capabilities) but also goes
in and fixes things when they get mucked up.
%
% I do not know how this fits in with the above users (root mysql) but
% I usually make myself a mysql superuser, should I do that?
Just like you shouldn't casually log in on your machine as root, you
shouldn't casually use a root mysql user for your work. You might make a
root account for yourself, but also make a normal account and work within
that except when you need special access.
%
% Thanks,
%
% TR
HTH HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)
iD8DBQE9/IBkGb7uCXufRwARArsQAJ9zpvytbgDTsjWnXKI3pKPmASTQaQCg4nvZ
5fPu2lv1uAgjLlH3Kuaub4s=
=upSJ
-END PGP SIGNATURE-
-
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: running mysql (mysql users)
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TR --
...and then [EMAIL PROTECTED] said...
%
% I wish to attempt to clarify one of my earlier questions:
That's always helpful :-)
%
% Most things I've read say to establish a mysql user -I take it this
% is to run the daemon(mysqld?) under?
No; that's a UNIX (or Windows or whatever) user who is running the
daemon.
Yes, that's what I meant, but please see below...
% Is the above user one that will be created in the users table of the
Yep. On a *NIX machine you have users, one (or at least few) of whom
are
root and the rest of which are pretty ordinary. Similarly, inside a
database you have users with various designations.
The users on the machine have nothing to do with the users in the
database. The two sets are completely separate, even if some of them
('root', 'david', 'guest') may have similar names (and even similar
passwords, if you care to have it that way).
% mysql db? What mysql privileges does such a user need?
It depends on what the user needs to do. You might have a user who can
only select from and update in one table of one database, or you might
have a user (like a backup job user) who can select from any table in
any
database.
What I'm asking about is to use this created user, username = mysql, to
start and I guess stop the server... I mean, is it a mysql user that
starts and stops the daemon? That is what I am trying to understand.
For example:
To me the manual sort of skips in both the Quick Start and the Adding
New Users (section 4.3 and other places), and also this famous website:
http://www.entropy.ch/software/macosx/mysql/#install
(I am not using that installation, I am using Apple's.)
...seem to skip over what this user named mysql is actually for?
%
% Also, why is a mysql root user needed and what mysql privileges
does
% that user need?
It's good to have at least one user who can do anything in the
database;
that user not only creates new databases and new users (sometimes
delegated
to other accounts with certain limited create capabilities) but also
goes
in and fixes things when they get mucked up.
%
% I do not know how this fits in with the above users (root mysql)
but
% I usually make myself a mysql superuser, should I do that?
Just like you shouldn't casually log in on your machine as root, you
shouldn't casually use a root mysql user for your work. You might
make a
root account for yourself, but also make a normal account and work
within
that except when you need special access.
What privileges might I NOT give myself as a normal user? (just
curious, this is not to terribly important for me in this post.)
Thanks very much,
Ted
p.s. I consistently have the problem of starting mysqld manually (which
is what I want here)... the problem is that I ALWAYS have to use sudo
-s, get root... then I can start it.
Do you know why that might be?
So, I am essentially after *this info if nothing else: is there a user
that is either already created by default on my MACHINE (not in mysql)
(username = mysql?) such as on my OS X Server (whose docs also do NOT
address this) or that I should Add to my MACHINE, that is *solely for
running mysqld under? Does running under mean or include starting
and stopping?
---
Does anyone know what NetInfo Manager means when it shows a username
(mysql) whose passwd is * (an asterisk)? And how I might incorporate
that user into... whatever I need it for? :)
-
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: running mysql (mysql users)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted -- ...and then [EMAIL PROTECTED] said... % % On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: % % ...and then [EMAIL PROTECTED] said... % % ... % % Most things I've read say to establish a mysql user -I take it this % % is to run the daemon(mysqld?) under? % % No; that's a UNIX (or Windows or whatever) user who is running the % daemon. % % Yes, that's what I meant, but please see below... OK. Good so far, then. % ... % % mysql db? What mysql privileges does such a user need? % % It depends on what the user needs to do. You might have a user who can % only select from and update in one table of one database, or you might % have a user (like a backup job user) who can select from any table in % any % database. % % What I'm asking about is to use this created user, username = mysql, to % start and I guess stop the server... I mean, is it a mysql user that OK; I gotcha. % starts and stops the daemon? That is what I am trying to understand. % For example: % To me the manual sort of skips in both the Quick Start and the Adding % New Users (section 4.3 and other places), and also this famous website: % http://www.entropy.ch/software/macosx/mysql/#install % (I am not using that installation, I am using Apple's.) % ...seem to skip over what this user named mysql is actually for? That user shouldn't need any particular privileges -- and that's because all of the database files should be owned by that user. % ... % % I usually make myself a mysql superuser, should I do that? % % Just like you shouldn't casually log in on your machine as root, you % shouldn't casually use a root mysql user for your work. You might % make a % root account for yourself, but also make a normal account and work % within % that except when you need special access. % % What privileges might I NOT give myself as a normal user? (just % curious, this is not to terribly important for me in this post.) Instead of something like grant all privileges on *.* to tr ; you might want grant all privileges on *.* to myroot ; grant all privileges on trdb to trroot ; grant select on trdb to truser ; or such. Note that I'm not yet a privilege expert :-) and that these examples are not expected to be either accurate or even sensible; you get the idea, though. % % Thanks very much, % Ted Sure thing! % % p.s. I consistently have the problem of starting mysqld manually (which % is what I want here)... the problem is that I ALWAYS have to use sudo % -s, get root... then I can start it. % Do you know why that might be? Probably because the files are currently owned by root. % % So, I am essentially after *this info if nothing else: is there a user % that is either already created by default on my MACHINE (not in mysql) Probably not; the 'create an OS user to run the daemon' step should be part of the installation instructions. I wouldn't expect to have users predefined for every possible application in the world -- including the next great one which hasn't even been written yet :-) % (username = mysql?) such as on my OS X Server (whose docs also do NOT % address this) or that I should Add to my MACHINE, that is *solely for That's a fine and good idea. Some applications prefer to run under their own userids (or even, as in the case of qmail, multiple users for the whole package), while others are happy to run as root; some sysadmins prefer to have all applications under their own IDs anyway even if the app doesn't care one way or another. I do not yet know the security factors of having mysqld run by root, but I shouldn't think you could go wrong running it as its own user. % running mysqld under? Does running under mean or include starting % and stopping? Yep. % --- % Does anyone know what NetInfo Manager means when it shows a username % (mysql) whose passwd is * (an asterisk)? And how I might incorporate % that user into... whatever I need it for? :) No idea here; sorry. Well, some idea... If NetInfo Manager is showing OS accounts, a * in the password entry means that there isn't really a password and you have to su (switch users, or what sudo does for you in a more structured manner) from the root account (or under sudo management). HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9/UJ9Gb7uCXufRwARAnQtAJ9stue1qpuiJhmak//k0lyPjBwSwwCg3mSK UN1zCJJ33VjqLxAMb9taxGg= =tGDE -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Re: running mysql (mysql users)
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote: % --- % Does anyone know what NetInfo Manager means when it shows a username % (mysql) whose passwd is * (an asterisk)? And how I might incorporate % that user into... whatever I need it for? :) No idea here; sorry. Well, some idea... If NetInfo Manager is showing OS accounts, a * in the password entry means that there isn't really a password and you have to su (switch users, or what sudo does for you in a more structured manner) from the root account (or under sudo management). Well (see my next list post :)... the username mysql which is default installed on OS XS, afaik, as I say has an asterisk in NetInfo. After starting up mysql i did several test: I tried to login to mysql using the the user mysql with none and every passwd i have, it would not let me in, good. I also could not reboot and login to my system with this user trying anything i could for a passwd and trying, again, none. So, I guess that's all good. yay. Next post will be right behind this one...! Thank you all very much, I have had good luck tonight! Ted - 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
running mysql (mysql users)
I wish to attempt to clarify one of my earlier questions: Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? Also, why is a mysql root user needed and what mysql privileges does that user need? I do not know how this fits in with the above users (root mysql) but I usually make myself a mysql superuser, should I do that? Thanks, TR - 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
Strange network error using mysql,mysql c api
Hi,
i am using mysql c api to send some queries to mysql server which is on
another computer (100MBit almost next to the client)
in my code i am doing this
if (mysql_real_query(mysql,query,strlen(query)))
{
fprintf(stderr,In query : \%s\\n,query);
fprintf(stderr,Error occured : %s\n,mysql_error(mysql));
}
and this sometimes (e.g. 1 from 1.000.000 sends) do this :
In query : insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
Error occured : Unknown column 'QR_ID' in 'field list'
In query : insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
do someone know what should be the problem?
Server is Win2K and has latest mysql server installed client is the one
from RedHat 7.3 (3.23.49) (=`mysql_config --version`)
Can someone help me? Thanks.
Krata
-
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
Strange network error using mysql,mysql c api
Hi,
i am using mysql c api to send some queries to mysql server which is on
another computer (100MBit almost next to the client)
in my code i am doing this
if (mysql_real_query(mysql,query,strlen(query)))
{
fprintf(stderr,In query : \%s\\n,query);
fprintf(stderr,Error occured : %s\n,mysql_error(mysql));
}
and this sometimes (e.g. 1 from 1.000.000 sends) do this :
In query : insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
Error occured : Unknown column 'QR_ID' in 'field list'
In query : insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
do someone know what should be the problem?
Server is Win2K and has latest mysql server installed client is the one
from RedHat 7.3 (3.23.49) (=`mysql_config --version`)
Can someone help me? Thanks.
Krata
-
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: Strange network error using mysql,mysql c api
Krata,
Friday, August 16, 2002, 5:10:20 PM, you wrote:
K Hi,
K i am using mysql c api to send some queries to mysql server which is on
K another computer (100MBit almost next to the client)
K in my code i am doing this
K if (mysql_real_query(mysql,query,strlen(query)))
K {
K fprintf(stderr,In query : \%s\\n,query);
K fprintf(stderr,Error occured : %s\n,mysql_error(mysql));
K }
K and this sometimes (e.g. 1 from 1.000.000 sends) do this :
K In query : insert into TR_ITEMS_TEMP
(PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX) values (-70,500,0,8052,2,8301)
K
K Error occured : Unknown column 'QR_ID' in 'field list'
K In query : insert into TR_ITEMS_TEMP
(PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX) values (-70,500,0,8052,2,8301)
K
K do someone know what should be the problem?
K Server is Win2K and has latest mysql server installed client is the one
K from RedHat 7.3 (3.23.49) (=`mysql_config --version`)
8-[ ]
I tested your example and it works nice...
Do you always get this error or you got it just once?
Does error occur if you execute query via mysql command line client
tool?
--
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: Strange network error using mysql,mysql c api
On Fri, 16 Aug 2002, Victoria Reznichenko wrote: K do someone know what should be the problem? K Server is Win2K and has latest mysql server installed client is the one K from RedHat 7.3 (3.23.49) (=`mysql_config --version`) Do you always get this error or you got it just once? well i get this error sometimes. (if i try to insert about 50.000 rows (in loop) then it occurs in one or two cases) Does error occur if you execute query via mysql command line client tool? well i am not crazy :) i am not keen of inserting thousands rows in mysqlcommand line. (My last hope is that there is wrong Eth card. Curios thing is that when errors occurs then T-P differs binary in one bit.) - 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: Strange network error using mysql,mysql c api
Hi, Usually Network Adapter doesn't make this things(Hardware and Software CRC).I think you should check what happened with the query string.When you hang the error make a dump of memory and see where is broke your array of char. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Krata [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 16, 2002 8:19 PM Subject: Re: Strange network error using mysql,mysql c api On Fri, 16 Aug 2002, Victoria Reznichenko wrote: K do someone know what should be the problem? K Server is Win2K and has latest mysql server installed client is the one K from RedHat 7.3 (3.23.49) (=`mysql_config --version`) Do you always get this error or you got it just once? well i get this error sometimes. (if i try to insert about 50.000 rows (in loop) then it occurs in one or two cases) Does error occur if you execute query via mysql command line client tool? well i am not crazy :) i am not keen of inserting thousands rows in mysqlcommand line. (My last hope is that there is wrong Eth card. Curios thing is that when errors occurs then T-P differs binary in one bit.) - 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
mysql/mysql++ fail on sun-solaris-sparc with segfault
(that was already sent to [EMAIL PROTECTED]) Description: Programs, compiled with mysql++ on that machine, abort with a segfault at an attempt to connect to the mysql server, while programs using Mysql C API (for instance, mysql's own benchmark suite) and the same programs executed on a local Linux machine run OK. I used mysql++-1.7.8 and recent stable 3.26.36 mysql (source). According to debugger's backtrace, it stops with signal 11 (and message: 'Segmentation fault (core dumped)') in mysql connection / memory allocation code: (gdb) bt #0 0xef545c18 in _malloc_unlocked () #1 0xef545b38 in malloc () #2 0xef78acec in my_malloc () #3 0xef7899c0 in vio_new () #4 0xef786a28 in mysql_real_connect () #5 0xef5c6568 in MysqlConnection::real_connect () #6 0xef5c5e74 in MysqlConnection::MysqlConnection () #7 0x2e398 in main () at test1.cc:9 It is not only my programs that fail like that, all the mysql++ examples abort exactly this way. Interestingly enough, one of the programs I use behave a bit differently. It starts with "Bad free() ignored" message and stops with 'Abort (core dumped)' message. Debugger produces the following backtrace (formatted manually for readability): (gdb) bt #0 0xef50828c in _libc_kill () #1 0xef4ba608 in abort () #2 0xef578bd0 in Letext () #3 0xef578c00 in __terminate () #4 0xef579708 in throw_helper (eh=0xef59be4c, pc=0xef5c7bff, my_udata=0xefffec70, offset_p=0xefffec6c) #5 0xef579910 in __throw () #6 0xef5c7c00 in MysqlConnection::execute () #7 0x111e38 in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::unique () #8 0x10f51c in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::append () #9 0x10af58 in MysqlQuery::~MysqlQuery () #10 0x4193c in _init () #11 0x3b6b4 in _init () #12 0x3cb04 in _init () #13 0x3dfb8 in _init () The more detailed report and listing of debugger outputs and some code is available online for your reference at: http://netec.mcc.ac.uk/HoPEc/g4/mysql-problem-details.txt I've tried several versions of mysql deamon (mentioned in the details doc), and to recompile mysql and mysql++ several times with two versions of gcc (2.95.1 and 2.95.2) and with different options (according to Mysql Documentation/installation/system specific/Solaris recommendations), with little success and minimal changes of soft behaviour. I've also tried --safe-mode and --loging but that didn't make situation clear, but please look into the details file mentioned above: may be for you it will make something clear. How-To-Repeat: should be obvious from the above description Fix: no idea, sorry Submitter-Id: submitter ID Originator:ivan kurmanov, [EMAIL PROTECTED] Organization: RePEc, http://repec.org MySQL support: none Synopsis: synopsis of the problem (one line) Severity: critical Priority: high Category: mysql mysql++ Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: Library used: Mysql++ 1.7.8 System: SunOS irwell 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /home/adnetec/usr/local/bin/perl /home/adnetec/bin/make /usr/local/bin/gmake /home/adnetec/usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /home/adnetec/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 ' CXX='c++' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/home/adnetec/Ivan --with-unix-socket-path=/home/adnetec/Ivan/tmp/mysql.socket --with-low-memory --enable-assembler Perl: This is perl, version 5.005_02 built for sun4-solaris NB: I didn't send this report with mysql-bug script, I just used its output for this message as draft, because I couldn't send mail from that machine, it is remote for me. Sorry, if that sets any limits to usefulnes of this report. Ivan - 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/mysql++ fail on sun-solaris-sparc with segfault
HI!
This is due to a bug in connection.cc.
Rebuild MySQL++ with this source and you will have no more problems
like this.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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] MySql can support Multi-Lingual??
¹è¼ÒÁ¤ wrote: Hi... I'm Bae So Jeong, a web-programmer at Digital Chosun. Would you help me for MySql? ^^: I will develop some web-sites by Japanese, Chinese, English etc. These sites will service at one server, one O/S. Many reference sites say: "Japanese site will service very well at Japanese O/S, JapaneseDB!" Then, some servers are necessary for some web-sites written by japanse, chinese, english In the web-server aspect, I guess, this is not a problem, with the exception of DB. How I must do these services by using MySQL? In Oracle, CharacterSet can be setted by a instance, a Program can encode characers to instance setted ascii-set, a instance can be setted UTF. In MySql, it can be? I'm a layman in MySql.. Please, Help me.. ^^; Reply to [EMAIL PROTECTED] Hi ./configure --help You will See "--with-charset=CHARSET , --with-extra-charsets=CHARSET[,CHARSET,...] " --with-extra-charsets=CHARSET,.. Use charsets in addition to default (none, complex, all, or a list selected from the above sets) Happy Hacking - 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/mysql++ fail on sun-solaris-sparc with segfault
Description: Programs, compiled with mysql++ on that machine, abort with a segfault at an attempt to connect to the mysql server, while programs using Mysql C API (for instance, mysql's own benchmark suite) and the same programs executed on a local Linux machine run OK. I used mysql++-1.7.8 and recent stable 3.26.36 mysql (source). According to debugger's backtrace, it stops with signal 11 (and message: 'Segmentation fault (core dumped)') in mysql connection / memory allocation code: (gdb) bt #0 0xef545c18 in _malloc_unlocked () #1 0xef545b38 in malloc () #2 0xef78acec in my_malloc () #3 0xef7899c0 in vio_new () #4 0xef786a28 in mysql_real_connect () #5 0xef5c6568 in MysqlConnection::real_connect () #6 0xef5c5e74 in MysqlConnection::MysqlConnection () #7 0x2e398 in main () at test1.cc:9 It is not only my programs that fail like that, all the mysql++ examples abort exactly this way. Interestingly enough, one of the programs I use behave a bit differently. It starts with "Bad free() ignored" message and stops with 'Abort (core dumped)' message. Debugger produces the following backtrace (formatted manually for readability): (gdb) bt #0 0xef50828c in _libc_kill () #1 0xef4ba608 in abort () #2 0xef578bd0 in Letext () #3 0xef578c00 in __terminate () #4 0xef579708 in throw_helper (eh=0xef59be4c, pc=0xef5c7bff, my_udata=0xefffec70, offset_p=0xefffec6c) #5 0xef579910 in __throw () #6 0xef5c7c00 in MysqlConnection::execute () #7 0x111e38 in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::unique () #8 0x10f51c in basic_stringchar, string_char_traitschar, __default_alloc_templatefalse, 0 ::append () #9 0x10af58 in MysqlQuery::~MysqlQuery () #10 0x4193c in _init () #11 0x3b6b4 in _init () #12 0x3cb04 in _init () #13 0x3dfb8 in _init () The more detailed report and listing of debugger outputs and some code is available online for your reference at: http://netec.mcc.ac.uk/HoPEc/g4/mysql-problem-details.txt I've tried several versions of mysql deamon (mentioned in the details doc), and to recompile mysql and mysql++ several times with two versions of gcc (2.95.1 and 2.95.2) and with different options (according to Mysql Documentation/installation/system specific/Solaris recommendations), with little success and minimal changes of soft behaviour. I've also tried --safe-mode and --loging but that didn't make situation clear, but please look into the details file mentioned above: may be for you it will make something clear. How-To-Repeat: should be obvious from the above description Fix: no idea, sorry Submitter-Id: submitter ID Originator:ivan kurmanov, [EMAIL PROTECTED] Organization: RePEc, http://repec.org MySQL support: none Synopsis: synopsis of the problem (one line) Severity: critical Priority: high Category: mysql mysql++ Class: sw-bug Release: mysql-3.23.36 (Source distribution) Environment: Library used: Mysql++ 1.7.8 System: SunOS irwell 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-Enterprise Architecture: sun4 Some paths: /home/adnetec/usr/local/bin/perl /home/adnetec/bin/make /usr/local/bin/gmake /home/adnetec/usr/local/bin/gcc /opt/SUNWspro/bin/cc GCC: Reading specs from /home/adnetec/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O6 ' CXX='c++' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1608144 Feb 7 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 21 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Feb 7 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/home/adnetec/Ivan --with-unix-socket-path=/home/adnetec/Ivan/tmp/mysql.socket --with-low-memory --enable-assembler Perl: This is perl, version 5.005_02 built for sun4-solaris NB: I didn't send this report with mysql-bug script, I just used its output for this message as draft, because I couldn't send mail from that machine, it is remote for me. Sorry, if that sets any limits to usefulnes of this report. - 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 PROTECTE
[MySQL] MySql can support Multi-Lingual??
Hi... I'm Bae So Jeong, a web-programmer at Digital Chosun. Would you help me for MySql? ^^: I will develop some web-sites by Japanese, Chinese, English etc. These sites will service at one server, one O/S. Many reference sites say: "Japanese site will service very well at Japanese O/S, JapaneseDB!" Then, some servers are necessary for some web-sites written by japanse, chinese, english In the web-server aspect, I guess, this is not a problem, with the exception of DB. How I must do these services by using MySQL? In Oracle, CharacterSet can be setted by a instance, a Program can encode characers to instance setted ascii-set, a instance can be setted UTF. In MySql, it can be? I'm a layman in MySql.. Please, Help me.. ^^; Reply to [EMAIL PROTECTED]
