| # |
Dec 13th 2017, 20:19 |
furqan |
yup will do that as well |
| # |
Dec 13th 2017, 20:19 |
hmic |
and try to compare to your environment at home as close as possible... |
| # |
Dec 13th 2017, 20:19 |
furqan |
i woukd most certainly .Thanks a lot again :) :P |
| # |
Dec 13th 2017, 20:19 |
hmic |
come back tomorrow if you need further help |
| # |
Dec 13th 2017, 20:18 |
hmic |
this and dns are the two things to look at from what i have understood now |
| # |
Dec 13th 2017, 20:18 |
furqan |
i just hope ,this one works ,have already exhausted 2 days on it |
| # |
Dec 13th 2017, 20:18 |
furqan |
:)) ,thanks a lot ,u have been of great grreat help |
| # |
Dec 13th 2017, 20:18 |
furqan |
i so so hope that ,it would be the one ...Thats probably the my best bet ,before uninstalling everything and reinstalling.. |
| # |
Dec 13th 2017, 20:18 |
hmic |
:L |
| # |
Dec 13th 2017, 20:17 |
hmic |
i did not want to explain the details at first, but told you to try 127.0.0.1 instead in the very beginning |
| # |
Dec 13th 2017, 20:17 |
hmic |
the localhost vs. 127.0.0.1 "trick" that libmysql does has tricked many before |
| # |
Dec 13th 2017, 20:17 |
furqan |
and if that (proxy) would be a problem, the insert would not work at all, would it? yes u are right it wpoule not at teh first place |
| # |
Dec 13th 2017, 20:16 |
hmic |
still, make sure dns is working and can resolve all the names involved, the local hostname, with and without domain name, localhost, the clients hostname and the http header server name, at least |
| # |
Dec 13th 2017, 20:16 |
furqan |
oooh ,localhost signifies unix sockets ...okay i will use 127.0.0.1 instead..and would try to debug the information ....Unfortunately will have to wait till tommorrow ,as i said tightly coupled office envoirnment... |
| # |
Dec 13th 2017, 20:16 |
hmic |
and if that (proxy) would be a problem, the insert would not work at all, would it? |
| # |
Dec 13th 2017, 20:15 |
hmic |
if you use 127.0.0.1 instead (or any ip address), it will use tcp sockets instead |
| # |
Dec 13th 2017, 20:15 |
hmic |
if you are using "localhost", the mysql lib will be fored to use unix sockets |
| # |
Dec 13th 2017, 20:15 |
furqan |
yes sorry my bad ,its just the insert !! |
| # |
Dec 13th 2017, 20:15 |
hmic |
you can swtich from unix socket to tcp socket |
| # |
Dec 13th 2017, 20:15 |
furqan |
or shall i try communication with unix pipes instead of tcp sockets ! |
| # |
Dec 13th 2017, 20:14 |
hmic |
in the request cycle name resolution plays an even more important role - like i mentioned above |
| # |
Dec 13th 2017, 20:14 |
furqan |
so which makes me suspect ,is there a chance when the cake php orm would be trying to send packets to mysql server over tcp socket ,will it encounter something identical |
| # |
Dec 13th 2017, 20:14 |
hmic |
you have been talking about the insert taking so long, not the full request |
| # |
Dec 13th 2017, 20:13 |
hmic |
why are you talking about a proxy, where do you think it could be involved in the problem you are debugging? |
| # |
Dec 13th 2017, 20:13 |
furqan |
but if i make a curl request to an api running on the localbox through terminal ,teh request goes through the proxy always ,till i do not set the option export no_proxy=localhost,127.0.0.1 ,and then the curl works fine with that api |
| # |
Dec 13th 2017, 20:12 |
hmic |
this is being able to resovle the db server, localhost, the name used in the http header, the actual hostname of the box and so on... |
| # |
Dec 13th 2017, 20:12 |
hmic |
yes, name resolution is a problem, if its not working (correctly) |
| # |
Dec 13th 2017, 20:11 |
furqan |
that woulod be teh first thing i would do ! |
| # |
Dec 13th 2017, 20:11 |
hmic |
there cannot be a proxy involved if you run the db on localhost |
| # |
Dec 13th 2017, 20:11 |
hmic |
check the query log |
| # |
Dec 13th 2017, 20:11 |
furqan |
yes ,i |
| # |
Dec 13th 2017, 20:11 |
hmic |
use the ip address instead of localhost |
| # |
Dec 13th 2017, 20:11 |
furqan |
yes it easy ,n i am really strugelling with that |
| # |
Dec 13th 2017, 20:11 |
hmic |
i've given you the usual suspects |
| # |
Dec 13th 2017, 20:11 |
furqan |
is there a chance it has to do something with proxy !! resolution ... |
| # |
Dec 13th 2017, 20:11 |
hmic |
so its easy to compare the two environments... |
| # |
Dec 13th 2017, 20:10 |
hmic |
good |
| # |
Dec 13th 2017, 20:10 |
furqan |
exactly same data |
| # |
Dec 13th 2017, 20:10 |
hmic |
with the same data? |
| # |
Dec 13th 2017, 20:10 |
hmic |
i'd still prefer dropping a docker container and let them execute it instead :D |
| # |
Dec 13th 2017, 20:10 |
furqan |
i would chek teh query log ,but i dont thing it has to do with centos ,as i told u that i am running the same code base ,on my home box which is a centos vm...n its much much faster |