Topic: sme7admin contrib

[dede77b]

I'm trying to install the sme7admin (smeserver-sme7admin-1.1.0-1.noarch.rpm) contrib but I got problem when the contrib try to connect to mysql to create database and tables.

I don't have standard  password in mysql.

How can I install this contrib?

Here is my error:
[root@p1000 ~]# rpm -ivh http://sme.firewall-services.com/rpms/smeserver-sme7admin-1.1.0-1.noarch.rpm
Retrieving http://sme.firewall-services.com/rpms/smeserver-sme7admin-1.1.0-1.noarch.rpm
Preparing...                ########################################### [100%]
   1:smeserver-sme7admin    ########################################### [100%]
Rebuilding server-manager panel list..please wait.
mv: cannot overwrite directory /var/lib/sme7admin.old/sme7admin'
Backup of the existing rrds directory : [OK]
Creation of the rrds directory :        [OK]
Creation of rrds files :                [OK]
Error in the creation of the database : mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Error in the creation of mysql user : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Error in the creation of the tables : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Default configuration file for sme7admind service
max_mail_in = 5
limit_vpn_duration = 2
max_mail_out = 5
limit_pppoe_disconnection = 1
ping_target = www.google.fr
max_sessions_vpn = 1
max_sessions_samba = 5
mail_status_delay_between = 0
img_width = 500
sensors_first_temp_tag = temp1
max_sessions_ftp = 2
mail_alert_recipient = admin
hddtemp_first_hd = hda
hddtemp_second_hd =
max_hd_used = 60
if_internal = eth0
sensors_second_temp_tag = temp2
mail_status_recipient = admin
max_temp_hard = 40
max_cpu_total = 50
db_database = sme7admin
db_username = sme7admin
other_mail_address_domains =
img_height = 250
if_external = eth1
sensors_fan_tag = fan1
img_format = PNG
max_sessions_ssh = 2
du_enabled = on
limit_pppoe_duration = 4
db_password = pass
max_temp_hd = 40
sme7admind service added to SME startup
sme7admind=service
    status=enabled
Starting sme7admin daemon: Daemon already running, or crashed..
Try 'pgrep sme7admin' to see if the daemon crashed, then exec 'rm -f /var/run/sme7admin.pid' before restarting daemon.
[FAILED]
error: %post(smeserver-sme7admin-1.1.0-1.noarch) scriptlet failed, exit status 1

[dsemuk]

I don't have standard  password in mysql.

No one has a "standard password" the MySQL password is a random string generated for each individual install.

[dede77b]

No one has a "standard password" the MySQL password is a random string generated for each individual install.

I mean, that my mysql "user" is not sme7admin and my password is not "pass".

So I asked some help to install the contrib. I know that noone has a standard password.

Thank you for your help.

[harshl]

Anyone have a solution to this? I am having the same problem.

Thanks,
-Landon

[frond]

dede77b

> ...my mysql "user" is not sme7admin and my password is not "pass".

There is no real gain in changing those. Try setting them back to original values and see if sme7admin works OK then. That will eliminate other config issues.

If sme7admin then works OK, then that indicates your install is OK etc, in that case you need to configure the different username and password that you wish to use in mysql.
Report back here with your results and I'll advise what you can try next.

[harshl]

My problem actually turned out to be something entirely different. I was using sudo to get root access to the shell via "sudo tcsh". This does not work as it keeps my users environment. After an "su -" everything went great for me.

Thanks,
-Landon