<?xml version="1.0" encoding="koi8-r"?>
<rss version="0.91">
<channel>
    <title>OpenForum RSS: socket with function mysql</title>
    <link>https://opennet.ru/openforum/vsluhforumID9/8403.html</link>
    <description>Доброго времени суток.&lt;br&gt;помогите пожалуйста разобраться с ошибкой.&lt;br&gt;вот код: &lt;br&gt;// тут сокет tcp висит на 80 порту. При запросе клиента server выводет(strout) то что клиет вводит + show tables;из mysql&lt;br&gt;//код компилируется&lt;br&gt;//#gcc -o server $(mysql_config --cflags) server.c $(mysql_config --libs)&lt;br&gt;#include &amp;lt;stdio.h&amp;gt;&lt;br&gt;#include &amp;lt;sys/socket.h&amp;gt;&lt;br&gt;#include &amp;lt;sys/types.h&amp;gt;&lt;br&gt;#include &amp;lt;string.h&amp;gt;&lt;br&gt;#include &amp;lt;sys/un.h&amp;gt;&lt;br&gt;#include &amp;lt;stdlib.h&amp;gt;&lt;br&gt;#include &amp;lt;netinet/in.h&amp;gt;&lt;br&gt;#include &amp;lt;mysql.h&amp;gt;&lt;br&gt;&lt;br&gt;#define QUEUE_LENGTH    10&lt;br&gt;#define BUF_LEN         4096&lt;br&gt;#define SOCK_NAME       &quot;mysocket&quot;&lt;br&gt;#define PORT    80&lt;br&gt;&lt;br&gt;int main (void)&lt;br&gt;&#123;&lt;br&gt;   MYSQL *conn;&lt;br&gt;   MYSQL_RES *res;&lt;br&gt;   MYSQL_ROW row;&lt;br&gt;&lt;br&gt;   char *server = &quot;localhost&quot;;&lt;br&gt;   char *user = &quot;root&quot;;&lt;br&gt;   char *password = &quot;&quot;; /* set me first */&lt;br&gt;   char *database = &quot;dbsend&quot;;&lt;br&gt;&lt;br&gt;   conn = mysql_init(NULL);&lt;br&gt;//      conn = malloc(sizeof(MYSQL));&lt;br&gt;&lt;br&gt;        int sock, client_sock;&lt;br&gt;        char * buf;&lt;br&gt;        char * mes;&lt;br&gt;        int count;&lt;br&gt;        struct sockaddr_in saddr;&lt;br&gt;&lt;br&gt;        sock = soc</description>

<item>
    <title>socket with function mysql (Артур)</title>
    <link>https://opennet.ru/openforum/vsluhforumID9/8403.html#5</link>
    <pubDate>Thu, 19 Nov 2009 01:48:15 GMT</pubDate>
    <description>&amp;gt;Hi, &lt;br&gt;&amp;gt;Thx for your reply, but if i took the second option(move mysql_init() &lt;br&gt;&amp;gt;call into loop.), what should be the parameters of the mysql_init() &lt;br&gt;&amp;gt;function? &lt;br&gt;&lt;br&gt;sorry for late answer,&lt;br&gt;&lt;br&gt;it depends. in the above code, &quot;conn&quot; is dynamically allocated, so: &quot;while (1) &#123; conn = mysql_init(NULL); ... &#125;&quot;, i think.&lt;br&gt;&lt;br&gt;p.s. i&apos;m not familiar with mysql API, here is what it really does http://dev.mysql.com/doc/refman/5.0/en/mysql-init.html&lt;br&gt;</description>
</item>

<item>
    <title>socket with function mysql (souha)</title>
    <link>https://opennet.ru/openforum/vsluhforumID9/8403.html#4</link>
    <pubDate>Wed, 18 Nov 2009 08:59:13 GMT</pubDate>
    <description>&amp;gt;&amp;gt;PS: I do not speak Russian, so kindly i need your reply &lt;br&gt;&amp;gt;&amp;gt;in english. &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;in his answer, primus noted that &quot;conn&quot; is finalized at end of &lt;br&gt;&amp;gt;first iteration, so second iteration (obviously) fails. &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;so, either: &lt;br&gt;&amp;gt;1. don&apos;t mysql_close(conn); &lt;br&gt;&amp;gt;2. move mysql_init() call into loop. (--seems likely correct) &lt;br&gt;&lt;br&gt;Hi,&lt;br&gt;Thx for your reply, but if i took the second option(move mysql_init() call into loop.), what should be the parameters of the mysql_init() function?&lt;br&gt;&lt;br&gt;thank you in advance,&lt;br&gt;souha&lt;br&gt;</description>
</item>

<item>
    <title>socket with function mysql (Артур)</title>
    <link>https://opennet.ru/openforum/vsluhforumID9/8403.html#3</link>
    <pubDate>Tue, 17 Nov 2009 21:46:06 GMT</pubDate>
    <description>&amp;gt;PS: I do not speak Russian, so kindly i need your reply &lt;br&gt;&amp;gt;in english. &lt;br&gt;&lt;br&gt;in his answer, primus noted that &quot;conn&quot; is finalized at end of first iteration, so second iteration (obviously) fails.&lt;br&gt;&lt;br&gt;so, either:&lt;br&gt;1. don&apos;t mysql_close(conn);&lt;br&gt;2. move mysql_init() call into loop. (--seems likely correct)&lt;br&gt;</description>
</item>

<item>
    <title>socket with function mysql (souha)</title>
    <link>https://opennet.ru/openforum/vsluhforumID9/8403.html#2</link>
    <pubDate>Tue, 17 Nov 2009 13:51:43 GMT</pubDate>
    <description>&amp;gt;&#091;оверквотинг удален&#093;&lt;br&gt;&amp;gt;.............. &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;&amp;gt;&#125;&lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;Здесь конец while &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;&amp;gt;проблема в том что после первого конекта все работает, а если повторить &lt;br&gt;&amp;gt;&amp;gt;то пишет большой error://не может второй раз оброботать mysql_real_connect() &lt;br&gt;&amp;gt;&lt;br&gt;&amp;gt;Для mysql_real_connect нужен указатель полученный от mysql_init. &lt;br&gt;&lt;br&gt;Hello,&lt;br&gt;I have the same problem, the application is blocked in the second call to mysql_init and i got the following error:&lt;br&gt;&lt;br&gt;*** glibc detected *** ./test: corrupted double-linked list: 0x08c954e8 ***&lt;br&gt;Aborted&lt;br&gt;&lt;br&gt;looking for your help,&lt;br&gt;thank you in advance,&lt;br&gt;Souha&lt;br&gt;PS: I do not speak Russian, so kindly i need your reply in english.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;</description>
</item>

<item>
    <title>socket with function mysql (primus)</title>
    <link>https://opennet.ru/openforum/vsluhforumID9/8403.html#1</link>
    <pubDate>Thu, 20 Aug 2009 14:21:13 GMT</pubDate>
    <description>&amp;gt;   conn = mysql_init(NULL);&lt;br&gt;&lt;br&gt;Здесь инициализируется conn &lt;br&gt;&amp;gt;        while (1) &#123; &lt;br&gt;&lt;br&gt;.......&lt;br&gt;&amp;gt;         if (!mysql_real_connect(conn, server, &lt;br&gt;&lt;br&gt;Здесь conn используется&lt;br&gt;..........&lt;br&gt;&amp;gt;            &lt;br&gt;&amp;gt;     mysql_close(conn); &lt;br&gt;&lt;br&gt;Здесь освобождается            &lt;br&gt;..............&lt;br&gt;&lt;br&gt;&amp;gt;&#125;&lt;br&gt;&lt;br&gt;Здесь конец while&lt;br&gt; &lt;br&gt;&amp;gt;проблема в том что после первого конекта все работает, а если повторить &lt;br&gt;&amp;gt;то пишет большой error://не может второй раз оброботать mysql_real_connect() &lt;br&gt;&lt;br&gt;Для mysql_real_connect нужен указатель полученный от mysql_init.&lt;br&gt;&lt;br&gt;</description>
</item>

</channel>
</rss>
