Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: ber on April 06, 2011, 04:50:46 AM

Title: sme7admin not displaying database query info
Post by: ber 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.

Title: Re: sme7admin not displaying database query info
Post by: Stefano on April 06, 2011, 10:46:54 AM

Quote from: ber on April 06, 2011, 04:50:46 AM

do you i need to query the developer??

this could be a good idea..

Title: Re: sme7admin not displaying database query info
Post by: imcintyre on April 07, 2011, 12:14:25 AM

I think his contact info is on main panel of SME7ADMIN contrib after installation.

Title: Re: sme7admin not displaying database query info
Post by: CharlieBrady on April 07, 2011, 02:13:38 PM

Quote from: Stefano on April 06, 2011, 10:46:54 AM

this could be a good idea..

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

Title: Re: sme7admin not displaying database query info
Post by: Stefano on April 07, 2011, 02:26:57 PM

is sme7admin in contribs repo? I didn't know.. :-)

Title: Re: sme7admin not displaying database query info
Post by: CharlieBrady on April 07, 2011, 04:04:02 PM

Quote from: Stefano on April 07, 2011, 02:26:57 PM

is sme7admin in contribs repo? I didn't know.. :-)

If it's not, it should be.

Title: Re: sme7admin not displaying database query info
Post by: ber 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.

Title: Re: sme7admin not displaying database query info
Post by: CharlieBrady on April 08, 2011, 02:03:17 PM

Quote from: ber on April 07, 2011, 10:54:34 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.

Title: Re: sme7admin not displaying database query info
Post by: Daniel B. 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.....