Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: ber on August 29, 2017, 08:18:24 AM

Title: sme9admin database connection issue.
Post by: ber on August 29, 2017, 08:18:24 AM

HI After some help for sme9admin contrib, love the software and very helpful.

Problem is that when I move SME using affa onto new hardware i loose connection to the database and when trying to display dhcp or email traffic data the data is "blank" or it says " MySQL error : Access denied for user 'admin'@'localhost' (using password: YES)

Ive tried as much as I know- setting up users using phpmyadmin and setting passwords and priviledges but still get the same problem. As mentioned new installs are fine but when I move SME onto new hardware using the Affa contrib I loose data display on the sme9admin contrib.
Love affa and sme9admin but just cant sort this out- any help appreciated.

Thanks John :)

Title: Re: sme9admin database connection issue.
Post by: mmccarn on August 29, 2017, 01:14:26 PM

Check the settings of 'sme9admind' on both systems:

Code: [Select]

# config show sme9admind
AlertMailRecipient=admin
    DbName=sme9admin
    DbPassword=xx-my-db-password-was-here-but-you-cant-have-it-xx
    DbUser=sme9admin
    ImgFormat=PNG
    ImgHeight=250
    ImgWidth=500
    LimitPppoeDisconnect=1
    LimitPppoeDuration=4
    LimitVpnDuration=2
    MaxCpu=50
    MaxDiskSpace=60
    MaxFtp=1
    MaxHdTemp=40
    MaxHwTemp=40
    MaxMailIn=5
    MaxMailOut=5
    MaxSamba=5
    MaxSsh=2
    MaxVpn=1
    OtherMailDomains=
    PingTarget=www.google.fr
    SensorsTag1=temp1
    SensorsTag2=temp2
    SensorsTagFan=fan1
    SensorsTagFan2=
    StatusInterval=3
    StatusMailRecipient=admin
    UseDu=off
    hd1=sda
    hd2=
    hd3=
    hd4=
    hd5=
    hd6=
    status=enabled

If the sme9admin database was created and udpated on the new server, you might get into it by granting access on the new machine using something like this (substitute the password returned by the first command above):

Code: [Select]

# mysql -e "grant all privileges on sme9admin.* to sme9admin identified by 'xx-my-db-password-was-here-but-you-cant-have-it-xx';"


Title: Re: sme9admin database connection issue.
Post by: ber on August 30, 2017, 12:51:28 AM

Hi I resolved the issue. I used phpmyadmin contrib to sift through and cull a lot of the old redundant same username users and updated database specific priviledges. (I had used Affa since SME 7 and it imported all previous users and databases)
Define sme9admin user to the sme9admin database and check for correct password.
Then updated the user on the sme9admin panel via server-manager panel.
Thanks again. :smile: