Access mysql database with Mysql Query Browser Options

[Guest_Stefan (Guest)]

Hello,

I have properly installed virtual bugzilla and i would like to access the mysql database with the mysql query browser on my windows computer via a remote connection.

So far, I have not managed to create a connection.

-The database is running and the deamon listens to port 3306
-I am able to ping the virtual bugzilla server
-tcp/ip connections in mysql are enabled
-There exists a user in mysql which is allowed to connect from a remote machine

Does anyone have an idea how to make this work?

[Igor Sereda]

Hello Stefan,

By default mysql connections are allowed only from localhost. To enable connections from anywhere, you need to edit configuration file /etc/mysql/my.cnf and comment out or remove this line:

CODE

bind-address = 127.0.0.1

, then restart mysql with

CODE

/etc/init.d/mysql restart

.

NB! Opening your mysql port to public is not secure.

Best regards,
Igor

[Guest_Stefan (Guest)]

I have removed the line

CODE

bind-address = 127.0.0.1

from file /etc/mysql/my.cnf but still I cannot connect to the mysql database via mysql query browser

A port scan executed on my windows machine shows, that the 3306 port is indeed open and i can connect via telnet to it but I do not get any characters back

(I also tried to establish a ftp connection with Virtual Bugzilla... i can log in, but I did not manage to transfer a file)

please help

[Guest_Stefan (Guest)]

Perhaps the detailed error message from mysql query browser helps to resolve this issue

can not establish connection to the specified instance
mysql error number 2013
lost connection to mysql server during query

[Igor Sereda]

Stefan,

If this is a network issue and if there's a DHCP server in your network, try setting network connection to Bridged and rebooting the VBS. If mysql error continues to appear, try to google for this specific mysql error code.

Hope this helps!
Igor

[Prashant]

Please tell me how to configure static IP address for Virtual Bugzilla 1.2

[Prashant]

Hi,
I am using Virtual Bugzilla 2.0 and VM Player 2.0 ...I am facing some error...i am attaching the screen shot of error


Please find attached file

Attached thumbnail(s)

 

[Raja]

Did you try installing this in some other machine preferably your own work machine?

[Igor Sereda]

I think the problem is that you installed VBS files on a FAT filesystem, which has 2GB file size limit. We'll need to add this to the system requirements. You need an NTFS or other type of filesystem (in other words, Windows XP or later). Sorry about that.

--Igor

[Guest_Tobie van Dyk (Guest)]

Perhaps the detailed error message from mysql query browser helps to resolve this issue

can not establish connection to the specified instance
mysql error number 2013
lost connection to mysql server during query

Have you found the solution? I'm having the same problem.

[Guest_Erick (Guest)]

Have you found the solution? I'm having the same problem.

I have also the same problem, somebody have found the solution ?

[Guest_BCF (Guest)]

Perhaps it's not (only) a MySql issue, but a network issue: in my VBS distribution /etc/hosts.allow and /etc/hosts.deny files were configured to deny ALL connections. I had to edit them to remove this limitation in order to make MySql Query Browser work from external PCs... and it seems to work.

[Igor Sereda]

Perhaps it's not (only) a MySql issue, but a network issue: in my VBS distribution /etc/hosts.allow and /etc/hosts.deny files were configured to deny ALL connections. I had to edit them to remove this limitation in order to make MySql Query Browser work from external PCs... and it seems to work.

BCF, thanks for the hint! We'll have these files attended in the next release of VBS.

Cheers,
Igor

[wolverine]

Perhaps it's not (only) a MySql issue, but a network issue: in my VBS distribution /etc/hosts.allow and /etc/hosts.deny files were configured to deny ALL connections. I had to edit them to remove this limitation in order to make MySql Query Browser work from external PCs... and it seems to work.

I have the same problem, can some show me what to cange in those files?

In /etc/mysql/my.cnf

CODE

#bind-address           = 127.0.0.1
#skip-networing

Is there something else what I have to change to connect to the mysql from a pc in my network with Toad for MySql?

netstat -an

CODE

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN
tcp6       0      0 :::80                   :::*                    LISTEN
tcp6       0      0 :::21                   :::*                    LISTEN
tcp6       0      0 :::22                   :::*                    LISTEN
tcp6       0      0 :::25                   :::*                    LISTEN

Active UNIX domain sockets (servers and established)
Proto RefCnt Flags       Type       State         I-Node Path
unix  2      [ ACC ]     STREAM     LISTENING     5311     /var/run/apache2/cgisock.2296
unix  2      [ ]         DGRAM                    853      @/org/kernel/udev/udevd
unix  2      [ ACC ]     STREAM     LISTENING     5291     /dev/log
unix  2      [ ACC ]     STREAM     LISTENING     4394     /var/run/mysqld/mysqld.sock
unix  3      [ ]         STREAM     CONNECTED     8115     /dev/log
unix  3      [ ]         STREAM     CONNECTED     8105

Thx for your help!

[Igor Sereda]

wolverine,

Check comment out or remove everything in your /etc/hosts.allow and /etc/hosts.deny and try again. This may help. I think there was some information about that on this forum.

Cheers,
Igor

[Guest_Jan (Guest)]

wolverine,

Check comment out or remove everything in your /etc/hosts.allow and /etc/hosts.deny and try again. This may help. I think there was some information about that on this forum.

Cheers,
Igor

I`dont understand, i do all but now i get everytime the messag that the access is deinied (1305). I dont understand because I use the root, but nothing

Givi it a way to make a complet dump? I get all time a file with 0 Byte.


Thanky and Greetz,

Jan

[Guest_Jan (Guest)]

I found the problem, the permissions for an external access was not set.

TY