Hey Asterisk Community
i want to make some changes into my asterisk 21.4.1 and change the database
i want to read and write data from another asterisk database, so my data will be allocated.
actually my main database is on freepbx machine
is that possible?
to change the asterisk and asteriskcdrdb databases
i would be thankful if you you could help me
Same thing, same answer
what is not clear in : it can’t be done ?
The only thing you might have in common is the cdr and the cel, which you can set up on a mysql machine and enter the parameters in advanced settings, which however does not make much sense to do
Asking the same question twice is not going to be productive because you will get the same answers and also annoy folks here.
Asterisk uses basically two databases, an sqlite3 astdb and a flatform voicemail.conf, cdrs and cels are also written out if so defined. On startup it interprets /etc/asterisk/asterisk.conf and loads modules and conf files it encounters, then maintains the current state of the machine in astdb.
Don’t conflate Asterisk with FreePBX, FreePBX is a mostly PHP GUI that gets and puts input into lots of mysql(Mariadb) tables in the asterisk database, on command those tables are converted into .conf files and asterisk is told to reload these conf files. At which point the sqlite3 astdb database will resume to monitor and maintain the ‘state’ of the running instance.
Although asterisk can be compiled ‘real-time’ FreePBX does not support that and due to the way the asterisk database code is written the sqlite3 astdb database is only multi-threaded and not multi-user, any attempts to use it on two machines will sooner or later corrupt it to the point of failure
So as you have found out, it is unlikely that anything but the built-in backup/restores of one FreePBX to another will be a within your reach.