Re: [MSEide-MSEgui-talk] MySql server gone away
On 12/11/2011 08:56 AM, Martin Schreiber wrote: Please check the server logs. It seems the server crashes while querying the index information. Please don't fix the problem now, I first want to fix the missing error message in MSEide. There is a recursive master detail relationship in your project. Please remove q1.datasource. git master 8d6a361c57b40aea80a8bdd706b25500eadcde5d has a check for recursion. Martin -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
Please check the server logs. It seems the server crashes while querying the index information. Please don't fix the problem now, I first want to fix the missing error message in MSEide. Martin How does it query the index information.. is there a direct api call.. The logs I can check are limited.. it is a shared hosting account. But I will see if I can find any logs. MySQL logs? Server logs for apache? hrm. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
Tested with libmysqlclient.so.18 (MySQL Libraries 5.5.16) to connect MariaDB server 5.1.55 is OK (Linux). -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
Removing q1.datasource seems to fix the problem. Martin In lazarus it warns about recursive use of datasource. i never understood exactly why this possibility exists... I can only think that sometimes one component needs datasource to be set, whereas other times the other one needs datasource to be set. Since lazarus warns about the recursive problem and doesn't let you set it, and since laz still had Gone Away error... sometimes.. but was working other times, I wonder if there is still a problem with my server although at least things are working better now. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
On 12/11/2011 07:58 PM, nore...@z505.com wrote: Removing q1.datasource seems to fix the problem. Martin In lazarus it warns about recursive use of datasource. i never understood exactly why this possibility exists... I can only think that sometimes one component needs datasource to be set, whereas other times the other one needs datasource to be set. You do not understand the purpose of tsqlquery.datasource? It can be set in the detaildataset to a datasource which is connected to the master dataset. If the master dataset scrolls, the values of parameters of the detail dataset with equal names as fields in the master dataset are set to the field values and referesh() of the detail dataset will be called. For MSEgui the use of tfieldparamlink or lookup fields with local indexes is normally better. Martin -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
You do not understand the purpose of tsqlquery.datasource?
I actually haven't done much GUI application programming in my life. I
never used data aware components before in delphi, so it is all new to me.
I always wanted to try them though.
My brain understands procedural programming more, when it comes to
databases..
DBConnect();
if error then writeln('problem here');
DBQuery();
DBClose();
But I understand that abstracting this into GUI components that you drop
onto a form saves time as long as you know how to use them (which, I
don't, but I'm learning).
--
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
___
mseide-msegui-talk mailing list
mseide-msegui-talk@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
Sometimes I get wrong message from git : Please, commit your changes or stash them before you can merge. Aborting What is that? libmysqlclient.so.18 if available. Wahono, please test your application with libmysqlclient.so.18 on Linux. If I have libmysqlclient.so.18 and libmysqlclient.so.16, which oen will be used with tmsemysqlconnection. BTW, I don't use prepare statement and I use MariaDB server, but I use MySQL client to connect to MariaDB. Thanks -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
On 12/09/2011 09:44 PM, nore...@z505.com wrote: What does it mean if a query component Active property stays stuck in false and won't go to true when you click it. When you try to put it to True there is no message stating anything sometimes. Does this mean an uncaught error like a connection problem or some other problem that should be caught and notified? I was hoping it will tell me that something is wrong rather than just staying stuck on active=false. Me too and for me it works like that. There is an error message every time I try setting tmsesqlquery.active to true if the connection fails. Can you send the project in order I can try to reproduce? Martin The project is here: http://z505.com/download/mse/mysqlproj.zip I will have to add your IP address to the allowed remote SQL ip addresses so you can connect to the mysql server I use. Otherwise access will be denied. Can you email me your ip privately? If your IP address changes all the time then I will need to add a wildcard like 132.324.%.% but only if it is changing lots. In this project I open it in MSEIDE and set query (q1) to active, and it says mysql gone away, and it stays as false and doesn't go to true if I try again. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
On 12/11/2011 12:32 AM, nore...@z505.com wrote: The project is here: http://z505.com/download/mse/mysqlproj.zip I will have to add your IP address to the allowed remote SQL ip addresses so you can connect to the mysql server I use. Otherwise access will be denied. Can you email me your ip privately? If your IP address changes all the time then I will need to add a wildcard like 132.324.%.% but only if it is changing lots. In this project I open it in MSEIDE and set query (q1) to active, and it says mysql gone away, and it stays as false and doesn't go to true if I try again. I can connect now and can reproduce the problems. I'll check it. Martin -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
I can connect now and can reproduce the problems. I'll check it. Martin Something is strange, lazarus has similar problems, but I was able to get lazarus working at run time after trying for a while. At design time the component gives the gone away message. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
Suggestion: On Windows copy the correct libmysql.dll to the directory of the MSEide exe and the directory of the test project to be sure that Windows loads the wanted library. Did that before.. and I also put it into windows/system32. In lazarus I got it working temporarily but it is not consistent. I tried mysql_options(conn.handle, MYSQL_OPT_RECONNECT, 'true'); And that seemed to help and get it working, however I am not sure, because I deleted that line now, and it works at run time in laz. For a minute I had it working in lazarus at design time in a dbgrid, now it only works at run time in laz if I set it to active using a button. Intermittent/strange behavior. -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
On 12/11/2011 08:29 AM, nore...@z505.com wrote: I can connect now and can reproduce the problems. I'll check it. Martin Something is strange, lazarus has similar problems, but I was able to get lazarus working at run time after trying for a while. At design time the component gives the gone away message. Please check the server logs. It seems the server crashes while querying the index information. Please don't fix the problem now, I first want to fix the missing error message in MSEide. Martin -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
On 12/09/2011 07:49 PM, nore...@z505.com wrote: When I put the database components on the form as recommended, and then set the active property of the query to true, the mysql server authenticates fine (no password problem) but then it says mysql server gone away. when I try to set active to true again, it just remains as false and won't switch to true. I have to then go into the other component and changed connected to false and then try setting active to true again in other component. Then when I set active to TRUE, it either stays as false or it gives me mysql gone away message. Any idea? AFAIK mysql closes the connection if there is no traffic some time. Maybe there is a connection parameter to influence the behaviour? I don't know MySQL well, possibly Wahono knows more. Please show the exact error message. Martin -- Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
Re: [MSEide-MSEgui-talk] MySql server gone away
How does mse database components figure out whether it is mysql 5.0 or 4.1 or 5.1 that it is connecting to, and how does it pick which dll? I'm also thinking possibly my problem might be due to some dll problem, lazarus says that 6.0.0 dll is installed in my system. I didn't know there was a 6.0.0 mysql dll. Anyway so how would mse database components figure out which database you want to connect to.. 5.0.. 4.1.. In lazarus they offer you the TMySQL50Connection and TMySQL41Connection components and you pick which one. Somehow mse bypasses this requirement and has a general component? -- Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
