Installer fails at database creation about sccp_manager HOT 86 CLOSED

The Stable branch will not fix errors in the user configuration.

The Develop branch should do this. The install error that you are seeing is caused by the fact that FreePbx Doctrine cannot parse correctly the files that it creates (unfortunately)

The Doctrine output has been corrected in the latest Develop branch (it may take some time for GitHub to propagate it to the snapshot).

Please try again in a few hours and confirm that this has been fixed.

from sccp_manager.

Got same error during install. Link I used https://github.com/chan-sccp/sccp_manager/archive/refs/heads/develop.zip

from sccp_manager.

The error is not the same but the result is.
Please paste the exact contents of the exception in the top left box - the command looks good

from sccp_manager.

@vaDrn In module admin, before trying to install this module, check for FreePBX module updates for your already installed modules, and apply any that are found

from sccp_manager.

updated all FreePBX modules. Still error during install

Text of the exception:
An exception occurred while executing 'CREATE TABLE sccpbuttonconfig (ref VARCHAR(15) DEFAULT '' NOT NULL, reftype VARCHAR(15) DEFAULT 'sccpdevice' NOT NULL, instance TINYINT(1) DEFAULT '0' NOT NULL, buttontype VARCHAR(255) DEFAULT 'line' NOT NULL, name VARCHAR(36) DEFAULT NULL, options VARCHAR(100) DEFAULT NULL, INDEX ref (ref, reftype), PRIMARY KEY(ref, reftype, instance, buttontype)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

from sccp_manager.

@vaDrn That command executes perfectly on Mariadb - what database are you using?

Are you familiar with accessing the database directly? If so can you run

SHOW TABLE STATUS WHERE NAME LIKE 'sccp%';

and paste the output here

I think that the issue is that you have run the mysql-enum as indicated in the old wiki instructions. This step is no longer necessary and in fact creates problems like this.

from sccp_manager.

It's database that goes preinstalled on FreePBX iso. I thought it was mariadb. Here is the version command output:

here is the table status output:

I followed this instructions: https://github.com/chan-sccp/chan-sccp/wiki/FreePBX_SCCP-modules it was last updated 7 days ago.
I can reinstall everything from scratch and skip mysql -p asterisk < /usr/src/chan-sccp/conf/mysql-v5_enum.sql part. Shouldn't take too long.

from sccp_manager.

so no any sccp tables.

still got error during install

An exception occurred while executing 'CREATE TABLE sccpbuttonconfig (ref VARCHAR(15) DEFAULT '' NOT NULL, reftype VARCHAR(15) DEFAULT 'sccpdevice' NOT NULL, instance TINYINT(1) DEFAULT '0' NOT NULL, buttontype VARCHAR(255) DEFAULT 'line' NOT NULL, name VARCHAR(36) DEFAULT NULL, options VARCHAR(100) DEFAULT NULL, INDEX ref (ref, reftype), PRIMARY KEY(ref, reftype, instance, buttontype)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

from sccp_manager.

@vaDrn No need - there are no conflicts in your tables. I have a fix (I think), but would really like to understand why this is failing on your machine and not on any others

can you do an

apt-get update;
apt-get upgrade;

(or the equivalent on your machine)
to see if there are any update packages for MariaDb

from sccp_manager.

FreePBX based on CentOS I think. yum update yum upgrade was the fist thing I made.

tried to install stable one again, no errors during install. Table status command output:

no realtime config tho

from sccp_manager.

@vaDrn There is an error in your database now, and it will prove fatal at some stage. You are mixing encodings in the view.

Can you do the following.

Uninstall and remove Stable
Download and install Develop (until it hangs)

In the database, run

SHOW TABLE STATUS WHERE NAME LIKE 'sccp%';

and paste the output again.

from sccp_manager.

i'm not mixing anything - it's created purely by stabe release installation.
I removed stable release and installed develop one. No error during install. Here is the status output:

also sccp module info:

from sccp_manager.

yep, fatal it is

from sccp_manager.

@vaDrn Are you using CENTOS 5 or 7?

from sccp_manager.

It's 7...?

from sccp_manager.

hmm

from sccp_manager.

@vaDrn OK Lets fix this. You need to update MariaDb and I will show you how to.

Logout and close FreePBX window

rm -r /var/www/html/admin/modules/sccp_manager/

run this in the Database

Drop table sccpbuttonconfig; drop table sccpuser; drop view sccpdeviceconfig;

Let me know when done

from sccp_manager.

done
only sccpdevice, sccpdevmodel, sccpline and sccpsettings tables left

from sccp_manager.

cd /etc/yum.repos.d/

using your favourite editor create a file called MariaDB.repo

and paste the following into it:

# MariaDB 10.5 CentOS repository list - created 2021-06-12 13:57 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Save the file

let me know when done

from sccp_manager.

done

from sccp_manager.

yum install MariaDB-server MariaDB-client

from sccp_manager.

done

from sccp_manager.

got error from firewall Firewall was unable to connect to MySQL after 30 seconds.

from sccp_manager.

mysql -V

from sccp_manager.

now it's spams it constantly

from sccp_manager.

mysql Ver 15.1 Distrib 10.5.10-MariaDB, for Linux (x86_64) using readline 5.1

from sccp_manager.

Firewall messages stopped?

from sccp_manager.

nope. still going

from sccp_manager.

dirty but a reboot is probably required

from sccp_manager.

it's dead after reboot

from sccp_manager.

bunch of errors after mariadb startup

from sccp_manager.

Have you tried running mysql_upgrade?

from sccp_manager.

after mysql_upgrade

from sccp_manager.

Does FreePBX load?

from sccp_manager.

nope. FreePBX won't load. MariaDB and asterisk won't start after reload. I can start them manually after systemctl daemon-reload command. FreePBX won't run at all

from sccp_manager.

Are you on a VM?

from sccp_manager.

yes. I have snapshots before db update

from sccp_manager.

So ---- rollback. Sorry but FreePBX are !!!! about their distros. Keep a snapshot of the present though and I will look into it more

from sccp_manager.

Once you have done, let me know what tables you have for sccp

from sccp_manager.

sorry, I was wrong. I only have snapshots before sccp manager installs. So there are no sccp tables in db.

from sccp_manager.

No pb

Download Develop and install (wait for the error)

from sccp_manager.

Sorry - do not install

from sccp_manager.

cd /var/www/html/admin/modules/sccp_manager

from sccp_manager.

done

from sccp_manager.

OK I think that I have seen the issue

In your favourite editor, edit module.xml and go to line 128

from sccp_manager.

<field name="buttontype" type="string" default="line" primarykey="true"/>

from sccp_manager.

change to

 <field name="buttontype" type="string" length="192" default="line" primarykey="true"/>

and save

from sccp_manager.

done

from sccp_manager.

Now try running install

from sccp_manager.

error:
An exception occurred while executing 'CREATE TABLE sccpbuttonconfig (ref VARCHAR(15) DEFAULT '' NOT NULL, reftype VARCHAR(15) DEFAULT 'sccpdevice' NOT NULL, instance TINYINT(1) DEFAULT '0' NOT NULL, buttontype VARCHAR(192) DEFAULT 'line' NOT NULL, name VARCHAR(36) DEFAULT NULL, options VARCHAR(100) DEFAULT NULL, INDEX ref (ref, reftype), PRIMARY KEY(ref, reftype, instance, buttontype)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

from sccp_manager.

Edit the file again and change the length from 192 to 150

from sccp_manager.

and try install ... again

from sccp_manager.

installed with no errors
tables:

and sccp info:

from sccp_manager.

OK looks good.

As you are a maso, uninstall Sccp manager, and change the length again to 190, and then reinstall

from sccp_manager.

this is new

from sccp_manager.

it shows as uninstalled anyway

from sccp_manager.

No sweat - thats normal.

Wait a sec please

from sccp_manager.

from sccp_manager.

You are too fast

Uninstall again please

from sccp_manager.

That was my mistake btw

from sccp_manager.

uninstalled. length set to 190

from sccp_manager.

now in db

drop table sccpdevice;drop table sccpuser;drop table sccpbuttonconfig;drop table sccpline;drop view sccpdeviceconfig;

from sccp_manager.

and then install

from sccp_manager.

it still working. we have to do something about it

from sccp_manager.

You have a very old version of MariaDb - an indexed field that can be NULL has a max length of 190

from sccp_manager.

But you are probably not alone with these distros, so I will look at the impact of changing the length.

In the meantime, try again to update MariaDB but FIRST, uninstall MariaDB, then add the repo, and install. That may work better

from sccp_manager.

Thanks for your patience and excellent feedback

from sccp_manager.

Comment here if you succeed in updating MariaDB

... and now, get some sleep!

from sccp_manager.

Aye Aye

from sccp_manager.

and finally, you can revert to stable at any time as the tables have been created, and your extconfig is correct.

What is in extconfig.conf, as the installer has updated extconfig.custom.conf?

from sccp_manager.

yep. custom one is updated:

from sccp_manager.

but what is in the base?

from sccp_manager.

from sccp_manager.

Are you joking?

from sccp_manager.

Sorry what is in /etc/extconfig.conf?

from sccp_manager.

mah bad. got it wrong - base one is empty

from sccp_manager.

So:

cp /etc/asterisk/extconfig.custom.conf /etc/asterisk/extconfig.conf
rm /etc/asterisk/extconfig.custom.conf

and you are clean

from sccp_manager.

And please, tomorrow, close this issue. It is the db at fault and not sccp_manager

from sccp_manager.

Trying to add sccp extension

from sccp_manager.

if i try to add it again i've got an error that this number is already taken. realtime load sccpline id 1 return nothing

from sccp_manager.

Create a new issue - this is Develop, but I am really concerned that it is related to the age of your install

This is the first time that I have seen this!!

from sccp_manager.

Ahh you are adding extensions via Extensions and not via add Phone. Create a new issue and I will look at it

from sccp_manager.

welp. it's official distro from freepbx.org. Even wiki says to download from there

from sccp_manager.

anyway. HUGE thanks for your time. I'll make other issue ticket tomorrow

from sccp_manager.

@vaDrn Could you please let me know which FreePBX distro you installed?

from sccp_manager.

default one on freepbx download page https://www.freepbx.org/downloads/. sng7-pbx-64bit-2104-1. release date: April 2021

from sccp_manager.