[Spce-user] Problems with mediator: database field

Thomas Odorfer thomas.odorfer at comjoo.com
Mon Mar 17 10:41:01 EDT 2014


Hi,

I tried to restart mediator unsuccessfully – I receive the following error (mediator was not running at all for a long time as it is a test system):

cdr.log

Mar 17 14:00:24 mediator[17490]: Unlocking mediator.

Mar 17 14:02:51 mediator[18393]: Locking process.

Mar 17 14:02:51 mediator[18393]: Daemonizing process.

Mar 17 14:02:51 mediator[18394]: Writing pid file.

Mar 17 14:02:51 mediator[18394]: ACC acc database host='localhost', port='3306', user='kamailio', name='kamailio'

Mar 17 14:02:51 mediator[18394]: CDR acc database host='localhost', port='3306', user='mediator', name='accounting'

Mar 17 14:02:51 mediator[18394]: Setting up mysql connections.

Mar 17 14:02:51 mediator[18394]: Up and running, daemonized=1, pid-path='/var/run/mediator.pid', interval=10

Mar 17 14:02:51 mediator[18394]: Call-Id '0502007f60ffa73b5cf9c68726b8407b at sipwise.local' has no separated source user id, '0'

…

Mar 17 14:02:51 mediator[18394]: Call-Id '7d4cf9702e0efdf84f114754170b34b1 at sipwise.local' has no separated source user id, '0'

Mar 17 14:02:53 mediator[18394]: Error executing query: Unknown column 'time_hires' in 'field list'

Mar 17 14:02:53 mediator[18394]: Shutting down.

Mar 17 14:02:53 mediator[18394]: Successfully shut down.

Mar 17 14:02:53 mediator[18394]: Unlocking mediator.

Database „accounting“: Table acc (empty table)

mysql> describe acc;

+------------+------------------+------+-----+---------+----------------+

| Field      | Type             | Null | Key | Default | Extra          |

+------------+------------------+------+-----+---------+----------------+

| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |

| method     | varchar(16)      | NO   |     |         |                |

| from_tag   | varchar(64)      | NO   |     |         |                |

| to_tag     | varchar(64)      | NO   |     |         |                |

| callid     | varchar(255)     | NO   | MUL |         |                |

| sip_code   | varchar(3)       | NO   |     |         |                |

| sip_reason | varchar(128)     | NO   |     |         |                |

| time       | datetime         | NO   |     | NULL    |                |

| time_hires | decimal(13,3)    | NO   |     | NULL    |                |

| src_leg    | varchar(2048)    | YES  |     | NULL    |                |

| dst_leg    | varchar(2048)    | YES  |     | NULL    |                |

| dst_user   | varchar(64)      | NO   |     |         |                |

| dst_ouser  | varchar(64)      | NO   |     |         |                |

| dst_domain | varchar(128)     | NO   |     |         |                |

| src_user   | varchar(64)      | NO   |     |         |                |

| src_domain | varchar(128)     | NO   |     |         |                |

+------------+------------------+------+-----+---------+----------------+

16 rows in set (0.00 sec)

Although I always updated to the latest version (repository from 13.3.14) it seems that there is a compatibility issue I cannot figure out.
BR
Thomas


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20140317/62904ba7/attachment.html>


More information about the Spce-user mailing list