2017

On 7 Jan 2017, at 09:38, <brian@endeavotech.com> <brian@endeavotech.com> wrote:

I =am now able to connect to mysql 5.5.3 & 5.6.33 from 3 different =servers (Win7 WebDNA 6.2 | Linux Ubantu 14 WebDNA 8.2 | Win2008 WebDNA =6.2) 

 

No luck on connecting to MySQL 5.7

 

I think MySQL made some changes to the security =in 5.7. I guess WebDNA does not support that. I was really hoping to use =5.7 since they have a great replication system built right into the =platform.

 

I am able to connect to =5.7 using TOAD from the same Windows7 machine.

 

Brian

 

From: Stuart =Tremain [mailto:webdna@idfk.com.au] 
Sent: Friday, January 06, 2017 =4:33 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Ubuntu 14.04 =& WebDNA

 

Hi Brian

 

Can you connect to the external MySQL from the =command line ?

 

If not, then I suggest a permissions/firewall problem =at the MySQL server.

 

Remember to restart MySQL after changing any =settings.

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

On 7 Jan 2017, at 04:28, <brian@endeavotech.com> =<brian@endeavotech.com> =wrote:

 

So=E2=80=A6..

1.= I reimaged my Cloud with Ubantu 14.04

2. Loaded server WebDNA 8.2 (very easy install =BTW)

3. Created a local mysql =database

4. Then ran all my connect =strings to test

 

MYSQL =5.5.3 on LOCALHOST / PORT 3306 

Host:	localhost
Server Version:	5.5.53-0ubuntu0.14.04.1
Client Version:	5.5.53

MYSQL 5.6 on EXTERNAL SERVER / PORT 3306 
ERROR: =(null) DATABASE CONNECTION FAILED! - Access denied for user ='UID=E2=80=99@'###.###.###.###' (using password: YES) 

MYSQL 5.7 on EXTERNAL SERVER (INT LINK) / PORT =3306 
ERROR: (null) DATABASE CONNECTION FAILED! - Unknown MySQL =server host '###.###.###.###=E2=80=99port-3306' (2) 

MYSQL 5.7 on EXTERNAL SERVER / PORT =30839 
ERROR: (null) DATABASE CONNECTION FAILED! - Can't connect to =MySQL server on '###.###.###.###=E2=80=99 (4)

 

 

 

 

 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Friday, January 06, 2017 =4:33 AM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Ubuntu 14.04 =& WebDNA

 

Could very well be a firewall problem, something in the back =of my head is reminded about port 3306 on standard Ubuntu installs being =blocked.

 

Remember to reboot after you make any =config changes.

 

Kind regards

 

Stuart Tremain

Pharoah Lane =Software

AUSTRALIA

webdna@idfk.com.au

 

 

 

 

 

On 6 Jan 2017, at 16:17, brian@endeavotech.com wrote:

 

Getting closers. WebDNA =8.02 is installed on Ubantu 14

 

WebDNA works=E2=80=A6 but = connecting to  remote MySQL 5.7 is not. Either is remote =MySQL 5.6.

 

ERROR:= (null) DATABASE CONNECTION FAILED! - Can't connect to MySQL server on ='xxx.xxx.xxx.xxx (4)

 

The =code works perfect on my Window2008 WebDNA 6.02 server when calling an =external MySQL 5.6 server.

 

--- Brian

 

From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Thursday, January 05, 2017 =9:03 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: Re: [WebDNA] Ubuntu 14.04 =& WebDNA

 

This will get you 8.0.2

 

http://dev.webdna.us/products.html

 

 

 

Kind regards

 

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

 

 

--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

 

--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list . To =unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us