[ANN] Eloipool - FAST Python3 pool server software - GBT/stratum/dyntarget/proxy

[ShurikAg]

I am getting this in the logs:

Code:

2014-02-16 23:15:09,278 BitcoinLink DEBUG Received block inv over p2p for 00000000000000002eb4caf6eabc94dbaafb569427b6b0a414aa363dd9ee07dc
eloipool.py: no process found
2014-02-16 23:15:09,471 merkleMaker INFO New block: 00000000000000002eb4caf6eabc94dbaafb569427b6b0a414aa363dd9ee07dc (height: 286323; bits: 19015f53)
2014-02-16 23:15:09,474 JSONRPCServer INFO Nobody to longpoll
2014-02-16 23:15:10,191 JSONRPCServer INFO Nobody to longpoll
eloipool.py: no process found
2014-02-16 23:18:32,053 BitcoinLink DEBUG Received block inv over p2p for 00000000000000004b86d9bc749093ddaa11156fb007a3735125898df92f654a
2014-02-16 23:18:32,215 merkleMaker INFO New block: 00000000000000004b86d9bc749093ddaa11156fb007a3735125898df92f654a (height: 286324; bits: 19015f53)
2014-02-16 23:18:32,216 JSONRPCServer INFO Nobody to longpoll
2014-02-16 23:18:32,828 JSONRPCServer INFO Nobody to longpoll
2014-02-16 23:23:42,376 BitcoinLink DEBUG Received block inv over p2p for 0000000000000001337babf9df90a713cc1abfac2bb63b00b8d336a7b9017e5e
eloipool.py: no process found
2014-02-16 23:23:42,570 merkleMaker INFO New block: 0000000000000001337babf9df90a713cc1abfac2bb63b00b8d336a7b9017e5e (height: 286325; bits: 19015f53)
2014-02-16 23:23:42,573 JSONRPCServer INFO Nobody to longpoll
2014-02-16 23:23:43,220 JSONRPCServer INFO Nobody to longpoll
2014-02-16 23:28:11,354 BitcoinLink DEBUG Received block inv over p2p for 0000000000000000479bceaf71cf63741e9bf2905415d46cdf9c33d09b3aa9ee
eloipool.py: no process found
2014-02-16 23:28:11,548 merkleMaker INFO New block: 0000000000000000479bceaf71cf63741e9bf2905415d46cdf9c33d09b3aa9ee (height: 286326; bits: 19015f53)
2014-02-16 23:28:11,558 JSONRPCServer INFO Nobody to longpoll
2014-02-16 23:28:12,292 JSONRPCServer INFO Nobody to longpoll

Does it mean that there is a block available for the pool? The miner is running, why is it not picking up tje block?

[1713249012]

1713249012

[1713249012]

1713249012

[1713249012]

1713249012

[1713249012]

1713249012

[Luke-Jr]

I am getting a warning in eloipool.log file

Code:

2014-02-16 02:48:08,360 merkleMaker CRITICAL Traceback (most recent call last):
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 692, in run
    self.merkleMaker_I()
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 682, in merkleMaker_I
    self.merkleMaker_II()
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 648, in merkleMaker_II
    return self._updateMerkleTree()
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 548, in _updateMerkleTree
    self._updateMerkleTree_I()
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 512, in _updateMerkleTree_I
    r = self._updateMerkleTree_fromTS(TS)
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 477, in _updateMerkleTree_fromTS
    MP = self._CallGBT(TS)
  File "/opt/eloipool-server/eloipool/merklemaker.py", line 327, in _CallGBT
    MP = access.getblocktemplate(self.GBTReq)
  File "/opt/eloipool-server/eloipool/bitcoinrpc/authproxy.py", line 112, in __call__
    'Content-type': 'application/json'})
  File "/usr/lib/python3.2/http/client.py", line 967, in request
    self._send_request(method, url, body, headers)
  File "/usr/lib/python3.2/http/client.py", line 995, in _send_request
    self.putrequest(method, url, **skips)
  File "/usr/lib/python3.2/http/client.py", line 850, in putrequest
    raise CannotSendRequest(self.__state)
http.client.CannotSendRequest: Request-sent

What is it and how to get read of it?

Thanks,

This seems to be yet another bug in the latest bitcoinrpc.
Eligius runs 22e290b0bcabf6bc88b4d3f5a7d074677e8fe7b9

[greatbotboy]

I am getting this in the logs:

Code:

2014-02-16 23:15:09,278 BitcoinLink DEBUG Received block inv over p2p for 0000000000000002eb4caf6eabc94dbaafb569427b6b0a414aa363dd9ee07dc

Does it mean that there is a block available for the pool? The miner is running, why is it not picking up tje block?

I'm assuming you are referring to this.  This just means there has been a new block found by the network, not your pool. bitcoind is notifying eloipool of the new block.

[ShurikAg]

I am getting this in the logs:

Code:

2014-02-16 23:15:09,278 BitcoinLink DEBUG Received block inv over p2p for 0000000000000002eb4caf6eabc94dbaafb569427b6b0a414aa363dd9ee07dc

Does it mean that there is a block available for the pool? The miner is running, why is it not picking up tje block?

I'm assuming you are referring to this.  This just means there has been a new block found by the network, not your pool. bitcoind is notifying eloipool of the new block.

Understood, thanks

[valsha]

Your miner is configured to use scrypt, which is used by litecoin and various other crypotcoins.  eloi does NOT support scrypt...

Hi, is this patch helps me to support scrypt https://gitorious.org/bitcoin/luke-jr-bitcoin/source/8f3f29550c2ad33f5635799ba835276eaebb4a2e:contrib/merged-mine-proxy ??

eloipool only supports sha256, basically only bitcoin is supported.

all cryptocurrency sha256 is supported ? or ONLY bitcoin ??
Thank you.

[agibby5]

eloipool only supports sha256, basically only bitcoin is supported.

all cryptocurrency sha256 is supported ? or ONLY bitcoin ??
Thank you.

alt sha256s work well too. you need to change the UpstreamNetworkId in the config though to match the alt.

Code:

# Network ID for the primary blockchain
# Other known network IDs can be found at:
#     https://en.bitcoin.it/wiki/Protocol_specification#Message_structure
UpstreamNetworkId = b'\x0b\x11\x09\x07'  # testnet3

[valsha]

eloipool only supports sha256, basically only bitcoin is supported.

all cryptocurrency sha256 is supported ? or ONLY bitcoin ??
Thank you.

alt sha256s work well too. you need to change the UpstreamNetworkId in the config though to match the alt.

Code:

# Network ID for the primary blockchain
# Other known network IDs can be found at:
#     https://en.bitcoin.it/wiki/Protocol_specification#Message_structure
UpstreamNetworkId = b'\x0b\x11\x09\x07'  # testnet3

Thank you.
Let say i need to run bitcoin and continuum, all sha256 based.
I need to run 2 separate copies Eloipool?

[agibby5]

eloipool only supports sha256, basically only bitcoin is supported.

all cryptocurrency sha256 is supported ? or ONLY bitcoin ??
Thank you.

alt sha256s work well too. you need to change the UpstreamNetworkId in the config though to match the alt.

Code:

# Network ID for the primary blockchain
# Other known network IDs can be found at:
#     https://en.bitcoin.it/wiki/Protocol_specification#Message_structure
UpstreamNetworkId = b'\x0b\x11\x09\x07'  # testnet3

Thank you.
Let say i need to run bitcoin and continuum, all sha256 based.
I need to run 2 separate copies Eloipool?

https://bitcointalk.org/index.php?topic=61731.msg3807307#msg3807307

[mydjuu]

I installed Eloipool and all its required dependencies. I tried eloipool on two different machines with the same problem. I get two errors.

The first error is when bfgminer connects over straturm on port 3334:

Code:

2014-02-19 16:43:02,707 StratumServer ERROR Traceback (most recent call last):
  File "/home/xxx/eloipool-server-master/eloipool/networkserver.py", line 392, in serve_forever
    f()
  File "/home/xxx/eloipool-server-master/eloipool/stratumserver.py", line 135, in sendJob
    self.push(self.server.JobBytes)
AttributeError: 'StratumServer' object has no attribute 'JobBytes'

The second type of error that appears whenever I Start the server and floods my screen repetitively is

Code:

2014-02-19 16:51:50,480 merkleMaker CRITICAL Traceback (most recent call last):
  File "/home/xxx/eloipool-server-master/eloipool/merklemaker.py", line 692, in run
    self.merkleMaker_I()
  File "/home/xxx/eloipool-server-master/eloipool/merklemaker.py", line 682, in merkleMaker_I
    self.merkleMaker_II()
  File "/home/xxx/eloipool-server-master/eloipool/merklemaker.py", line 648, in merkleMaker_II
    return self._updateMerkleTree()
  File "/home/xxx/eloipool-server-master/eloipool/merklemaker.py", line 553, in _updateMerkleTree
    if self.needMerkle == 2:
AttributeError: 'merkleMaker' object has no attribute 'needMerkle'

I have been trying to fix this problem for two days before I come here and appreciate any help!

[greatbotboy]

Is the TrackerAddr a valid Bitcoin address.
Do 25 BTC of a solved block go on that address?

Yes, put your BTC address in there.

[whitehathacker]

Greetings! New poster, solved MOST problems. The only problems I have now are:

Code:

2014-02-26 20:43:30,962 StratumHandler  DEBUG   Traceback (most recent call last):
  File "/var/www/eloipool/networkserver.py", line 47, in handle_read
    data = self.recv (self.ac_in_buffer_size)
  File "/usr/lib/python3.2/asyncore.py", line 384, in recv
    data = self.socket.recv(buffer_size)
socket.error: [Errno 110] Connection timed out

and

Code:

2014-02-26 20:43:30,962 StratumHandler  DEBUG   Traceback (most recent call last                                                                                        ):
  File "/var/www/eloipool/networkserver.py", line 47, in handle_read
    data = self.recv (self.ac_in_buffer_size)
  File "/usr/lib/python3.2/asyncore.py", line 384, in recv
    data = self.socket.recv(buffer_size)
socket.error: [Errno 110] Connection timed out

    bcnode.newBlock = lambda blkhash: MM.updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 561, in updateMerkleTree
    self._updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 549, in _updateMerkleTree
    self._updateMerkleTree_I()
  File "/var/www/eloipool/merklemaker.py", line 513, in _updateMerkleTree_I
    r = self._updateMerkleTree_fromTS(TS)
  File "/var/www/eloipool/merklemaker.py", line 478, in _updateMerkleTree_fromTS
    MP = self._CallGBT(TS)
  File "/var/www/eloipool/merklemaker.py", line 328, in _CallGBT
    MP = access.getblocktemplate(self.GBTReq)
  File "/var/www/eloipool/python-bitcoinrpc/bitcoinrpc/authproxy.py", line 112, in __call__
    'Content-type': 'application/json'})
  File "/usr/lib/python3.2/http/client.py", line 967, in request
    self._send_request(method, url, body, headers)
  File "/usr/lib/python3.2/http/client.py", line 995, in _send_request
    self.putrequest(method, url, **skips)
  File "/usr/lib/python3.2/http/client.py", line 850, in putrequest
    raise CannotSendRequest(self.__state)
http.client.CannotSendRequest: Request-sent

I've solved some of the issues I had already with this thread (thank you very much guys).

Once I get this sucker running without errors I plan on helping out (if thats alright with you luke-jr) by documenting the whole process thoroughly. Also eventually working on a basic frontend.

~WHH

[greatbotboy]

Code:

2014-02-26 20:43:30,962 StratumHandler  DEBUG   Traceback (most recent call last                                                                                        ):
  File "/var/www/eloipool/networkserver.py", line 47, in handle_read
    data = self.recv (self.ac_in_buffer_size)
  File "/usr/lib/python3.2/asyncore.py", line 384, in recv
    data = self.socket.recv(buffer_size)
socket.error: [Errno 110] Connection timed out

    bcnode.newBlock = lambda blkhash: MM.updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 561, in updateMerkleTree
    self._updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 549, in _updateMerkleTree
    self._updateMerkleTree_I()
  File "/var/www/eloipool/merklemaker.py", line 513, in _updateMerkleTree_I
    r = self._updateMerkleTree_fromTS(TS)
  File "/var/www/eloipool/merklemaker.py", line 478, in _updateMerkleTree_fromTS
    MP = self._CallGBT(TS)
  File "/var/www/eloipool/merklemaker.py", line 328, in _CallGBT
    MP = access.getblocktemplate(self.GBTReq)
  File "/var/www/eloipool/python-bitcoinrpc/bitcoinrpc/authproxy.py", line 112, in __call__
    'Content-type': 'application/json'})
  File "/usr/lib/python3.2/http/client.py", line 967, in request
    self._send_request(method, url, body, headers)
  File "/usr/lib/python3.2/http/client.py", line 995, in _send_request
    self.putrequest(method, url, **skips)
  File "/usr/lib/python3.2/http/client.py", line 850, in putrequest
    raise CannotSendRequest(self.__state)
http.client.CannotSendRequest: Request-sent

Luke-Jr seems to think this is a problem with the bitcoind rpc.  I see this error when bitcoin isn't up to date or still starting.  the first error I've not seen before.

[whitehathacker]

Code:

2014-02-26 20:43:30,962 StratumHandler  DEBUG   Traceback (most recent call last                                                                                        ):
  File "/var/www/eloipool/networkserver.py", line 47, in handle_read
    data = self.recv (self.ac_in_buffer_size)
  File "/usr/lib/python3.2/asyncore.py", line 384, in recv
    data = self.socket.recv(buffer_size)
socket.error: [Errno 110] Connection timed out

    bcnode.newBlock = lambda blkhash: MM.updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 561, in updateMerkleTree
    self._updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 549, in _updateMerkleTree
    self._updateMerkleTree_I()
  File "/var/www/eloipool/merklemaker.py", line 513, in _updateMerkleTree_I
    r = self._updateMerkleTree_fromTS(TS)
  File "/var/www/eloipool/merklemaker.py", line 478, in _updateMerkleTree_fromTS
    MP = self._CallGBT(TS)
  File "/var/www/eloipool/merklemaker.py", line 328, in _CallGBT
    MP = access.getblocktemplate(self.GBTReq)
  File "/var/www/eloipool/python-bitcoinrpc/bitcoinrpc/authproxy.py", line 112, in __call__
    'Content-type': 'application/json'})
  File "/usr/lib/python3.2/http/client.py", line 967, in request
    self._send_request(method, url, body, headers)
  File "/usr/lib/python3.2/http/client.py", line 995, in _send_request
    self.putrequest(method, url, **skips)
  File "/usr/lib/python3.2/http/client.py", line 850, in putrequest
    raise CannotSendRequest(self.__state)
http.client.CannotSendRequest: Request-sent

Luke-Jr seems to think this is a problem with the bitcoind rpc.  I see this error when bitcoin isn't up to date or still starting.  the first error I've not seen before.

So is there a specific build of the bitcoind rpc that works works?

[greatbotboy]

Code:

2014-02-26 20:43:30,962 StratumHandler  DEBUG   Traceback (most recent call last                                                                                        ):
  File "/var/www/eloipool/networkserver.py", line 47, in handle_read
    data = self.recv (self.ac_in_buffer_size)
  File "/usr/lib/python3.2/asyncore.py", line 384, in recv
    data = self.socket.recv(buffer_size)
socket.error: [Errno 110] Connection timed out

    bcnode.newBlock = lambda blkhash: MM.updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 561, in updateMerkleTree
    self._updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 549, in _updateMerkleTree
    self._updateMerkleTree_I()
  File "/var/www/eloipool/merklemaker.py", line 513, in _updateMerkleTree_I
    r = self._updateMerkleTree_fromTS(TS)
  File "/var/www/eloipool/merklemaker.py", line 478, in _updateMerkleTree_fromTS
    MP = self._CallGBT(TS)
  File "/var/www/eloipool/merklemaker.py", line 328, in _CallGBT
    MP = access.getblocktemplate(self.GBTReq)
  File "/var/www/eloipool/python-bitcoinrpc/bitcoinrpc/authproxy.py", line 112, in __call__
    'Content-type': 'application/json'})
  File "/usr/lib/python3.2/http/client.py", line 967, in request
    self._send_request(method, url, body, headers)
  File "/usr/lib/python3.2/http/client.py", line 995, in _send_request
    self.putrequest(method, url, **skips)
  File "/usr/lib/python3.2/http/client.py", line 850, in putrequest
    raise CannotSendRequest(self.__state)
http.client.CannotSendRequest: Request-sent

Luke-Jr seems to think this is a problem with the bitcoind rpc.  I see this error when bitcoin isn't up to date or still starting.  the first error I've not seen before.

So is there a specific build of the bitcoind rpc that works works?

I use this PPA, for my ubuntu box. It doesn't produce any errors for me.

[whitehathacker]

Code:

2014-02-26 20:43:30,962 StratumHandler  DEBUG   Traceback (most recent call last                                                                                        ):
  File "/var/www/eloipool/networkserver.py", line 47, in handle_read
    data = self.recv (self.ac_in_buffer_size)
  File "/usr/lib/python3.2/asyncore.py", line 384, in recv
    data = self.socket.recv(buffer_size)
socket.error: [Errno 110] Connection timed out

    bcnode.newBlock = lambda blkhash: MM.updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 561, in updateMerkleTree
    self._updateMerkleTree()
  File "/var/www/eloipool/merklemaker.py", line 549, in _updateMerkleTree
    self._updateMerkleTree_I()
  File "/var/www/eloipool/merklemaker.py", line 513, in _updateMerkleTree_I
    r = self._updateMerkleTree_fromTS(TS)
  File "/var/www/eloipool/merklemaker.py", line 478, in _updateMerkleTree_fromTS
    MP = self._CallGBT(TS)
  File "/var/www/eloipool/merklemaker.py", line 328, in _CallGBT
    MP = access.getblocktemplate(self.GBTReq)
  File "/var/www/eloipool/python-bitcoinrpc/bitcoinrpc/authproxy.py", line 112, in __call__
    'Content-type': 'application/json'})
  File "/usr/lib/python3.2/http/client.py", line 967, in request
    self._send_request(method, url, body, headers)
  File "/usr/lib/python3.2/http/client.py", line 995, in _send_request
    self.putrequest(method, url, **skips)
  File "/usr/lib/python3.2/http/client.py", line 850, in putrequest
    raise CannotSendRequest(self.__state)
http.client.CannotSendRequest: Request-sent

Luke-Jr seems to think this is a problem with the bitcoind rpc.  I see this error when bitcoin isn't up to date or still starting.  the first error I've not seen before.

So is there a specific build of the bitcoind rpc that works works?

I use this PPA, for my ubuntu box. It doesn't produce any errors for me.

Interesting, I just checked my repo and I'm using the same one you are (Also ubuntu user)

[greatbotboy]

Weird.. Other than a couple extra signals, for restarting and stopping, my eloipool is unmolested.

Code:

2014-02-27 10:44:50,958 BitcoinLink DEBUG Received block inv over p2p for 0000000000000000fff2604f9110d1af25e302ae2c3bdd8fe4be10dc37c788ac
2014-02-27 10:44:51,046 newBlockNotification INFO Received new block notification
2014-02-27 10:44:51,734 merkleMaker INFO New block: 0000000000000000fff2604f9110d1af25e302ae2c3bdd8fe4be10dc37c788ac (height: 288136; bits: 19015f53)
2014-02-27 10:44:51,827 JSONRPCServer INFO Longpoll woke up 5 clients in 0.005 seconds
2014-02-27 10:44:52,846 JSONRPCServer INFO Waiting 3.98 seconds to longpoll
2014-02-27 10:44:56,920 JSONRPCServer INFO Longpoll woke up 5 clients in 0.092 seconds

and my debug logs only show errors when I have restarted the server.

[whitehathacker]

Weird.. Other than a couple extra signals, for restarting and stopping, my eloipool is unmolested.

Code:

2014-02-27 10:44:50,958 BitcoinLink DEBUG Received block inv over p2p for 0000000000000000fff2604f9110d1af25e302ae2c3bdd8fe4be10dc37c788ac
2014-02-27 10:44:51,046 newBlockNotification INFO Received new block notification
2014-02-27 10:44:51,734 merkleMaker INFO New block: 0000000000000000fff2604f9110d1af25e302ae2c3bdd8fe4be10dc37c788ac (height: 288136; bits: 19015f53)
2014-02-27 10:44:51,827 JSONRPCServer INFO Longpoll woke up 5 clients in 0.005 seconds
2014-02-27 10:44:52,846 JSONRPCServer INFO Waiting 3.98 seconds to longpoll
2014-02-27 10:44:56,920 JSONRPCServer INFO Longpoll woke up 5 clients in 0.092 seconds

and my debug logs only show errors when I have restarted the server.

So do you just get the new block notifications and the standard longpools in your logfile?

[greatbotboy]

Yup.  Nothing out of the ordinary. Unless as I've said before I have just restarted my server.

[whitehathacker]

Well, I did a reinstall and currently the only error I'm getting has to do with PyMySql (for share logging).

Code:

2014-02-27 15:20:29,964 sharelogging.sql        CRITICAL        Error inserting data: ('insert into shares (rem_host, username, our_result, upstream_result, reason, solution) values (%s, %s, %s, %s, %s, unhex(%s))', ('::ffff:2.50.70.154', '1Nnb5S3z8kPMiiej9fUnvRqHorwb5C5mzq', 'Y', None, None, '000000020fb44678de6c8516585ffd8178369745cca945fea47b2c870000000000000000f418f5e1a6e38a2291e92c237ce1b97a44fd7f0864b795c58a34e976bd5edadd530fc83319015f5339bd0823'))Traceback (most recent call last):
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/cursors.py", line 112, in execute
    result = self._query(query)
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/cursors.py", line 230, in _query
    conn.query(q)
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 607, in query
    self._affected_rows = self._read_query_result()
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 691, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 873, in read
    self._read_ok_packet()
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 880, in _read_ok_packet
    self.insert_id = self.first_packet.read_length_coded_binary()
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 292, in read_length_coded_binary
    return unpack_int24(self.read(UNSIGNED_INT24_LENGTH))
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 161, in unpack_int24
    return struct.unpack('B',n[0])[0] + (struct.unpack('B', n[1])[0] << 8) +\
TypeError: 'int' does not support the buffer interface

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/www/eloipool/sharelogging/sql.py", line 53, in _doInsert
    dbc.execute(stmt, params)
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/cursors.py", line 117, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python3.2/dist-packages/PyMySQL3-0.5-py3.2.egg/pymysql/connections.py", line 187, in defaulterrorhandler
    raise Error(errorclass, errorvalue)
pymysql.err.Error: (<class 'TypeError'>, TypeError("'int' does not support the buffer interface",))

This is interesting because I havent changed any of it.

[greatbotboy]

This is a known bug in pymysql. You have to modify pymysql, I can't remember exactly what line or file but I remember finding the solution in a google group somewhere.  I found it with a little googling.