различия с локальной только что там используется https, а тут стоит proxy
В манифесте дописал
Код: Выделить всё
<uses-permission android:name="android.permission.INTERNET"/>
в данный момент при попытке коннекта
Код: Выделить всё
conn=DriverManager.getConnection("jdbc:mysql://"+sServerName+"/"+sDBName,properties);
Код: Выделить всё
11-19 08:44:31.488: DEBUG/myLogs(17837): >>> jdbc.Driver: instance successful
11-19 08:44:31.488: DEBUG/myLogs(17837): >>> befor DriverManager.getConnection
11-19 08:44:31.759: INFO/ActivityManager(95): Displayed activity com.example.Todo_List/.MyActivity: 1511 ms (total 1511 ms)
11-19 08:44:32.318: DEBUG/dalvikvm(17837): GC_FOR_MALLOC freed 3804 objects / 226160 bytes in 42ms
11-19 08:44:32.628: WARN/dalvikvm(17837): VFY: unable to find class referenced in signature (Ljavax/naming/Reference;)
11-19 08:44:32.628: INFO/dalvikvm(17837): Could not find method javax.naming.Reference.get, referenced from method com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.initializeFrom
11-19 08:44:32.628: WARN/dalvikvm(17837): VFY: unable to resolve virtual method 8366: Ljavax/naming/Reference;.get (Ljava/lang/String;)Ljavax/naming/RefAddr;
11-19 08:44:32.628: DEBUG/dalvikvm(17837): VFY: replacing opcode 0x6e at 0x0004
11-19 08:44:32.628: DEBUG/dalvikvm(17837): VFY: dead code 0x0007-0013 in Lcom/mysql/jdbc/ConnectionPropertiesImpl$ConnectionProperty;.initializeFrom (Ljavax/naming/Reference;Lcom/mysql/jdbc/ExceptionInterceptor;)V
11-19 08:44:32.628: WARN/dalvikvm(17837): VFY: unable to find class referenced in signature (Ljavax/naming/Reference;)
11-19 08:44:32.628: ERROR/dalvikvm(17837): Could not find class 'javax.naming.StringRefAddr', referenced from method com.mysql.jdbc.ConnectionPropertiesImpl$ConnectionProperty.storeTo
11-19 08:44:32.628: WARN/dalvikvm(17837): VFY: unable to resolve new-instance 545 (Ljavax/naming/StringRefAddr;) in Lcom/mysql/jdbc/ConnectionPropertiesImpl$ConnectionProperty;
11-19 08:44:32.628: DEBUG/dalvikvm(17837): VFY: replacing opcode 0x22 at 0x0006
11-19 08:44:32.628: DEBUG/dalvikvm(17837): VFY: dead code 0x0008-0019 in Lcom/mysql/jdbc/ConnectionPropertiesImpl$ConnectionProperty;.storeTo (Ljavax/naming/Reference;)V
11-19 08:44:32.778: INFO/dalvikvm(17837): Could not find method java.lang.management.ManagementFactory.getThreadMXBean, referenced from method com.mysql.jdbc.MysqlIO.appendDeadlockStatusInformation
11-19 08:44:32.778: WARN/dalvikvm(17837): VFY: unable to resolve static method 7733: Ljava/lang/management/ManagementFactory;.getThreadMXBean ()Ljava/lang/management/ThreadMXBean;
11-19 08:44:32.778: DEBUG/dalvikvm(17837): VFY: replacing opcode 0x71 at 0x0079
11-19 08:44:32.778: DEBUG/dalvikvm(17837): VFY: dead code 0x007c-00a9 in Lcom/mysql/jdbc/MysqlIO;.appendDeadlockStatusInformation (Ljava/lang/String;Ljava/lang/StringBuffer;)V
11-19 08:44:32.778: DEBUG/dalvikvm(17837): VFY: dead code 0x00ea-020a in Lcom/mysql/jdbc/MysqlIO;.appendDeadlockStatusInformation (Ljava/lang/String;Ljava/lang/StringBuffer;)V
11-19 08:44:36.919: DEBUG/dalvikvm(214): GC_EXPLICIT freed 572 objects / 32544 bytes in 129ms
11-19 08:44:41.969: DEBUG/dalvikvm(301): GC_EXPLICIT freed 100 objects / 4264 bytes in 139ms
11-19 08:44:51.669: DEBUG/dalvikvm(351): GC_EXPLICIT freed 47 objects / 2224 bytes in 118ms
11-19 08:48:26.279: DEBUG/SntpClient(95): request time failed: java.net.SocketException: Address family not supported by protocol
11-19 08:53:26.294: DEBUG/SntpClient(95): request time failed: java.net.SocketException: Address family not supported by protocol
Код: Выделить всё
11-19 08:54:04.401: DEBUG/myLogs(17837): >>> danach DriverManager.getConnection
11-19 08:54:04.409: DEBUG/myLogs(17837): >>> jdbc.Driver: connect error
11-19 08:54:04.409: INFO/System.out(17837): >SQLException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
11-19 08:54:04.409: INFO/System.out(17837): >SQLState: 08001
11-19 08:54:04.409: INFO/System.out(17837): >VendorError: 0
11-19 08:54:04.409: WARN/System.err(17837): com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1012)
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2388)
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2309)
11-19 08:54:04.419: WARN/System.err(17837): at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
11-19 08:54:04.429: WARN/System.err(17837): at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:412)
11-19 08:54:04.429: WARN/System.err(17837): at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
11-19 08:54:04.429: WARN/System.err(17837): at java.sql.DriverManager.getConnection(DriverManager.java:191)
11-19 08:54:04.429: WARN/System.err(17837): at com.example.Todo_List.DBHelper$1.run(DBHelper.java:196)
11-19 08:54:04.429: WARN/System.err(17837): at java.lang.Thread.run(Thread.java:1096)
11-19 08:54:04.429: WARN/System.err(17837): Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure
11-19 08:54:04.439: WARN/System.err(17837): [ 11-19 08:54:04.439 17837:0x45b5 W/System.err ]
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
11-19 08:54:04.439: WARN/System.err(17837): at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
11-19 08:54:04.439: WARN/System.err(17837): at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)
11-19 08:54:04.439: WARN/System.err(17837): at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2482)
11-19 08:54:04.439: WARN/System.err(17837): at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2327)
11-19 08:54:04.439: WARN/System.err(17837): ... 7 more
11-19 08:54:04.439: WARN/System.err(17837): Caused by: java.net.SocketException: The operation timed out
11-19 08:54:04.439: WARN/System.err(17837): at org.apache.harmony.luni.platform.OSNetworkSystem.connectStreamWithTimeoutSocketImpl(Native Method)
11-19 08:54:04.439: WARN/System.err(17837): at org.apache.harmony.luni.platform.OSNetworkSystem.connect(OSNetworkSystem.java:115)
11-19 08:54:04.449: WARN/System.err(17837): at org.apache.harmony.luni.net.PlainSocketImpl.connect(PlainSocketImpl.java:244)
11-19 08:54:04.449: WARN/System.err(17837): at org.apache.harmony.luni.net.PlainSocketImpl.connect(PlainSocketImpl.java:219)
11-19 08:54:04.449: WARN/System.err(17837): at java.net.Socket.startupSocket(Socket.java:781)
11-19 08:54:04.449: WARN/System.err(17837): at java.net.Socket.<init>(Socket.java:316)
11-19 08:54:04.449: WARN/System.err(17837): at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
11-19 08:54:04.449: WARN/System.err(17837): at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)
11-19 08:54:04.449: WARN/System.err(17837): ... 9 more
11-19 08:58:26.349: DEBUG/SntpClient(95): request time failed: java.net.SocketException: Address family not supported by protocol
PS: Прокси на всякий случай отключили, результат тот же
через вебинтерфейс в админку с теми же данными пускает без проблемм
При чём даже из браузера в самом эмуляторе
Значит дело в HTTPS? Пробовал типичный для него порт 443, эффекта так же не дало
Что ещё нужно учесть?