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

Configure Issues
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=12&t=91
Page 1 of 1

Author:  PDAOnline [ 20 Aug 2004, 07:43 ]
Post subject:  Configure Issues

Mario,

Firstly, Thankyou for taking the time in building your interface. I think is it fantastic. Have loaded and done some testing on program and all works well and easy.

Problem.

Using same Config Specs as OSC Setup however cannot connect to my database. Are any documetns avail on configs.

Thanks

peter@pdaonline.com.au

Author:  airolg [ 20 Aug 2004, 09:43 ]
Post subject:  Me, too!

This seems like it would be a dream to work with and making the adminstration of a store so easy.

I installed it, but I have no idea whether or not I have SSH and where I'd find out or get the config information to supply to make that part work.

I can't connect to mysql so I'm sure it's something I haven't done correctly...

I guess I need a bit more hand-holding...I'm so close.

Author:  Prodigal [ 20 Aug 2004, 11:32 ]
Post subject: 

Yeah, I have the same problems. I have tried my domain name, IP address and variations thereof as a host, but still unable to connect.

In fact, the message I get is "Requested database driver was not found".

Author:  airolg [ 20 Aug 2004, 12:01 ]
Post subject:  Error message

My error message reads:

Error while connecting to database XXXX
SQL Error: Can't connec to MySQL server on XXXX (10061)

To get this error message I used my domain name as the host. Try that and see if you can connect.

Author:  Guest [ 20 Aug 2004, 13:03 ]
Post subject: 

I'm getting that same error message, even though all configuration settings seem to be correct.

Author:  PDAOnline [ 20 Aug 2004, 18:51 ]
Post subject:  Config Issues

We all seem t obe having the exact same problem. Have worked on it all night without any luck. Obviously popular. Has anyone made any progress?

:D

peter@pdaonline.com.au

Author:  keith [ 20 Aug 2004, 19:36 ]
Post subject:  same problem here

i can not connect to my database at all. i think ive tried everything.

Author:  Drako [ 21 Aug 2004, 02:00 ]
Post subject: 

same problem here! I think it's a lak in the software.

The idea is wonderfoul, but no istruction at all is no good.

Anyone have a clue?

Author:  mvaldez [ 21 Aug 2004, 05:24 ]
Post subject:  Most common DB connections problems and solutions.

Hi everybody. I will try to explain the most common problems when connecting to the MySQL database server and how to solve them.

If you are the MySQL admin, note that most checkings can be done from the phpMyAdmin web interface (which may be enabled in your DB server).


What are my database server parameters?
If you installed/configured your own osCommerce server you already have that information.

If you don't remember or are not sure, check the osComerce file catalog/includes/configure.php. Near the end of the file there are the following constants: DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD and DB_DATABASE, which correspond to the following OSCPMWin options (in the Configuration dialog, Database section): Host, Username, Password and Database. The default MySQL port is 3306.

What if the hostname is "localhost"?
The hostname to be entered in the OSCPMWin configuration should be the server name as seen by other computers. Find out what is the name of the host (maybe www.yourstoredomain.xxx?) If in doubt, ask your service provider or server admin.

Also, check that your user is configured to be used both from localhost and from the server name. If in doubt, ask the server admin, or, if you are the admin, check the permission table of MySQL (check the Host field of the user).

What to use as port number?
The port number that you can configure in the OSCPMWin application is usually 3306. If the host name (as configured in osCommerce) includes a ":xxxx number" that is the port number. If there is none, use the default (3306).

If the hostname includes path (like :/tmp/mysql.sock or something) then the osCommerce store is connecte thru a local socket, which cannot be used by the OSCPMWin application. Find out if the DB server can receive connections thru TCP.

How to check if the connectivity of the MySQL server?
Use a telnet application (like the one included with Windows). In the command prompt invoke the command "telnet hostname 3306", where hostname is the name of the MySQL server.

a) If you receive a message like "cannot open a connection to the host at port 3306: connection error" then you cannot establish a link to the DB server. Maybe there is a firewall or simply the MySQL server is configured to not accept TCP connections. If MySQL is using a different port number you would get this same error. Also, this can happens if you are using the wrong hostname.

b) If you receive a message like "P*Host 'yourcomputer' is not allowed to connect to this MySQL server" where "yourcomputer" is the name of your Windows workstation, then MySQL is configured to deny remote connections (or at least, remote connections from your workstation).

c) If you get a message like "4.0.15*******" then your MySQL server can receive TCP connections from your computer.


In case a) you should check with the network admin (maybe that's yourself) if there is something blocking the connection. Check for firewalls (including local firewalls in your computer). Check the connection from within the server itself (if you have access). Check if the server has several names, test using the IP address.

In case b) you need to reconfigure MySQL (or ask the server admin) to allow remote connections from your computer. If you cannot do this, check if you have an SSH account in the server and try with SSH tunneling enabled in the OSCPMWin. (With the SSH tunnel the server sees your connection as local).

In case c) you should be able to connect from the OSCPMWin application. Just a note, even if you are using a 4.0.x MySQL server, select the protocol version 3.23; there is a bug when choosing 4.0 (you would see the message "Requested database driver was not found").



How to check if I have a SSH account?
If you are using a shared hosting service maybe your provider gives you SSH access; check the features of your hosting service or ask them.

If you are using a colocation service then you for sure has several SSH accounts.

If you are using your own servers (or your company's) then you for sure has one or several SSH accounts. If you are not sure (because you are not the admin) ask the server admin to provide you with an SSH account.

If your server admins have any concerns about giving you SSH access to the server, explain them that you will only use it for tunneling your MySQL connection, that the login shell can be changed to a dummy shell so nobody will run remote commands with that account (refer them to this page: http://www.mariovaldez.net/software/sleepshell/).

The version 0.1.0.316 of the OSCPMWin application has a very silly bug when trying to use the SSH tunnel. It was expected that you already has made a tunnel with the puTTY applications, so it would fail if you have never used puTTY with your server. I have uploaded a new version with a "TEST SSH" button in the configuration dialog to let you 1) test your SSH parameters and 2) confirm manually the SSH connection when doing that for the first time.

Note that OSCPMWin depends on PLINK (which is included with OSCPMWin), a puTTY SSH open-source application to create the SSH tunnel to the server. For increased security all puTTY programs ask you the first time you connect to a remote SSH server if you are sure you trust the remote server, and you should type "y". So far I have not automated this step, so use the new "TEST SSH" button in the configuration window (available since version 0.1.0.319).


I receive a message like "Access denied" or something like that.
Your user is not allowed to connect from your workstation. Most MySQL servers are configured by default to allow connection only from the same computer they are running. Remote connections should be enabled in a per-user basis.

The solutions are 2:
1) Ask the server admin to enable your user as remote, or, if you are the server admin, change the Host field of the user permission record to "%" or to the name of your workstation.
2) Use the SSH tunnel. As explained before, the server will see your connection as coming from the same server, allowing you to connect.


What if I cannot use a direct DB connection?
There is no solution for this (today). I'm aware that this is a problem for many users using shared hosting services. I'm working on it.

I'm designing a HTTP interface to do the DB transactions as an alternative to the direct MySQL protocol. But that is not still ready.

Where is the documentation?!
There is none today. I understand your feelings (I'm a software user myself). I will write the docs and hope to release them by December. I cannot stress enough that this is a preview version; think of it as an alpha or beta version. Please bear with me in the mean time.

Originally I expected to release the software until December, but my users were so excited that I couldn't keep it for ourselves any longer.

I will try to help you all in these forums as much as I can. :)


Regards,

Mario A. Valdez-Ramirez.



If you have any questions, comments or suggestions, please post to the forum.

Author:  airolg [ 21 Aug 2004, 07:57 ]
Post subject: 

Very thorough response and you should make that a sticky note.

So, my host does not provide SSH, so does that mean I can't use this software until you are able to provide an http version?

I'm so broken-hearted.

Author:  mvaldez [ 21 Aug 2004, 09:10 ]
Post subject:  No SSH access...

Hi airolg,

> Very thorough response and you
> should make that a sticky note.

Done. Thanks for the suggestion.


> So, my host does not provide SSH,
> so does that mean I can't use this
> software until you are able to provide
> an http version? I'm so broken-hearted.

Yes, until the HTTP version is available. I'm still figuring out and making some tests to see the best way to do this.


Regards,

Mario A. Valdez-Ramirez.

Author:  airolg [ 24 Aug 2004, 17:25 ]
Post subject: 

Should I look for a host that will give me Shell access or wait the HTTP version?

Do you have a timeline? If it's going to be weeks, then I'll just move. This software is so inviting... :D

Author:  mvaldez [ 24 Aug 2004, 19:08 ]
Post subject:  Changing hosting service or waiting...

airlog:

> Should I look for a host that will give me
> Shell access or wait the HTTP version?
> Do you have a timeline? If it's going to
> be weeks, then I'll just move. This software
> is so inviting... Very Happy

Hi. I don't know the answer to your first question. My only recomendation is to play safe (unless you have nothing to lose).

As for the HTTP version, I don't know if it will be faster, slower, more or less prone to connection problems, or corruption, etc. I'm confident it can be done, because other software do it all the time (with SOAP, XMLRPC or raw sockets, for example) and because I have build similar interfaces before. But I'm not sure how long it will take me to build it and debug it.

As for a timeline, I expect and hope to get an experimental HTTP-linked release in a couple of weeks. So, right now, the HTTP interface is on paper only. It's vaporware. :P

I think that if you are happy with your current hosting service, don't change it. Better wait until the HTTP is ready and then, with both options at hand, decide what to do.

At least for me, changing hosting providers has been always a thoughtful decision. (Fortunately most providers have a free-trial period, so you can change your mind the first days).

Regards,

Mario A. Valdez-Ramirez.

Author:  airolg [ 24 Aug 2004, 19:48 ]
Post subject:  What to do, what to do???

Thank you so much for your honest and thoughtful response. Changing hosting service can be a nightmare, so I'll just try my hardest to be patient and wait for the HTTP version.

I'd be so willing to help you test it or whatever you need me to do to get it up and running.

Thanks again for all your hard work and know that your work is appreciated...even by those that can't use it yet. :wink:

Author:  Drako [ 25 Aug 2004, 12:56 ]
Post subject: 

I resolved my problems of connection, the problem was caused by the bugged driver for mysql 4.0

BTW i've so heavy modified my OsCommerce that your (very nice) program won't fit my needs. Thx for your hard work!

Author:  mvaldez [ 25 Aug 2004, 17:51 ]
Post subject:  What kind of modifications?

Drako:

> BTW i've so heavy modified my OsCommerce
> that your (very nice) program won't fit my
> needs. Thx for your hard work!

Hi. What kind of modifications did you do? Were the changes really so extensive? Do the application crash on your store? I'm curious about it.


Regards,

Mario A. Valdez-Ramirez.

Author:  Lighthouse [ 19 Sep 2004, 12:18 ]
Post subject:  add to sticky

Hi Mario,

Can you add the text that you have add to de install prog to the sticky topic or make
a new sticky topic with it.
I have search all text file's but ik can't find what to do with sleepshell and if i am right
the info i am looking for stoud a the end of the install prog.

Lighthouse

Author:  mvaldez [ 19 Sep 2004, 15:55 ]
Post subject:  Server-side setup.

Lighthouse:

> Hi Mario, Can you add the text that you have
> add to de install prog to the sticky topic or make
> a new sticky topic with it. I have search all text
> file's but ik can't find what to do with sleepshell
> and if i am right the info i am looking for stoud
> a the end of the install prog. Lighthouse

Hi. Sorry for the lack of documentation; I'm working on it.

In the mean time, check the following posting about the server-side setup:
http://www.mariovaldez.net/webapps/forums/viewtopic.php?p=434

If you have questions, comments or suggestions, post them to the forum (or send me an email). :)

Regards,

Mario A. Valdez-Ramirez.

Author:  Arthas [ 31 Jan 2005, 09:53 ]
Post subject:  same pb here

I begin by apologising for my english, I'm frensh.
I'm confronted to the exact same pb that semms to have touched most of us.
I read the whole page and think i tried everything...
-The host and portI selected is the good one (I'm quite sure of that, as I had chosen them the same way mvaldez explained).
-I asked the admin and remote connections are opened but I can't connect by telnet (I'll try to translate the error message the better I can, it says : "No connection could be performed because the host refused it")
-I actually can connect via ssh but I did not find a working configuration for ssh tunnelling

So here are my questions :
1) May I have been wrong with the ssh tunneling configuration and then how exactly must I configure it
2) if not do you have any idea on how I can solve my pb (I didn't really hat the thing about buged sql4 drivers was)?[/b]

Author:  mvaldez [ 06 Feb 2005, 08:41 ]
Post subject:  SSH tunnel problem...

Arthas:

> -The host and portI selected is the good one
> (I'm quite sure of that, as I had chosen them
> the same way mvaldez explained).
> -I asked the admin and remote connections
> are opened but I can't connect by telnet (I'll
> try to translate the error message the better
> I can, it says : "No connection could be
> performed because the host refused it")

That message means that there is no answer from the host using the given port. Or MySQL is not listening on that port or the server (not mysql) is refusing you connection.


> -I actually can connect via ssh but I did not find
> a working configuration for ssh tunnelling

If you have a SSH account in the server, then login and try to do the telnet from there. If you can get a connection, then you can use SSH. If you cannot, maybe MySQL is not even listening to TCP sockets.


> So here are my questions : 1) May I have
> been wrong with the ssh tunneling
> configuration and then how exactly must
> I configure it

Lets review the SSH configuration. Open the Configuration window of OSCPMWin, select the Network tab. Check the following settings:
Host: the full domain name of the server.
Port: 3306.
Database: the database name, as used by OSCommerce.
Username: the username for MySQL, as used by OSCommerce.
Password: the password for MySQL, as used by OSCommerce.
Protocol: 3.23 is a safe choice. 4.0 has some problems.
Compress traffic: enable it if you are connecting thru the Internet.
Log SQL queries: disable.
DB timeout: 1000 to 5000, first try with a small value like 1000 (one second) and increase it if you receive lot of disconnections.
DB retries: 3 is safe.

Then select the Network2 tab. Check the following settings:
Use SSH: enable.
SSH username: the username for your SSH account.
SSH password: the password for your SSH account.
Local tunnel port: 3306.
SSH wait time: 1000 to 20000. Start with 10000 (ten seconds), increase it only if the SSH login time is too long.

Then press the "Test Tunnel" button. This step is very important the first time you use the SSH tunnel or after you change the parameters, because the PLink tunnel program will ask you to confirm the identity of the host. (That will be automated in a later release, for now you have to do it manually).

A confirmation dialog will appear, asking if you really want to do the test. Click "Yes". An information dialog will appear showing the test parameters that will be tested. Click "Ok". Now, a console window will appear. If this is the first time you have tested the host, the following message will appear:

Quote:
The server's host key is not cached in the registry. You have no guarantee that the server is the computer you think it is.
The server's rsa2 key fingerprint is: ssh-rsa 1024 94:f8:26:fe:ac:34:3e:a5:93:14:57:26:1e:f6:f9:3b
If you trust this host, enter "y" to add the key to PuTTY's cache and carry on connecting. If you want to carry on connecting just once, without
adding the key to the cache, enter "n". If you do not trust this host, press Return to abandon the connection.
Store key in cache? (y/n)


Press the key "y" and then press the key "Enter". Your SSH session will appear in the console window. If you can get this far, the tunnel will work (however, you still need to do the telnet test from the SSH session to check if MySQL is listening).

After the test, you can logout in the console window to close the tunnel. In the Configuration window of OSCPMWin, click "OK" to save the configuration. Now try to connect. The tunnel will be set automatically.


> 2) if not do you have any idea on how I
> can solve my pb (I didn't really hat the
> thing about buged sql4 drivers was)?

Check your SSH settings and do the telnet test from your SSH session.

Let me know if you have any problem. :)


Regards,

Mario A. Valdez-Ramirez.

Author:  ANTONIS GREECE [ 01 Oct 2005, 14:42 ]
Post subject:  SOME QUESTIONS

Hello Mario.

I receive like others, the message 10061 can't connect to mysql server

I tried other program that use a tunel php file, the oscEditer and it works perfect

So I would like to ask you if in that case mysql accept call from localhost

I like very much your program, I have seen many and my opinion is that is the best, but I dont know what to do in order to configure it
Also I tried with telner this : open xxx.xxx.xxx.xxx port 3306 and I received the message "cannot open xxx.xxx.. in this port

looking froward in hearing from you soon

best regards

Author:  mvaldez [ 10 Oct 2005, 09:55 ]
Post subject:  MySQL connection...

Antonis:

> I receive like others, the message 10061
> can't connect to mysql server I tried other
> program that use a tunel php file, the oscEditer
> and it works perfect So I would like to ask you
> if in that case mysql accept call from localhost

Yes, it means MySQL is listening (at least) to localhost.


> I like very much your program, I have seen
> many and my opinion is that is the best, but

Thanks for the comment. :)


> I dont know what to do in order to configure it
> Also I tried with telner this : open xxx.xxx.xxx.xxx
> port 3306 and I received the message "cannot
> open xxx.xxx.. in this port

Well, it seems MySQL is only listening to localhost.

Do you have SSH access to the server? If so, try to do the telnet test from the DB server. If it fails, then MySQL has TCP connections disabled. Are you the server administrator? If so, check that the option skip-networking is not enabled in the MySQL configuration.

Also read the following posting (as it contains several tips): http://www.mariovaldez.net/webapps/foru ... c.php?t=94


Let me know what you find.


Regards,

Mario A. Valdez-Ramirez.

Author:  Randyn [ 01 Dec 2005, 18:40 ]
Post subject:  connection problems

This is what I get when I try to connect through telnet

telnet xxxxx.com 3306
'
4.0.22%Wof5pVA~y,☻

Connection to host lost.

????? Any Ideas

Author:  mvaldez [ 02 Dec 2005, 01:09 ]
Post subject:  Normal telnet answer...

Randyn:

> This is what I get when I try to connect through telnet
> telnet xxxxx.com 3306
> 4.0.22%Wof5pVA~y,☻
> Connection to host lost.
> ????? Any Ideas

That is the normal answer of your MySQL server. That is good, because it means your MySQL is listening to TCP connections and that you can connect directly to it.

Are you having problems to connect? If so, let us know what is exactly the problem.


Regards,

Mario A. Valdez-Ramirez.

Author:  Randyn [ 02 Dec 2005, 08:36 ]
Post subject:  connection problems

Yes. It says connecting, then loading category list.
Then it locks up (2 computers now) and says "Range check error"
I have to end task to recover

Randy

Author:  mvaldez [ 02 Dec 2005, 18:38 ]
Post subject:  Range check error...

Randy:

> Yes. It says connecting, then loading category list.
> Then it locks up (2 computers now) and says
> "Range check error" I have to end task to recover

Hi again. How many categories do you have? Please tell me if you have more than these:

more than 20 languages,
more than 5000 categories,
more than 5000 manufacturers.


Regards,

Mario A. Valdez-Ramirez.

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