Justin,

Suddenly everything started working again and messages came flowing in, contacted my host and they said that the had restarted the mail server Never mind, I'm just glad I'm seeing some action acton again

Alfred

-----Oorspronkelijk bericht----- Van: Dada Mail (Justin Simoni) [mailto:dada@skazat com] Verzonden: maandag 11 september 2006 3:35 Aan: dadadev@skazat com Onderwerp: [dadadev] Re: MySQL Connections

On Sep 9, 2006, at 2:35 PM, Alfred Vink wrote:

I checked the MySQL database, but couldn't find any empty field

You're probably getting that, "empty field" error, because the DB isn't returning anything ala this error:

Sat Sep 9 10:05:02 2006] dada_bridge pl: DBD::mysql::st execute failed: MySQL server has gone away at

It probably should propagate so far up, ie: give you the, listshortname is empty! error, but it is, at the moment :)

This is strange, since the most recent version of dada_bridge pl should be pretty optimized for SQL I'd say it'd need just one connection in total, but I'd do some profiling, and leave the profiling in so it can be tested by anyone (say, yourself) in the future

I'll also make a test suite for SQL stuff, and the subscription db stuff and oh boy I have things to do :)

-- Justin Simoni

: Dada Mail "Write Once - Distribute Everywhere" Email Communication Software

url: http://mojo skazat com aolim: leaddadaist

On Sep 9, 2006, at 2:35 PM, Alfred Vink wrote:

> >

I swithced the pop server setting to localhost and than it can connect, but when sending manual it seems to work OK, but the messages never show up anywhere although they are removed from the pop box

I have several error messages:

Sat Sep 9 10:05:02 2006] dada_bridge pl: DBD::mysql::st execute failed: MySQL server has gone away at /home/alfsoftc/public_html/cgi-bin/dada/DADA/MailingList/Settings/ baseSQL pm line 157 [Sat Sep 9 10:05:02 2006] dada_bridge pl: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/alfsoftc/public_html/cgi-bin/dada/DADA/MailingList/Settings/ baseSQL pm line 159 [Sat Sep 9 10:05:02 2006] dada_bridge pl: ALFsoft 2 11 alpha 1 warning! List settings sql db empty! List setting DB Possibly corrupted! at /home/alfsoftc/public_html/cgi-bin/dada/DADA/MailingList/Archives/ baseSQL pm line 76 [Sat Sep 9 10:05:02 2006] dada_bridge pl: ALFsoft 2 11 alpha 1 warning! no listshortname saved in list settings sql db! List settings sql DB Possibly corrupted! at /home/alfsoftc/public_html/cgi-bin/dada/DADA/MailingList/Archives/ baseSQL pm line 76

I checked the MySQL database, but couldn't find any empty field

Alfred

-----Oorspronkelijk bericht----- Van: Alfred Vink [mailto:alfred@alfsoft com] Verzonden: zaterdag 9 september 2006 10:25 Aan: dadadev@skazat com Onderwerp: [dadadev] Re: MySQL Connections

Checked the rrorlogs again, apparently it suddenly can't connect to the mailserver anymore to check the inboxes and redistribute the mail I haven't changed anything in the setup

Checking mail through outlook shows several messages Trying the manual function of dadabridge and it tells me it can't connect

Any suggestions ?

Alfred

-----Oorspronkelijk bericht----- Van: Dada Mail (Justin Simoni) [mailto:dada@skazat com] Verzonden: vrijdag 8 september 2006 6:35 Aan: dadadev@skazat com Onderwerp: [dadadev] Re: MySQL Connections

On Sep 7, 2006, at 11:13 AM, Alfred Vink wrote:

Is it easy to revert back to using db or text to see if the problem lies in the MySQL setup ?

No, there's no SQL2Db scripts, moving to SQL is sort of a one way route

If you can, see if your host has an actual limit on the number of connections

-- Justin Simoni

: Dada Mail "Write Once - Distribute Everywhere" Email Communication Software

url: http://mojo skazat com aolim: leaddadaist

On Sep 7, 2006, at 11:13 AM, Alfred Vink wrote:

> >

I'm always using the latest ;-)

Is it easy to revert back to using db or text to see if the problem lies in the MySQL setup ?

Alfred

-----Oorspronkelijk bericht----- Van: Dada Mail (Justin Simoni) [mailto:dada@skazat com] Verzonden: maandag 4 september 2006 1:10 Aan: dadadev@skazat com Onderwerp: [dadadev] Re: MySQL Connections

On Sep 3, 2006, at 7:20 AM, Alfred Vink wrote:

Justin,

Every now and then the dadabridge plugin seems to hang and I get complaints from my Host that there are too many MySQL connections

Hmm, more recent versions of dada_bridge pl have been cleaned up and only require (I think) only about one connection to your database - which is all that should be required Earlier versions would use many SQL connections I would say 3 if not more was normal for the program If you go over the connection limit, I'd say that'd cause a hang If another program is running that uses SQL and they're running at the same time as dada_bridge pl, well, that'll do it Do you remember what version of Dada Mail you're currently using?

-- Justin Simoni

: Dada Mail "Write Once - Distribute Everywhere" Email Communication Software

url: http://mojo skazat com aolim: leaddadaist

On Sep 3, 2006, at 7:20 AM, Alfred Vink wrote:

> >

Justin,

Every now and then the dadabridge plugin seems to hang and I get complaints from my Host that there are too many MySQL connections

Is this a fault in the configuration on my part, a flaw in the script or a bad host ?

Alfred

--

Post: dadadev@skazat com

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive:

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive:

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive:

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive:

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive:

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive: