Benetl, a free ETL tool for MySQL, out in version 4.5
Dear all, Benetl, a free ETL tool for MySQL, is out in version 4.5. This version of Benetl is now Java 7 and has been tested on 64 bit systems. This versions is correcting two bugs: Trouble with double parsing when data contains ',' as float separator Divide function now accepts negative operand and shows an error when divide by 0 Part operator brings a new function: fact. New error messages provided. More than 100 tests passed. You should really update. Benetl is freely dowloadable at:http://www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier http://www.benetl.net Founder of Benetl and Java project manager
cannot connect remotely on 3306
Hi, On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. Please help Nicu
Re: cannot connect remotely on 3306
Hi again, I removed Firewall on the win7 server, I set the server in Home network, and joined the workgroup / homegroup. From other computers I can access \\server\Users, can ping it, but cannot telnet to 3306 (which locally i can on both localhost and ip), nor connect with DBVisualizer (which locally i can referring the server both by localhost as well as its ip 192.168.0.12). Thanks Nicu On Sat, Apr 12, 2014 at 5:33 PM, Nicolae Marasoiu nicolae.maras...@gmail.com wrote: Hi, On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. Please help Nicu
Re: cannot connect remotely on 3306
Am 12.04.2014 16:37, schrieb Nicolae Marasoiu: I removed Firewall on the win7 server, I set the server in Home network, and joined the workgroup / homegroup. From other computers I can access \\server\Users, can ping it, but cannot telnet to 3306 (which locally i can on both localhost and ip), nor connect with DBVisualizer (which locally i can referring the server both by localhost as well as its ip 192.168.0.12). On Sat, Apr 12, 2014 at 5:33 PM, Nicolae Marasoiu nicolae.maras...@gmail.com wrote: On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. that's hardly a mysql problem * the windows telnet client is unuseable because it strips outputs * how long do you wait for a response? most likely you run into dns timeouts especially if ipv6 is enabled and not proper configured network wide and if your network is wrong configured at all (no PTR records for your IP's for ipv4 and ipv6 well then you have both timeouts for name-resolve) try skip-name-resolve in my.cnf but be aware that you need to use ip-addresses for mysql-permissions instead hostnames get rid of Windows and setup a virtual machine for development servers will solve a lot of problems - i maintained over years two customers with mysql on Windows servers and that wasted more time than the 30 production servers on Linux signature.asc Description: OpenPGP digital signature
Re: cannot connect remotely on 3306
solved.. firewall was up:) it had 3 profiles and i had just set it off on one of them Trimis de pe iPhone-ul meu Pe 12.04.2014, la 17:48, Reindl Harald h.rei...@thelounge.net a scris: Am 12.04.2014 16:37, schrieb Nicolae Marasoiu: I removed Firewall on the win7 server, I set the server in Home network, and joined the workgroup / homegroup. From other computers I can access \\server\Users, can ping it, but cannot telnet to 3306 (which locally i can on both localhost and ip), nor connect with DBVisualizer (which locally i can referring the server both by localhost as well as its ip 192.168.0.12). On Sat, Apr 12, 2014 at 5:33 PM, Nicolae Marasoiu nicolae.maras...@gmail.com wrote: On the win7 mysql server I see that the LISTENING is done on 0.0.0.0:3306. From other computers I can ping the server, but cannot telnet on 3306. that's hardly a mysql problem * the windows telnet client is unuseable because it strips outputs * how long do you wait for a response? most likely you run into dns timeouts especially if ipv6 is enabled and not proper configured network wide and if your network is wrong configured at all (no PTR records for your IP's for ipv4 and ipv6 well then you have both timeouts for name-resolve) try skip-name-resolve in my.cnf but be aware that you need to use ip-addresses for mysql-permissions instead hostnames get rid of Windows and setup a virtual machine for development servers will solve a lot of problems - i maintained over years two customers with mysql on Windows servers and that wasted more time than the 30 production servers on Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql