Comments (86)
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.
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:
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:
from sccp_manager.
yep, fatal it is
from sccp_manager.
@vaDrn Are you using CENTOS 5 or 7?
from sccp_manager.
from sccp_manager.
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.
from sccp_manager.
bunch of errors after mariadb startup
from sccp_manager.
Have you tried running mysql_upgrade?
from sccp_manager.
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:
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.
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.
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.
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.
Related Issues (20)
- After changing Sound Language in FreePBX, changes do not propogate to sccp_manager controlled phones - sccp_manager v14.5.0.4
- cid_num in table sccpline does not fill in when creating SCCP extension HOT 1
- Cisco 8841 phone template HOT 1
- SCCP extensions tab disappears from FreePBX Extensions module
- Auto answer attempt on Cisco 7962 hangs entire pbx HOT 1
- HTTP Country Locale Phone Provisioning Issue HOT 1
- Pushed a new commit to the 'develop' branch, which handles alertinfo2ringtype conversion nicely and correctly this time.
- Voicemail not working HOT 1
- SCCP Extensions tab disappears when FreePBX Core module is upgraded HOT 6
- Problems on fresh install of FreePBX 16 HOT 1
- Cannot Load List of SCCP Phones HOT 2
- Cisco 99XX phones not registering
- save+continue gives undefined ip index xmlinterface.class.php:260 HOT 9
- Cant add new keyset HOT 1
- SCCP line unset from device after editing extension under SCCP extension tab HOT 6
- SCCP Manager not connecting to realtime database
- "Undefined index" error pops up on all FreePBX pages from sccp_manager php
- EndCall Button not working with onhook
- Language setup issues / Tips on how to develop this module
- Call Pickup/Group Call Pickup for Extensiones SCCP
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sccp_manager.