Zend Studio 6.1 et connexion réseau local MysQL
Bonjour,
Sur notre réseau local (Server 192.168.1.4 windows 2003 - oui je sais :oops: - Poste de travail - unique pour cet aspect du projet 192.168.1.10 - sous 7Pro 64bits).
Zend Studio 6.1.
Sur le serveur : wampserver (dernière version) MySQL 5.5 php 5.3 Apache 2.2.8 phpMyAdmin 3.4.10
Dont un utilisateur 'jlc' dont client '192.168.1.4' Tous les droits (nous sommes en local :zoubi:).
Propriété de la connexion sous Zend Studio :
- Driver : MySQL JDBC Driver 5.1 (pas de plus récent proposé par Zend Studio)
- URL : jdbc:mysql://192.168.1.4:3306/server
- User name : jlc
- Password : monMotDePasse
Au test de la connexion nous obtenons "Ping failed" suivi de l'incompréhensible message pour moi :
Citation:
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection timed out: connect
STACKTRACE:
java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2744)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at com.zend.php.datatools.core.connection.JDBCConnection.createConnection(Unknown Source)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at com.zend.php.datatools.core.connection.JDBCConnectionFactory.createConnection(Unknown Source)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2820)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at com.zend.php.datatools.core.connection.JDBCConnection.createConnection(Unknown Source)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at com.zend.php.datatools.core.connection.JDBCConnectionFactory.createConnection(Unknown Source)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Pourriez-vous me donner quelques conseils ?
Merci d'avance !
Jean-Louis