ANN: Advanced Data Generator 1.6.1 released

[Martijn Tonies]

Dear ladies and gentlemen,

Upscene Productions is happy to announce a new version of
the database developer tool:
Advanced Data Generator (version 1.6.1)

Version 1.6.1 for MySQL specifically fixes an issue with
reporting the null-ability on columns in MySQL 4 and 4.1
( http://tracker.upscene.com/view.php?id=346 )

A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, many filling options, presets and 
much more.

This new release consists of four versions:

- Pro: ADO and ODBC connectivity
- InterBase Edition
- Firebird Edition
- MySQL Edition


More info and a 30-day trial version on www.upscene.com

Pricing information available on www.upscene.com/purchase.htm#adg


Recent changes include MySQL 5 Stored Procedure support
(MySQL Edition), Microsoft SQL 2005 support (Pro), large
font systems enhancements and several bugfixes.


With regards,

Martijn Tonies
Upscene Productions - Database Tools for Developers
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: Unicode (UTF-8) question

[古雷]

http://dev.mysql.com/doc/refman/5.0/en/myodbc-windows-binary-installation.html

I don't know how to use Delphi. But I think Delphi is easy to use ODBC just 
like VB or PB.

Run set names utf8 just like a normal SQL statement after connect.

If you don't understand let me know.

regards,

gu lei

- Original Message - 
From: Daniel Levy [EMAIL PROTECTED]
To: 古雷 [EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 3:26 PM
Subject: Re: Unicode (UTF-8) question


 Dear Gu Lei,
 
 Again, thank you very much for your reply and your help.
 
 I'm working with MySQL 5.0.18-nt via TCP/IP, MyODBC 3.51.12.00, and Delphi 5 
 on Windows XP Pro. The database in installed locally on the computer.
 
 From what you say, I understand that you need to set set names utf8 before 
 every attempt to connect to the db and retrieve data. Is this correct?
 
 Also, in the sample code you sent me, you call routines defined in 
 odbc32.dll, such as SQLAllocHandle and SQLExecDirect. Is there a file on the 
 internet with the definitions (interface) of the routines defined in this 
 dll, so that I can call them from Delphi?
 
 Thanks again. Best regards,
 Daniel
 
 
 
 - Original Message - 
 From: 古雷 [EMAIL PROTECTED]
 To: Daniel Levy [EMAIL PROTECTED]
 Sent: Thursday, March 23, 2006 3:41 AM
 Subject: Re: Unicode (UTF-8) question
 
 
 Daniel Levy,

 My pleasure.

 We have serveral communication servers such as mail server, SIP server and 
 conference server. All of them connect to and get data from a server 
 called PS server. And PS server read and write data from and to MySQL5.0 
 through MyODBC. Some of the data include Chinese. We use utf8 to store 
 Chinese in MySQL. All of those servers are on Linux.

 We use mysql-connector-odbc 3.51.12.
 Before this version mysql-connector-odbc reconnected to MySQL 
 automatically after connection lost. After reconnection ,variables' value 
 set by set unames utf8 were restored to default latin1. At that time 
 PS server can not read and write correct Chinese from and to MySQL.

 I don't know if what I said is enough.

 Regards,

 gu lei

 - Original Message - 
 From: Daniel Levy [EMAIL PROTECTED]
 To: 古雷 [EMAIL PROTECTED]
 Sent: Wednesday, March 22, 2006 6:57 PM
 Subject: Re: Unicode (UTF-8) question


 Dear Gu Lei,

 I have been reviewing your reply to the question I posted on the mysql 
 list.

 Due to the problems I was having trying to retrieve Unicode data using
 MyODBC, I decided to try other third-party data access components. When I
 thought that I finally found a solution, I started getting some strange
 internal errors in the IDE. I'm using Delphi 5.

 I want to give MyODBC another try. Can you please explain briefly where 
 you
 are using this code you sent me? What else do I need? Any tip you can 
 give
 me will be greatly appreciated.

 Thanks in advance,
 Daniel Levy


 - Original Message - 
 From: 古雷 [EMAIL PROTECTED]
 To: Daniel Levy [EMAIL PROTECTED]; Paun [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, February 06, 2006 3:09 AM
 Subject: Re: Unicode (UTF-8) question


 I have tried setting the character set of the table to utf8, and the
 specific column character set to utf8. I've also tried configuring 
 the
 ODBC's Connect Options to 'set names utf8';
 How did you configure that option?
 This is my may:
SQLHSTMT hstmtset;
SQLINTEGER rc;
rc = SQLAllocHandle (SQL_HANDLE_STMT, hdbc, hstmtset);
if(rc0)
{
ostringstream err;
errSQLAllocHandle (SQL_HANDLE_STMT, hdbc, 
 hstmtset)endl;
errgetSQLError(SQL_HANDLE_STMT,hstmtset);
throwExecption(__FILE__,__LINE__,err.str());
}
char setnames[]=SET names utf8;
rc = 
 SQLExecDirect(hstmtset,(SQLCHAR*)setnames,sizeof(setnames)-1);
if(rc0)
{
ostringstream err;
errsetnamesendl;
errgetSQLError(SQL_HANDLE_STMT,hstmtset);
throwExecption(__FILE__,__LINE__,err.str());
}
 Our C/C++ application reads and writes utf8 Chinese with myODBC3.51. Our
 java application connect to MYSQL with JDBC. Both of them and MySQL 
 Query
 Browser can get correct Chinese from MySQL.

 Moreover, MySQL can convert character set between GB2312 and UTF-8. If 
 my
 program SQLExecDirect SET NAMES gb2312, it can read and write GB2312
 Chinese from and to MySQL correctly even the columns' character set is
 utf8.

 regards,
 gu lei
 

digest not received

[Rithish Saralaya]

I have not been receiving the daily digest for the past 2 days. Just wanted
to check if I am the only one it's the same for others too.

Regards,
Rithish.

Content analysis

[Jacob Friis Saxberg]

Is there any way I can do a content analysis with MySQL?

I need to find text in a database that have similarity.

/Jacob

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0.18 restore dump file 'max_allowed_packet' error

[Remo Tex]

Luke Vanderfluit wrote:

Hi.

I've got mysql 4.0.18 installed on a sun X4100 running solaris.
This is just a 32 bit version of mysql.

I've reverted back to this version after trying mysql 5, 4.0.26 and 
4.0.18 64bit.
Those versions were all unstable on 64bit, that is, the server would 
just go away for no apparent reason.
This would ofter rear it's head when importing a dump file, the dump 
file I need to import is around 10 GIG, but also at other unpredictable 
times.


I have this same database running on another machine running solaris, 
with no problems, except speed/performance.
This other machine is the one that produces the dump file I'm trying to 
import.

It does that with the following command:

/usr/local/bin/mysqldump --opt --complete-insert 
--max_allowed_packet=32M rt3 | bzip2 -9  rt3.out-`date +\%Y\%m\%d-\%H`.bz2


I'm trying to restore the file on the new machine and I'm getting a 
'max_allowed_packet' error:

ERROR 1153 at line 162: Got a packet bigger than 'max_allowed_packet

I've tried different settings for this in my.cnf, from 32 up to 1024M, 
and I still get the error.


Is there anything I can do to remedy this?

Kind regards.



  Yes in principle rules are:
http://www.mysql.com/news-and-events/newsletter/2003-08/a000216.html
  but you *must* enforce them on server too (not just on mysqldump):
http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html
 so either run second mysql with: mysqld --max_allowed_packet=32M
 or edit your my.cnf and restart mysqld:
   You can also use an option file to set max_allowed_packet. For 
example, to set the size for the server to 16MB, add the following lines 
in an option file:


[mysqld]
max_allowed_packet=32M

Before MySQL 4.0, use this syntax instead:

[mysqld]
set-variable = max_allowed_packet=32M

 or (if you're trying from mysql console then run it with)
  mysql --max_allowed_packet=32M

HTH

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Converting password to old format.

[Eugene Kosov]

Hi, everyone!

I have transfer user's database and grants from one mysql server 
(4.1.15) to an older one (4.0.26). I don't know user's password and have 
only it's hash. How can I convert hashed password stored in 
mysql.user.password field to the 4.0 format? Is there something similar 
to OLD_PASSWORD(), but with 4.1's hashed password as a parameter?


Any links, man references, etc. are welcome!

Thanks in advance!

--
Regards,
Eugene Kosov.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Error Messages

[rb]

Does anyone know the cause of the following error message
Ignoring query to other database

When I log onto the mysql monitor and use any command I get this message.
This is strange because last time I used my copy of mysql it worked just
fine.

I am using MAC OSX and I was wondering if the latest OSX update may have
caused this issue. This is the only change on my machine.
Or may be  I have just forgotten how to log in properly.
Thanks
Rob B



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Content analysis

[Jay Blanchard]

[snip]

Is there any way I can do a content analysis with MySQL?

I need to find text in a database that have similarity.
[/snip]

http://www.mysql.com/fulltext


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0.18 restore dump file 'max_allowed_packet' error

[SGreen]

Luke Vanderfluit [EMAIL PROTECTED] wrote on 03/22/2006 08:29:02 
PM:

 Hi.
 
 I've got mysql 4.0.18 installed on a sun X4100 running solaris.
 This is just a 32 bit version of mysql.
 
 I've reverted back to this version after trying mysql 5, 4.0.26 and 
 4.0.18 64bit.
 Those versions were all unstable on 64bit, that is, the server would 
 just go away for no apparent reason.
 This would ofter rear it's head when importing a dump file, the dump 
 file I need to import is around 10 GIG, but also at other unpredictable 
 times.
 
 I have this same database running on another machine running solaris, 
 with no problems, except speed/performance.
 This other machine is the one that produces the dump file I'm trying to 
 import.
 It does that with the following command:
 
 /usr/local/bin/mysqldump --opt --complete-insert 
 --max_allowed_packet=32M rt3 | bzip2 -9  rt3.out-`date 
+\%Y\%m\%d-\%H`.bz2
 
 I'm trying to restore the file on the new machine and I'm getting a 
 'max_allowed_packet' error:
 ERROR 1153 at line 162: Got a packet bigger than 'max_allowed_packet
 
 I've tried different settings for this in my.cnf, from 32 up to 1024M, 
 and I still get the error.
 
 Is there anything I can do to remedy this?
 
 Kind regards.
 
 
 -- 
 Luke
 

Not exactly sure if this has changed in a recent version but I believe 
that the MySQL protocol only allows for packets up to 16M. That has to do 
with the size of the part of the packet that handles that value.

Yep, here it is:  
http://dev.mysql.com/doc/internals/en/the-packet-header.html

7.4. The Packet Header

Bytes Name
- 
3 Packet Length
1 Packet Number

Packet Length: The length, in bytes, of the packet
   that follows the Packet Header. There
   may be some special values in the most
   significant byte. Since 2**24 = 16MB,
   the maximum packet length is 16MB.


You are going to need to re-dump your file or you will need to split your 
larger packets (probably INSERT statements) into smaller chunks.

More troubleshooting and information:
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

However, here it says the limit is 1GB:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

I don't know which document to trust. Try changing it to use 16M chunks 
and see if that helps you work around the issue.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

newbee error (1044)

[Shawn Sharp]

I get the following error while trying to create the following database

mysql mysql  zm_cre­ate.sql.in
ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database
'mysql'

I tried to run the following script

/usr/bin/mysql_in­stall_db --user­=mysql

It does not create mysql database in the correct directory I still only see
the 2 databases

/us­r/bin/mysqlshow
+---+
| Databases |
+---+
| test  |
+---+

Thanks

Re: Converting password to old format.

[SGreen]

Eugene Kosov [EMAIL PROTECTED] wrote on 03/23/2006 07:03:15 AM:

 Hi, everyone!
 
 I have transfer user's database and grants from one mysql server 
 (4.1.15) to an older one (4.0.26). I don't know user's password and have 

 only it's hash. How can I convert hashed password stored in 
 mysql.user.password field to the 4.0 format? Is there something similar 
 to OLD_PASSWORD(), but with 4.1's hashed password as a parameter?
 
 Any links, man references, etc. are welcome!
 
 Thanks in advance!
 
 --
 Regards,
 Eugene Kosov.
 

If such a function actually exists, it invalidates the premise that 
password hashes are only one-way. The algorithms (both pre-4.1 and 
post-4.1)  for generating password hashes are intended to be one-way 
hashes. Unless you have the original plain-text password, you should not 
be able to transfer your existing 4.1 users onto the 4.0.26 system. You 
will need to create new accounts on your 4.0.26 system for the old user 
names and let them reset their passwords.

Sorry! but it's designed to be this way.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Freeradius and MySql

[Atkins, Dwane P]

Good morning.  I am trying to install Free Radius with MySql, but I
either have a login issue or a permissions issue.  

 

I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
and just about everywhere I can think possible.  I have added
permissions for radius  radius local to databases mysql and database
radius.  However, when I try to log in to mysql using the command mysql
-u radius -p radius, I get and error stating, Error 1045 (28000):
Access Denied for user 'radius'@'localhost' (using:Password: YES).  I am
really frustrated since I have been working on this login and permission
issue for some time.


Thanks

mailto:[EMAIL PROTECTED]  

 

Question about autoincrement ID

[saf]

Hi,

I have a question about autoincremend id:
If I have an autoincrement id set on my first column field of my table and I 
have the
following entries:
1
3

And then I make a INSERT INTO foobar VALUES(''); , the next field would be 
automatically 4:
1
3
4

Is there a possibility to take a free ID to not use too high IDs for nothing?
I would like to take the ID 2 and not 4, because ID 2 is free.

My problem is that my system which uses the ID numbers in applications which 
uses them
as signed int or unsigned int,
so I will soon have a problem, because I insert (and delete some times) many 
entries in my SQL database,
but not more than the highest value of an signed integer.


-- 
Best regards,
saf
http://TrashMail.net/


signature.asc
Description: Digital signature

Re: Freeradius and MySql

[SGreen]

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM:

 Good morning.  I am trying to install Free Radius with MySql, but I
 either have a login issue or a permissions issue. 
 
 
 
 I have added Radius and [EMAIL PROTECTED] to database, Fedora local users
 and just about everywhere I can think possible.  I have added
 permissions for radius  radius local to databases mysql and database
 radius.  However, when I try to log in to mysql using the command mysql
 -u radius -p radius, I get and error stating, Error 1045 (28000):
 Access Denied for user 'radius'@'localhost' (using:Password: YES).  I am
 really frustrated since I have been working on this login and permission
 issue for some time.
 
 
 Thanks
 
 mailto:[EMAIL PROTECTED] 
 
 
 

Try this:
a) Verify that you have actually GRANTED permission for the account you 
are trying to authenticate with

SELECT user, host from mysql.user where user ='radius';
Then for each user-host combination listed above do one of these and 
compare the privileges listed to those you expected the accounts to have.

SHOW GRANTS FOR 'user'@'host';

b) if the records exist but aren't being respected, issue a FLUSH 
PRIVILEGES command.  I have noticed that (in contradiction to the 
documentation) that you sometimes need to manually refresh the privilege 
cache even after using a GRANT or REVOKE command.


If those don't get you started, come back with whatever new information 
you learn and we can try something else.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: Question about autoincrement ID

[SGreen]

[EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:

 Hi,
 
 I have a question about autoincremend id:
 If I have an autoincrement id set on my first column field of my 
 table and I have the
 following entries:
 1
 3
 
 And then I make a INSERT INTO foobar VALUES(''); , the next field 
 would be automatically 4:
 1
 3
 4
 
 Is there a possibility to take a free ID to not use too high IDs for 
nothing?
 I would like to take the ID 2 and not 4, because ID 2 is free.
 
 My problem is that my system which uses the ID numbers in 
 applications which uses them
 as signed int or unsigned int,
 so I will soon have a problem, because I insert (and delete some 
 times) many entries in my SQL database,
 but not more than the highest value of an signed integer.
 
 
 -- 
 Best regards,
 saf
 http://TrashMail.net/


The short answer is no.  The Record #2 already existed. It's current 
status is deleted. If you had other tables that linked their data to 
record #2 and you created a new #2 to replace the one you already deleted 
then you could possibly be making a bad match between the old data and 
the new data. 

For the sake of data consistency and for all of the other good reasons to 
have a relational database, once an auto_increment value has been issued 
it's considered used and no other record should ever have that number. 
Only if you completely reset your table (see the command TRUNCATE TABLE) 
could it be possibly safe to begin re-issuing the smaller numbers. Again, 
it's only possible if all of the child records that used to point to the 
old data were also deleted.

Do not rely on the auto_increment value for record sequencing. If you need 
your records serialized in some sequential way, you will need to code the 
support for those sequential numbers in your application.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: Question about autoincrement ID

[saf]

On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
 [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:

 The short answer is no.  The Record #2 already existed. It's current 
 status is deleted. If you had other tables that linked their data to 
 record #2 and you created a new #2 to replace the one you already deleted 
 then you could possibly be making a bad match between the old data and 
 the new data. 
 
 For the sake of data consistency and for all of the other good reasons to 
 have a relational database, once an auto_increment value has been issued 
 it's considered used and no other record should ever have that number. 
 Only if you completely reset your table (see the command TRUNCATE TABLE) 
 could it be possibly safe to begin re-issuing the smaller numbers. Again, 
 it's only possible if all of the child records that used to point to the 
 old data were also deleted.
 
 Do not rely on the auto_increment value for record sequencing. If you need 
 your records serialized in some sequential way, you will need to code the 
 support for those sequential numbers in your application.

So I must do a big SELECT and then check my self every time (for each INSERT),
which IDs are free?
Hmm if the table has more than 100 000 entries, this will slow down my system.
Specialitty because the check function would be written in PHP.

-- 
Best regards,
saf
http://www.trashmail.net/



signature.asc
Description: Digital signature

Re: Question about autoincrement ID

[Alec . Cawley]

[EMAIL PROTECTED] (saf) wrote on 23/03/2006 16:10:04:

 On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
  [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
 
  The short answer is no.  The Record #2 already existed. It's current 

  status is deleted. If you had other tables that linked their data to 

  record #2 and you created a new #2 to replace the one you already 
deleted 
  then you could possibly be making a bad match between the old data 
and 
  the new data. 
  
  For the sake of data consistency and for all of the other good reasons 
to 
  have a relational database, once an auto_increment value has been 
issued 
  it's considered used and no other record should ever have that number. 

  Only if you completely reset your table (see the command TRUNCATE 
TABLE) 
  could it be possibly safe to begin re-issuing the smaller numbers. 
Again, 
  it's only possible if all of the child records that used to point to 
the 
  old data were also deleted.
  
  Do not rely on the auto_increment value for record sequencing. If you 
need 
  your records serialized in some sequential way, you will need to code 
the 
  support for those sequential numbers in your application.
 
 So I must do a big SELECT and then check my self every time (for each 
INSERT),
 which IDs are free?
 Hmm if the table has more than 100 000 entries, this will slow down my 
system.
 Specialitty because the check function would be written in PHP.

Lots of ways round this. Instead of deleting records, add a boolean 
deleted flag. All selects then need to add and deleted = 0. But you 
can find a (random) deleted row with select id from table where deleted = 
1 limit 1. If this returns a result, use update to re-populate that 
record, clearing the deleted flag. If it returns nothing, use insert to 
create a new record.

Alec


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question about autoincrement ID

[saf]

On Thu, Mar 23, 2006 at 04:17:44PM +, [EMAIL PROTECTED] wrote:
 Lots of ways round this. Instead of deleting records, add a boolean
 deleted flag. All selects then need to add and deleted = 0. But you can
 find a (random) deleted row with select id from table where deleted = 1
 limit 1. If this returns a result, use update to re-populate that record,
 clearing the deleted flag. If it returns nothing, use insert to create a
 new record.

Great idea!!
Many thanks!!!

-- 
Best regards,
saf
http://Trashmail.net/



signature.asc
Description: Digital signature

Re: Question about autoincrement ID

[Martijn Tonies]

So I must do a big SELECT and then check my self every time (for each
INSERT),
which IDs are free?

No, you just ignore deleted IDs.

What's the point?


Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Freeradius and MySql

[Atkins, Dwane P]

*  a) Verify that you have actually GRANTED permission for the
account you are trying to authenticate with 

SELECT user, host from mysql.user where user ='radius'; 



mysql SELECT user, host from mysql.user where user ='radius';

++---+

| user   | host  |

++---+

| radius | % |

| radius | localhost |

++---+

2 rows in set (0.00 sec)

 

SHOW GRANTS FOR 'user'@'host';

 

mysql SHOW GRANTS FOR 'radius'@'localhost'; 

++

| Grants for [EMAIL PROTECTED]|

++

| GRANT USAGE ON *.* TO 'radius'@'localhost' |

| GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |

++

2 rows in set (0.00 sec)

 

 

As you can see, it looks like I have granted permissions to the user,
[EMAIL PROTECTED] for db radius.  I am not sure what to do next.

 

Thanks

 

Dwane

 

 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 23, 2006 9:51 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: Re: Freeradius and MySql

 



Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM:

 Good morning.  I am trying to install Free Radius with MySql, but I
 either have a login issue or a permissions issue.  
 
  
 
 I have added Radius and [EMAIL PROTECTED] to database, Fedora local
users
 and just about everywhere I can think possible.  I have added
 permissions for radius  radius local to databases mysql and database
 radius.  However, when I try to log in to mysql using the command
mysql
 -u radius -p radius, I get and error stating, Error 1045 (28000):
 Access Denied for user 'radius'@'localhost' (using:Password: YES).  I
am
 really frustrated since I have been working on this login and
permission
 issue for some time.
 
 
 Thanks
 
 mailto:[EMAIL PROTECTED]  
 
  
 

Try this: 
a) Verify that you have actually GRANTED permission for the account you
are trying to authenticate with 

SELECT user, host from mysql.user where user ='radius'; 
Then for each user-host combination listed above do one of these and
compare the privileges listed to those you expected the accounts to
have. 

SHOW GRANTS FOR 'user'@'host'; 

b) if the records exist but aren't being respected, issue a FLUSH
PRIVILEGES command.  I have noticed that (in contradiction to the
documentation) that you sometimes need to manually refresh the privilege
cache even after using a GRANT or REVOKE command. 


If those don't get you started, come back with whatever new information
you learn and we can try something else. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

Re: Question about autoincrement ID

[SGreen]

[EMAIL PROTECTED] (saf) wrote on 03/23/2006 11:10:04 AM:

 On Thu, Mar 23, 2006 at 11:04:55AM -0500, [EMAIL PROTECTED] wrote:
  [EMAIL PROTECTED] (saf) wrote on 03/23/2006 10:50:10 AM:
 
  The short answer is no.  The Record #2 already existed. It's current 

  status is deleted. If you had other tables that linked their data to 

  record #2 and you created a new #2 to replace the one you already 
deleted 
  then you could possibly be making a bad match between the old data 
and 
  the new data. 
  
  For the sake of data consistency and for all of the other good reasons 
to 
  have a relational database, once an auto_increment value has been 
issued 
  it's considered used and no other record should ever have that number. 

  Only if you completely reset your table (see the command TRUNCATE 
TABLE) 
  could it be possibly safe to begin re-issuing the smaller numbers. 
Again, 
  it's only possible if all of the child records that used to point to 
the 
  old data were also deleted.
  
  Do not rely on the auto_increment value for record sequencing. If you 
need 
  your records serialized in some sequential way, you will need to code 
the 
  support for those sequential numbers in your application.
 
 So I must do a big SELECT and then check my self every time (for each 
INSERT),
 which IDs are free?
 Hmm if the table has more than 100 000 entries, this will slow down my 
system.
 Specialitty because the check function would be written in PHP.
 
 -- 
 Best regards,
 saf
 http://www.trashmail.net/
 

No, you should quit trying to tell the database how it should implement 
auto_increment. If you don't want a monotonically increasing integer value 
to be automatically generated for each new record (or attempted new 
record) then simply don't use auto_increment. At that point you can make 
your ID values anything you want because you are going to be completely in 
charge of creating them.

There are dozens of great reasons why the database has an auto_increment 
function built into it. There are probably as many reasons why doing what 
you propose to do is normally considered very bad practice.  What's the 
real reason you don't want to let auto_increment do its automatic 
numbering? 

Many of us on the list manage databases with millions or billions of rows 
in our tables and we DO NOT even attempt to fill in the gaps as you 
propose to do.  There is just no good reason to do it, and several good 
reasons to NOT do it.

One important thing to remember: You should not let UI design requirements 
dictate your DB design. Most developers who design the database just to 
support the front end up regretting the decision. Those designs are either 
impossible to extend or impossible to manage or both. You should always 
design for an efficient database and adjust your retrieval methods to 
present the data in the manner requested, not the other way around.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

RE: Freeradius and MySql

[SGreen]

You could try suggestion B)   ;-)

Shawn

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24 AM:

 *  a) Verify that you have actually GRANTED permission for the
 account you are trying to authenticate with 
 
 SELECT user, host from mysql.user where user ='radius'; 
 
 
 
 mysql SELECT user, host from mysql.user where user ='radius';
 
 ++---+
 
 | user   | host  |
 
 ++---+
 
 | radius | % |
 
 | radius | localhost |
 
 ++---+
 
 2 rows in set (0.00 sec)
 
 
 
 SHOW GRANTS FOR 'user'@'host';
 
 
 
 mysql SHOW GRANTS FOR 'radius'@'localhost'; 
 
 ++
 
 | Grants for [EMAIL PROTECTED]|
 
 ++
 
 | GRANT USAGE ON *.* TO 'radius'@'localhost' |
 
 | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
 
 ++
 
 2 rows in set (0.00 sec)
 
 
 
 
 
 As you can see, it looks like I have granted permissions to the user,
 [EMAIL PROTECTED] for db radius.  I am not sure what to do next.
 
 
 
 Thanks
 
 
 
 Dwane
 
 
 
 
 
 
 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, March 23, 2006 9:51 AM
 To: Atkins, Dwane P
 Cc: mysql@lists.mysql.com
 Subject: Re: Freeradius and MySql
 
 
 
 
 
 Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM:
 
  Good morning.  I am trying to install Free Radius with MySql, but I
  either have a login issue or a permissions issue. 
  
  
  
  I have added Radius and [EMAIL PROTECTED] to database, Fedora local
 users
  and just about everywhere I can think possible.  I have added
  permissions for radius  radius local to databases mysql and database
  radius.  However, when I try to log in to mysql using the command
 mysql
  -u radius -p radius, I get and error stating, Error 1045 (28000):
  Access Denied for user 'radius'@'localhost' (using:Password: YES).  I
 am
  really frustrated since I have been working on this login and
 permission
  issue for some time.
  
  
  Thanks
  
  mailto:[EMAIL PROTECTED] 
  
  
  
 
 Try this: 
 a) Verify that you have actually GRANTED permission for the account you
 are trying to authenticate with 
 
 SELECT user, host from mysql.user where user ='radius'; 
 Then for each user-host combination listed above do one of these and
 compare the privileges listed to those you expected the accounts to
 have. 
 
 SHOW GRANTS FOR 'user'@'host'; 
 
 b) if the records exist but aren't being respected, issue a FLUSH
 PRIVILEGES command.  I have noticed that (in contradiction to the
 documentation) that you sometimes need to manually refresh the privilege
 cache even after using a GRANT or REVOKE command. 
 
 
 If those don't get you started, come back with whatever new information
 you learn and we can try something else. 
 
 Shawn Green
 Database Administrator
 Unimin Corporation - Spruce Pine 
 

RE: Freeradius and MySql

[Atkins, Dwane P]

I did do a FLUSH PRIVILEGES and this still resulted in the same error.

 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 23, 2006 10:31 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql

 


You could try suggestion B)   ;-) 

Shawn 

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24 AM:

 *  a) Verify that you have actually GRANTED permission for the
 account you are trying to authenticate with 
 
 SELECT user, host from mysql.user where user ='radius'; 
 
 
 
 mysql SELECT user, host from mysql.user where user ='radius';
 
 ++---+
 
 | user   | host  |
 
 ++---+
 
 | radius | % |
 
 | radius | localhost |
 
 ++---+
 
 2 rows in set (0.00 sec)
 
  
 
 SHOW GRANTS FOR 'user'@'host';
 
  
 
 mysql SHOW GRANTS FOR 'radius'@'localhost'; 
 
 ++
 
 | Grants for [EMAIL PROTECTED]|
 
 ++
 
 | GRANT USAGE ON *.* TO 'radius'@'localhost' |
 
 | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
 
 ++
 
 2 rows in set (0.00 sec)
 
  
 
  
 
 As you can see, it looks like I have granted permissions to the user,
 [EMAIL PROTECTED] for db radius.  I am not sure what to do next.
 
  
 
 Thanks
 
  
 
 Dwane
 
  
 
  
 
 
 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, March 23, 2006 9:51 AM
 To: Atkins, Dwane P
 Cc: mysql@lists.mysql.com
 Subject: Re: Freeradius and MySql
 
  
 
 
 
 Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57
AM:
 
  Good morning.  I am trying to install Free Radius with MySql, but I
  either have a login issue or a permissions issue.  
  
   
  
  I have added Radius and [EMAIL PROTECTED] to database, Fedora local
 users
  and just about everywhere I can think possible.  I have added
  permissions for radius  radius local to databases mysql and
database
  radius.  However, when I try to log in to mysql using the command
 mysql
  -u radius -p radius, I get and error stating, Error 1045 (28000):
  Access Denied for user 'radius'@'localhost' (using:Password: YES).
I
 am
  really frustrated since I have been working on this login and
 permission
  issue for some time.
  
  
  Thanks
  
  mailto:[EMAIL PROTECTED]  
  
   
  
 
 Try this: 
 a) Verify that you have actually GRANTED permission for the account
you
 are trying to authenticate with 
 
 SELECT user, host from mysql.user where user ='radius'; 
 Then for each user-host combination listed above do one of these and
 compare the privileges listed to those you expected the accounts to
 have. 
 
 SHOW GRANTS FOR 'user'@'host'; 
 
 b) if the records exist but aren't being respected, issue a FLUSH
 PRIVILEGES command.  I have noticed that (in contradiction to the
 documentation) that you sometimes need to manually refresh the
privilege
 cache even after using a GRANT or REVOKE command. 
 
 
 If those don't get you started, come back with whatever new
information
 you learn and we can try something else. 
 
 Shawn Green
 Database Administrator
 Unimin Corporation - Spruce Pine 
 

RE: Freeradius and MySql

[SGreen]

OK, make sure you are using the correct password, too.  Did you remember 
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you create 
the account? 

SELECT user, host, password
FROM mysql.user 
WHERE user='radius';

make sure your password is hashed, if not we can help you fix that pretty 
easily

UPDATE mysql.user
SET `password`=PASSWORD('plain-text-of-password')
WHERE user='radius';

FLUSH PRIVILEGES;

Then try again.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:30:41 AM:

 I did do a FLUSH PRIVILEGES and this still resulted in the same error.
 
 
 
 
 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, March 23, 2006 10:31 AM
 To: Atkins, Dwane P
 Cc: mysql@lists.mysql.com
 Subject: RE: Freeradius and MySql
 
 
 
 
 You could try suggestion B)   ;-) 
 
 Shawn 
 
 Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24 AM:
 
  *  a) Verify that you have actually GRANTED permission for the
  account you are trying to authenticate with 
  
  SELECT user, host from mysql.user where user ='radius'; 
  
  
  
  mysql SELECT user, host from mysql.user where user ='radius';
  
  ++---+
  
  | user   | host  |
  
  ++---+
  
  | radius | % |
  
  | radius | localhost |
  
  ++---+
  
  2 rows in set (0.00 sec)
  
  
  
  SHOW GRANTS FOR 'user'@'host';
  
  
  
  mysql SHOW GRANTS FOR 'radius'@'localhost'; 
  
  ++
  
  | Grants for [EMAIL PROTECTED]|
  
  ++
  
  | GRANT USAGE ON *.* TO 'radius'@'localhost' |
  
  | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
  
  ++
  
  2 rows in set (0.00 sec)
  
  
  
  
  
  As you can see, it looks like I have granted permissions to the user,
  [EMAIL PROTECTED] for db radius.  I am not sure what to do next.
  
  
  
  Thanks
  
  
  
  Dwane
  
  
  
  
  
  
  
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, March 23, 2006 9:51 AM
  To: Atkins, Dwane P
  Cc: mysql@lists.mysql.com
  Subject: Re: Freeradius and MySql
  
  
  
  
  
  Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57
 AM:
  
   Good morning.  I am trying to install Free Radius with MySql, but I
   either have a login issue or a permissions issue. 
   
   
   
   I have added Radius and [EMAIL PROTECTED] to database, Fedora local
  users
   and just about everywhere I can think possible.  I have added
   permissions for radius  radius local to databases mysql and
 database
   radius.  However, when I try to log in to mysql using the command
  mysql
   -u radius -p radius, I get and error stating, Error 1045 (28000):
   Access Denied for user 'radius'@'localhost' (using:Password: YES).
 I
  am
   really frustrated since I have been working on this login and
  permission
   issue for some time.
   
   
   Thanks
   
   mailto:[EMAIL PROTECTED] 
   
   
   
  
  Try this: 
  a) Verify that you have actually GRANTED permission for the account
 you
  are trying to authenticate with 
  
  SELECT user, host from mysql.user where user ='radius'; 
  Then for each user-host combination listed above do one of these and
  compare the privileges listed to those you expected the accounts to
  have. 
  
  SHOW GRANTS FOR 'user'@'host'; 
  
  b) if the records exist but aren't being respected, issue a FLUSH
  PRIVILEGES command.  I have noticed that (in contradiction to the
  documentation) that you sometimes need to manually refresh the
 privilege
  cache even after using a GRANT or REVOKE command. 
  
  
  If those don't get you started, come back with whatever new
 information
  you learn and we can try something else. 
  
  Shawn Green
  Database Administrator
  Unimin Corporation - Spruce Pine 
  
 

RE: Freeradius and MySql

[Atkins, Dwane P]

I didn't encrypt and that was going to be my next questions.  How do I
do that?

 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 23, 2006 10:45 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql

 


OK, make sure you are using the correct password, too.  Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you
create the account? 

SELECT user, host, password 
FROM mysql.user 
WHERE user='radius'; 

make sure your password is hashed, if not we can help you fix that
pretty easily 

UPDATE mysql.user 
SET `password`=PASSWORD('plain-text-of-password') 
WHERE user='radius'; 

FLUSH PRIVILEGES; 

Then try again. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:30:41 AM:

 I did do a FLUSH PRIVILEGES and this still resulted in the same error.
 
  
 
 
 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, March 23, 2006 10:31 AM
 To: Atkins, Dwane P
 Cc: mysql@lists.mysql.com
 Subject: RE: Freeradius and MySql
 
  
 
 
 You could try suggestion B)   ;-) 
 
 Shawn 
 
 Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24
AM:
 
  *  a) Verify that you have actually GRANTED permission for the
  account you are trying to authenticate with 
  
  SELECT user, host from mysql.user where user ='radius'; 
  
  
  
  mysql SELECT user, host from mysql.user where user ='radius';
  
  ++---+
  
  | user   | host  |
  
  ++---+
  
  | radius | % |
  
  | radius | localhost |
  
  ++---+
  
  2 rows in set (0.00 sec)
  
   
  
  SHOW GRANTS FOR 'user'@'host';
  
   
  
  mysql SHOW GRANTS FOR 'radius'@'localhost'; 
  
  ++
  
  | Grants for [EMAIL PROTECTED]|
  
  ++
  
  | GRANT USAGE ON *.* TO 'radius'@'localhost' |
  
  | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
  
  ++
  
  2 rows in set (0.00 sec)
  
   
  
   
  
  As you can see, it looks like I have granted permissions to the
user,
  [EMAIL PROTECTED] for db radius.  I am not sure what to do next.
  
   
  
  Thanks
  
   
  
  Dwane
  
   
  
   
  
  
  
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, March 23, 2006 9:51 AM
  To: Atkins, Dwane P
  Cc: mysql@lists.mysql.com
  Subject: Re: Freeradius and MySql
  
   
  
  
  
  Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57
 AM:
  
   Good morning.  I am trying to install Free Radius with MySql, but
I
   either have a login issue or a permissions issue.  
   

   
   I have added Radius and [EMAIL PROTECTED] to database, Fedora local
  users
   and just about everywhere I can think possible.  I have added
   permissions for radius  radius local to databases mysql and
 database
   radius.  However, when I try to log in to mysql using the command
  mysql
   -u radius -p radius, I get and error stating, Error 1045 (28000):
   Access Denied for user 'radius'@'localhost' (using:Password: YES).
 I
  am
   really frustrated since I have been working on this login and
  permission
   issue for some time.
   
   
   Thanks
   
   mailto:[EMAIL PROTECTED]  
   

   
  
  Try this: 
  a) Verify that you have actually GRANTED permission for the account
 you
  are trying to authenticate with 
  
  SELECT user, host from mysql.user where user ='radius'; 
  Then for each user-host combination listed above do one of these and
  compare the privileges listed to those you expected the accounts to
  have. 
  
  SHOW GRANTS FOR 'user'@'host'; 
  
  b) if the records exist but aren't being respected, issue a FLUSH
  PRIVILEGES command.  I have noticed that (in contradiction to the
  documentation) that you sometimes need to manually refresh the
 privilege
  cache even after using a GRANT or REVOKE command. 
  
  
  If those don't get you started, come back with whatever new
 information
  you learn and we can try something else. 
  
  Shawn Green
  Database Administrator
  Unimin Corporation - Spruce Pine 
  
 

RE: Freeradius and MySql

[Atkins, Dwane P]

Shawn,


Thanks.  That has done the trick.  It turns out that I had passwords
hashed for [EMAIL PROTECTED], but not [EMAIL PROTECTED]  Resetting the password
and flushing the privilege has really helped.  Guess what, you have done
in 20 minutes what myself and other could not do in a week.

 

Dwane

 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 23, 2006 10:45 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql

 


OK, make sure you are using the correct password, too.  Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you
create the account? 

SELECT user, host, password 
FROM mysql.user 
WHERE user='radius'; 

make sure your password is hashed, if not we can help you fix that
pretty easily 

UPDATE mysql.user 
SET `password`=PASSWORD('plain-text-of-password') 
WHERE user='radius'; 

FLUSH PRIVILEGES; 

Then try again. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine 

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:30:41 AM:

 I did do a FLUSH PRIVILEGES and this still resulted in the same error.
 
  
 
 
 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, March 23, 2006 10:31 AM
 To: Atkins, Dwane P
 Cc: mysql@lists.mysql.com
 Subject: RE: Freeradius and MySql
 
  
 
 
 You could try suggestion B)   ;-) 
 
 Shawn 
 
 Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24
AM:
 
  *  a) Verify that you have actually GRANTED permission for the
  account you are trying to authenticate with 
  
  SELECT user, host from mysql.user where user ='radius'; 
  
  
  
  mysql SELECT user, host from mysql.user where user ='radius';
  
  ++---+
  
  | user   | host  |
  
  ++---+
  
  | radius | % |
  
  | radius | localhost |
  
  ++---+
  
  2 rows in set (0.00 sec)
  
   
  
  SHOW GRANTS FOR 'user'@'host';
  
   
  
  mysql SHOW GRANTS FOR 'radius'@'localhost'; 
  
  ++
  
  | Grants for [EMAIL PROTECTED]|
  
  ++
  
  | GRANT USAGE ON *.* TO 'radius'@'localhost' |
  
  | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
  
  ++
  
  2 rows in set (0.00 sec)
  
   
  
   
  
  As you can see, it looks like I have granted permissions to the
user,
  [EMAIL PROTECTED] for db radius.  I am not sure what to do next.
  
   
  
  Thanks
  
   
  
  Dwane
  
   
  
   
  
  
  
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, March 23, 2006 9:51 AM
  To: Atkins, Dwane P
  Cc: mysql@lists.mysql.com
  Subject: Re: Freeradius and MySql
  
   
  
  
  
  Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57
 AM:
  
   Good morning.  I am trying to install Free Radius with MySql, but
I
   either have a login issue or a permissions issue.  
   

   
   I have added Radius and [EMAIL PROTECTED] to database, Fedora local
  users
   and just about everywhere I can think possible.  I have added
   permissions for radius  radius local to databases mysql and
 database
   radius.  However, when I try to log in to mysql using the command
  mysql
   -u radius -p radius, I get and error stating, Error 1045 (28000):
   Access Denied for user 'radius'@'localhost' (using:Password: YES).
 I
  am
   really frustrated since I have been working on this login and
  permission
   issue for some time.
   
   
   Thanks
   
   mailto:[EMAIL PROTECTED]  
   

   
  
  Try this: 
  a) Verify that you have actually GRANTED permission for the account
 you
  are trying to authenticate with 
  
  SELECT user, host from mysql.user where user ='radius'; 
  Then for each user-host combination listed above do one of these and
  compare the privileges listed to those you expected the accounts to
  have. 
  
  SHOW GRANTS FOR 'user'@'host'; 
  
  b) if the records exist but aren't being respected, issue a FLUSH
  PRIVILEGES command.  I have noticed that (in contradiction to the
  documentation) that you sometimes need to manually refresh the
 privilege
  cache even after using a GRANT or REVOKE command. 
  
  
  If those don't get you started, come back with whatever new
 information
  you learn and we can try something else. 
  
  Shawn Green
  Database Administrator
  Unimin Corporation - Spruce Pine 
  
 

Re: newbee error (1044)

[Frank Delatorre]

Dilipkumar,

Thanks much for the tipit did the job!

Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:

[EMAIL PROTECTED]:/usr/bin mysqlshow
+---+
| Databases |
+---+
| test  |
+---+
[EMAIL PROTECTED]:/usr/bin

Here is where BOTH databases reside:

wdshss:/var/lib/mysql # ll
total 20527
drwxr-xr-x   5 mysql mysql  464 2006-03-23 08:46 .
drwxr-xr-x  50 root  root  1296 2006-03-20 21:34 ..
-rw---   1 mysql mysql   99 2005-10-21 12:20 .bash_history
drwx--   4 mysql mysql   96 2006-03-23 07:02 data
-rw-rw   1 mysql mysql 10485760 2006-03-23 08:46 ibdata1
-rw-rw   1 mysql mysql  5242880 2006-03-23 08:46 ib_logfile0
-rw-rw   1 mysql mysql  5242880 2006-09-17 09:15 ib_logfile1
drwx--   2 mysql mysql 1584 2006-03-23 07:03 mysql
-rw-rw   1 mysql mysql 1767 2006-03-23 08:46 mysqld.log
-rw-rw   1 mysql mysql  503 2006-03-23 06:44 mysqld.log.1
-rw-r--r--   1 mysql mysql  402 2006-03-14 19:30 mysqld.log.4.gz
-rw-rw   1 mysql mysql6 2006-03-23 08:46 mysqld.pid
srwxrwxrwx   1 mysql mysql0 2006-03-23 08:46 mysql.sock
drwx--   2 mysql mysql   48 2006-03-23 07:03 test
-rw-r--r--   1 mysql mysql0 2006-09-17 09:15 update-stamp-4.1
-rw-rw   1 mysql mysql6 2006-03-14 06:49 wdshss.site.pid
wdshss:/var/lib/mysql #






On 3/23/06, Dilipkumar [EMAIL PROTECTED] wrote:

 Hi,

 Use

 /usr/bin/mysql_in­stall_db --datadir=/mysql/data --user=mysql

 This might help ypu to solve the problem.



 Shawn Sharp wrote:

 I get the following error while trying to create the following database
 
 mysql mysql  zm_cre­ate.sql.in
 ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database
 'mysql'
 
 I tried to run the following script
 
 /usr/bin/mysql_in­stall_db --user­=mysql
 
 It does not create mysql database in the correct directory I still only
 see
 the 2 databases
 
 /us­r/bin/mysqlshow
 +---+
 | Databases |
 +---+
 | test  |
 +---+
 
 Thanks
 
 
 


 --
 Thanks  Regards
 Dilipkumar
 DBA Support

 ** DISCLAIMER **
 Information contained and transmitted by this E-MAIL is proprietary to
 Sify Limited and is intended for use only by the individual or entity to
 which it is addressed, and may contain information that is privileged,
 confidential or exempt from disclosure under applicable law. If this is a
 forwarded message, the content of this E-MAIL may not have been sent with
 the authority of the Company. If you are not the intended recipient, an
 agent of the intended recipient or a  person responsible for delivering
 the
 information to the named recipient,  you are notified that any use,
 distribution, transmission, printing, copying or dissemination of this
 information in any way or in any manner is strictly prohibited. If you
 have
 received this communication in error, please delete this mail  notify us
 immediately at [EMAIL PROTECTED]

 www.sify.com - your homepage on the internet for news, sports, finance,
 astrology, movies, entertainment, food, languages etc




--
Frank DeLaTorre
408.390.0415

Re: Question about autoincrement ID

[mysql]

On Thu, 23 Mar 2006 [EMAIL PROTECTED] wrote:

 To: saf [EMAIL PROTECTED]
 From: [EMAIL PROTECTED]
 Subject: Re: Question about autoincrement ID
 
 One important thing to remember: You should not let UI 
 design requirements dictate your DB design. Most 
 developers who design the database just to support the 
 front end up regretting the decision. Those designs are 
 either impossible to extend or impossible to manage or 
 both. You should always design for an efficient database 
 and adjust your retrieval methods to present the data in 
 the manner requested, not the other way around.
 
 Shawn Green
 Database Administrator
 Unimin Corporation - Spruce Pine

IMHO I think the database is the central core of a DB driven 
website. Therefore it should be the first thing designed in 
a DB driven website.

Everything else in a DB driven site should then be built 
around the expected functionality of the database.

So, if one starts out by designing a database (and it's 
server(s)) with optimum performance and upgradability as 
design goals, you won't go to far wrong.

Just my 2c.

Keith Roberts

In theory, theory and practice are the same;
in practice they are not.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqld_safe and timezone settings

[Michael Sutter]

Hello everybody,

I have a problem with replication of data from master to slave server. 
The problem is, that the master is in a other timezone than the slave 
and so inserts with using the now() function creates different values on 
master and slave. If I want to update on the master and use the time as 
criterion the slave doesn't get the update.
After searching the internet the problem is, that the MySQL Server 
starts with the default system timezone. But this could be changed. So  
configured my slave server so, that it has the same timezone as the 
master server. For doing this I used the:


set global time_zone='America/Argentina/Mendoza';

command. After changing the timezone everything works fine and all data 
is replictated correctly.


The problem is, that I must configure it manually every time the server 
restarts and I want to do it automatically by starting. But this doesn't 
work. I tried to use the


mysqld_safe --user=mysql --timezone=America/Argentina/Mendoza

command, but the server starts with SYSTEM timezone. I although put an 
entry in my.cnf configuration file which looks:


#[mysqld_safe]
timezone = America/Argentina/Mendoza

But this doesn't work to.
Can anybody tell me what's my error, or what I although could do to 
start my Server in another than the SYSTEM timezone?

I use the MySQL 5.0.18 Server on a Suse Linux 10.0

Regards Michael


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unknown command '\'' during load

[sheeri kritzer]

What does line 1189 look like?

-Sheeri

On 3/17/06, Jack Baty [EMAIL PROTECTED] wrote:
 I'm trying to restore a database from a dump as part of my
 make-sure-this-will-restore-just-in-case process and I get the
 following error...

 ERROR at line 1189: Unknown command '\''.

 The only thing I've been able to find is this bug report...

 http://bugs.mysql.com/bug.php?id=9756

 ...which claims that this (or something similar) was fixed in 5.0.6.
 I'm running 5.0.18 on OS X here and the dump is from a Debian box
 running 4.0.15. (I've also tried loading the dump on a box running
 4.0.x with the same result)

 The table in question has just over 25 million rows, so it would be
 nice to be able to restore it if necessary :)

 I'm just trying to figure out if it's a data problem, version problem,
 or something else.


 --
 Jack Baty
 Fusionary Media - http://www.fusionary.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: Fw: About Data types

[sheeri kritzer]

On 3/19/06, shreeseva [EMAIL PROTECTED] wrote:

 - Original Message -
 From: shreeseva
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Monday, March 20, 2006 01:15 AM
 Subject: About Data types


 Dear friends,
 I am using MySQL 5.0.17 on Win XP Prof. I have created a prototype database 
 design in Ms Access 2003 and using MySQL Migration tool uploaded this to 
 MySQL server. I have encounterred few problems with it.
 1) Migration toolkit successfully transfered all tabels and indexes but all 
 Autonumber fields are transfered as 'int'. Also all boolean fields(In Access 
 'Yes/No' ) are transfered as 'tinyint'. Is there a bug the toolkit?

No.  Try to familiarize yourself with MySQL a bit, and read some
manual pages.  An autonumber field in Access is a number.  In MySQL
an autonumber field looks like this:

int unsigned not null auto_increment primary key

So int is correct.

As well, the manual page for the BOOLEAN type (try
http://www.mysql.com/boolean) says that real booleans aren't
supported, it just uses tinyint(1) to store the values.  So that is
correct, no bug in the toolkit there.

 2) When I go for data entry through Access form It displays as '#deleted' in 
 all fields. Why?

Are you asking a question about MS Access?

-Sheeri

 I am entering data from Master form and when control goes into the Subform 
 linked with the master form it makes all entered fileds as '#deleted'. The 
 master form is related with documents table having one field as AutoIncrement 
 and subform is based on Transactions for that document. This Transactions 
 table also contains one Autoincrement filed. Both such fileds are PK's also.
 Now when I changed the AutoIncrement to 'No' for Documents table it goes 
 correctly and not displayed '#deleted'. But when I entered data into 
 Transactions table having AutoIncrement still to 'Yes' then it displayed as 
 '#deleted'. Why?
 Is this a bug or my mistake or ODBC driver problem or Access problem?

 Please help
 Thanks and regards.

 CPK


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Matching of german umlauts with LIKE

[sheeri kritzer]

MySQL doesn't have anything like that.  You can use the wildcard
characters instead of the umlauts if you want, such as

SELECT * from person where name like %bersee
which would get
übersee and uebersee
but also a whole lot more.

But doing something like
SELECT * from person where name like _bersee or name like __bersee
might work -- the underscore means 1 of any character, so here the
only noise you'd get are other folks whose names are
_  _  bersee
So there's still a margin for error.

Unfortunately, there's no special case for hey, when you're looking
at LIKE, I want to define that x=y -- particularly when x and y have
differing #'s of characters.

-Sheeri
On 3/22/06, Markus Fischer [EMAIL PROTECTED] wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 Hi,

 what is the best way to match german umlauts like 'ä' also their
 alternative writing 'ae'?

 For example I'm searching for übersee and I also want to find the word
 uebersee in the database. The words are actually names of persons.

 One possibility  is to dynamically expand the SQL statement if such
 special characters are found. So the search term übersee will be
 expanded to SELECT * FROM person WHERE name LIKE 'übersee%' AND name
 LIKE 'uebersee%' but this is getting dirty and very very long if
 multiple umlauts are used to cover all cases ...

 So the other idea is to have the name twice in the database for every
 person and the second version of the name is a normalized for where
 all special characters are replaced with their alternative writing. E.g.
 I store the field name übersee and also name2 uebersee and when
 matching I match against name2. If the field would container more
 special characters it still would work without much more work, e.g. name
 is überseemöbel then name2 would be ueberseemoebel and when the term
 überseemö is entered it's also normalized to ueberseemoe and the
 LIKE statement will still match. Basically this is some kind of
 primitive stemming like lucene does it.

 Is there maybe some built-in support from MySQL for such special cases?

 thanks for any pointers,
 - - Markus
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v1.4.2.2 (MingW32)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

 iD8DBQFEIWDH1nS0RcInK9ARAkzyAKCyoPPVd1YRfhs1p/p8kY465/QPVQCfa5uj
 r2ZarPZvsJp5FPNDsdhAN7E=
 =5ADZ
 -END PGP SIGNATURE-

 --
 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: Unknown command '\'' during load

[Jack Baty]

On 3/23/06, sheeri kritzer [EMAIL PROTECTED] wrote:
 What does line 1189 look like?


Good question. Hard to tell, since it's the insert statement for a
rather large table (25 million rows) and I have --extended-insert set,
so it's all on one *really* long line. Seems like there should be a
return or two in there, but apparently it doesn't work that way.



 On 3/17/06, Jack Baty [EMAIL PROTECTED] wrote:
  I'm trying to restore a database from a dump as part of my
  make-sure-this-will-restore-just-in-case process and I get the
  following error...
 
  ERROR at line 1189: Unknown command '\''.
 
  The only thing I've been able to find is this bug report...
 
  http://bugs.mysql.com/bug.php?id=9756
 
  ...which claims that this (or something similar) was fixed in 5.0.6.
  I'm running 5.0.18 on OS X here and the dump is from a Debian box
  running 4.0.15. (I've also tried loading the dump on a box running
  4.0.x with the same result)
 
  The table in question has just over 25 million rows, so it would be
  nice to be able to restore it if necessary :)
 
  I'm just trying to figure out if it's a data problem, version problem,
  or something else.
 
 
  --
  Jack Baty
  Fusionary Media - http://www.fusionary.com
 
  --
  MySQL General Mailing List
  For list archives: http://lists.mysql.com/mysql
  To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 




--
Jack Baty
Fusionary Media - http://www.fusionary.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unknown command '\'' during load

[SGreen]

[EMAIL PROTECTED] wrote on 03/23/2006 02:20:00 PM:

 On 3/23/06, sheeri kritzer [EMAIL PROTECTED] wrote:
  What does line 1189 look like?
 
 
 Good question. Hard to tell, since it's the insert statement for a
 rather large table (25 million rows) and I have --extended-insert set,
 so it's all on one *really* long line. Seems like there should be a
 return or two in there, but apparently it doesn't work that way.
 
 
 
  On 3/17/06, Jack Baty [EMAIL PROTECTED] wrote:
   I'm trying to restore a database from a dump as part of my
   make-sure-this-will-restore-just-in-case process and I get the
   following error...
  
   ERROR at line 1189: Unknown command '\''.
  
   The only thing I've been able to find is this bug report...
  
   http://bugs.mysql.com/bug.php?id=9756
  
   ...which claims that this (or something similar) was fixed in 5.0.6.
   I'm running 5.0.18 on OS X here and the dump is from a Debian box
   running 4.0.15. (I've also tried loading the dump on a box running
   4.0.x with the same result)
  
   The table in question has just over 25 million rows, so it would be
   nice to be able to restore it if necessary :)
  
   I'm just trying to figure out if it's a data problem, version 
problem,
   or something else.
  
  
   --
   Jack Baty
   Fusionary Media - http://www.fusionary.com
  
   --
   MySQL General Mailing List
   For list archives: http://lists.mysql.com/mysql
   To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
  
  
 
 
 
 
 --
 Jack Baty
 Fusionary Media - http://www.fusionary.com
 

When you generated this dump file, did you remember to use the 
--max_allowed_packet parameter to make sure that mysqldump didn't create 
any extended insert statements larger than your server wants to handle? It 
could be crapping out because at line 1189 you exceeded 
max_allowed_packet.  To be safe always use a value of 16M or less when 
setting max_allowed_packet. Check your server's variables for the value 
it's currently using

SHOW VARIABLES LIKE 'max%';

I don't know for sure that this is going to be the problem but it's always 
something to look at when you start dealing in larger dumpfiles.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

RE: MySQL malloc error on Solaris

[Ubaidul Khan]

Following is the configuraton of mysqld:

- Excerpt from my.cnf -
   # The MySQL server
   [mysqld]
   user= mysql
   port= 4406
   socket  = /tmp/mysql.sock
   #socket = /tmp/mysql_4.0.13.sock
   set-variable= max_connections=150
   skip-locking
   key_buffer = 16M
   max_allowed_packet = 1M
   table_cache = 64
   sort_buffer_size = 512K
   net_buffer_length = 8K
   myisam_sort_buffer_size = 8M
   local-infile = 0
   # Clients authenticate to server must do so by the IP only
   skip-name-resolve
   # Display only the databases the authenticated user has privileges to
   safe-show-database

   # Don't listen on a TCP/IP port at all. This can be a security 
enhancement,

   # if all processes that need to connect to mysqld run on the same host.
   # All interaction with mysqld must be made via Unix sockets or named 
pipes.

   # Note that using this option without enabling named pipes on Windows
   # (via the enable-named-pipe option) will render mysqld useless!
   #
   #skip-networking

   # Replication Master Server (default)
   # binary logging is required for replication
   #log-bin

   # required unique id between 1 and 2^32 - 1
   # defaults to 1 if master-host is not set
   # but will not function as a master if omitted
   server-id   = 1

   # Replication Slave (comment out master section to use this)
   #
   # To configure this host as a replication slave, you can choose between
   # two methods :
   #
   # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
   #the syntax is:
   #
   #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port,
   #MASTER_USER=user, MASTER_PASSWORD=password ;
   #
   #where you replace host, user, password by quoted strings and
   #port by the master's port number (3306 by default).
   #
   #Example:
   #
   #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
   #MASTER_USER='joe', MASTER_PASSWORD='secret';
   #
   # OR
   #
   # 2) Set the variables below. However, in case you choose this method, 
then
   #start replication for the first time (even unsuccessfully, for 
example
   #if you mistyped the password in master-password and the slave fails 
to

   #connect), the slave will create a master.info file, and any later
   #change in this file to the variables' values below will be ignored 
and
   #overridden by the content of the master.info file, unless you 
shutdown

   #the slave server, delete master.info and restart the slaver server.
   #For that reason, you may want to leave the lines below untouched
   #(commented) and instead use CHANGE MASTER TO (see above)
   #
   # required unique id between 2 and 2^32 - 1
   # (and different from the master)
   # defaults to 2 if master-host is set
   # but will not function as a slave if omitted
   #server-id   = 2
   #
   # The replication master for this slave - required
   #master-host =   hostname
   #
   # The username the slave will use for authentication when connecting
   # to the master - required
   #master-user =   username
   #
   # The password the slave will authenticate with when connecting to
   # the master - required
   #master-password =   password
   #
   # The port the master is listening on.
   # optional - defaults to 3306
   #master-port =  port
   #
   # binary logging - not required for slaves, but recommended
   log-bin = /usr/local/mysql/var/myupdate-bin.log

   # Point the following paths to different dedicated disks
   #tmpdir = /tmp/
   #log-update = /usr/local/mysql/var/myupdate.log
   # Logs connections and queries to file. Use for troubleshooting, disable 
afterward

   s
   #log= /usr/local/mysql/var/myquery.log

   # Uncomment the following if you are using BDB tables
   #bdb_cache_size = 4M
   #bdb_max_lock = 1

   # Uncomment the following if you are using InnoDB tables
   #innodb_data_home_dir = /opt/mysql_4.0.13/var/
   #innodb_data_file_path = ibdata1:10M:autoextend
   #innodb_log_group_home_dir = /opt/mysql_4.0.13/var/
   #innodb_log_arch_dir = /opt/mysql_4.0.13/var/
   # You can set .._buffer_pool_size up to 50 - 80 %
   # of RAM but beware of setting memory usage too high
   #innodb_buffer_pool_size = 16M
   #innodb_additional_mem_pool_size = 2M
   # Set .._log_file_size to 25 % of buffer pool size
   #innodb_log_file_size = 5M
   #innodb_log_buffer_size = 8M
   #innodb_flush_log_at_trx_commit = 1
   #innodb_lock_wait_timeout = 50

   [mysqldump]
   quick
   max_allowed_packet = 16M

   [mysql]
   no-auto-rehash
   # Remove the next comment character if you are not familiar with SQL
   #safe-updates

   [isamchk]
   key_buffer = 20M
   sort_buffer_size = 20M
   read_buffer = 2M
   write_buffer = 2M

   [myisamchk]
   key_buffer = 20M
   sort_buffer_size = 20M
   read_buffer = 2M
   write_buffer = 2M

   [mysqlhotcopy]
   

web assistant?

[Bing Du]

Hello,

Anybody here are also familiar with SQL server 2000 Web Assistant Wizard?

The wizard enables you to create queries that run against the SQL server
2000 database to push data to your web site in the form of static pages.
You can choose how often the web client sees the changes in the SQL server
2000 data by specifying how often the HTML pages are updated.

I'm wondering if any equivalent or similar feature is provided by MySQL?

Thanks,

Bing

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unknown command '\'' during load

[Jack Baty]

On 3/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:

 When you generated this dump file, did you remember to use the
 --max_allowed_packet parameter to make sure that mysqldump didn't create any
 extended insert statements larger than your server wants to handle? It could
 be crapping out because at line 1189 you exceeded max_allowed_packet.  To be
 safe always use a value of 16M or less when setting max_allowed_packet.
 Check your server's variables for the value it's currently using

 SHOW VARIABLES LIKE 'max%';

 I don't know for sure that this is going to be the problem but it's always
 something to look at when you start dealing in larger dumpfiles.


I hadn't considered that. I think I'll also be dealing with
net_buffer_length, since it seems that is what actually affects the
dump insert statement size limit. I'll give it a whirl, thanks.


--
Jack Baty
Fusionary Media - http://www.fusionary.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql for freebsd 6.0

[Ludwig Pummer]

kalin mintchev wrote:

  hi all...

  i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
  am i blind or it's on purpose?!?!

  curious...  and actually need it...

  thanks...




/usr/ports/databases/mysql50-server/
/usr/ports/databases/mysql51-server/

I suggest you familiarize yourself with the search feature at 
http://www.freebsd.org/ports/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: newbee error (1044)

[Shawn Sharp]

Dilipkumar,

Thanks much for the tipit did the job!

Now we query mysql to see if the new mysql database is seen by mysql and it
still only sees test:

[EMAIL PROTECTED]:/usr/bin mysqlshow
+---+
| Databases |
+---+
| test  |
+---+
[EMAIL PROTECTED]:/usr/bin

Here is where BOTH databases reside:

wdshss:/var/lib/mysql # ll
total 20527
drwxr-xr-x   5 mysql mysql  464 2006-03-23 08:46 .
drwxr-xr-x  50 root  root  1296 2006-03-20 21:34 ..
-rw---   1 mysql mysql   99 2005-10-21 12:20 .bash_history
drwx--   4 mysql mysql   96 2006-03-23 07:02 data
-rw-rw   1 mysql mysql 10485760 2006-03-23 08:46 ibdata1
-rw-rw   1 mysql mysql  5242880 2006-03-23 08:46 ib_logfile0
-rw-rw   1 mysql mysql  5242880 2006-09-17 09:15 ib_logfile1
drwx--   2 mysql mysql 1584 2006-03-23 07:03 mysql
-rw-rw   1 mysql mysql 1767 2006-03-23 08:46 mysqld.log
-rw-rw   1 mysql mysql  503 2006-03-23 06:44 mysqld.log.1
-rw-r--r--   1 mysql mysql  402 2006-03-14 19:30 mysqld.log.4.gz
-rw-rw   1 mysql mysql6 2006-03-23 08:46 mysqld.pid
srwxrwxrwx   1 mysql mysql0 2006-03-23 08:46 mysql.sock
drwx--   2 mysql mysql   48 2006-03-23 07:03 test
-rw-r--r--   1 mysql mysql0 2006-09-17 09:15 update-stamp-4.1
-rw-rw   1 mysql mysql6 2006-03-14 06:49 wdshss.site.pid
wdshss:/var/lib/mysql #


On 3/23/06, Dilipkumar [EMAIL PROTECTED] wrote:

 Hi,

 Use

 /usr/bin/mysql_in­stall_db --datadir=/mysql/data --user=mysql

 This might help ypu to solve the problem.



 Shawn Sharp wrote:

 I get the following error while trying to create the following database
 
 mysql mysql  zm_cre­ate.sql.in
 ERROR 1044 (42000): Access denied for user ''@'­loc­al­host' to database
 'mysql'
 
 I tried to run the following script
 
 /usr/bin/mysql_in­stall_db --user­=mysql
 
 It does not create mysql database in the correct directory I still only
 see
 the 2 databases
 
 /us­r/bin/mysqlshow
 +---+
 | Databases |
 +---+
 | test  |
 +---+
 
 Thanks
 
 
 


 --
 Thanks  Regards
 Dilipkumar
 DBA Support

 ** DISCLAIMER **
 Information contained and transmitted by this E-MAIL is proprietary to
 Sify Limited and is intended for use only by the individual or entity to
 which it is addressed, and may contain information that is privileged,
 confidential or exempt from disclosure under applicable law. If this is a
 forwarded message, the content of this E-MAIL may not have been sent with
 the authority of the Company. If you are not the intended recipient, an
 agent of the intended recipient or a  person responsible for delivering
 the
 information to the named recipient,  you are notified that any use,
 distribution, transmission, printing, copying or dissemination of this
 information in any way or in any manner is strictly prohibited. If you
 have
 received this communication in error, please delete this mail  notify us
 immediately at [EMAIL PROTECTED]

 www.sify.com - your homepage on the internet for news, sports, finance,
 astrology, movies, entertainment, food, languages etc

auto_increment syntax

[Eric Beversluis]

Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.

EG: 
CREATE TABLE Books (
 bookID INT(5) PRIMARY KEY AUTO_INCREMENT...

THEN WHAT? 

Thanks.
EB

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: auto_increment syntax

[Simon Garner]

On 24/03/2006 11:06 a.m., Eric Beversluis wrote:

Can someone illustrate the correct syntax for using auto_increment in
making a table? I've studied the manual and I'm not seeing how it comes
out.

EG: 
CREATE TABLE Books (

 bookID INT(5) PRIMARY KEY AUTO_INCREMENT...

THEN WHAT? 


Thanks.
EB



Should be:

bookID INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY

Primary keys have to be NOT NULL, and AUTO_INCREMENT must appear 
before PRIMARY KEY


AUTO_INCREMENT fields should normally be INT UNSIGNED as well since you 
generally won't want to store a negative ID number, and this gives you 
an extra byte.


-Simon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Matching of german umlauts with LIKE

[Markus Fischer]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

I realized this also. Martin Schwarz off list suggested to me to use
REGEXP for that purpose. That means that I'm rewriting the user input
übersee behind the scenes to ^(ü|ue)bersee.* which works quote well.

The only gotcha is that the user may enter any special regexp characters
also, so I had to make a list of them and escape them prior to modifying
the string.

thanks,
- - Markus

sheeri kritzer wrote:
 MySQL doesn't have anything like that.  You can use the wildcard
 characters instead of the umlauts if you want, such as
 
 SELECT * from person where name like %bersee
 which would get
 übersee and uebersee
 but also a whole lot more.
 
 But doing something like
 SELECT * from person where name like _bersee or name like __bersee
 might work -- the underscore means 1 of any character, so here the
 only noise you'd get are other folks whose names are
 _  _  bersee
 So there's still a margin for error.
 
 Unfortunately, there's no special case for hey, when you're looking
 at LIKE, I want to define that x=y -- particularly when x and y have
 differing #'s of characters.
 
 -Sheeri
 On 3/22/06, Markus Fischer [EMAIL PROTECTED] wrote:
 Hi,
 
 what is the best way to match german umlauts like 'ä' also their
 alternative writing 'ae'?
 
 For example I'm searching for übersee and I also want to find the word
 uebersee in the database. The words are actually names of persons.
 
 One possibility  is to dynamically expand the SQL statement if such
 special characters are found. So the search term übersee will be
 expanded to SELECT * FROM person WHERE name LIKE 'übersee%' AND name
 LIKE 'uebersee%' but this is getting dirty and very very long if
 multiple umlauts are used to cover all cases ...
 
 So the other idea is to have the name twice in the database for every
 person and the second version of the name is a normalized for where
 all special characters are replaced with their alternative writing. E.g.
 I store the field name übersee and also name2 uebersee and when
 matching I match against name2. If the field would container more
 special characters it still would work without much more work, e.g. name
 is überseemöbel then name2 would be ueberseemoebel and when the term
 überseemö is entered it's also normalized to ueberseemoe and the
 LIKE statement will still match. Basically this is some kind of
 primitive stemming like lucene does it.
 
 Is there maybe some built-in support from MySQL for such special cases?
 
 thanks for any pointers,
 - Markus

- --
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEI4BC1nS0RcInK9ARAnMrAJ9jZ5LAxS1S2bjqrPvIUBSiTGsxxQCgv+5l
xyxQhd7B9HTnc8sTa7Tsekk=
=uycm
-END PGP SIGNATURE-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

multiple mysqld processes running

[Tatyana Gurevich]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL malloc error on Solaris

[Heikki Tuuri]

Ubaidul,

ok, there is nothing in my.cnf that can explain why memory runs out.

What kind of query are you running when the memory runs out? Does 'top' show 
that the mysqld process size grows uncontrollably?


If you are using the C client interface, do you use 'mysql_store_result()' 
or 'mysql_use_result()'? For huge resultsets, one of them uses a huge amount 
of memory in the server.


Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables

http://www.innodb.com/order.php

- Original Message - 
From: Ubaidul Khan [EMAIL PROTECTED]

Newsgroups: mailing.database.myodbc
Sent: Thursday, March 23, 2006 11:06 PM
Subject: RE: MySQL malloc error on Solaris




Following is the configuraton of mysqld:

- Excerpt from my.cnf -
   # The MySQL server
   [mysqld]
   user= mysql
   port= 4406
   socket  = /tmp/mysql.sock
   #socket = /tmp/mysql_4.0.13.sock
   set-variable= max_connections=150
   skip-locking
   key_buffer = 16M
   max_allowed_packet = 1M
   table_cache = 64
   sort_buffer_size = 512K
   net_buffer_length = 8K
   myisam_sort_buffer_size = 8M
   local-infile = 0
   # Clients authenticate to server must do so by the IP only
   skip-name-resolve
   # Display only the databases the authenticated user has privileges to
   safe-show-database

   # Don't listen on a TCP/IP port at all. This can be a security
enhancement,
   # if all processes that need to connect to mysqld run on the same host.
   # All interaction with mysqld must be made via Unix sockets or named
pipes.
   # Note that using this option without enabling named pipes on Windows
   # (via the enable-named-pipe option) will render mysqld useless!
   #
   #skip-networking

   # Replication Master Server (default)
   # binary logging is required for replication
   #log-bin

   # required unique id between 1 and 2^32 - 1
   # defaults to 1 if master-host is not set
   # but will not function as a master if omitted
   server-id   = 1

   # Replication Slave (comment out master section to use this)
   #
   # To configure this host as a replication slave, you can choose between
   # two methods :
   #
   # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
   #the syntax is:
   #
   #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port,
   #MASTER_USER=user, MASTER_PASSWORD=password ;
   #
   #where you replace host, user, password by quoted strings and
   #port by the master's port number (3306 by default).
   #
   #Example:
   #
   #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
   #MASTER_USER='joe', MASTER_PASSWORD='secret';
   #
   # OR
   #
   # 2) Set the variables below. However, in case you choose this method,
then
   #start replication for the first time (even unsuccessfully, for
example
   #if you mistyped the password in master-password and the slave 
fails

to
   #connect), the slave will create a master.info file, and any later
   #change in this file to the variables' values below will be ignored
and
   #overridden by the content of the master.info file, unless you
shutdown
   #the slave server, delete master.info and restart the slaver 
server.

   #For that reason, you may want to leave the lines below untouched
   #(commented) and instead use CHANGE MASTER TO (see above)
   #
   # required unique id between 2 and 2^32 - 1
   # (and different from the master)
   # defaults to 2 if master-host is set
   # but will not function as a slave if omitted
   #server-id   = 2
   #
   # The replication master for this slave - required
   #master-host =   hostname
   #
   # The username the slave will use for authentication when connecting
   # to the master - required
   #master-user =   username
   #
   # The password the slave will authenticate with when connecting to
   # the master - required
   #master-password =   password
   #
   # The port the master is listening on.
   # optional - defaults to 3306
   #master-port =  port
   #
   # binary logging - not required for slaves, but recommended
   log-bin = /usr/local/mysql/var/myupdate-bin.log

   # Point the following paths to different dedicated disks
   #tmpdir = /tmp/
   #log-update = /usr/local/mysql/var/myupdate.log
   # Logs connections and queries to file. Use for troubleshooting, 
disable

afterward
   s
   #log= /usr/local/mysql/var/myquery.log

   # Uncomment the following if you are using BDB tables
   #bdb_cache_size = 4M
   #bdb_max_lock = 1

   # Uncomment the following if you are using InnoDB tables
   #innodb_data_home_dir = /opt/mysql_4.0.13/var/
   #innodb_data_file_path = ibdata1:10M:autoextend
   #innodb_log_group_home_dir = /opt/mysql_4.0.13/var/
   #innodb_log_arch_dir =