Koozali.org: home of the SME Server

sme7admin not displaying database query info

Offline ber

  • *****
  • 239
  • +0/-0
sme7admin not displaying database query info
« on: April 06, 2011, 04:50:46 AM »
Hi Ive installed sme7admin on my SME 7.5.2 server only- system runs fine. sme7admin doesnt display the dhcp table when i click on the dhcp daemon in the server-manager sme7admin console.

Here is the error":

MySQL error : Can't execute query : Table 'sme7admin.dhcpd' doesn't exist


Ive checked the database (phpmyadmin)- its created a database but has no tables??- is this normal, a limitation in this contrib or do you i need to query the developer??

Can anyone advise regarding this.

Thank You.

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: sme7admin not displaying database query info
« Reply #1 on: April 06, 2011, 10:46:54 AM »
do you i need to query the developer??

this could be a good idea..

Offline imcintyre

  • *
  • 609
  • +0/-0
Re: sme7admin not displaying database query info
« Reply #2 on: April 07, 2011, 12:14:25 AM »
I think his contact info is on main panel of SME7ADMIN contrib after installation.

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: sme7admin not displaying database query info
« Reply #3 on: April 07, 2011, 02:13:38 PM »
this could be a good idea..

Problems should be reported via the bug tracker. The developer will be automatically notified.

Offline Stefano

  • *
  • 10,894
  • +3/-0
Re: sme7admin not displaying database query info
« Reply #4 on: April 07, 2011, 02:26:57 PM »
is sme7admin in contribs repo? I didn't know.. :-)

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: sme7admin not displaying database query info
« Reply #5 on: April 07, 2011, 04:04:02 PM »
is sme7admin in contribs repo? I didn't know.. :-)

If it's not, it should be.

Offline ber

  • *****
  • 239
  • +0/-0
Re: sme7admin not displaying database query info
« Reply #6 on: April 07, 2011, 10:54:34 PM »
Hi All, contacted Daniel (developer) and we were able to resolve the problem- sme7admin contrib was installed, database was setup but no tables.

Ran the following command to populate database tables:

mysql sme7admin < /usr/share/doc/smeserver-sme7admin/tables.sql

Problem solved.

Thank You.
« Last Edit: April 07, 2011, 11:14:34 PM by ber »

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: sme7admin not displaying database query info
« Reply #7 on: April 08, 2011, 02:03:17 PM »
Ran the following command to populate database tables:

mysql sme7admin < /usr/share/doc/smeserver-sme7admin/tables.sql

This indicates that the contrib doesn't correctly use the mysql.init service.

Offline Daniel B.

  • *
  • 1,700
  • +0/-0
    • Firewall Services, la sécurité des réseaux
Re: sme7admin not displaying database query info
« Reply #8 on: April 08, 2011, 02:42:56 PM »
The contrib correctly uses the mysql.init service. The database is populated on all the servers I manage. I just don't know why it hasn't worked in this case. Anyway, we don't really have time to maintain sme7admin actually, so, if someone want to enhance it.....
C'est la fin du monde !!! :lol: