<div>Hi all:</div><div><br></div><div>I got some errors when using new (require db) module.</div><div>Here are the two errors:</div><div>1. io:read-null-terminated-bytes: internal error: communication problem (unexpected EOF)</div><div>2. parse-packet: internal error: communication problem (expected authentication ok packet)</div><div><br></div><div>The whole thing is like this:</div><div>1. write my code like this:</div><div>(require db)</div><div>(define sql-exp <br> (mysql-connect #:server "my sql server ip"<br> #:port 3306<br> #:database "name"<br> #:user "user"<br> #:password "password"))</div><div><br></div><div>2. when I run this code , I met my problems:</div><div>I have two mysql servers to connect, they are in different ips.</div><div><br></div><div>when use the code to connect 1 , I got Error 1:</div><div>
io:read-null-terminated-bytes: internal error: communication problem (unexpected EOF)
</div><div><br></div><div>Then I tried to connect server 2, I got another error:</div><div>
parse-packet: internal error: communication problem (expected authentication ok packet)
</div><div><br></div><div>3. other tries</div><div>After got the errors, I tried to connect a localhost server,</div><div>Like this :</div><div>(define test <br> (mysql-connect #:server "localhost"<br> #:port 3306<br> #:database "test"<br> #:user "root"))</div><div><br></div><div>It's OK and no error happens.</div><div><br></div><div>Then I tried this in a virtual machine like this </div><div>
<div>(define test <br> (mysql-connect #:server "10.0.2.2"<br> #:port 3306<br> #:database "test"<br> #:user "root"))</div></div><div>It's OK , too.</div><div><br></div><div>Also I tried postgresql, it's OK , too.</div><div><br></div><div>Can you help me to figure out what's wrong when connecting my mysql server ?</div><div>Thanks very much!</div><div><br></div><div>MQ</div>