Re: on-rev reliability ?
Le 10 juil. 2013 à 04:02, Rick Harrison a écrit : Hi Pierre, Were you able to get phpPgAdmin to work correctly with the new version of PostgreSQL? It keeps throwing permission errors at me when it tries to execute it's SQL code for queries etc. phpPgAdmin works fine against my apps. About the permission sets, i suppose you mean the tables owners rights. While accessing the tables via phpPgAdmin needs to use the main on-rev account owner rights, i have the habit to create and grant dedicated sub owners to my different dbs to restrict securely the way my LC-server handlers interacts with PostgreSQL and in this way all works fine and as expected. So now we have to use WHERE CAST instead of WHERE? Who thought that would be better? A simple and interesting PostgreSQL ascending compatibility glich, at least but, to the end, PostgreSQL stay indeed the rock-solid RDBMS it always went before, AKA 100% trustable/reliable to the end ;-) Of course now I'm on the tio server so I guess my mileage may vary from yours. Just be sure to have an eye on the version number of the PostgreSQL installation running on tio to know if you have to update your LC coding… Best, Pierre Thanks in advance, Rick On Jul 9, 2013, at 6:22 PM, Pierre Sahores s...@sahores-conseil.com wrote: AFAIK, the PostgreSQL version installed on pancake (8.4.13) the one i relied before on Loki (8.1.x) needed me to update some of my revDB calls to get my LC-Server apps OK. Was not a LC problem but a PostgreSQL one. If your LC-Server powered apps don't rely on a PostgreSQL backend, the problem should be elsewhere (MySQL ?) but in case of yes, see below what revDB call update went needed on my side, very simple to the end (all the statements containing a WHERE close have to be updated) : What worked fine before against PostgreSQL 8.1.x : put SELECT * FROM CustArticles WHERE article_chemin = ' tparam2 ' into sqlStatement put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID need to become against PostgreSQL 8.4.13 : put SELECT * FROM CustArticles WHERE CAST(article_chemin as TEXT) = ' tparam2 ' into sqlStatement put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID Same kind of pg syntax update are needed against the DELETE … WHERE and UPDATE … WHERE statements. That said, pancake is against my own LC-Server/PostgreSQL production apps (previously installed on loki) a very trustable and reliable platform with no down time at all (alike this seems to happen, time to time, against some other on-rev servers even if my own apps went running perfectly fine too when they went hosted on loki). widestep Uptime Outages Response time 100.00% 1 462 ms Downtimes FromTo Downtime 2013-06-12 12:13:27 2013-06-12 12:14:27 0h 01m 00s This is a scheduled report from Pingdom. If you wish to no longer receive this report you can unsubscribe by logging in to My Pingdom and update your email report settings. Copyright © 2013 Pingdom AB HTH, -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
on-rev reliability ?
Hi folks, I'm back on this list after a few of years (although I never stopped using LC). I'd like to get opinions and experiences about on-rev... I have been using the service for almost 3 years via 3 different accounts, and have built professional apps websites on LC on-rev, and several companies are using these apps and have built their business around them. Everything worked seamlessly for almost 2 years, but last february march, we started experiencing huge frequent server (thor) crashes and slowdowns, which put us in a terrible situation towards our clients who threatened to sue us because we weren't delivering the service they paid for... Meanwhile, one of our accounts was moved to a new server (pancake) but it appeared that something went wrong during the move, because we experienced random bugs in some scripts that lead to corrupted data in DBs and random errors in automatically generated pdf files (invoices for instance)... To solve this problem, I had to move all scripts, files and DBs to another account of ours still on thor... Last but not least, for the last few days, we had a few server crashes again, and of course our clients yelling at us... Last week-end I also noticed some erratic behavior during ftp transfer that lead to corrupted scripts and huge bugs in web pages... Searching through the list archives I found a few posts mentioning that thor was down again, but nobody seemed to be in a panic business-wise because of that... So finally, here's my question / request : we have the feeling that most of the problems are due to the fact that thor is a shared server and that some other on-rev users are playing dirty games, and we are thinking of moving our accounts to a dedicated server. Before subscribing to on-rev, I had a Revolution engine installed on a dedicated Linux server an experienced crashes or slowdowns only 2 or 3 times a year, not every 2 or 3 days... Does anyone on this list have built rather sophisticated with Livecode on-rev ? If yes, how do you deal with all those server problems ? Thanks in advance for any opinion, and sorry for the long post... jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: on-rev reliability ?
I have not made any sophisticated solutions on on-rev. However, The servers where seldomly down for me. I was on Loki, and during the server move was transferred to tio. I don't think i've had many major downs, altho I am mostly judging it by the availability of email service (am not checking my site regularly). I too have seen a lot of mentions of thor downtimes. It seems to me, that one is a dirty server somehow, at least compared to the ones I was/am on. Said that, if you worry about downtime so much, I am very sure that a single failure shared hosting point like on-rev is not what you want, not even my experience. Neither would of course be dreamhost, networksolutions or other such services. You'd need a dedicated machine (rack space), or a cloud based account like amazon offers. Those do cost money and are harder to set up and also need more work to maintain. On 09.07.2013, at 20:32, j...@souslelogo.com wrote: Hi folks, I'm back on this list after a few of years (although I never stopped using LC). I'd like to get opinions and experiences about on-rev... I have been using the service for almost 3 years via 3 different accounts, and have built professional apps websites on LC on-rev, and several companies are using these apps and have built their business around them. Everything worked seamlessly for almost 2 years, but last february march, we started experiencing huge frequent server (thor) crashes and slowdowns, which put us in a terrible situation towards our clients who threatened to sue us because we weren't delivering the service they paid for... Meanwhile, one of our accounts was moved to a new server (pancake) but it appeared that something went wrong during the move, because we experienced random bugs in some scripts that lead to corrupted data in DBs and random errors in automatically generated pdf files (invoices for instance)... To solve this problem, I had to move all scripts, files and DBs to another account of ours still on thor... Last but not least, for the last few days, we had a few server crashes again, and of course our clients yelling at us... Last week-end I also noticed some erratic behavior during ftp transfer that lead to corrupted scripts and huge bugs in web pages... Searching through the list archives I found a few posts mentioning that thor was down again, but nobody seemed to be in a panic business-wise because of that... So finally, here's my question / request : we have the feeling that most of the problems are due to the fact that thor is a shared server and that some other on-rev users are playing dirty games, and we are thinking of moving our accounts to a dedicated server. Before subscribing to on-rev, I had a Revolution engine installed on a dedicated Linux server an experienced crashes or slowdowns only 2 or 3 times a year, not every 2 or 3 days... Does anyone on this list have built rather sophisticated with Livecode on-rev ? If yes, how do you deal with all those server problems ? Thanks in advance for any opinion, and sorry for the long post... jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode -- Use an alternative Dictionary viewer: http://bjoernke.com/bvgdocu/ Chat with other RunRev developers: http://bjoernke.com/chatrev/ ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: on-rev reliability ?
jbv, Le 9 juil. 2013 à 20:32, j...@souslelogo.com a écrit : Meanwhile, one of our accounts was moved to a new server (pancake) but it appeared that something went wrong during the move, because we experienced random bugs in some scripts that lead to corrupted data in DBs and random errors in automatically generated pdf files (invoices for instance)... To solve this problem, I had to move all scripts, files and DBs to another account of ours still on thor… AFAIK, the PostgreSQL version installed on pancake (8.4.13) the one i relied before on Loki (8.1.x) needed me to update some of my revDB calls to get my LC-Server apps OK. Was not a LC problem but a PostgreSQL one. If your LC-Server powered apps don't rely on a PostgreSQL backend, the problem should be elsewhere (MySQL ?) but in case of yes, see below what revDB call update went needed on my side, very simple to the end (all the statements containing a WHERE close have to be updated) : What worked fine before against PostgreSQL 8.1.x : put SELECT * FROM CustArticles WHERE article_chemin = ' tparam2 ' into sqlStatement put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID need to become against PostgreSQL 8.4.13 : put SELECT * FROM CustArticles WHERE CAST(article_chemin as TEXT) = ' tparam2 ' into sqlStatement put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID Same kind of pg syntax update are needed against the DELETE … WHERE and UPDATE … WHERE statements. That said, pancake is against my own LC-Server/PostgreSQL production apps (previously installed on loki) a very trustable and reliable platform with no down time at all (alike this seems to happen, time to time, against some other on-rev servers even if my own apps went running perfectly fine too when they went hosted on loki). widestep UptimeOutages Response time 100.00% 1 462 ms Downtimes From To Downtime 2013-06-12 12:13:27 2013-06-12 12:14:27 0h 01m 00s This is a scheduled report from Pingdom. If you wish to no longer receive this report you can unsubscribe by logging in to My Pingdom and update your email report settings. Copyright © 2013 Pingdom AB HTH, -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: on-rev reliability ?
I have been on freyr and then recently was moved to pancake. I would say that my experience parallels yours, though, thankfully, not with clients -- just our own company. I don't run programs at all -- just http forms on our website and email for our 30 employees. We have experienced a /lot/ of trouble with email -- which really hurts business. Also, we do radio and tv programs, and let viewers contact us via the web page. We're just a local program so the volume is not huge, but, still, when the web page goes down a couple hours before airtime, it is very stressful. Just yesterday, our email was down again for 2 or 3 hours in the middle of the afternoon. Frankly, I think we're going to have to give up on on-rev, and I've got egg all over my face for having recommended them to the company during the 'founder' campaign Tim Selander Tokyo, Japan On 7/10/13 3:32 AM, j...@souslelogo.com wrote: Hi folks, I'm back on this list after a few of years (although I never stopped using LC). I'd like to get opinions and experiences about on-rev... I have been using the service for almost 3 years via 3 different accounts, and have built professional apps websites on LC on-rev, and several companies are using these apps and have built their business around them. Everything worked seamlessly for almost 2 years, but last february march, we started experiencing huge frequent server (thor) crashes and slowdowns, which put us in a terrible situation towards our clients who threatened to sue us because we weren't delivering the service they paid for... Meanwhile, one of our accounts was moved to a new server (pancake) but it appeared that something went wrong during the move, because we experienced random bugs in some scripts that lead to corrupted data in DBs and random errors in automatically generated pdf files (invoices for instance)... To solve this problem, I had to move all scripts, files and DBs to another account of ours still on thor... Last but not least, for the last few days, we had a few server crashes again, and of course our clients yelling at us... Last week-end I also noticed some erratic behavior during ftp transfer that lead to corrupted scripts and huge bugs in web pages... Searching through the list archives I found a few posts mentioning that thor was down again, but nobody seemed to be in a panic business-wise because of that... So finally, here's my question / request : we have the feeling that most of the problems are due to the fact that thor is a shared server and that some other on-rev users are playing dirty games, and we are thinking of moving our accounts to a dedicated server. Before subscribing to on-rev, I had a Revolution engine installed on a dedicated Linux server an experienced crashes or slowdowns only 2 or 3 times a year, not every 2 or 3 days... Does anyone on this list have built rather sophisticated with Livecode on-rev ? If yes, how do you deal with all those server problems ? Thanks in advance for any opinion, and sorry for the long post... jbv ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: on-rev reliability ?
jbv@... writes: So finally, here's my question / request : we have the feeling that most of the problems are due to the fact that thor is a shared server and that some other on-rev users are playing dirty games, and we are thinking of moving our accounts to a dedicated server. It gets worse - because of the shared servers, the server's ip address and or address block can get blacklisted by spamhaus or other services and then you have to petition them to get back on the air. -- Mark Wieder mwie...@ahsoftware.net ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: on-rev reliability ?
Hi Pierre, Were you able to get phpPgAdmin to work correctly with the new version of PostgreSQL? It keeps throwing permission errors at me when it tries to execute it's SQL code for queries etc. So now we have to use WHERE CAST instead of WHERE? Who thought that would be better? Of course now I'm on the tio server so I guess my mileage may vary from yours. Thanks in advance, Rick On Jul 9, 2013, at 6:22 PM, Pierre Sahores s...@sahores-conseil.com wrote: AFAIK, the PostgreSQL version installed on pancake (8.4.13) the one i relied before on Loki (8.1.x) needed me to update some of my revDB calls to get my LC-Server apps OK. Was not a LC problem but a PostgreSQL one. If your LC-Server powered apps don't rely on a PostgreSQL backend, the problem should be elsewhere (MySQL ?) but in case of yes, see below what revDB call update went needed on my side, very simple to the end (all the statements containing a WHERE close have to be updated) : What worked fine before against PostgreSQL 8.1.x : put SELECT * FROM CustArticles WHERE article_chemin = ' tparam2 ' into sqlStatement put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID need to become against PostgreSQL 8.4.13 : put SELECT * FROM CustArticles WHERE CAST(article_chemin as TEXT) = ' tparam2 ' into sqlStatement put revQueryDatabase(myDatabaseID,sqlStatement) into dbCursorID Same kind of pg syntax update are needed against the DELETE … WHERE and UPDATE … WHERE statements. That said, pancake is against my own LC-Server/PostgreSQL production apps (previously installed on loki) a very trustable and reliable platform with no down time at all (alike this seems to happen, time to time, against some other on-rev servers even if my own apps went running perfectly fine too when they went hosted on loki). widestep Uptime Outages Response time 100.00% 1 462 ms Downtimes From To Downtime 2013-06-12 12:13:27 2013-06-12 12:14:27 0h 01m 00s This is a scheduled report from Pingdom. If you wish to no longer receive this report you can unsubscribe by logging in to My Pingdom and update your email report settings. Copyright © 2013 Pingdom AB HTH, -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: on-rev reliability ?
On 7/9/13 7:22 PM, Mark Wieder wrote: Tim Selander selander@... writes: Just yesterday, our email was down again for 2 or 3 hours in the middle of the afternoon. Yeah, what a pain. And then when it started coming in all the emails were out of sync. Ended up getting some responses before the original questions. That was my fault. Sorry. ;) -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode