Re: [WebDNA] Ubuntu 14.04 & WebDNA

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113332
interpreted = N
texte = 925 --Apple-Mail=_E2E84974-BD0D-4BA9-A2ED-075593C9A958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Chris I have done a number of reboots to no avail. All goes to muck as soon as I enter the answer to the math question. I have sent further details to support. Hitting: /cgi-bin/WebCatalogEngine/Admin/AdminPrefs.dna results in this: top - 06:20:52 up 3:54, 1 user, load average: 1.91, 0.71, 0.26 Tasks: 135 total, 2 running, 133 sleeping, 0 stopped, 0 zombie %Cpu(s): 22.2 us, 72.9 sy, 0.0 ni, 4.9 id, 0.0 wa, 0.0 hi, 0.0 si, = 0.0 st KiB Mem: 4043436 total, 540896 used, 3502540 free, 20904 buffers KiB Swap: 524284 total, 0 used, 524284 free. 384068 cached = Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ = COMMAND = =20 3533 www-data 20 0 575644 9068 7896 R 99.9 0.2 1:44.31 = WebCatalog = =20 3426 syslog 20 0 255844 3412 2332 S 43.6 0.1 0:46.53 = rsyslogd = =20 3531 root 20 0 4332 1344 1244 S 43.6 0.0 0:46.10 = WebDNAMonitor = =20 1 root 20 0 33644 4028 2580 S 0.0 0.1 0:01.42 init = = =20 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 = kthreadd = =20 3 root 20 0 0 0 0 S 0.0 0.0 0:00.86 = ksoftirqd/0 = =20 4 root 20 0 0 0 0 S 0.0 0.0 0:00.04 = kworker/0:0 =20 Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 8 Jan 2017, at 17:14, christophe.billiottet@webdna.us wrote: >=20 > Hi Stuart! >=20 > the message "the WebDNA engine has reached its connection limit" plus = the "the processor hits 96% usage" would make me think there is either a = loop or intense activity. Can you just reboot? a shell command like = "top" will give you the CPU activity for WebDNA and "netstat -an" will = show the number of connections to your website. >=20 > - chris >=20 >=20 >=20 >=20 >> On Jan 8, 2017, at 08:50, Stuart Tremain wrote: >>=20 >> Mmmm, something wrong here, the processor hits 96% usage when WebDNA = errors. >>=20 >> I have sent my logs etc to support, hopefully they can see what is = going wrong. >>=20 >> Sure would prefer that WebDNA kept going with MySQL otherwise my = multi server solutions can not progress with the language. >>=20 >> Kind regards >>=20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 8 Jan 2017, at 15:15, Brian Boegershausen = wrote: >>>=20 >>> My same install went smooth on 8.2 and ubuntu 14.04 >>> Only thing i saw today was when rebooting, i need to reset my webdna = pref and reenter the dev serial #. >>>=20 >>> Brian >>>=20 >>>=20 >>>=20 >>> Sent from my Verizon, Samsung Galaxy smartphone >>>=20 >>> -------- Original message -------- >>> From: Stuart Tremain =20 >>> Date: 1/7/17 9:06 PM (GMT-05:00)=20 >>> To: WebDNA Talk List =20 >>> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA=20 >>>=20 >>> I have tried to install 8.2 on Ubuntu 14.04. >>>=20 >>> All seemed to have gone well until I went to enter the math = question, then all I get is: >>>=20 >>> Sorry, the WebDNA engine has reached its connection limit. >>>=20 >>> Any ideas ? >>>=20 >>>=20 >>>=20 >>>=20 >>> Kind regards >>>=20 >>> Stuart Tremain >>> Pharoah Lane Software >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>>> On 8 Jan 2017, at 02:03, Brian Boegershausen = wrote: >>>>=20 >>>> I think i may just need to setup a mysql 5.6 server until webdna is = available for ubuntu 16.=20 >>>> I am able to connect to mysql 5.7 using TOAD from my laptop, so it = is not a firewall issue. >>>>=20 >>>> Not a big deal. I am much happier to have a newer version of webdna = on a cloud server. >>>>=20 >>>> Time to setup load balancing and it is showtime. >>>>=20 >>>> Thanks for all your help Stuart. >>>>=20 >>>> Brian >>>>=20 >>>>=20 >>>> Sent from my Verizon, Samsung Galaxy smartphone >>>>=20 >>>> -------- Original message -------- >>>> From: Stuart Tremain =20 >>>> Date: 1/6/17 8:53 PM (GMT-05:00)=20 >>>> To: WebDNA Talk List =20 >>>> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA=20 >>>>=20 >>>> This may help: >>>>=20 >>>> https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html >>>>=20 >>>>=20 >>>> Kind regards >>>>=20 >>>> Stuart Tremain >>>> Pharoah Lane Software >>>> AUSTRALIA >>>> webdna@idfk.com.au >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>>> On 7 Jan 2017, at 09:38, = wrote: >>>>>=20 >>>>> 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)=20 >>>>>=20 >>>>> No luck on connecting to MySQL 5.7 >>>>>=20 >>>>> 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. >>>>>=20 >>>>> I am able to connect to 5.7 using TOAD from the same Windows7 = machine. >>>>>=20 >>>>> Brian >>>>>=20 >>>>> From: Stuart Tremain [mailto:webdna@idfk.com.au]=20 >>>>> Sent: Friday, January 06, 2017 4:33 PM >>>>> To: WebDNA Talk List >>>>> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA >>>>>=20 >>>>> Hi Brian >>>>>=20 >>>>> Can you connect to the external MySQL from the command line ? >>>>>=20 >>>>> If not, then I suggest a permissions/firewall problem at the MySQL = server. >>>>>=20 >>>>> Remember to restart MySQL after changing any settings. >>>>>=20 >>>>> Kind regards >>>>>=20 >>>>> Stuart Tremain >>>>> Pharoah Lane Software >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>>> 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 c >>> = N=18=EF=BF=BD=EF=BF=BD,j=07=EF=BF=BD=C7=A7=EF=BF=BD=EF=BF=BD2=EF=BF=BD=EF=BF= =BD=EF=BF=BDq=EF=BF=BD{*.j=EF=BF=BD=1C=EF=BF=BD&=EF=BF=BDv=EF=BF=BD-=EF=BF= =BD=E9=9A=8AX=EF=BF=BDX#<^_NSEDR_^#<=D6=A5=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD= :.=EF=BF=BD=CB=9B=EF=BF=BD=EF=BF=BD=EF=BF=BDm=EF=BF=BD&j)m#<^_NSEDR_^#<=D6= =A5=EF=BF=BDW=EF=BF=BD=EF=BF=BD=1Em=EF=BF=BD=DA=BA=C6=ABr=18=EF=BF=BDz=EF=BF= =BDm=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=DD=9D=EF=BF=BDX=EF=BF=BDZ=EF=BF=BD= L=1Em=EF=BF=BD=DA=BA=EF=BF=BDn=EF=BF=BD=17=EF=BF=BDb=EF=BF=BD=0B= ..=EF=BF=BD+=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD >>=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 --Apple-Mail=_E2E84974-BD0D-4BA9-A2ED-075593C9A958 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi Chris

I = have done a number of reboots to no avail.

All goes to muck as soon as I enter the = answer to the math question.

I have sent further details to = support.

Hitting: = /cgi-bin/WebCatalogEngine/Admin/AdminPrefs.dna

results in this:

top - 06:20:52 up  3:54,  1 user,  load = average: 1.91, 0.71, 0.26
Tasks: 135 total,   2 running, 133 sleeping,   0 stopped,   0 zombie
%Cpu(s): 22.2 us, 72.9 = sy,  0.0 ni,  4.9 = id,  0.0 wa,  0.0 = hi,  0.0 si,  0.0 = st
KiB Mem:   4043436 = total,   540896 used,  = 3502540 free,    20904 = buffers
KiB Swap:   524284 = total,        0 used,   524284 free.   384068 = cached Mem

  PID USER      PR  NI    = VIRT    RES    SHR S  %CPU %MEM     = TIME+ COMMAND                =                     =                     =                     =  
 3533 www-data  = 20   0  575644   9068   7896 R  99.9  0.2 =   1:44.31 WebCatalog             =                     =                     =                     =  
 3426 syslog    20   = 0  255844   3412   2332 S  43.6  0.1   = 0:46.53 rsyslogd                 =                     =                     =                   =  
 3531 root      20 =   0    4332   1344   1244 S  43.6  = 0.0   0:46.10 WebDNAMonitor          =                     =                     =                     =  
    1 root      = 20   0   33644   4028   2580 S   0.0  0.1 =   0:01.42 init               =                     =                     =                     =      
    2 root      = 20   0       0      0    =   0 S   0.0  0.0   0:00.00 kthreadd     =                     =                     =                     =            
  =   3 root      20   0       = 0      0      0 S   0.0  0.0 =   0:00.86 ksoftirqd/0            =                     =                     =                     =  
    4 root      = 20   0       0      0    =   0 S   0.0  0.0   0:00.04 kworker/0:0     =  

Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au






On 8 Jan 2017, at 17:14, christophe.billiottet@webdna.us wrote:

Hi = Stuart!

the message "the WebDNA engine has = reached its connection limit" plus the "the processor hits 96% usage" = would make me think there is either a loop or intense activity. Can you = just reboot? a shell command like "top" will give you the CPU activity = for WebDNA and "netstat -an" will show the number of connections to your = website.

- chris




On Jan 8, 2017, at 08:50, Stuart Tremain <webdna@idfk.com.au> = wrote:

Mmmm, something wrong here, the = processor hits 96% usage when WebDNA errors.

I have sent my logs etc to support, hopefully they can see = what is going wrong.

Sure would prefer that = WebDNA kept going with MySQL otherwise my multi server solutions can not = progress with the language.

Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au





On 8 Jan = 2017, at 15:15, Brian Boegershausen <brian@endeavotech.com> = wrote:

My same install went smooth on 8.2 = and ubuntu 14.04
Only thing i saw today was when = rebooting, i need to reset my webdna pref and reenter the dev serial = #.

Brian



Sent from my Verizon, Samsung Galaxy = smartphone

-------- Original message = --------
From: Stuart Tremain <webdna@idfk.com.au> =
Date: 1/7/17 9:06 PM (GMT-05:00)
To: = WebDNA Talk List <talk@webdna.us>
Subject: Re: = [WebDNA] Ubuntu 14.04 & WebDNA

I have = tried to install 8.2 on Ubuntu 14.04.

All = seemed to have gone well until I went to enter the math question, then = all I get is:

Sorry, the WebDNA engine has = reached its connection limit.

Any ideas = ?




Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au






On 8 Jan 2017, at 02:03, = Brian Boegershausen <brian@endeavotech.com> wrote:
I think i may just need to setup a mysql 5.6 server until = webdna is available for ubuntu 16.
I am able to connect = to mysql 5.7 using TOAD from my laptop, so it is not a firewall = issue.

Not a big deal. I am much happier to = have a newer version of webdna on a cloud server.

Time to setup load balancing and it is showtime.

Thanks for all your help Stuart.

Brian


Sent from my Verizon, Samsung Galaxy smartphone

-------- Original message --------
From: Stuart Tremain <webdna@idfk.com.au>
Date: 1/6/17 8:53 PM (GMT-05:00)
To: WebDNA = Talk List <talk@webdna.us>
Subject: Re: [WebDNA] = Ubuntu 14.04 & WebDNA

This may = help:

https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.htm= l


Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au





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 c
N=18=EF=BF=BD=EF=BF=BD,j= =07=EF=BF=BD=C7=A7=EF=BF=BD=EF=BF=BD2=EF=BF=BD=EF=BF=BD=EF=BF=BDq=EF=BF=BD= {*.j=EF=BF=BD=1C=EF=BF=BD&=EF=BF=BDv=EF=BF=BD-=EF=BF=BD=E9=9A=8AX=EF=BF= =BDX#<^_NSEDR_^#<=D6=A5=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD:.=EF=BF=BD=CB= =9B=EF=BF=BD=EF=BF=BD=EF=BF=BDm=EF=BF=BD&j)m#<^_NSEDR_^#<=D6=A5=EF= =BF=BDW=EF=BF=BD=EF=BF=BD=1Em=EF=BF=BD=DA=BA=C6=ABr=18=EF=BF=BDz=EF=BF=BDm= =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=DD=9D=EF=BF=BDX=EF=BF=BDZ=EF=BF=BDL=1E= m=EF=BF=BD=DA=BA=EF=BF=BDn=EF=BF=BD=17=EF=BF=BDb=EF=BF=BD=0B= ..=EF=BF=BD+=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD
--------------------------------------------------------- = 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 <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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=_E2E84974-BD0D-4BA9-A2ED-075593C9A958-- . 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)
925 --Apple-Mail=_E2E84974-BD0D-4BA9-A2ED-075593C9A958 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Chris I have done a number of reboots to no avail. All goes to muck as soon as I enter the answer to the math question. I have sent further details to support. Hitting: /cgi-bin/WebCatalogEngine/Admin/AdminPrefs.dna results in this: top - 06:20:52 up 3:54, 1 user, load average: 1.91, 0.71, 0.26 Tasks: 135 total, 2 running, 133 sleeping, 0 stopped, 0 zombie %Cpu(s): 22.2 us, 72.9 sy, 0.0 ni, 4.9 id, 0.0 wa, 0.0 hi, 0.0 si, = 0.0 st KiB Mem: 4043436 total, 540896 used, 3502540 free, 20904 buffers KiB Swap: 524284 total, 0 used, 524284 free. 384068 cached = Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ = COMMAND = =20 3533 www-data 20 0 575644 9068 7896 R 99.9 0.2 1:44.31 = WebCatalog = =20 3426 syslog 20 0 255844 3412 2332 S 43.6 0.1 0:46.53 = rsyslogd = =20 3531 root 20 0 4332 1344 1244 S 43.6 0.0 0:46.10 = WebDNAMonitor = =20 1 root 20 0 33644 4028 2580 S 0.0 0.1 0:01.42 init = = =20 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 = kthreadd = =20 3 root 20 0 0 0 0 S 0.0 0.0 0:00.86 = ksoftirqd/0 = =20 4 root 20 0 0 0 0 S 0.0 0.0 0:00.04 = kworker/0:0 =20 Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 8 Jan 2017, at 17:14, christophe.billiottet@webdna.us wrote: >=20 > Hi Stuart! >=20 > the message "the WebDNA engine has reached its connection limit" plus = the "the processor hits 96% usage" would make me think there is either a = loop or intense activity. Can you just reboot? a shell command like = "top" will give you the CPU activity for WebDNA and "netstat -an" will = show the number of connections to your website. >=20 > - chris >=20 >=20 >=20 >=20 >> On Jan 8, 2017, at 08:50, Stuart Tremain wrote: >>=20 >> Mmmm, something wrong here, the processor hits 96% usage when WebDNA = errors. >>=20 >> I have sent my logs etc to support, hopefully they can see what is = going wrong. >>=20 >> Sure would prefer that WebDNA kept going with MySQL otherwise my = multi server solutions can not progress with the language. >>=20 >> Kind regards >>=20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 8 Jan 2017, at 15:15, Brian Boegershausen = wrote: >>>=20 >>> My same install went smooth on 8.2 and ubuntu 14.04 >>> Only thing i saw today was when rebooting, i need to reset my webdna = pref and reenter the dev serial #. >>>=20 >>> Brian >>>=20 >>>=20 >>>=20 >>> Sent from my Verizon, Samsung Galaxy smartphone >>>=20 >>> -------- Original message -------- >>> From: Stuart Tremain =20 >>> Date: 1/7/17 9:06 PM (GMT-05:00)=20 >>> To: WebDNA Talk List =20 >>> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA=20 >>>=20 >>> I have tried to install 8.2 on Ubuntu 14.04. >>>=20 >>> All seemed to have gone well until I went to enter the math = question, then all I get is: >>>=20 >>> Sorry, the WebDNA engine has reached its connection limit. >>>=20 >>> Any ideas ? >>>=20 >>>=20 >>>=20 >>>=20 >>> Kind regards >>>=20 >>> Stuart Tremain >>> Pharoah Lane Software >>> AUSTRALIA >>> webdna@idfk.com.au >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>>=20 >>>> On 8 Jan 2017, at 02:03, Brian Boegershausen = wrote: >>>>=20 >>>> I think i may just need to setup a mysql 5.6 server until webdna is = available for ubuntu 16.=20 >>>> I am able to connect to mysql 5.7 using TOAD from my laptop, so it = is not a firewall issue. >>>>=20 >>>> Not a big deal. I am much happier to have a newer version of webdna = on a cloud server. >>>>=20 >>>> Time to setup load balancing and it is showtime. >>>>=20 >>>> Thanks for all your help Stuart. >>>>=20 >>>> Brian >>>>=20 >>>>=20 >>>> Sent from my Verizon, Samsung Galaxy smartphone >>>>=20 >>>> -------- Original message -------- >>>> From: Stuart Tremain =20 >>>> Date: 1/6/17 8:53 PM (GMT-05:00)=20 >>>> To: WebDNA Talk List =20 >>>> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA=20 >>>>=20 >>>> This may help: >>>>=20 >>>> https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html >>>>=20 >>>>=20 >>>> Kind regards >>>>=20 >>>> Stuart Tremain >>>> Pharoah Lane Software >>>> AUSTRALIA >>>> webdna@idfk.com.au >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>>=20 >>>>> On 7 Jan 2017, at 09:38, = wrote: >>>>>=20 >>>>> 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)=20 >>>>>=20 >>>>> No luck on connecting to MySQL 5.7 >>>>>=20 >>>>> 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. >>>>>=20 >>>>> I am able to connect to 5.7 using TOAD from the same Windows7 = machine. >>>>>=20 >>>>> Brian >>>>>=20 >>>>> From: Stuart Tremain [mailto:webdna@idfk.com.au]=20 >>>>> Sent: Friday, January 06, 2017 4:33 PM >>>>> To: WebDNA Talk List >>>>> Subject: Re: [WebDNA] Ubuntu 14.04 & WebDNA >>>>>=20 >>>>> Hi Brian >>>>>=20 >>>>> Can you connect to the external MySQL from the command line ? >>>>>=20 >>>>> If not, then I suggest a permissions/firewall problem at the MySQL = server. >>>>>=20 >>>>> Remember to restart MySQL after changing any settings. >>>>>=20 >>>>> Kind regards >>>>>=20 >>>>> Stuart Tremain >>>>> Pharoah Lane Software >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>>=20 >>>>>> 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 c >>> = N=18=EF=BF=BD=EF=BF=BD,j=07=EF=BF=BD=C7=A7=EF=BF=BD=EF=BF=BD2=EF=BF=BD=EF=BF= =BD=EF=BF=BDq=EF=BF=BD{*.j=EF=BF=BD=1C=EF=BF=BD&=EF=BF=BDv=EF=BF=BD-=EF=BF= =BD=E9=9A=8AX=EF=BF=BDX#<^_NSEDR_^#<=D6=A5=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD= :.=EF=BF=BD=CB=9B=EF=BF=BD=EF=BF=BD=EF=BF=BDm=EF=BF=BD&j)m#<^_NSEDR_^#<=D6= =A5=EF=BF=BDW=EF=BF=BD=EF=BF=BD=1Em=EF=BF=BD=DA=BA=C6=ABr=18=EF=BF=BDz=EF=BF= =BDm=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=DD=9D=EF=BF=BDX=EF=BF=BDZ=EF=BF=BD= L=1Em=EF=BF=BD=DA=BA=EF=BF=BDn=EF=BF=BD=17=EF=BF=BDb=EF=BF=BD=0B= ..=EF=BF=BD+=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD >>=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 --Apple-Mail=_E2E84974-BD0D-4BA9-A2ED-075593C9A958 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Hi Chris

I = have done a number of reboots to no avail.

All goes to muck as soon as I enter the = answer to the math question.

I have sent further details to = support.

Hitting: = /cgi-bin/WebCatalogEngine/Admin/AdminPrefs.dna

results in this:

top - 06:20:52 up  3:54,  1 user,  load = average: 1.91, 0.71, 0.26
Tasks: 135 total,   2 running, 133 sleeping,   0 stopped,   0 zombie
%Cpu(s): 22.2 us, 72.9 = sy,  0.0 ni,  4.9 = id,  0.0 wa,  0.0 = hi,  0.0 si,  0.0 = st
KiB Mem:   4043436 = total,   540896 used,  = 3502540 free,    20904 = buffers
KiB Swap:   524284 = total,        0 used,   524284 free.   384068 = cached Mem

  PID USER      PR  NI    = VIRT    RES    SHR S  %CPU %MEM     = TIME+ COMMAND                =                     =                     =                     =  
 3533 www-data  = 20   0  575644   9068   7896 R  99.9  0.2 =   1:44.31 WebCatalog             =                     =                     =                     =  
 3426 syslog    20   = 0  255844   3412   2332 S  43.6  0.1   = 0:46.53 rsyslogd                 =                     =                     =                   =  
 3531 root      20 =   0    4332   1344   1244 S  43.6  = 0.0   0:46.10 WebDNAMonitor          =                     =                     =                     =  
    1 root      = 20   0   33644   4028   2580 S   0.0  0.1 =   0:01.42 init               =                     =                     =                     =      
    2 root      = 20   0       0      0    =   0 S   0.0  0.0   0:00.00 kthreadd     =                     =                     =                     =            
  =   3 root      20   0       = 0      0      0 S   0.0  0.0 =   0:00.86 ksoftirqd/0            =                     =                     =                     =  
    4 root      = 20   0       0      0    =   0 S   0.0  0.0   0:00.04 kworker/0:0     =  

Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au






On 8 Jan 2017, at 17:14, christophe.billiottet@webdna.us wrote:

Hi = Stuart!

the message "the WebDNA engine has = reached its connection limit" plus the "the processor hits 96% usage" = would make me think there is either a loop or intense activity. Can you = just reboot? a shell command like "top" will give you the CPU activity = for WebDNA and "netstat -an" will show the number of connections to your = website.

- chris




On Jan 8, 2017, at 08:50, Stuart Tremain <webdna@idfk.com.au> = wrote:

Mmmm, something wrong here, the = processor hits 96% usage when WebDNA errors.

I have sent my logs etc to support, hopefully they can see = what is going wrong.

Sure would prefer that = WebDNA kept going with MySQL otherwise my multi server solutions can not = progress with the language.

Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au





On 8 Jan = 2017, at 15:15, Brian Boegershausen <brian@endeavotech.com> = wrote:

My same install went smooth on 8.2 = and ubuntu 14.04
Only thing i saw today was when = rebooting, i need to reset my webdna pref and reenter the dev serial = #.

Brian



Sent from my Verizon, Samsung Galaxy = smartphone

-------- Original message = --------
From: Stuart Tremain <webdna@idfk.com.au> =
Date: 1/7/17 9:06 PM (GMT-05:00)
To: = WebDNA Talk List <talk@webdna.us>
Subject: Re: = [WebDNA] Ubuntu 14.04 & WebDNA

I have = tried to install 8.2 on Ubuntu 14.04.

All = seemed to have gone well until I went to enter the math question, then = all I get is:

Sorry, the WebDNA engine has = reached its connection limit.

Any ideas = ?




Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au






On 8 Jan 2017, at 02:03, = Brian Boegershausen <brian@endeavotech.com> wrote:
I think i may just need to setup a mysql 5.6 server until = webdna is available for ubuntu 16.
I am able to connect = to mysql 5.7 using TOAD from my laptop, so it is not a firewall = issue.

Not a big deal. I am much happier to = have a newer version of webdna on a cloud server.

Time to setup load balancing and it is showtime.

Thanks for all your help Stuart.

Brian


Sent from my Verizon, Samsung Galaxy smartphone

-------- Original message --------
From: Stuart Tremain <webdna@idfk.com.au>
Date: 1/6/17 8:53 PM (GMT-05:00)
To: WebDNA = Talk List <talk@webdna.us>
Subject: Re: [WebDNA] = Ubuntu 14.04 & WebDNA

This may = help:

https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.htm= l


Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au





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 c
N=18=EF=BF=BD=EF=BF=BD,j= =07=EF=BF=BD=C7=A7=EF=BF=BD=EF=BF=BD2=EF=BF=BD=EF=BF=BD=EF=BF=BDq=EF=BF=BD= {*.j=EF=BF=BD=1C=EF=BF=BD&=EF=BF=BDv=EF=BF=BD-=EF=BF=BD=E9=9A=8AX=EF=BF= =BDX#<^_NSEDR_^#<=D6=A5=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD:.=EF=BF=BD=CB= =9B=EF=BF=BD=EF=BF=BD=EF=BF=BDm=EF=BF=BD&j)m#<^_NSEDR_^#<=D6=A5=EF= =BF=BDW=EF=BF=BD=EF=BF=BD=1Em=EF=BF=BD=DA=BA=C6=ABr=18=EF=BF=BDz=EF=BF=BDm= =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=DD=9D=EF=BF=BDX=EF=BF=BDZ=EF=BF=BDL=1E= m=EF=BF=BD=DA=BA=EF=BF=BDn=EF=BF=BD=17=EF=BF=BDb=EF=BF=BD=0B= ..=EF=BF=BD+=EF=BF=BD=07=EF=BF=BDvv=EF=BF=BD
--------------------------------------------------------- = 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 <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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=_E2E84974-BD0D-4BA9-A2ED-075593C9A958-- . 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:

MS Access data conversion (2001) Creating folders and deleting files (1997) can WC render sites out? (1997) FW: writefile and emailer (2002) Forcing a NEWCART (1997) database size? (1997) DataBaseHelper Flawed (1997) [WebDNA] detailed description of what [sendmail] does - repost please (2012) Include Files (1998) using showpage and showcart commands (1996) WebCatalog can't find database (1997) ShowIf variables (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Frames and WebCat (1997) Converting characters to numbers ... (1997) Price + Texte (1999) Webcat no longer supported? (2006) Here we go again... (2006) No Data Results (1997) html delivery (1997)