<div class="gmail_extra">Hi Andreas,<br><br><div class="gmail_quote">On Sat, Apr 21, 2012 at 4:11 PM, Andreas Granig <span dir="ltr"><<a href="mailto:agranig@sipwise.com" target="_blank">agranig@sipwise.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<div class="im"><br>
On 04/21/2012 11:31 PM, Skyler wrote:<br>
> Can anyone suggest how I can overcome this now? It is a production box<br>
> in pre-deployment still so I can remove/re-install/restore databases<br>
> etc. but I'd like to avoid wiping/re-install of OS.<br>
<br>
</div>Check with "dpkg -l|grep mysql" if you really have the right versions<br>
installed. Another thing could be that it fails to allocate the innodb<br>
buffer pool size because of too little memory, try lowering<br>
bufferpoolsize in config.yml just to make sure it's (not) that.<br>
<span class="HOEnZb"><br><font color="#888888">
Andreas</font><br>
<br><br></span></blockquote><div><br></div><div> Thank you for the quick reply, very appreciated. Here is what I have:</div><div><br></div><div>root@prod1:~# dpkg -l | grep mysql</div><div>ii kamailio-mysql-modules 3.1.5+sipwise3 MySQL database connectivity module for Kamailio</div>
<div>ii libclass-dbi-mysql-perl 1.00-3 extensions to Class::DBI for MySQL</div><div>ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database</div>
<div>ii libmysql++3 3.0.9-1+b1 MySQL C++ library bindings (runtime)</div><div>hi libmysqlclient16 5.1.57-rel12.8-233.squeeze Percona Server database client library</div>
<div>iU libmysqlclient16-dev 5.1.61-rel13.2-430.squeeze Percona Server database development files</div><div>ii ngcp-templates-ce-mysql 2.4.4 Configuration templates for mysql configuration in NGCP platforms</div>
<div>ii percona-server-common-5.1 5.1.61-rel13.2-430.squeeze Percona Server database common files (e.g. /etc/mysql/my.cnf)</div><div>ii php5-mysql 5.3.3-7+squeeze8 MySQL module for php5</div>
<div>ii rsyslog-mysql 4.6.4-2 MySQL output plugin for rsyslog</div><div> </div><div><div>root@prod1:~# dpkg -l | grep kamailio</div><div>ii kamailio 3.1.5+sipwise3 very fast and configurable SIP proxy</div>
<div>ii kamailio-mysql-modules 3.1.5+sipwise3 MySQL database connectivity module for Kamailio</div><div>ii kamailio-tls-modules 3.1.5+sipwise3 contains the TLS kamailio transport module</div>
<div>ii kamailio-xml-modules 3.1.5+sipwise3 XML based extensions for Kamailio's Management Interface</div><div>ii ngcp-templates-ce-kamailio 2.4.4 Configuration templates for Kamailio configuration in NGCP platforms</div>
</div><div><br></div><div><br></div><div> Is this correct mysql version? The bufferpoolsize is set to 128M, I did have it set to 1024M but lowered it after reading a suggestion via google. </div><div><br></div><div><br></div>
<div> Here is the latest in the log file:</div><div><br></div><div><div>120421 16:38:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql</div><div>120421 16:38:04 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.</div>
<div>120421 16:38:04 [Warning] '--default-collation' is deprecated and will be removed in a future release. Please use '--collation-server' instead.</div><div>120421 16:38:04 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.</div>
<div>120421 16:38:04 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.</div><div>120421 16:38:04 [Note] Flashcache bypass: disabled</div>
<div>120421 16:38:04 [Note] Flashcache setup error is : ioctl failed</div><div><br></div><div>120421 16:38:04 [Note] Plugin 'FEDERATED' is disabled.</div><div>InnoDB: The InnoDB memory heap is disabled</div><div>InnoDB: Mutexes and rw_locks use GCC atomic builtins</div>
<div>InnoDB: Compressed tables use zlib 1.2.3.4</div><div>/usr/sbin/mysqld: Can't create/write to file '/tmp/ibCzWCcB' (Errcode: 13)</div><div>120421 16:38:04 InnoDB: Error: unable to create temporary file; errno: 13</div>
<div>120421 16:38:04 [ERROR] Plugin 'InnoDB' init function returned error.</div><div>120421 16:38:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.</div><div>120421 16:38:04 [Warning] 'user' entry 'root@gvrd01' ignored in --skip-name-resolve mode.</div>
<div>120421 16:38:04 [Warning] 'user' entry 'replicator@sp1' ignored in --skip-name-resolve mode.</div><div>120421 16:38:04 [Warning] 'user' entry 'replicator@sp2' ignored in --skip-name-resolve mode.</div>
<div>120421 16:38:04 [Warning] 'user' entry 'nagios@sp1' ignored in --skip-name-resolve mode.</div><div>120421 16:38:04 [Warning] 'user' entry 'nagios@sp2' ignored in --skip-name-resolve mode.</div>
<div>120421 16:38:04 [Note] Event Scheduler: Loaded 0 events</div><div>120421 16:38:04 [Note] /usr/sbin/mysqld: ready for connections.</div><div>Version: '5.1.61-rel13.2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Percona Server (GPL), 13.2, Revision 430)</div>
</div><div><br></div><div>....And show engines....</div><div><br></div><div><div>mysql> show engines \G</div><div>*************************** 1. row ***************************</div><div> Engine: MRG_MYISAM</div><div>
Support: YES</div><div> Comment: Collection of identical MyISAM tables</div><div>Transactions: NO</div><div> XA: NO</div><div> Savepoints: NO</div><div>*************************** 2. row ***************************</div>
<div> Engine: MyISAM</div><div> Support: DEFAULT</div><div> Comment: Default engine as of MySQL 3.23 with great performance</div><div>Transactions: NO</div><div> XA: NO</div><div> Savepoints: NO</div>
<div>*************************** 3. row ***************************</div><div> Engine: BLACKHOLE</div><div> Support: YES</div><div> Comment: /dev/null storage engine (anything you write to it disappears)</div>
<div>Transactions: NO</div><div> XA: NO</div><div> Savepoints: NO</div><div>*************************** 4. row ***************************</div><div> Engine: CSV</div><div> Support: YES</div><div> Comment: CSV storage engine</div>
<div>Transactions: NO</div><div> XA: NO</div><div> Savepoints: NO</div><div>*************************** 5. row ***************************</div><div> Engine: MEMORY</div><div> Support: YES</div><div> Comment: Hash based, stored in memory, useful for temporary tables</div>
<div>Transactions: NO</div><div> XA: NO</div><div> Savepoints: NO</div><div>*************************** 6. row ***************************</div><div> Engine: FEDERATED</div><div> Support: NO</div><div> Comment: Federated MySQL storage engine</div>
<div>Transactions: NULL</div><div> XA: NULL</div><div> Savepoints: NULL</div><div>*************************** 7. row ***************************</div><div> Engine: ARCHIVE</div><div> Support: YES</div><div>
Comment: Archive storage engine</div><div>Transactions: NO</div><div> XA: NO</div><div> Savepoints: NO</div><div>7 rows in set (0.00 sec)</div></div><div><br></div><div><br></div><div><br></div></div></div>