mariovaldez.net
http://www.mariovaldez.net/webapps/forums/

connection type without direct MySQL connection
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=15&t=285		 Page 1 of 1
Author:  dabserver [ 25 Feb 2006, 18:16 ]
Post subject:  connection type without direct MySQL connection
for example like in oscEditor (http://osceditor.com/index_en.php) - can we hope on fis feature?
Author:  mvaldez [ 28 Mar 2006, 12:04 ]
Post subject:  Pure HTTP version in beta... testers required...
Hi everybody:

A beta test version is available which uses pure HTTP calls so it does not require a direct MySQL connection. This version should work without the need of a SSH account or a direct MySQL connection (in other words, it should work with any hosting service).

:!: THIS IS A TEST VERSION, NOT READY FOR PRODUCTION USE. :!:

You can find it at:
http://www.mariovaldez.net/software/oscpmwin/files/private_versions/oscpmwin_0.4.1.632_setup.exe


Please, do not use it in any production osCommerce store, use it only on a testing install of osCommerce. This version has not been fully tested.

If you use it, please report back the following:
* Integrity of data (if your data is not lost).
* Network connection reliability (if you get network error or timeouts).
* Connection speed and general performance.

Again, please use it only with a test store, not with your production store(s).
:!: THIS IS A TEST VERSION, NOT READY FOR PRODUCTION USE. :!:


:arrow: If this version works well, the next release of OSCPMWin will use only HTTP calls, not direct MySQL connections. But I need your feedback.


If you have further questions or comments, please post to the forums or email me at mario@mariovaldez.org.

Regards,

Mario A. Valdez-Ramirez.
Author:  Delphi dreamer [ 02 Apr 2006, 06:24 ]
Post subject:  Re: Pure HTTP version in beta... testers required...
What do we need to put on the server ?

What solution did you use Mario ? Im realy intrested.

Is it like the Turbocash.php or do you have a better system ?
Please email me at pvalentijn(at)turbocash.nl
Author:  mvaldez [ 02 Apr 2006, 14:38 ]
Post subject:  What to install for the test version...
Pieter:

> What do we need to put on the server ?

Just update the oscpm1_upload.php script with the one included (which gets stored in the /oscpmwin/serverside/ directory of the Windows install).


> What solution did you use Mario ? Im realy intrested.

I created an ad-hoc protocol, very simple and somehow crude. Queries are sent as POST parameters, Base64 encoded (to preserve special chars). The server-side script pass the SQL string to MySQL, retrieves resulting rows (if it is a SELECT, if it is an INSERT, it returns the ID [id available]), encode each field with Base64, adds field tags, creates a CRC checksum, adds record tags, compress the whole record set with Gzip compression, encode with Base64 and return everything in plain text to the client application.



> Is it like the Turbocash.php or do you
> have a better system ?

I don't know if it is really better, but I think it has the following advantages/disadvantages:


* It won't work with Delphi DB-aware controles.
* It does not require any DB-related VCL code, so it should compile even in Delphi Personal editions.
* It does not require any MIDAS-related code, so it should not have any licensing issues.
* The code is mostly CPU-bound, not bandwidth-bound. The most expensive operations (client-side) are the Gzip decompression and the Base64 decoding. (I need further testing because it may be a memory-related issue).
* Even with the Base64 encoding (which increases the size of the data by 33%) the recordsets are compact, because the Gzip algorithm compresses them pretty well.
* The server-side code is very simple.
* The client-side code is not more complex than what I used before.

I'm sending you this by email, too; because maybe these things are not very interesting for most people.


Regards,

Mario A. Valdez-Ramirez.
Author:  mvaldez [ 04 Apr 2006, 12:48 ]
Post subject:  New beta version (0.4.1.636).
To everybody else testing the beta version:

There is a bug in the 0.4.1.632 version which causes it to display an empty product list. It was a bug in the server-side script. Please upgrade to the 0.4.1.636 version available in:

http://www.mariovaldez.net/software/oscpmwin/files/private_versions/oscpmwin_0.4.1.636_setup.exe


Regards,

Mario A. Valdez-Ramirez.
Author:  bwest [ 06 Oct 2006, 08:25 ]
Post subject:  Empty product list
I'm running with the 636 build, but still do not see any products in the tree.

The 636 serversidescript has been uploaded. Any advice on how I should test my set up?

regards

Ben
Author:  Bwest [ 27 Oct 2006, 05:21 ]
Post subject:  Still no products showing
Hi,
I have tried all versions of the program. I couldn't access the database using earler models because of the password problem so I have tried with the 636 build, but still do not see any products in the tree. :cry:

The 636 serversidescript has been uploaded. Any advice on how I should test my set up?

regards

Ben
Author:  animatco [ 15 Dec 2006, 09:26 ]
Post subject:  oscpmwin v.0.4.1.646 working fine.
Mario,

I have been using oscpmwin v.0.4.1.646 for about 2 months now with no problems. It is the only inventory application that seems to work for me (my host is 1&1) are you still working on updates for the application?

Thank you for making a excellent program.

Steve
Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/