Syed Jahanzaib Personal Blog to Share Knowledge !

February 24, 2015

Table ‘conntrack.tabidx’ doesn’t exist

Filed under: Linux Related — Tags: , — Syed Jahanzaib / Pinochio~:) @ 11:32 AM


Short reference:

While accessing RM users section , received “Table ‘conntrack.tabidx‘ doesn’t exist” error.
As showed in the image below …



This is how I fixed it.

On your RM box, create a file in which we will add table information.

touch conntrack.sql
nano conntrack.sql

Paste the following table

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- Host: localhost
-- Generation Time: Sep 03, 2008 at 11:57 AM
-- Server version: 5.0.18
-- PHP Version: 5.1.2


-- Database: `conntrack`

-- --------------------------------------------------------

-- Table structure for table `tabidx`

`date` date NOT NULL,
PRIMARY KEY  (`date`)



SAVE and exit.

Now use the following command to import table into mysql database ‘conntrack

mysql -h localhost -u root -pYOURPASS radius < conntrack.sql




The table code have been extracted from radius manager installation archive.  Example:

You can import any missing table from above file and import it in mysql.





  1. salam jahanzaib,
    i m planning to install dmasoft lab, i just wana know which of urs methods is best for radius,
    radius with ubuntu
    radius with centos
    or radius with fedora
    another question is what dmasoftlab license procedure its like mikrotik bcoz MT do licensing with harddrive soft id
    what is DMA method of licensing.
    please ans me if know these.

    Comment by rehmat ali — February 26, 2015 @ 7:39 PM

    • DMA works fine with both flavors, It depends on what higher level of expertise you have in. I feel comfortable with Ubuntu, but recently moved to CANTOS as well.
      for licensing contact me on email or Skype.

      Comment by Syed Jahanzaib / Pinochio~:) — March 1, 2015 @ 2:56 PM

  2. Dear Sir, I need your help urgently i have mikrotik routerboard 450g with firmware 3.18 which not support PCC ….can i configure 2 wan load balancing without PCC…simply need to load balance 2 ptcl connection on wired network your help required. Fawad

    Comment by Fawad Ahmad — February 27, 2015 @ 11:52 AM

    • You can use NTH method on older version of Routeros to acheive load balancing, although it have its own problems for breaking links, but good for downloading.

      Comment by Syed Jahanzaib / Pinochio~:) — March 1, 2015 @ 2:55 PM

  3. dear jahanzaib i m still waiting for ur reply nad please do reply in other posts i asked more questions there.

    Comment by rehmat ali — February 28, 2015 @ 10:03 PM

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: