This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 148753 - Can't start MySQL server from Netbeans in the latest build
Summary: Can't start MySQL server from Netbeans in the latest build
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P1 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-30 15:08 UTC by theyaa
Modified: 2008-10-06 10:24 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
Netbeans screenshot showing the disabled start button for mysql (82.82 KB, text/plain)
2008-10-02 23:07 UTC, theyaa
Details
netbeans screenshot showing the greyed mysql start command (82.82 KB, image/gif)
2008-10-03 16:00 UTC, theyaa
Details

Note You need to log in before you can comment on or make changes to this bug.
Description theyaa 2008-09-30 15:08:57 UTC
When configuring a new MySQL server inside netbeans, right clicking to start the server shows the start command grayed 
out. I have the same exact settings in version 6.5M1 and the start command is enabled and I can start the server 
without any issues.
Comment 1 David Vancouvering 2008-09-30 17:39:56 UTC
I gray out the start command if I can successfully to ping the server at the configured host and port.  Are you sure the
server's not already running?
Comment 2 David Vancouvering 2008-10-01 22:23:37 UTC
You can't start if there's already something listening at that host/port. Please reopen with counter-argument and any suggestions you have for how to do 
this if you disagree
Comment 3 theyaa 2008-10-02 14:49:46 UTC
I have tried the database connectivity in 2 versions of netbeans, 6.1 and the latest build. In 6.1 everything is fine
and the database starts fine. In the latest build I can not start the datatabase as the start command is greyed out.
Both versions have the same db config.

Please investigate further
Comment 4 David Vancouvering 2008-10-02 18:32:03 UTC
Can you please try this with the latest build and tell me if this is still a problem - I made some adjustments to this
code that may have solved your problem.

Thanks
Comment 5 theyaa 2008-10-02 23:03:15 UTC
Hi,
 I have downloaded the latest build, NetBeans IDE Dev (Build 200810011401). Configured the new database server, right
click on the server and it is the same thing, the Start command is greyed out. So, there is no change.

Would you please investigate more. Thank you
Comment 6 theyaa 2008-10-02 23:07:08 UTC
Created attachment 71080 [details]
Netbeans screenshot showing the disabled start button for mysql
Comment 7 theyaa 2008-10-02 23:08:07 UTC
I have attached a screenshot to show what I am referring to. Thank you
Comment 8 John Baker 2008-10-02 23:23:25 UTC
Are you certain that MySQL isn't already running?
Can you expand the MySQL node ?

From commandline you can use   mysqlshow -u <username> -p <password>

Please re-attach the screenshot and choose gif as the MIME type
Comment 9 theyaa 2008-10-03 16:00:26 UTC
Created attachment 71126 [details]
netbeans screenshot showing the greyed mysql start command
Comment 10 theyaa 2008-10-03 16:03:49 UTC
I have been using netbeans for ruby development for about 1.5 years and I went through several releases and milestones, 
so I know what I am talking about and I am certain about what I am referring to.

I have followed your advice and tried the commandline and here is what I got:
mysqlshow: Can't connect to MySQL server on 'localhost' (10061)

Screenshot attached again with mimetype gif, please take a look and you will see the command greyed out.

Comment 11 David Vancouvering 2008-10-03 17:12:38 UTC
Hi, theyaa, don't worry, we'll get this problem fixed.  I'm working on it.  The challenge is none of us can reproduce
it, but that doesn't mean we don't believe you :)

Can you do me one favor and when you think you should be able to start the server, please do "telnet localhost 3306" and
see what happens.  I really am curious to see if something else is running at that port.

At any rate, I'm redoing the logic to detect if the server is running, there are too many edge cases with this and we
should be erring on the side of enabling actions when it's not clear what the state of the system is.

So, working on it.

Thanks,

David
Comment 12 David Vancouvering 2008-10-03 17:13:53 UTC
Since there is no clear workaround (except to start it manually, which is basically as if the feature were not there),
this is a P1.
Comment 13 theyaa 2008-10-03 23:39:26 UTC
Hi,
  I really appreciate it that you are spending the time to fix those issues, I totally depend on netbeans for 
everything I do with ruby on rails, it is a great product and no other product matches up to it.

I executed the command telnet localhost 3306 and here is the result.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Theyaa>telnet localhost 3306
Connecting To localhost...Could not open connection to the host, on port 3306: C
onnect failed

C:\Documents and Settings\Theyaa>


One suggestion I have, please compare the current build to version 6.1 as I can start MySQL with version 6.1, you might 
find a clue there.

Thanks
Comment 14 David Vancouvering 2008-10-04 12:42:35 UTC
e18773e6403d

Redid how we check for aliveness of the server, by using Andrei's suggestion of
just opening a connection.

Also, reduced assumptions about whether the server is "up" or "down."  All we
really know for sure is we are connected or not connected.  Thus Start and Stop
are always enabled, and Connect is always enabled except when you're connected
already.

Also should be handling error conditions like bad port better now - please test
and let me know.

I am running a fetch/merge/build/test cycle now, should be able to push in the
morning (well, later in the morning :))
Comment 15 Quality Engineering 2008-10-05 05:13:11 UTC
Integrated into 'main-golden', will be available in build *200810050201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main/rev/e18773e6403d
User: David Van Couvering <davidvc@netbeans.org>
Log: #148753: Can't start MySQL server from Netbeans in the latest build
#149150: [65cat] cannot click the submenu properties on server due to error dialog box
#148197: Connection can't be established because of too many errors
Comment 16 Roman Mostyka 2008-10-06 10:24:07 UTC
theyaa, can You verify, please, that this issue were really fixed?