Re: is this normal?
kalin mintchev wrote: system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i get right in. even if i type -p. i do get the password prompt but doesn't matter what i type there - even nothing i get straight in... is this normal?? thanks... What is the error message? Is yor server running? Usually by default this should work: /usr/local/mysql/bin/mysql i.e. default user root without password connecting from localhost or /usr/local/mysql/bin/mysql -u root or (preferably disabled if possible for security reasons if localhost is just enough) /usr/local/mysql/bin/mysql -h host.domain.com -u root -p after mysql installation and root password set up i can... Well if you also changed some RIGHTS/GRANTs or changing some options in your my.cnf e.g. --skip-networking sometimes lead to this confusion ..or sometimes its just good old Caps Lock :) also look in the manual (depends on your vesrion): http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cancel [EMAIL PROTECTED]
This message was cancelled from within Mozilla. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is this normal?
kalin mintchev wrote: system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i get right in. even if i type -p. i do get the password prompt but doesn't matter what i type there - even nothing i get straight in... is this normal?? thanks... Sorry I first misread yor question (I hope I cancelled prev. post on time). I thought you have problems connecting to mysql while actual problem is: Why it is so easy for everyone (even from outside) to connect? Yes this is normal: default user is root *without password* if you wan't to secure your installation... well just read the manual :-) http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html also http://dev.mysql.com/doc/refman/5.0/en/security.html HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is this normal?
Sorry I first misread yor question (I hope I cancelled prev. post on time). I thought you have problems connecting to mysql while actual problem is: Why it is so easy for everyone (even from outside) to connect? Yes this is normal: default user is root *without password* if you wan't to secure your installation... well just read the manual :-) ok.. but i have root password set up. that works fine. if i'm as root and start the client it complains if i don't indicate that i'll be using password. but if y use _anything-else_ as user (i.e. -u stuff ) it just lets me right through. the users are not real local system users. just invented stuff. once i'm in thought i can not (apparently) do anything - create or drop or anything like that - and don't see any of the databases. but i still shouldn't even get to that point... by default... my guess is that i have to set up a password for '' (empty user) @ localhost and '' (empty user) @ my.machine.name.xxx... right? http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html also http://dev.mysql.com/doc/refman/5.0/en/security.html HTH -- 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: question regarding compiling for libmysqlclient.so
Hello. According to the output of configure shared libraries are enabled by default: --enable-shared[=PKGS] build shared libraries [default=yes] Have you tried to just configure and make without any options? Daryn wrote: hi there. 1st time posting to this list (and although i know linux, libraries linking is above my level slightly as yet) so apologies if this is a case of rtfm but i can't find a clear definition on this subject. I want to run Postfix with Mysql support for aliasing etc. I installed postfix with non-mysql support and it worked fine. installed Mysql 5 (latest version), recompiled postfix with mysql support and postfix didnt work. I was told there was a fair chance that the reason for this was that the mysql binary tarball i downloaded didnt contain libmysqlclient.so. Thus I want to install what would be the mysql-devel package for Centos onto my linux centos system without using the actual package. I want to compile mysql on my system with the libmysqlclient.so files. I'm told it's the dynamic package and the compile strings in the docs all seem to be all-static. can anyone help an idiot out and provide me the string for compilation of mysql 5 please to include the development libraries please? thanks very much and once more, apologies if it is a case of deeper rtfm. Daryn -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: question regarding compiling for libmysqlclient.so
Did you try doing a find for the lib? Perhaps it needs to be in the ld.conf or ldlibpath? - Sent from my NYPL BlackBerry Handheld. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] Sent: 12/06/2005 05:51 PM To: mysql@lists.mysql.com Subject: Re: question regarding compiling for libmysqlclient.so Hello. According to the output of configure shared libraries are enabled by default: --enable-shared[=PKGS] build shared libraries [default=yes] Have you tried to just configure and make without any options? Daryn wrote: hi there. 1st time posting to this list (and although i know linux, libraries linking is above my level slightly as yet) so apologies if this is a case of rtfm but i can't find a clear definition on this subject. I want to run Postfix with Mysql support for aliasing etc. I installed postfix with non-mysql support and it worked fine. installed Mysql 5 (latest version), recompiled postfix with mysql support and postfix didnt work. I was told there was a fair chance that the reason for this was that the mysql binary tarball i downloaded didnt contain libmysqlclient.so. Thus I want to install what would be the mysql-devel package for Centos onto my linux centos system without using the actual package. I want to compile mysql on my system with the libmysqlclient.so files. I'm told it's the dynamic package and the compile strings in the docs all seem to be all-static. can anyone help an idiot out and provide me the string for compilation of mysql 5 please to include the development libraries please? thanks very much and once more, apologies if it is a case of deeper rtfm. Daryn -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Band width consume
On 12/4/05, Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote: Dear Friends Is their an Page with data of how much bandwidth mysql consume when using remote servers? mysql show status like 'Bytes_%'; +++ | Variable_name | Value | +++ | Bytes_received | 1718034415 | | Bytes_sent | 2783965287 | +++ 2 rows in set (0.00 sec) This will give you an incrementing value that you can plot on a graph using MRTG (www.mrtg.org) or similar. -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is this normal?
Yes you're right! you can safely delete those - but first make some changes... as it seems you've set up root password only for : [EMAIL PROTECTED] - right? that's why you can't login using localhost (mysql without -h host option assumes -h localhost and if you only changed password for [EMAIL PROTECTED] then password for [EMAIL PROTECTED] is probably still the same default *no password* :) In that case to login with password you changed try (I assume mysql runs without --skip-netowrking) following instead: mysql -h my.machine.name.xxx -u root -p thanks i already have that. fot both my.machine.xxx and localhost.. logging in as root wasn't the issue. those where the first passwords i did set up. i just freaked out for a minute there realizing that typing -u some-stuff will get you in even if you can't do anything inside. i did try select - not even that... and no, you can't see test - at least not on this sql - 5.0.* thanks again... -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.15 : strange behaviour with current_date
Hi, For any reason, current_date doens't look to behave normally since a few days. I run reports in a MySQL DB through sql queries and I use a statement like ... invd between current_date - 7 and current_date - 1 ... It always worked. I just noticed that this week's report was wrong. Indeed : current_date - 7 returns an empty set while current_date - 2 returns the correct date. Current_date - 8 returns an empty set an a warning : Warning | 1292 | Incorrect date value: '20051199' for column 'invd' at row 1 Current_date -100 returns the 30 last days, current_date - 200 returns the 60 last days. Maybe I'm missing something very basic with the use of current_date, but I really don't understand why current_date - 7 doesn't work anymore. I must say that I upgraded my DB from 4.1 to 5.0 on the 21st of november, but I don't remember having problems with my reports the days after. Does anyone have an idea of the problem ? Thanks in advance. C.N.
Re: MySQL 5.0.15 : strange behaviour with current_date
In current_date - 7 the date is converted to a string and than to an Integer. Use adddate function: adddate(CURRENT_DATE(),interval -1 day) Santino At 11:37 +0100 7-12-2005, christophe nauwelaers wrote: Hi, For any reason, current_date doens't look to behave normally since a few days. I run reports in a MySQL DB through sql queries and I use a statement like ... invd between current_date - 7 and current_date - 1 ... It always worked. I just noticed that this week's report was wrong. Indeed : current_date - 7 returns an empty set while current_date - 2 returns the correct date. Current_date - 8 returns an empty set an a warning : Warning | 1292 | Incorrect date value: '20051199' for column 'invd' at row 1 Current_date -100 returns the 30 last days, current_date - 200 returns the 60 last days. Maybe I'm missing something very basic with the use of current_date, but I really don't understand why current_date - 7 doesn't work anymore. I must say that I upgraded my DB from 4.1 to 5.0 on the 21st of november, but I don't remember having problems with my reports the days after. Does anyone have an idea of the problem ? Thanks in advance. C.N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Edit utf-8 tables via the client
Hello, I'm using mysql-standard-4.1.14 and mysql-client-4.1.14 on a RH9 machine, I have utf-8 tables with hebrew data. When using the client I see the hebrew as question marks. I would like to view and edit the data via the client. I've tried using a terminal that is surely able to view unicode. Any suggestions? Yair. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
transaction with bdb table gives error Lock table is out of available locks
Hi,
I have a berkeley db table containing about 5 rows where I do this
transaction (pseudocode follows):
begin work
delete from mytable where myfield='boo' /*delete about 100 rows*/
for (i=0; i=100; i++){
insert into mytable values(...);
}
commit
During the insert command i get the following error:
Lock table is out of available locks
I tried to resolve the problem starting mysqld with -O
bdb_max_lock=6 and later with -O bdb_max_lock=12 but i still
receive the same error.
dbd related variables follows:
mysql show variables like %bdb%;
+-++
| Variable_name |
Value |
+-++
| bdb_cache_size |
8388600|
| bdb_home|
/var/lib/mysql/|
| bdb_log_buffer_size |
32768 |
| bdb_logdir
||
| bdb_max_lock|
12 |
| bdb_shared_data |
OFF|
| bdb_tmpdir |
/tmp/ |
| have_bdb|
YES|
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 13,
2005) |
+-++
9 rows in set (0.00 sec)
Any hint is welcome..
Thanx in advance for the help,
Marco
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Wrap a href Tag Around Result
Hi, Is it possible to wrap an a href tag around a column in a resultset? For example: SELECT Firstname FROM Users; Matthew Mark Luke John Becomes: a href=index.php?action=view_userfirstname=MatthewMatthew/a a href=index.php?action=view_userfirstname=MarkMark/a a href=index.php?action=view_userfirstname=LukeLuke/a a href=index.php?action=view_userfirstname=JohnJohn/a I need to do this with pure SQL - no server side scripting... Thanks for your advice -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Wrap a href Tag Around Result
On Wednesday 07 December 2005 15:29, Shaun wrote: SELECT Firstname FROM Users; Matthew a href=index.php?action=view_userfirstname=MatthewMatthew/a I need to do this with pure SQL - no server side scripting... http://dev.mysql.com/doc/refman/4.1/en/string-functions.html CONCAT() perhaps. Scanned by mailCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Wrap a href Tag Around Result
select CONCAT('a
href=index.php?action=view_userfirstname=',Firstname,'',Firstname,'/a')
from Users;
Shaun wrote:
Hi,
Is it possible to wrap an a href tag around a column in a resultset? For
example:
SELECT Firstname FROM Users;
Matthew
Mark
Luke
John
Becomes:
a href=index.php?action=view_userfirstname=MatthewMatthew/a
a href=index.php?action=view_userfirstname=MarkMark/a
a href=index.php?action=view_userfirstname=LukeLuke/a
a href=index.php?action=view_userfirstname=JohnJohn/a
I need to do this with pure SQL - no server side scripting...
Thanks for your advice
--
Marco Baroetto Parisi
Ribes Informatica - Via Jervis, 60 - 10015 Ivrea (TO) - Italy
Tel: +39-0125-62.78.50 - Fax: +39-0125-64.44.39
Web: http://www.grupporibes.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Edit utf-8 tables via the client
Hello. Please, check that you can see hebrew data in your terminal (you have appropriative fonts installed). Send to the list a CREATE statement for you table and output of the following statement: show variables like '%char%'; Yair Zohar wrote: Hello, I'm using mysql-standard-4.1.14 and mysql-client-4.1.14 on a RH9 machine, I have utf-8 tables with hebrew data. When using the client I see the hebrew as question marks. I would like to view and edit the data via the client. I've tried using a terminal that is surely able to view unicode. Any suggestions? Yair. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
mysqlbug_ problem with 5016 startup - doesnt work (2 bugs found)
Description: mysql will not create /tmp/mysql.sock at first it would not create /var/run/mysql/mysqld.pid - I manually created the /var/run/mysql and set permissions, and it works. now i have problems with the socket file - it wont create it How-To-Repeat: bin/mysqld_safe --user=mysql ./bin/mysqladmin -u root password 'new-password' seems to put the socket file in the wrong place- (should be in /tmp) mysql29520 0.0 0.6 116700 14372 pts/0 S11:56 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] (root) Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-5.0.16-max (MySQL Community Edition - Experimental (GPL)) C compiler:gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) Environment: machine, os, target, libraries (multiple lines) System: Linux tidctnsddcdb01 2.4.21-37.ELsmp #1 SMP Wed Sep 7 13:28:55 EDT 2005 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-53) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 4 15:12 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x1 root root 1569156 Sep 16 19:45 /lib/libc-2.3.2.so -rw-r--r--1 root root 2469146 Sep 16 18:02 /usr/lib/libc.a -rw-r--r--1 root root 204 Sep 16 17:43 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Edition - Experimental (GPL)' '--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-zlib-dir=bundled' '--with-big-tables' '--with-readline' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--with-ndbcluster' '--with-csv-storage-engine' '--with-example-storage-engine' '--with-federated-storage-engine' '--with-innodb' 'CC=gcc' 'CXX=gcc' _ Take advantage of powerful junk e-mail filters built on patented Microsoft® SmartScreen Technology. http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: DBD::mysql will make but won't test on Solaris10...
Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-xarch=v9' Using DBI 1.48 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE dbdimp.c /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI//Driver.xst mysql.xsi /usr/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -typemap /usr/perl5/5.8.4/lib/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 224 Warning: duplicate function definition 'rows' detected in mysql.xs, line 559 cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/opt/mysql/mysql/lib:/lib:/usr/lib /usr/bin/perl myld cc -G dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/opt/mysql/mysql/lib -lmy sqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc chmod 755 blib/arch/auto/DBD/mysql/mysql.so cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs chmod 644 blib/arch/auto/DBD/mysql/mysql.bs Manifying blib/man3/DBD::mysql.3 Manifying blib/man3/DBD::mysql::INSTALL.3 Manifying blib/man3/Mysql.3 Manifying blib/man3/Bundle::DBD::mysql.3 /usr/local/bin/make -- OK Running make test PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00base.install_driver(mysql) failed: Can't load '/export/home/root/.cpan/build/DBD- mysql-3.0002/blib/arch/auto/DBD/mysql/mysql.so' for module DBD ::mysql: ld.so.1: perl: fatal: libmtmalloc.so.1 : DF_1_NOOPEN tagged object may not be dlopen()'ed at /usr/perl5/5.8.4/lib/sun4-solaris-64int/DynaLoader.pm line 230. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay
Question
What is the MySQL equivalent to Sybase's @@error and @@rowcount? I'm writing stored procedures where I want to log database error codes. Please let me know. Thanks, Brandon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBD::mysql will make but won't test on Solaris10...
Yep, the objects appear to be ok including the offending libmtmalloc.so.1... # ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so librt.so.1 =/lib/librt.so.1 libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1 libgen.so.1 = /lib/libgen.so.1 libsocket.so.1 =/lib/libsocket.so.1 libnsl.so.1 = /lib/libnsl.so.1 libm.so.2 = /lib/libm.so.2 libmtmalloc.so.1 = /usr/lib/libmtmalloc.so.1 libc.so.1 = /lib/libc.so.1 libaio.so.1 = /lib/libaio.so.1 libmd5.so.1 = /lib/libmd5.so.1 libmp.so.2 =/lib/libmp.so.2 libscf.so.1 = /lib/libscf.so.1 libdoor.so.1 = /lib/libdoor.so.1 libuutil.so.1 = /lib/libuutil.so.1 /platform/SUNW,Ultra-80/lib/libc_psr.so.1 /platform/SUNW,Ultra-80/lib/libmd5_psr.so.1 On 12/7/05, Mir Islam [EMAIL PROTECTED] wrote: hmm it appears that the module got compiled fine. Try doing: ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so and see if all of the referenced objects are loading fine On 12/7/05, Jake Peavy [EMAIL PROTECTED] wrote: Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD- mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-xarch=v9' Using DBI 1.48 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE dbdimp.c /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI//Driver.xst mysql.xsi /usr/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -typemap /usr/perl5/5.8.4/lib/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 224 Warning: duplicate function definition 'rows' detected in mysql.xs, line 559 cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so
Re: mysqlbug_ problem with 5016 startup - doesnt work (2 bugs found)
Hello. seems to put the socket file in the wrong place- (should be in /tmp) Your running copy of mysqld has --socket==/var/lib/mysql/mysql.sock argument. Perhaps mysqld_safe puts it by default or reads from [mysqld_safe] or [mysqld] sections of configuration file. Specify the value of socket variable explicitly. See: http://dev.mysql.com/doc/refman/5.0/en/program-options.html Dan Gahlinger wrote: Description: mysql will not create /tmp/mysql.sock at first it would not create /var/run/mysql/mysqld.pid - I manually created the /var/run/mysql and set permissions, and it works. now i have problems with the socket file - it wont create it How-To-Repeat: bin/mysqld_safe --user=mysql ./bin/mysqladmin -u root password 'new-password' seems to put the socket file in the wrong place- (should be in /tmp) mysql29520 0.0 0.6 116700 14372 pts/0 S11:56 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] (root) Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-5.0.16-max (MySQL Community Edition - Experimental (GPL)) C compiler:gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) C++ compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52) Environment: machine, os, target, libraries (multiple lines) System: Linux tidctnsddcdb01 2.4.21-37.ELsmp #1 SMP Wed Sep 7 13:28:55 EDT 2005 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.3/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux Thread model: posix gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-53) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 4 15:12 /lib/libc.so.6 - libc-2.3.2.so -rwxr-xr-x1 root root 1569156 Sep 16 19:45 /lib/libc-2.3.2.so -rw-r--r--1 root root 2469146 Sep 16 18:02 /usr/lib/libc.a -rw-r--r--1 root root 204 Sep 16 17:43 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=MySQL Community Edition - Experimental (GPL)' '--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-zlib-dir=bundled' '--with-big-tables' '--with-readline' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--with-ndbcluster' '--with-csv-storage-engine' '--with-example-storage-engine' '--with-federated-storage-engine' '--with-innodb' 'CC=gcc' 'CXX=gcc' _ Take advantage of powerful junk e-mail filters built on patented Microsoft� SmartScreen Technology. http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN� Premium right now and get the first two months FREE*. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: Character set issue ( maybe )
Hello. But anyway, the source *IS* latin1, so maybe this shouldn't be a problem anyway? In theory if the source contains only characters from latin1 set there shouldn't be any problems, but are you sure that you're inserting latin1 characters? What is your locale settings? If you can, temporary switch it to utf8. Force character_set_connection, character_set_client, character_set_results variables to have 'utf8' value. Change the default character set of all fields to utf8 (ALTER TABLE can do this or just create a new table). Check if you're able to store and get correct data in mysql command line client. Thanks for the reply, by the way :) I also read your posts to the list with great pleasure :) Daniel Kasak wrote: Gleb Paharenko wrote: Hello. I've been able to insert Russian characters (utf8) through the QueryBrowser under Linux (FC4). Please, could you provide CREATE statement for you table CREATE TABLE `WebNewsPostings` ( `PRID` mediumint(8) unsigned NOT NULL auto_increment, `MyStamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `DateDay` tinyint(3) unsigned NOT NULL default '0', `DateMonth` tinyint(3) unsigned NOT NULL default '0', `DateYear` mediumint(8) unsigned NOT NULL default '0', `CopyTitle` varchar(255) character set latin1 NOT NULL default '', `CopyMain` mediumtext character set latin1 NOT NULL, `Image` varchar(50) character set latin1 default '', `Language` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`PRID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 I don't know what those individual 'character set latin1' bits are. I haven't been messing with per-field character sets - I've just been using mysql-administrator to change the character set for the entire table. But anyway, the source *IS* latin1, so maybe this shouldn't be a problem anyway? and output of: show variables like '%char%'; mysql show variables like '%char%'; +--++ | Variable_name| Value | +--++ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_results| latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--++ 7 rows in set (0.00 sec) As far as I know, QueryBrowser invokes SET NAMES 'utf8' by default. And the only way to force it to use your connection character sets is to run a transaction. Are characters that you're pasting into QueryBrowser displayed correctly in the query tab? Yes. They display correctly - both in query browser AND in my Perl Gtk2 app. What's more, when I inspect the binary query log, the same sequence of reverse-coloured characters is used to represent the characters that are giving problems. Which ever method I use to get the data in ( query browser / in-house Perl Gtk2 app ), the data *looks* perfect when I paste it in, but when I return to look at it later it's corrupted. Thanks for the reply, by the way :) Dan -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: DBD::mysql will make but won't test on Solaris10...
Hello. I'm not a Solaris or DBD guru, so I could be wrong, but ldd output doesn't show that mysql.so loads libmysqlclient (however, it can be statically linked). There could be some problems with compiling MySQL clients which described more in detail at: http://dev.mysql.com/doc/refman/5.0/en/solaris.html http://dev.mysql.com/doc/refman/5.0/en/perl-support-problems.html I've found a bit similar issue related to building php-mysql extension on MySQL forums. The person declares that he has solve the problem. May be it will help you: http://forums.mysql.com/read.php?52,9,9,quote=1` Jake Peavy [EMAIL PROTECTED] wrote: Yep, the objects appear to be ok including the offending libmtmalloc.so.1... # ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so librt.so.1 =/lib/librt.so.1 libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1 libgen.so.1 = /lib/libgen.so.1 libsocket.so.1 =/lib/libsocket.so.1 libnsl.so.1 = /lib/libnsl.so.1 libm.so.2 = /lib/libm.so.2 libmtmalloc.so.1 = /usr/lib/libmtmalloc.so.1 libc.so.1 = /lib/libc.so.1 libaio.so.1 = /lib/libaio.so.1 libmd5.so.1 = /lib/libmd5.so.1 libmp.so.2 =/lib/libmp.so.2 libscf.so.1 = /lib/libscf.so.1 libdoor.so.1 = /lib/libdoor.so.1 libuutil.so.1 = /lib/libuutil.so.1 /platform/SUNW,Ultra-80/lib/libc_psr.so.1 /platform/SUNW,Ultra-80/lib/libmd5_psr.so.1 On 12/7/05, Mir Islam [EMAIL PROTECTED] wrote: hmm it appears that the module got compiled fine. Try doing: ldd /export/home/root/.cpan/build/DBD-mysql-3.0002 /blib/arch/auto/DBD/mysql/mysql.so and see if all of the referenced objects are loading fine On 12/7/05, Jake Peavy [EMAIL PROTECTED] wrote: Since I didn't get a response from the perl list, and since Daryn received some responses to his similar question I thought I might see if you guys had any ideas on why I can't make test for DBD::mysql on Solaris. TIA, F -- Forwarded message -- From: Jake Peavy [EMAIL PROTECTED] Date: Nov 29, 2005 11:37 PM Subject: DBD::mysql will make but won't test on Solaris10... To: [EMAIL PROTECTED] Hey yall, I'm having all kinds of problems trying to install DBD::mysql on my newly built Solaris 10 box. I have installed the Sun CC compiler, and DBI installed fine along with a number of other CPAN modules. I have installed mysql via the pkgadd package. Here's the output (this is only the results from the first test. none of the tests passed 100% - there were TONS of failures.) note that there are some warnings thrown by make - duplicate functions? xarch=v9 not recognized? also, libmtmalloc.so.1 is located in /usr/lib. Thanks in advance, -jp CPAN.pm: Going to build C/CA/CAPTTOFU/DBD- mysql-3.0002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none embedded (mysql_config) = libs (mysql_config) = -xarch=v9 -L/opt/mysql/mysql/lib -lmysqlclient -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm -lmtmalloc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-xarch=v9' Using DBI 1.48 (for perl 5.008004 on sun4-solaris-64int) installed in /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI/ -I/opt/mysql/mysql/include -xO3 -mt -D_FORTEC_ -xarch=v9 -xc99=none -DDBD_MYSQL_INSERT_ID_IS_G OOD -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -xarch=v8 -D_TS_ERRNO -xO3 -xspace -xildoff -DVERSION=\ 3.0002\ -DXS_VERSION=\3.0002\ -KPIC -I/usr/per l5/5.8.4/lib/sun4-solaris-64int/CORE dbdimp.c /usr/bin/perl -p -e s/~DRIVER~/mysql/g /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/auto/DBI//Driver.xst mysql.xsi /usr/bin/perl
mysqldump dumping a table but not all columns?
i´m using mysqldump to dump some tables and then load it into another mysql server with mysql command. but can i specify what columns in the tables to dump? i´m using something like this now mysqldump -h localhost -u root db tbl | mysql -h xxx.xxx.xxx -u login -pass -w db - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
New free desktop search application with MySql database option
kbforge.com is pleased to announce the first public release of kbforge, a new free desktop search application specifically designed for software developers. What differentiates kbforge from other desktop search programs, is its ability to assist the user in categorising the information before it is indexed. Using databases and collections of databases, kbforge can categorise information into meaningful subject matters. A host of other features and options make kbforge the ultimate tool for finding that elusive program fragment, or example or article. Its companion product, kbforge.plus, provides additional features, such as indexing inside .ZIP and .JAR files, removal of HTML tags before indexing, etc., and a wide choice of database managers including MySql and other relational databases. kbforge is a Java application, and possibly the first of its kind to run under Linux as well as Windows, and soon under Mac OS. kbforge v1.20 can be downloaded completely free from http://www.kbforge.com Victor Negrin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
