Re: Does anyone actually use this on OS X? - Alfredo Kengi Kojima - com.mysql.lists.gui-tools

4 messages in com.mysql.lists.gui-toolsRe: Does anyone actually use this on ...

From	Sent On	Attachments
Florian Ebeling	18 Apr 2005 11:07
Alfredo Kengi Kojima	18 Apr 2005 11:51
Florian Ebeling	20 Apr 2005 11:58
Alfredo Kengi Kojima	20 Apr 2005 12:39

Subject:	Re: Does anyone actually use this on OS X?
From:	Alfredo Kengi Kojima (alfr...@mysql.com)
Date:	04/20/2005 12:39:09 PM
List:	com.mysql.lists.gui-tools

Hi Florian,

On Wed, 20 Apr 2005, Florian Ebeling wrote:

Hi Alfredo,

I try to create a table. First thing that looks suspicious is the DDL after I hit "Apply":

CREATE TABLE `(null)`.`table1` ( `id` INT NOT NULL, ...

The database name seems to be missing. When I hit "Execute" then, the following error message appears in a GUI box:

Error executing SQL commands to create table. Can't create/write to file './(null)/table1.frm' (Errcode: 2) (error 1)

This has been fixed in 1.0.8, which has just been released. It's still propagating through the mirrors, so you may have to wait until tomorrow to get it.

I use server version MySQL 4.1.10-standard via socket. The tool is 1.0.7-beta. Btw, does the tool write to a log file somewhere?

No, it doesn't produce a log at the moment.

I also observed another problem. When I select the "Logs" tab, I have to enter the users (system, not mysql) password, because it tries apprently "to change "MySQL Admininstrator.app", though I actually doesn't want to do this. When you enter it the dialog disappears, only to pop up again immediately. No matter wether you "Cancel" or enter it again, it keeps coming up several times.

Let me explain: The log files are by default, readable by the mysql or root user only. So Administrator uses a helper tool which aquires supervisor rights whenever it's executed. The password dialog is requested because I only want to allow users with administrator rights to be able to call the helper. Also, the 1st time Administrator is executed, the helper needs to request the system to set a special flag in it and that requires the authentication again. Subsequent uses, should only request the password once.

This happens also when I select the "Options" tab. There the tool reports:

The my.cnf file could not be located at /etc/my.cnf Click "Create" to initialize a new one or "Cancel".

Then it asks if it should create one. On "Create" it asks again for a password and generates an error again, which also sounds like a permissions problem.

This one has been fixed.

Best, -Florian

On 4/18/05, Alfredo Kengi Kojima <alfr...@mysql.com> wrote:

Hi Florian,

The OSX version has been started later than the other platforms, so the version number will be a bit behind until it goes out of beta. As for your error, can you give more details? Such as error messages and version of the server you're using.

-- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina

Are you MySQL certified? www.mysql.com/certification

On Mon, 18 Apr 2005, Florian Ebeling wrote:

Hi,

when I try to use the Mac OS X version to create a table I get stuck really right away. Is the OS X version 1.0.7beta from the same source branch as those other ports which have version number like 1.0.19? I hope the Mac port doesn't get abandoned, since there seem to be particularly few DB browsers for OS X for any DBMS whatsoever. I could submit detailed error messages, but I also doubt that those problems aren't well known already.

-Florian