Can't create TCP/IP socket (10106)

[Yosh]

Hello.

I've created a batch file wich works v good when i run it by myself.
I've add it on the upload event but i always have this message when the php script try to use mysql_connect:
Can't create TCP/IP socket (10106)

I've try to add these lines in my ioftpd.env:
SYSTEMROOT=%[environment(SYSTEMROOT)]
WINDIR=%[environment(WINDIR)]

but always the same thing happends. I don't know what to do.

During my researches I read that this problem exists just after the 5.4 version of ioFTPD.

Where can I find a old version to fix this problem.

Thank for advance.

Yosh

[darkone]

"The requested service provider could not be loaded or initialized. " Perhaps it needs path environment variable defined?

[Yosh]

what can I do ?

[Yosh]

Maybe these lines aren't initialized as they should.
SYSTEMROOT=%[environment(SYSTEMROOT)]
WINDIR=%[environment(WINDIR)]


Is there a solution to put the good values directly ?
......

Or should I find an old version ?

[Mouton]

This is not related to any versions.
Your problem is that those aren't set correctly, so io can't open any outbound tcp connections.

Enable site exec, then try "site exec set",
systemroot and windir needs to be there. If they're not, try again to add them to your ioftpd.env and to restart io until they show in "site exec set".
If they are, check they have the same value as in a command prompt "set".

[Yosh]

I'm sorry, I don't understand what to do ????

I'm sure you're right, but I don't know what am I suppose to do to fix it.....

[Mouton]

Enable site exec:
change your ioftpd.ini to be able to use site exec on your ftp. search on this forum to know how to do this. not sure if the default ioFTPD package comes with it.

Then, use site exec to check your environment variables. site exec allows u to execute anything from ioFTPD as if you would be in a command prompt. In a command prompt, executing "set" shows you the current environment variables. "site exec set" would do the same in ioFTPD. Execute that using the raw command feature of your Ftp client (CTRL-R in FlashFXP, or "quote" in ftp.exe).

[Yosh]

ok, I've enable the exec command.
And the var are set

[R] 200-SYSTEMROOT=C:\WINNT
[R] 200-WINDIR=C:\WINNT


but I still have the ": mysql_connect(): Can't create TCP/IP socket (10106)" error.....


Is there another way to fix it ?

[Mouton]

That's the only known fix.

[Yosh]

I've read that the previous version doesn't have this "bug".
Is it true ?
Where can I find a compatible version ?

[Mouton]

Old versions are available to registered users.
But I don't suggest using anything else than the latest version. Much more problems than solutions.

You could try site exec ping www.google.com to make sure outbound tcp connections are working.

[Yosh]

[R] site exec ping google.fr
[R] 200-'ping' is not recognized as an internal or external command,
[R] 200-operable program or batch file.
[R] 200 Command successful.



??? doesn't work.

I don't want to use some advanced function of ioftpd, I just need the onupload event.
If I'm sure that the functions I want to use works, I'd like to register.

[Mouton]

site exec c:\winnt\system32\ping www.google.fr

Makes me think the problem might be with the active directory in your batch file...
at the top of your .bat file, do this:

c:
cd c:\some.dir

replace c: by the right drive
and some.dir by the dir in which your .bat is located.
this will better reproduce the way you execute the .bat from the command prompt...

you could also try from a command prompt:
cd c:\ioftpd\system
c:\some.dir\your.bat

this will simulate the way ioftpd executes your .bat file.

[Yosh]

I don't understand.

the site exec c:\winnt\system32\ping ip@dress works good, so, there's no problem with tcp .....

But still the same message appears.....

I've created a new bat file at c:\majbdd.bat
Inside, I've only this :
echo "cat2"
cd \
cd c:\program files\easyphp1-7\php\
php -f C:\users\ApacheServerFiles\THC\root\nouvelleiemevi deo.php 2


Here is the log of flashfxp :
Opening BINARY mode data connection for writerstz4.war.
[R] 226-
[R] 226-C:\Program Files\ioftpd\ioFTPD-beta5-8-4u\ioFTPD\system>echo "cat2"
[R] 226-"cat2"
[R] 226-
[R] 226-C:\Program Files\ioftpd\ioFTPD-beta5-8-4u\ioFTPD\system>cd \
[R] 226-
[R] 226-C:\>cd c:\program files\easyphp1-7\php\
[R] 226-
[R] 226-C:\Program Files\EasyPHP1-7\php>php -f C:\users\ApacheServerFiles\THC\root\nouvelleiemevi deo.php 2
[R] 226-<br />
[R] 226-<b>Warning</b>: mysql_connect(): Can't create TCP/IP socket (10106) in <b>C:\users\ApacheServerFiles\THC\root\nouvelleiem evideo.php</b> on line <b>7</b><br />
[R] 226 Transfer complete.




I'm so desesperated, I NEED this, and don't understand why it doesn't work...
someone has an idea to check comething ???

pleeeeeeeease

[Mouton]

Try stuff...
Try to connect to other ports in your php script, to other pc, etc.
Search how other php scripts are run from ioftpd. there's a php zs. see it's documentation to know how it calls php files. you might need a special switch.
etc.