Python: Send data to one client from database

Question

I have a python script that receives tcp data from client and I want to send a response to a specific client (I handle more than 500). This command comes from a mysql database and I handle the clientsocket by a dictionary, but the script is down when it receives a lot of connections.

How can I store the clientsocket in mysql database, or which is the best way to handle the clientsocket?

My code is:

import thread
from socket import *

def sendCommand():
    try:
        for clientsocket,id_client in conn_dict.iteritems():
            if id_cliente == "TEST_from_mysql_db":
                clientsocket.send("ACK SEND")
                break
    except:
        print "NO"

def handler(clientsocket, clientaddr):
    print "Accepted connection from: ", clientaddr
    while 1:
        data = clientsocket.recv(buf)
        if not data:
            break
        else:
            conn_dict[clientsocket] = id_client
            sendCommand()
    clientsocket.close()

if __name__ == "__main__":

    conn_dict = dict()
    host = str("XXX.XXX.XXX.XXX")
    port = XXX
    buf = 1024

    addr = (host, port)
    serversocket = socket(AF_INET, SOCK_STREAM)
    serversocket.setsockopt(SOL_SOCKET, SO_REUSEADDR, 1)
    serversocket.bind(addr)
    serversocket.listen(2)

    while 1:
        print "Server is listening for connections\n"
        clientsocket, clientaddr = serversocket.accept()
        thread.start_new_thread(handler, (clientsocket, clientaddr))
    serversocket.close()

Why not use ordinal strategy to handle many connection not create new thread, use select — fghj, Oct 30 '15 at 20:35
The size of the queue where the pending connections are queued is only 2 which is allocated using the listen function. If your queue is full and a new connection comes, the client receives an ECONNREFUSED error code — ffff, Oct 30 '15 at 20:39
@user1034749 can you give an example to handle the id_client and clientsocket please? — user5508525, Oct 30 '15 at 20:43
See answer here: http://stackoverflow.com/questions/5308080/python-socket-accept-nonblocking — fghj, Oct 30 '15 at 20:44
@FaizPinkman so what do you recommend me? The maximum value es 128? — user5508525, Oct 30 '15 at 20:46
@user5508525 have a look at this http://stackoverflow.com/questions/114874/socket-listen-backlog-parameter-how-to-determine-this-value — ffff, Oct 31 '15 at 06:30
@user1034749 thanks, but how i link the device (i have the imei) with client socket? — user5508525, Nov 10 '15 at 21:22

Python: Send data to one client from database

0 Answers0