Re: [WebDNA] Ubuntu 14.04 & WebDNA

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113323
interpreted = N
texte = 916 --Apple-Mail=_B68C252D-7164-4209-A22C-E48BD82EF7F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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, = wrote: >=20 > 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 > =20 > MYSQL 5.5.3 on LOCALHOST / PORT 3306=20 > Host: > localhost > Server Version: > 5.5.53-0ubuntu0.14.04.1 > Client Version: > 5.5.53 >=20 >=20 > MYSQL 5.6 on EXTERNAL SERVER / PORT 3306=20 > ERROR: (null) DATABASE CONNECTION FAILED! - Access denied for user = 'UID=E2=80=99@'###.###.###.###' (using password: YES)=20 >=20 > MYSQL 5.7 on EXTERNAL SERVER (INT LINK) / PORT 3306=20 > ERROR: (null) DATABASE CONNECTION FAILED! - Unknown MySQL server host = '###.###.###.###=E2=80=99port-3306' (2)=20 >=20 > MYSQL 5.7 on EXTERNAL SERVER / PORT 30839=20 > ERROR: (null) DATABASE CONNECTION FAILED! - Can't connect to MySQL = server on '###.###.###.###=E2=80=99 (4) > =20 > =20 > =20 > =20 > =20 > From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 > Sent: Friday, January 06, 2017 4:33 AM > To: WebDNA Talk List > > Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA > =20 > 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. > =20 > Remember to reboot after you make any config changes. > =20 > Kind regards > =20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au > =20 > =20 > =20 > =20 >=20 > =20 >> On 6 Jan 2017, at 16:17, brian@endeavotech.com = wrote: >> =20 >> Getting closers. WebDNA 8.02 is installed on Ubantu 14 >> =20 >> WebDNA works=E2=80=A6 but connecting to remote MySQL 5.7 is not. = Either is remote MySQL 5.6. >> =20 >> ERROR: (null) DATABASE CONNECTION FAILED! - Can't connect to MySQL = server on 'xxx.xxx.xxx.xxx (4) >> =20 >> The code works perfect on my Window2008 WebDNA 6.02 server when = calling an external MySQL 5.6 server. >> =20 >> --- Brian >> =20 >> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >> Sent: Thursday, January 05, 2017 9:03 PM >> To: WebDNA Talk List > >> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA >> =20 >> This will get you 8.0.2 >> =20 >> http://dev.webdna.us/products.html = >> =20 >> =20 >> =20 >> Kind regards >> =20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >> =20 >> =20 >> --------------------------------------------------------- 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 > =20 > --------------------------------------------------------- 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 --Apple-Mail=_B68C252D-7164-4209-A22C-E48BD82EF7F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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






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
 
 
 

 

 
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
 
 
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
 
 
--------------------------------------------------------- = 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
= --------------------------------------------------------- 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 --Apple-Mail=_B68C252D-7164-4209-A22C-E48BD82EF7F4-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) (christophe.billiottet@webdna.us 2017)
  2. Re: [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) (Brian Boegershausen 2017)
  3. Re: [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) (christophe.billiottet@webdna.us 2017)
  4. Re: [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) (Stuart Tremain 2017)
  5. RE: [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) ( 2017)
  6. Re: [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) (Stuart Tremain 2017)
  7. [WebDNA] Ubuntu 14.04 & WebDNA 8.2 (html not rendering) ( 2017)
  8. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Brian Boegershausen 2017)
  9. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  10. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  11. Re: [WebDNA] Ubuntu 14.04 & WebDNA (christophe.billiottet@webdna.us 2017)
  12. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  13. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Brian Boegershausen 2017)
  14. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  15. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Brian Boegershausen 2017)
  16. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  17. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  18. RE: [WebDNA] Ubuntu 14.04 & WebDNA ( 2017)
  19. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  20. RE: [WebDNA] Ubuntu 14.04 & WebDNA ( 2017)
  21. Re: [WebDNA] Ubuntu 14.04 & WebDNA (christophe.billiottet@webdna.us 2017)
  22. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  23. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  24. Re: [WebDNA] Ubuntu 14.04 & WebDNA (christophe.billiottet@webdna.us 2017)
  25. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  26. RE: [WebDNA] Ubuntu 14.04 & WebDNA ( 2017)
  27. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  28. RE: [WebDNA] Ubuntu 14.04 & WebDNA ( 2017)
  29. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  30. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  31. RE: [WebDNA] Ubuntu 14.04 & WebDNA ( 2017)
  32. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  33. RE: [WebDNA] Ubuntu 14.04 & WebDNA ( 2017)
  34. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Kenneth Grome 2017)
  35. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  36. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Kenneth Grome 2017)
  37. Re: [WebDNA] Ubuntu 14.04 & WebDNA (christophe.billiottet@webdna.us 2017)
  38. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  39. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  40. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  41. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Kenneth Grome 2017)
  42. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Donovan Brooke 2017)
  43. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  44. Re: [WebDNA] Ubuntu 14.04 & WebDNA (Donovan Brooke 2017)
  45. [WebDNA] Ubuntu 14.04 & WebDNA (Stuart Tremain 2017)
  46. Re: [WebDNA] Ubuntu 14.04 LTS / Apache 2.4 (Kenneth Grome 2014)
  47. Re: [WebDNA] Ubuntu 14.04 LTS / Apache 2.4 (christophe.billiottet@webdna.us 2014)
  48. [WebDNA] Ubuntu 14.04 LTS / Apache 2.4 (Kenneth Grome 2014)
916 --Apple-Mail=_B68C252D-7164-4209-A22C-E48BD82EF7F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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, = wrote: >=20 > 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 > =20 > MYSQL 5.5.3 on LOCALHOST / PORT 3306=20 > Host: > localhost > Server Version: > 5.5.53-0ubuntu0.14.04.1 > Client Version: > 5.5.53 >=20 >=20 > MYSQL 5.6 on EXTERNAL SERVER / PORT 3306=20 > ERROR: (null) DATABASE CONNECTION FAILED! - Access denied for user = 'UID=E2=80=99@'###.###.###.###' (using password: YES)=20 >=20 > MYSQL 5.7 on EXTERNAL SERVER (INT LINK) / PORT 3306=20 > ERROR: (null) DATABASE CONNECTION FAILED! - Unknown MySQL server host = '###.###.###.###=E2=80=99port-3306' (2)=20 >=20 > MYSQL 5.7 on EXTERNAL SERVER / PORT 30839=20 > ERROR: (null) DATABASE CONNECTION FAILED! - Can't connect to MySQL = server on '###.###.###.###=E2=80=99 (4) > =20 > =20 > =20 > =20 > =20 > From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 > Sent: Friday, January 06, 2017 4:33 AM > To: WebDNA Talk List > > Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA > =20 > 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. > =20 > Remember to reboot after you make any config changes. > =20 > Kind regards > =20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au > =20 > =20 > =20 > =20 >=20 > =20 >> On 6 Jan 2017, at 16:17, brian@endeavotech.com = wrote: >> =20 >> Getting closers. WebDNA 8.02 is installed on Ubantu 14 >> =20 >> WebDNA works=E2=80=A6 but connecting to remote MySQL 5.7 is not. = Either is remote MySQL 5.6. >> =20 >> ERROR: (null) DATABASE CONNECTION FAILED! - Can't connect to MySQL = server on 'xxx.xxx.xxx.xxx (4) >> =20 >> The code works perfect on my Window2008 WebDNA 6.02 server when = calling an external MySQL 5.6 server. >> =20 >> --- Brian >> =20 >> From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 >> Sent: Thursday, January 05, 2017 9:03 PM >> To: WebDNA Talk List > >> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA >> =20 >> This will get you 8.0.2 >> =20 >> http://dev.webdna.us/products.html = >> =20 >> =20 >> =20 >> Kind regards >> =20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >> =20 >> =20 >> --------------------------------------------------------- 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 > =20 > --------------------------------------------------------- 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 --Apple-Mail=_B68C252D-7164-4209-A22C-E48BD82EF7F4 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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






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
 
 
 

 

 
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
 
 
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
 
 
--------------------------------------------------------- = 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
= --------------------------------------------------------- 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 --Apple-Mail=_B68C252D-7164-4209-A22C-E48BD82EF7F4-- . Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

rn doesn't work on date fields (1998) Cookie problems using Mozilla and Camino browsers (2004) Close-to Comparison Code (1998) Email within tmpl ? (1997) 911: testing if the field is empty (2000) Starting WebCatalog on Linux (2000) Nested tags count question (1997) passing info to correct frame (2000) WebMerchant when CC network is down - bug? (1998) Writing multiple data into one field (1998) Reload adding to cart (2001) Privacy Issue (Built in sniffer) (2003) [WebDNA] [showif] problem (2009) Search results templates (1996) Multi-processor Mac info ... (1997) [WebDNA] [OT] Google redirect or not (2014) Finding unused SKU's in a database (2002) [ConvertChars] problem (1997) [WebDNA] Crashing again (2008) Database Options (1997)