MySql on Leopard
Have anyone out there any experience building, installing, and using MySql on Leopard (PowerPC G4) (MySql Community server 5.0.51) If so, I would be thankful for info on possible problems. -- Skinheads are so tired of immigration, that they are going to move to a country that don't accept immigrants! Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: keyboard-ONLY problem with mysql-client and UTF8; compilation flags?
On 10 jun 2007, at 20.47, tAndRead wrote: Hi all, snip when I try to add a foreign text from the keyboard in the mysql client, keystrokes are ignored! unless they are numbers, commas etc (using kde-konsole with the the DeJaVu international font) I believe this has to do something with the compilation and not configuration; because if I use the mysql-client rpm packages from SUSE 10.2, the keyboard works ok in interactive mysql sessions! Any ideas will be very much appreciated! This is probably a problem with your terminal program. I've had similar problems with other apps. -- Home is not where you are born, but where your heart finds peace - Tommy Nordgren, The dying old crone [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimal tabletype?
I've got a table with two fields, (a string [Primary Key], and an integer). The table needs to be as secure as possible against corruption, and need as fast access as possible, but do not need transaction support. (The integer is an access counter for a web page, so is does not need to be very accurate) What is the optimal table type to use for this purpose? -- What is a woman that you forsake her, and the hearth fire and the home acre, to go with the old grey Widow Maker. --Kipling, harp song of the Dane women Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Bind to Port
Try the command: find / -name mysql 2/dev/null then you will find out if you have multiple mysql installations on your system, which I consider highly likely. On 3 mar 2007, at 07.42, Drew Jenkins wrote: 26- Original Message From: Tommy Nordgren [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 7:32:16 PM Subject: Re: Can't Bind to Port server312# netstat -nlap tcp | grep 3306 tcp4 0 0 *.3306 *.*LISTEN So... mysqld *is* listening on 3306? Why does it complain that the port is being used and that it can't bind to it? server312# mkdir /usr/local/localhost server312# chown mysql:mysql /usr/local/localhost/ server312# /usr/local/libexec/mysqld -uroot -hlocalhost -- max_allowed_packet=999M InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 070302 15:58:29 InnoDB: Started; log sequence number 0 0 /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 070302 15:58:29 [ERROR] Do you already have another mysqld server running on port: 3306 ? 070302 15:58:29 [ERROR] Aborting 070302 15:58:30 InnoDB: Starting shutdown... 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete # ps wax|grep mysqld 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my server312# nmap localhost Starting Nmap 4.11 ( http://www.insecure.org/nmap/87 ) at 2007-03-02 16:02 UTC Interesting ports on localhost.by2012.com (127.0.0.1): Not shown: 1672 closed ports PORT STATE SERVICE 22/tcp open ssh 25/tcp open smtp 110/tcp open pop3 143/tcp open imap 993/tcp open imaps 3306/tcp open mysql 8021/tcp open ftp-proxy 8080/tcp open http-proxy TIA, Drew __ __ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ Kine dies, Kinfolk dies, and thus at last yourself This I know that never dies, how a dead mans deeds are deemed. -- Elder edda Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Bind to Port
On 3 mar 2007, at 15.31, Drew Jenkins wrote: - Original Message From: ed [EMAIL PROTECTED] To: Drew Jenkins [EMAIL PROTECTED] Sent: Saturday, March 3, 2007 10:24:54 AM Subject: Re: Can't Bind to Port be root/superuser; try it as find / -name mysql and then, (as in 2nd) send they instances of mysql that you do not want to /dev/null this assumes a *nix not MS WIndows install, I do believe... # find / -name mysql /usr/local/bin/mysql /usr/local/include/mysql /usr/local/lib/mysql /usr/local/libdata/ldconfig/mysql /usr/local/share/mysql /usr/backup/usr/local/include/mysql /var/db/mysql /var/db/mysql/mysql I believe I want all of those ;) TIA, Drew There is no need to be superuser to run find. But there can be problems if there is another find command earlier in the PATH, than the standard unix find utility. Try running : /usr/bin/find / -name 'mysqld' 2/dev/null This will show if you have multiple instances of the mysqld server daemon on your system. the syntax 2/dev/null redirects standard error to /dev/null, skipping error messages about unaccessible directories Kine dies, Kinfolk dies, and thus at last yourself This I know that never dies, how a dead mans deeds are deemed. -- Elder edda Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't Bind to Port
On 3 mar 2007, at 00.21, Drew Jenkins wrote: Oops. Forgot to add I passed it tcp as the protocol and it returned blank: # netstat -nlp tcp| grep 3306 # I presume that means nothing's listening on that port? If so, then why did nmap return mysql on that port? At any rate, what do? TIA, Drew You need to add the -a option to netstat, to show server processes -- What is a woman that you forsake her, and the hearth fire and the home acre, to go with the old grey Widow Maker. --Kipling, harp song of the Dane women Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Building MySql and Qt from source.
I'm trying out the MySql database connection example from C++ Gui programming with Qt. I'm using the binary build of Qt open-source edition from the books cd, and a binary build of MySql 5.0.27 downloaded from the official MySql website. The Qt libraries includes a MySql driver, which however uses a shared version of the MySql client library. However, there are no shared libraries installed by the mySql installer. I've concluded that to use MySql with Qt, I have to do source builds of both Qt and MySql. Now I wonder how to configure the packages for Mac OS X. I've already found out trying to build Qt for Mac OS X, that the default configure settings are unsuitable. Even if I choose a framework build, the frameworks ends up in a subdirectory of /usr/local, instead of properly inside /Library/Frameworks If you reply to this message please note that it's cross-posted. You might have to edit the adresses, if you are not subscribed to both the Qt and MySql lists. - This sig is dedicated to the advancement of Nuclear Power Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Logging IP adresses
Is it possible to have a transaction automatically write the IP adress of the client to a field of a record? - This sig is dedicated to the advancement of Nuclear Power Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Generating SQL or flat file code for Object persistence
Do anyone know of any tools to automatically generate SQL tables, and C++ or Objective C code for object persistence. What I want is code that takes for example code like this: class MyClass { Persistent int key; /* rest omitted */ }; And generates an SQL table declaration from it. (In C-based languages with a preprocessor, it's easy to tag variable declarations with metadata by using identifiers that is macro-expanded to nothing) - This sig is dedicated to the advancement of Nuclear Power Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Datatype MEDIUMTEXT
do MySQL store this in fixed-size or variable-sized fisk space? I need to be able to store large fields, but usually the size will be just a few kilobytes. - This sig is dedicated to the advancement of Nuclear Power Tommy Nordgren [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]