{"id":300,"date":"2017-04-23T22:04:29","date_gmt":"2017-04-23T18:04:29","guid":{"rendered":"https:\/\/bukleev.ru\/?page_id=300"},"modified":"2018-12-14T07:56:25","modified_gmt":"2018-12-14T03:56:25","slug":"%d0%b4%d0%be%d0%b1%d0%b0%d0%b2%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-mysql-%d0%b2-sql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80","status":"publish","type":"page","link":"https:\/\/bukleev.ru\/?page_id=300","title":{"rendered":"\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 Mysql \u0432 SQL \u0441\u0435\u0440\u0432\u0435\u0440"},"content":{"rendered":"<p>\u041d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u00a0<em><strong><a href=\"http:\/\/\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 ODBC Mysql\">ODBC Mysql<\/a><\/strong><\/em><\/p>\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c MySQL \u0441\u0435\u0440\u0432\u0435\u0440 OTRS, \u0432\u043c\u0435\u0441\u0442\u043e<\/p>\n<p>rmtpassword=&#8217;########&#8217; \u0432\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u0440\u0435\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u0430\u0440\u043e\u043b\u044c<\/p>\n<pre>USE [master]\r\nGO\r\n\r\n\/****** Object: LinkedServer [OTRS] ******\/\r\nEXEC master.dbo.sp_addlinkedserver @server = N'OTRS', @srvproduct=N'MySQL', @provider=N'MSDASQL', @datasrc=N'OTRS', @provstr=N'ODBC;DSN=OTRS;', @catalog=N'otrs'\r\n\r\nEXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'OTRS',@useself=N'False',@locallogin=NULL,@rmtuser=N'root',@rmtpassword='########'\r\n\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'collation compatible', @optvalue=N'true'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'data access', @optvalue=N'true'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'dist', @optvalue=N'false'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'pub', @optvalue=N'false'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'rpc', @optvalue=N'true'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'rpc out', @optvalue=N'true'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'sub', @optvalue=N'false'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'connect timeout', @optvalue=N'0'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'collation name', @optvalue=null\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'lazy schema validation', @optvalue=N'false'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'query timeout', @optvalue=N'0'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'use remote collation', @optvalue=N'true'\r\nGO\r\n\r\nEXEC master.dbo.sp_serveroption @server=N'OTRS', @optname=N'remote proc transaction promotion', @optvalue=N'true'\r\nGO<\/pre>\n<p>\u0410\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u044f \u043f\u0440\u0438\u0441\u043e\u0435\u0434\u0438\u043d\u0438\u043b \u0438 \u0431\u0430\u0437\u0443 \u043b\u043e\u0433\u0430 \u0437\u0432\u043e\u043d\u043a\u043e\u0432 \u0438\u0437 Issabel (Elastix 4) c \u0438\u043c\u0435\u043d\u0435\u043c VOIP<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041d\u0430\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u00a0ODBC Mysql \u0414\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c MySQL \u0441\u0435\u0440\u0432\u0435\u0440 OTRS, \u0432\u043c\u0435\u0441\u0442\u043e rmtpassword=&#8217;########&#8217; \u0432\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u0440\u0435\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u0430\u0440\u043e\u043b\u044c USE [master] GO \/****** Object: LinkedServer [OTRS] ******\/ EXEC master.dbo.sp_addlinkedserver @server = N&#8217;OTRS&#8217;, @srvproduct=N&#8217;MySQL&#8217;, @provider=N&#8217;MSDASQL&#8217;, @datasrc=N&#8217;OTRS&#8217;, @provstr=N&#8217;ODBC;DSN=OTRS;&#8217;, @catalog=N&#8217;otrs&#8217; EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N&#8217;OTRS&#8217;,@useself=N&#8217;False&#8217;,@locallogin=NULL,@rmtuser=N&#8217;root&#8217;,@rmtpassword=&#8217;########&#8217; GO EXEC master.dbo.sp_serveroption @server=N&#8217;OTRS&#8217;, @optname=N&#8217;collation compatible&#8217;, @optvalue=N&#8217;true&#8217; GO<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-300","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=300"}],"version-history":[{"count":6,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/300\/revisions"}],"predecessor-version":[{"id":543,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/300\/revisions\/543"}],"wp:attachment":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}