{"id":448,"date":"2011-05-12T10:38:46","date_gmt":"2011-05-12T08:38:46","guid":{"rendered":""},"modified":"2018-11-01T01:07:13","modified_gmt":"2018-11-01T00:07:13","slug":"opensips-control-panel-installation-debian","status":"publish","type":"post","link":"https:\/\/nil.uniza.sk\/en\/opensips-control-panel-installation-debian\/","title":{"rendered":"OpenSIPs Control Panel installation on Debian"},"content":{"rendered":"<h1><span>Installation OpenSIPs Control Panel on Debian Squeeze 32 bit.<\/span><\/h1>\n<p>&nbsp;<\/p>\n<h2><span>&nbsp;Control pannel <strong>does not work<\/strong> correctly yet&nbsp;!!!<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>Download tarball from http:\/\/opensips-cp.sourceforge.net\/<br \/>\nupack into \/var\/www\/ directory<\/p>\n<p>&nbsp;<\/p>\n<p>Installation of <strong>apache<\/strong> server:<\/p>\n<pre>\r\ninstall apache2\r\napt-get install apache2<\/pre>\n<p>in file \/etc\/apache2\/apache2.conf add<\/p>\n<pre>\r\nAlias \/cp \/var\/www\/opensips-cp\/web<\/pre>\n<p>run next command to make access.log file writeable by apache<\/p>\n<pre>\r\nchown www-data.www-data \/var\/www\/opensips-cp\/config\/access.log<\/pre>\n<p>&nbsp;<\/p>\n<p>Installation of <strong>php<\/strong> support:<\/p>\n<pre>\r\napt-get install php5<\/pre>\n<p>&nbsp;in file \/etc\/php5\/apache2\/php.ini add following lines<\/p>\n<pre>\r\nextension=mysql.so\r\nextension=xmlrpc.so<\/pre>\n<p>next option needs to be set into your \/etc\/php5\/apache2\/php.ini<\/p>\n<pre>\r\nshort_open_tag = On<\/pre>\n<p>&nbsp;<\/p>\n<p>Installation of <strong>php-pear<\/strong> and <strong>MDB2<\/strong> package with driver for mysql<\/p>\n<pre>\r\napt-get install php5-mysql php-pear\r\n\r\npear install MDB2\r\npear install MDB2#mysql\r\npear install log<\/pre>\n<p>For the <strong>admin tool<\/strong> you must add a table ocp_admin_privileges. Run the following script:<\/p>\n<pre>\r\nmysql -D opensips -p &lt; \/var\/www\/opensips-cp\/config\/tools\/admin\/add_admin\/ocp_admin_privileges.mysql<\/pre>\n<p>To create an admin account with the following username and password: admin\/admin<\/p>\n<pre>\r\nmysql -p\r\nuse opensips\r\n\r\nINSERT INTO ocp_admin_privileges (username,password,ha1,available_tools,permissions)\r\nvalues ('admin','admin',md5('admin:admin'),'all','all');\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>For the <strong>cdrviewer tool<\/strong> you must add a table and a stored procedure to the OpenSIPS database:<\/p>\n<pre>\r\nmysql -D opensips -p &lt; \/var\/www\/opensips-cp\/config\/tools\/system\/cdrviewer\/cdrs.mysql\r\n\r\nmysql -D opensips -p &lt; \/var\/www\/opensips-cp\/config\/tools\/system\/cdrviewer\/opensips_cdrs_1_6.mysql<\/pre>\n<p>\nEdit hostname,username,password and database in \/var\/www\/opensips-cp\/cron_job\/generate-cdrs_mysql.sh to correct values<\/p>\n<pre>\r\nHOSTNAME=&quot;localhost&quot;\r\nUSER=&quot;opensips&quot;\r\nPASS=&quot;opensipsrw&quot;\r\nDATABASE=&quot;opensips&quot;\r\n<\/pre>\n<p>edit cron table<\/p>\n<pre>\r\ncrontab -e<\/pre>\n<p>add in it following line for execute this scrip every 3 minutes<\/p>\n<pre>\r\n*\/3 * * * * root \/var\/www\/opensips-cp\/cron_job\/generate-cdrs_mysql.sh<\/pre>\n<p>add into file \/var\/www\/opensips-cp\/config\/globals.php<\/p>\n<pre>\r\n$config-&gt;table_aliases = array(&quot;DBaliases&quot;=&gt;&quot;dbaliases&quot;);\r\n$config-&gt;permissions = array(&quot;read-only&quot;,&quot;read-write&quot;);<\/pre>\n<p>\nin file \/var\/www\/opensips-cp\/config\/db.inc.php edit statements to correct values<\/p>\n<pre>\r\n\/\/database connection password\r\n$config-&gt;db_pass = &quot;student&quot;;<\/pre>\n<p>\nin file \/var\/www\/opensips-cp\/config\/boxes.global.inc.php edit statements to correct values<\/p>\n<p><span><strong><br \/>\n<\/strong><\/span><\/p>\n<p><span><strong>look at<\/strong><\/span><\/p>\n<p>&nbsp;http:\/\/www.openser.org\/pipermail\/users\/2010-March\/011524.html<\/p>\n<p><strong>SHOULD&nbsp;HELP:<\/strong><\/p>\n<pre>\r\n$boxes[$box_id]['mi']['conn']=&quot;\/tmp\/opensips_fifo&quot;;<\/pre>\n<pre>\r\n\/\/ mi host:port pair || fifo_file\r\n$boxes[$box_id]['mi']['conn']=&quot;127.0.0.1:8081&quot;;\r\n\r\n\/\/ monit host:port\r\n$boxes[$box_id]['monit']['conn']=&quot;127.0.0.1:2812&quot;;\r\n$boxes[$box_id]['monit']['user']=&quot;admin&quot;;\r\n$boxes[$box_id]['monit']['pass']=&quot;pass&quot;;\r\n$boxes[$box_id]['monit']['has_ssl']=1;<\/pre>\n<p>&nbsp;<\/p>\n<p>Restart apache server<\/p>\n<pre>\r\n\/etc\/init.d\/apache2 restart<\/pre>\n<p>in your browser try<\/p>\n<pre>\r\nhttp:\/\/your_server_address\/cp\/\r\n<\/pre>\n<p>and login with created login\/password<\/p>\n<p>&nbsp;<\/p>\n<p>Control pannel <strong>does not work<\/strong> correctly yet.<\/p>","protected":false},"excerpt":{"rendered":"<h1><span>Installation OpenSIPs Control Panel on Debian Squeeze 32 bit.<\/span><\/h1>\n<p>&nbsp;<\/p>\n<h2><span>&nbsp;Control pannel <strong>does not work<\/strong> correctly yet&nbsp;!!!<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>Download tarball from http:\/\/opensips-cp.sourceforge.net\/<br \/>\nupack into \/var\/www\/ directory<\/p>\n<p>&nbsp;<\/p>\n<p>Installation of <strong>apache<\/strong> server:<\/p>\n<pre>\r\ninstall apache2\r\napt-get install apache2<\/pre>\n<p>in file \/etc\/apache2\/apache2.conf add<\/p>","protected":false},"author":435,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[787],"tags":[],"class_list":["post-448","post","type-post","status-publish","format-standard","hentry","category-opensips-en"],"taxonomy_info":{"category":[{"value":787,"label":"OpenSIPS"}]},"featured_image_src_large":false,"author_info":{"display_name":"","author_link":"https:\/\/nil.uniza.sk\/en\/author\/"},"comment_info":11,"category_info":[{"term_id":787,"name":"OpenSIPS","slug":"opensips-en","term_group":0,"term_taxonomy_id":785,"taxonomy":"category","description":"","parent":771,"count":2,"filter":"raw","cat_ID":787,"category_count":2,"category_description":"","cat_name":"OpenSIPS","category_nicename":"opensips-en","category_parent":771}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/users\/435"}],"replies":[{"embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/comments?post=448"}],"version-history":[{"count":0,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/448\/revisions"}],"wp:attachment":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/media?parent=448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/categories?post=448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/tags?post=448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}