ejabberd - Comments for "ejabberd_sql:sql_query to another database server" https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server en Thanks for kindness, yes it https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67831 <p>Thanks for kindness, yes it is working for me with an alternative option you advised. i moved <strong>mod_http_upload</strong>, <strong>mod_pubsub</strong> and <strong>mod_mix</strong> to <em>chatserver.com</em></p> Fri, 02 Mar 2018 01:59:12 +0000 dev23 comment 67831 at https://www.ejabberd.im So, ejabberd has two vhosts, https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67830 <p>So, ejabberd has two vhosts, and it will start mod_http_upload for each vhost trying to serve "upload.chatserver.com". When it will start the second module instance, it will complain. Both module instances will attempt to serve the same upload host, and that isn't possible.</p> <p>Try to use this instead:</p> <pre> host: "upload.@HOST@" </pre><p> Alternative: use the option append_host_config: to define that module only in one vhost<br /> <a href="https://docs.ejabberd.im/admin/configuration/#virtual-hosting" title="https://docs.ejabberd.im/admin/configuration/#virtual-hosting">https://docs.ejabberd.im/admin/configuration/#virtual-hosting</a></p> Thu, 01 Mar 2018 18:06:20 +0000 badlop comment 67830 at https://www.ejabberd.im mod_http_upload: host: https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67829 <pre> mod_http_upload: host: "upload.chatserver.com" access: local thumbnail: true docroot: "/var/www/html/upload" put_url: "https://chatserver.com:5443/upload" get_url: "https://chatserver.com/upload" </pre> Wed, 28 Feb 2018 01:45:53 +0000 dev23 comment 67829 at https://www.ejabberd.im Show your mod_http_upload https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67828 <p>Show your mod_http_upload configuration</p> Tue, 27 Feb 2018 15:54:27 +0000 badlop comment 67828 at https://www.ejabberd.im If i defined another host https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67827 <p>If i defined another host then i cannot start the server, encountered this problem :</p> <div class="codeblock"><code>11:32:39.340 [critical] Problem starting the module mod_http_upload for host another.chatserver.com<br />options: [{host,&lt;&lt;&quot;upload.chatserver.com&quot;&gt;&gt;},<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {access,local},<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {thumbnail,true},<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {docroot,&lt;&lt;&quot;/var/www/html/upload&quot;&gt;&gt;},<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {put_url,&lt;&lt;&quot;https://chatserver.com:5443/upload&quot;&gt;&gt;},<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {get_url,&lt;&lt;&quot;https://chatserver.com/upload&quot;&gt;&gt;}]<br /> error: {error,{already_started,&lt;0.558.0&gt;}}<br />[{gen_mod,start_module,3,[{file,&quot;src/gen_mod.erl&quot;},{line,198}]},<br /> {lists,foreach,2,[{file,&quot;lists.erl&quot;},{line,1337}]},<br /> {gen_mod,start_link,0,[{file,&quot;src/gen_mod.erl&quot;},{line,76}]},<br /> {supervisor,do_start_child,2,[{file,&quot;supervisor.erl&quot;},{line,358}]},<br /> {supervisor,start_children,3,[{file,&quot;supervisor.erl&quot;},{line,341}]},<br /> {supervisor,init_children,2,[{file,&quot;supervisor.erl&quot;},{line,307}]},<br /> {gen_server,init_it,6,[{file,&quot;gen_server.erl&quot;},{line,328}]},<br /> {proc_lib,init_p_do_apply,3,[{file,&quot;proc_lib.erl&quot;},{line,240}]}]</code></div> Tue, 27 Feb 2018 04:40:06 +0000 dev23 comment 67827 at https://www.ejabberd.im Well, you can define a new https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67826 <p>Well, you can define a new host in hosts, that you will use only to setup another database in it, and use it in oyur custom code:</p> <pre> hosts: - "chatserver.com" - "another.chatserver.com" </pre> Mon, 26 Feb 2018 16:26:20 +0000 badlop comment 67826 at https://www.ejabberd.im Well, you can define a new https://www.ejabberd.im/forum/29806/ejabberdsqlsqlquery-another-database-server#comment-67825 <p>Well, you can define a new host in hosts, that you will use only to setup another database in it, and use it in oyur custom code:</p> <pre> hosts: - "chatserver.com" - "another.chatserver.com" </pre> Mon, 26 Feb 2018 16:26:19 +0000 badlop comment 67825 at https://www.ejabberd.im