Building Elastix 4 via RPM Repo

nick

Got this installed except for the same error I see here (http://mangolassi.it/topic/6319/elastix-4-install-errors-with-sqlite-unable-to-update-admin-password/6) Any resolution to this?

The database asterisk is there with a table called "ampusers" where it looks like passwords are stored in a field called "password_sha1".

I had no luck with UPDATE (ing) that table and setting password_sha1=SHA1("newpassword") WHERE user="admin"

Feels so close.

nick

@scottalanmiller tried removing this section, but then no password is set for the admin account. I seem installed, but cannot log in. . Am trying on digitalocean as well with centOS 7.

Also, the line "systemctl enable httpd.server" produces file not found error.

scottalanmiller

@nick what does rpm -qa | grep httpd return?

rialejo

@nick Hello, i´m too in the same part of problem... please if you have any update, let me know. regards!

rialejo

I get that request:

[root@78 ~]# rpm -qa | grep httpd
httpd-2.4.6-40.el7.centos.x86_64
httpd-tools-2.4.6-40.el7.centos.x86_64

scottalanmiller

@rialejo said:

I get that request:

[root@78 ~]# rpm -qa | grep httpd
httpd-2.4.6-40.el7.centos.x86_64
httpd-tools-2.4.6-40.el7.centos.x86_64

So systemctl enable httpd.server doesn't work but systemctl start httpd.server does?

rialejo

@scottalanmiller I think no...

[root@78 ~]# systemctl start httpd.server
Failed to start httpd.server.service: Unit httpd.server.service failed to load: No such file or directory.

&

[root@78 ~]# systemctl enable httpd.server
Failed to execute operation: No such file or directory

scottalanmiller

If it fails to start, how are you getting to the web page shown in the example?

scottalanmiller

Try systemctl start httpd

rialejo

@scottalanmiller That works... but the user and pass faill...

Could you please confirm the user and pass default?

[root@78 ~]# systemctl start httpd

And its true.. im asked the same, it say error to enable that but showme the initial webpage...

scottalanmiller

@rialejo said:

And its true.. im asked the same, it say error to enable that but showme the initial webpage...

It's because you are getting the name wrong. The .server is not part of the name. Remove that.

rialejo

@rialejo said:

systemctl start httpd

To access your Elastix System, using a separate workstation (PC/MAC/Linux)
Open the Internet Browser using the following URL:
http://xxx.xxx.xxx.xx

[root@li1307-78 ~]# systemctl start httpd
[root@li1307-78 ~]#

nick

@rialejo @scottalanmiller
I tried restarting the service httpd, no luck. I think http server is working because it serves the login page no problem. The troublesome error happens when the first_boot script tries to set the Elastix admin password where there is an sql_lite command that produces error acl_users table not found.

I tried login: admin, password: palosanto to no avail. Going to try doing a fresh start with the httpd service line corrected, and will advise.

nick

error on httpd resolved.
After running firstboot script, I get:

The password for mysql and cyrus admin were successfully changed!
Applying MySQL script /var/spool/elastix-mysqldbscripts/01-asteriskcdrdb.sql ...
Applying MySQL script /var/spool/elastix-mysqldbscripts/01-freepbx.sql ...
Applying MySQL script /var/spool/elastix-mysqldbscripts/02-asteriskuser-password.sql ...
No Elastix CallCenter database found.
No A2Billing database found.
No VTigerCRM database found.
Updating FreePBX database password: mysql... files... updated
Updating FreePBX admin password: mysql... files... updated
Updating FreePBX ARI password: mysql... files... updated
Updating Flash Operator Panel password: mysql... files... updated
Updating Asterisk Manager Interface password: mysql... files... updated
Updating Elastix admin password: sqlite... FATAL: unable to update Elastix admin password: SQLSTATE[HY000]: General error: 1 no such table: acl_user

nick

@rialejo I have the same result from rpm -qa | grep httpd

nick

I owe a coffee to whoever can fix this issue

scottalanmiller

I'm trying to get to a point that I can do a fresh build. Got a couple of things demanding my attention in the queue in front of it, I'm afraid.

JaredBusch

The solution is to not use a product it's not going to be supported

nick

@scottalanmiller After restarting several times, I finally made a snapshot on digital ocean just after downloading the ISO. It feels like I have saved my game just before a big boss.

nick

any luck @rialejo ?
I may try 3.5 instead of 4...