------------------------------------------------------------------------
r4775 | apache | 2005-10-20 18:05:20 +0200 (Thu, 20 Oct 2005) | 1 line

submitted changes as 4775
------------------------------------------------------------------------
r4774 | raarts | 2005-10-20 18:05:16 +0200 (Thu, 20 Oct 2005) | 6 lines

The qualify value is also used for determining if the first
response to an SIP INVITEtakes too long. Try to make that clear
for non-technical users in the qualify online help text.

Improve the view v_my_channels to also include Zap channels

------------------------------------------------------------------------
r4765 | apache | 2005-10-19 22:55:50 +0200 (Wed, 19 Oct 2005) | 1 line

submitted changes as 4765
------------------------------------------------------------------------
r4764 | raarts | 2005-10-19 22:55:46 +0200 (Wed, 19 Oct 2005) | 3 lines

Add cidnum field to department, contact and phoneline tables, so they
can override the company phonenumber on outbound calls.

------------------------------------------------------------------------
r4762 | apache | 2005-10-19 17:25:49 +0200 (Wed, 19 Oct 2005) | 1 line

submitted changes as 4762
------------------------------------------------------------------------
r4761 | ivar | 2005-10-19 17:25:45 +0200 (Wed, 19 Oct 2005) | 1 line

fixed bug in mustredirect function
------------------------------------------------------------------------
r4759 | apache | 2005-10-19 16:20:37 +0200 (Wed, 19 Oct 2005) | 1 line

submitted changes as 4759
------------------------------------------------------------------------
r4758 | ivar | 2005-10-19 16:20:33 +0200 (Wed, 19 Oct 2005) | 1 line

new column for schedule: company
------------------------------------------------------------------------
r4756 | apache | 2005-10-19 15:59:10 +0200 (Wed, 19 Oct 2005) | 1 line

submitted changes as 4756
------------------------------------------------------------------------
r4755 | perry | 2005-10-19 15:59:05 +0200 (Wed, 19 Oct 2005) | 1 line

added view v_my_channels
------------------------------------------------------------------------
r4733 | apache | 2005-10-18 09:48:32 +0200 (Tue, 18 Oct 2005) | 1 line

submitted changes as 4733
------------------------------------------------------------------------
r4732 | raarts | 2005-10-18 09:48:28 +0200 (Tue, 18 Oct 2005) | 3 lines

Fix two errors in triggers.
Added functionality to reboot old phone if you log in to a new phone.

------------------------------------------------------------------------
r4728 | apache | 2005-10-17 16:31:03 +0200 (Mon, 17 Oct 2005) | 1 line

submitted changes as 4728
------------------------------------------------------------------------
r4727 | ivar | 2005-10-17 16:30:59 +0200 (Mon, 17 Oct 2005) | 1 line

new table: schedule will eventually (but not yet) replace current redirect database structure
------------------------------------------------------------------------
r4722 | raarts | 2005-10-17 12:14:01 +0200 (Mon, 17 Oct 2005) | 2 lines

Warp back in time to fix a typo in the previous update.

------------------------------------------------------------------------
r4721 | apache | 2005-10-17 12:07:33 +0200 (Mon, 17 Oct 2005) | 1 line

submitted changes as 4721
------------------------------------------------------------------------
r4720 | raarts | 2005-10-17 12:07:29 +0200 (Mon, 17 Oct 2005) | 2 lines

Set proper defaults for callwaiting column in channel table.

------------------------------------------------------------------------
r4696 | apache | 2005-10-12 16:39:21 +0200 (Wed, 12 Oct 2005) | 1 line

submitted changes as 4696
------------------------------------------------------------------------
r4695 | raarts | 2005-10-12 16:39:14 +0200 (Wed, 12 Oct 2005) | 5 lines

Added max calls to phone field. This overrides the maxcalls
value for any configured phonelines on this phone.
Also added proper defaults for some other fields that were
opverlooked in the past.

------------------------------------------------------------------------
r4689 | apache | 2005-10-12 12:43:25 +0200 (Wed, 12 Oct 2005) | 1 line

submitted changes as 4689
------------------------------------------------------------------------
r4688 | ivar | 2005-10-12 12:43:20 +0200 (Wed, 12 Oct 2005) | 1 line

don't stop running when encountering an error
------------------------------------------------------------------------
r4687 | apache | 2005-10-12 12:32:44 +0200 (Wed, 12 Oct 2005) | 1 line

submitted changes as 4687
------------------------------------------------------------------------
r4686 | ivar | 2005-10-12 12:32:40 +0200 (Wed, 12 Oct 2005) | 1 line

update crontab, older Astium's don't have cron.5min defined
------------------------------------------------------------------------
r4685 | apache | 2005-10-12 11:30:45 +0200 (Wed, 12 Oct 2005) | 1 line

submitted changes as 4685
------------------------------------------------------------------------
r4684 | ivar | 2005-10-12 11:30:40 +0200 (Wed, 12 Oct 2005) | 1 line

error in inbound.sql caused invalid trigger to be created. Fix error, create new trigger.
------------------------------------------------------------------------
r4683 | apache | 2005-10-12 10:51:45 +0200 (Wed, 12 Oct 2005) | 1 line

submitted changes as 4683
------------------------------------------------------------------------
r4682 | raarts | 2005-10-12 10:51:38 +0200 (Wed, 12 Oct 2005) | 5 lines

Oops. The logoutuser function did not work very well.
It wrote an erroneous activation record with the phone id
as the contact id. astcfgd barfed on it, but nobody
noticed so far.

------------------------------------------------------------------------
r4679 | ivar | 2005-10-11 17:16:46 +0200 (Tue, 11 Oct 2005) | 1 line

version 7-5 is not available on server, back to 7-3
------------------------------------------------------------------------
r4674 | ivar | 2005-10-11 12:14:53 +0200 (Tue, 11 Oct 2005) | 1 line

now that queue_log rotates, saving file pointer is not enough. If filesize is smaller than pointer, log has rotated: set pointer to 0.
------------------------------------------------------------------------
r4673 | apache | 2005-10-11 11:21:08 +0200 (Tue, 11 Oct 2005) | 1 line

submitted changes as 4673
------------------------------------------------------------------------
r4672 | ivar | 2005-10-11 11:21:04 +0200 (Tue, 11 Oct 2005) | 1 line

limit cdr_astium to 5000 entries per run, and add script to activate both cdr_astium and queue_log
------------------------------------------------------------------------
r4671 | apache | 2005-10-11 10:55:48 +0200 (Tue, 11 Oct 2005) | 1 line

submitted changes as 4671
------------------------------------------------------------------------
r4670 | raarts | 2005-10-11 10:55:43 +0200 (Tue, 11 Oct 2005) | 5 lines

Improved docu on how to change database layouts etc
altered functions voicemail_on/off and recording_on/off
because they still used'on/off' values and it should be
'yes/no'.

------------------------------------------------------------------------
r4656 | apache | 2005-10-07 15:02:53 +0200 (Fri, 07 Oct 2005) | 1 line

submitted changes as 4656
------------------------------------------------------------------------
r4655 | ivar | 2005-10-07 15:02:49 +0200 (Fri, 07 Oct 2005) | 1 line

changed conference: give it a phoneline
------------------------------------------------------------------------
r4647 | ivar | 2005-10-07 11:48:45 +0200 (Fri, 07 Oct 2005) | 1 line

oops left some garbage, cleaning it up
------------------------------------------------------------------------
r4646 | apache | 2005-10-07 11:31:19 +0200 (Fri, 07 Oct 2005) | 1 line

submitted changes as 4646
------------------------------------------------------------------------
r4645 | ivar | 2005-10-07 11:31:14 +0200 (Fri, 07 Oct 2005) | 1 line

new conference table
------------------------------------------------------------------------
r4640 | apache | 2005-10-06 23:42:49 +0200 (Thu, 06 Oct 2005) | 1 line

submitted changes as 4640
------------------------------------------------------------------------
r4639 | raarts | 2005-10-06 23:42:45 +0200 (Thu, 06 Oct 2005) | 3 lines

Add state column to trunk_sip and trunk_iax so we can monitor 
those as well.

------------------------------------------------------------------------
r4638 | apache | 2005-10-06 23:23:31 +0200 (Thu, 06 Oct 2005) | 1 line

submitted changes as 4638
------------------------------------------------------------------------
r4637 | raarts | 2005-10-06 23:23:27 +0200 (Thu, 06 Oct 2005) | 2 lines

You have to do svn add of course....

------------------------------------------------------------------------
r4636 | raarts | 2005-10-06 23:20:28 +0200 (Thu, 06 Oct 2005) | 2 lines

Enlarged the state column to make room for pingtimes.

------------------------------------------------------------------------
r4635 | raarts | 2005-10-06 21:47:48 +0200 (Thu, 06 Oct 2005) | 3 lines

Add sample.call, that shows how you can setup a call
by dropping a file into a directory.

------------------------------------------------------------------------
r4626 | apache | 2005-10-05 21:15:47 +0200 (Wed, 05 Oct 2005) | 1 line

submitted changes as 4626
------------------------------------------------------------------------
r4625 | raarts | 2005-10-05 21:15:43 +0200 (Wed, 05 Oct 2005) | 3 lines

Added 'state' field to the channel table, so we will be able to
track the status of phone channels in the web.

------------------------------------------------------------------------
r4624 | apache | 2005-10-05 16:10:09 +0200 (Wed, 05 Oct 2005) | 1 line

submitted changes as 4624
------------------------------------------------------------------------
r4623 | wijnand | 2005-10-05 16:10:05 +0200 (Wed, 05 Oct 2005) | 2 lines

Fix pg_hba.conf part deux.

------------------------------------------------------------------------
r4621 | wijnand | 2005-10-05 15:19:28 +0200 (Wed, 05 Oct 2005) | 4 lines

fix pg_hba.conf.

I hope it works, this is my first astium.changes.after

------------------------------------------------------------------------
r4605 | apache | 2005-10-04 10:31:28 +0200 (Tue, 04 Oct 2005) | 1 line

submitted changes as 4605
------------------------------------------------------------------------
r4604 | raarts | 2005-10-04 10:31:24 +0200 (Tue, 04 Oct 2005) | 2 lines

Set maxcalls default to 2. Is what most users want.

------------------------------------------------------------------------
r4603 | raarts | 2005-10-04 10:03:52 +0200 (Tue, 04 Oct 2005) | 2 lines

Add new option per phoneline: max concurrent calls.

------------------------------------------------------------------------
r4602 | raarts | 2005-10-04 01:31:08 +0200 (Tue, 04 Oct 2005) | 2 lines

And another helpfunction failed.

------------------------------------------------------------------------
r4601 | raarts | 2005-10-04 01:26:07 +0200 (Tue, 04 Oct 2005) | 2 lines

Fix error in help message. 

------------------------------------------------------------------------
r4595 | apache | 2005-10-03 23:12:46 +0200 (Mon, 03 Oct 2005) | 1 line

submitted changes as 4595
------------------------------------------------------------------------
r4594 | raarts | 2005-10-03 23:12:43 +0200 (Mon, 03 Oct 2005) | 4 lines

Drop columns ivrmenu from inbound and redirect.
Fix relating trigggers.
Fix mustredirect() function so that it still does what it should do.

------------------------------------------------------------------------
r4593 | raarts | 2005-10-03 22:43:38 +0200 (Mon, 03 Oct 2005) | 2 lines

Fixed filling in redirect table

------------------------------------------------------------------------
r4592 | raarts | 2005-10-03 21:46:55 +0200 (Mon, 03 Oct 2005) | 2 lines

Fix the previous update so it works

------------------------------------------------------------------------
r4591 | apache | 2005-10-03 21:32:06 +0200 (Mon, 03 Oct 2005) | 1 line

submitted changes as 4591
------------------------------------------------------------------------
r4590 | raarts | 2005-10-03 21:32:02 +0200 (Mon, 03 Oct 2005) | 2 lines

Really commit astium.changes.before

------------------------------------------------------------------------
r4589 | raarts | 2005-10-03 21:21:47 +0200 (Mon, 03 Oct 2005) | 3 lines

Convert the info in ivrmenu to ivr and ivroption tables
Also adjust inbound and redirect.

------------------------------------------------------------------------
r4586 | apache | 2005-10-03 12:55:33 +0200 (Mon, 03 Oct 2005) | 1 line

submitted database changes as 4586
------------------------------------------------------------------------
r4585 | raarts | 2005-10-03 12:55:28 +0200 (Mon, 03 Oct 2005) | 3 lines

Added ivr columns to inbound and redirect tables, as
a preparation for splitting up the ivrmenu table.

------------------------------------------------------------------------
r4584 | raarts | 2005-10-03 01:11:04 +0200 (Mon, 03 Oct 2005) | 2 lines

More fixes in ivr tables

------------------------------------------------------------------------
r4583 | raarts | 2005-10-03 00:36:31 +0200 (Mon, 03 Oct 2005) | 2 lines

More small repairs in triggers

------------------------------------------------------------------------
r4582 | raarts | 2005-10-03 00:28:40 +0200 (Mon, 03 Oct 2005) | 2 lines

Repaired trigger. 

------------------------------------------------------------------------
r4581 | apache | 2005-10-03 00:15:07 +0200 (Mon, 03 Oct 2005) | 1 line

submitted database changes as 4581
------------------------------------------------------------------------
r4580 | raarts | 2005-10-03 00:15:02 +0200 (Mon, 03 Oct 2005) | 3 lines

Added two tables ivr and ivroption. These will be used
to tpliy the ivrmenu table in header and option lines.

------------------------------------------------------------------------
r4571 | apache | 2005-09-30 11:42:36 +0200 (Fri, 30 Sep 2005) | 1 line

submitted database changes as 4571
------------------------------------------------------------------------
r4570 | ivar | 2005-09-30 11:42:32 +0200 (Fri, 30 Sep 2005) | 1 line

changes for last commit
------------------------------------------------------------------------
r4569 | ivar | 2005-09-30 11:41:26 +0200 (Fri, 30 Sep 2005) | 1 line

extension to view v_my_queues: don't include agents on 'pause' in count
------------------------------------------------------------------------
r4568 | apache | 2005-09-30 11:12:29 +0200 (Fri, 30 Sep 2005) | 1 line

submitted database changes as 4568
------------------------------------------------------------------------
r4567 | ivar | 2005-09-30 11:12:25 +0200 (Fri, 30 Sep 2005) | 1 line

new index (for optimizing abandoned calls in index-queues)
------------------------------------------------------------------------
r4562 | apache | 2005-09-30 10:45:05 +0200 (Fri, 30 Sep 2005) | 1 line

submitted database changes as 4562
------------------------------------------------------------------------
r4561 | ivar | 2005-09-30 10:45:01 +0200 (Fri, 30 Sep 2005) | 1 line

create index on 'created' column in queue_log table
------------------------------------------------------------------------
r4560 | ivar | 2005-09-30 10:41:41 +0200 (Fri, 30 Sep 2005) | 1 line

new version of queue_log import script
------------------------------------------------------------------------
r4554 | ivar | 2005-09-29 12:31:48 +0200 (Thu, 29 Sep 2005) | 1 line

removed some debug code (will remove more later)
------------------------------------------------------------------------
r4553 | ivar | 2005-09-29 12:30:27 +0200 (Thu, 29 Sep 2005) | 1 line

change to queue_log script: no longer read entire logfile in an array, but remember location in file and read from there, with a maximum
------------------------------------------------------------------------
r4548 | apache | 2005-09-29 11:43:53 +0200 (Thu, 29 Sep 2005) | 1 line

submitted database changes as 4548
------------------------------------------------------------------------
r4547 | wijnand | 2005-09-29 11:43:49 +0200 (Thu, 29 Sep 2005) | 4 lines

Oops, forgot 
AND contact.pause = 'no'


------------------------------------------------------------------------
r4545 | raarts | 2005-09-29 11:17:55 +0200 (Thu, 29 Sep 2005) | 2 lines

Skip analog phones when filling channel table

------------------------------------------------------------------------
r4543 | apache | 2005-09-29 11:16:49 +0200 (Thu, 29 Sep 2005) | 1 line

submitted database changes as 4543
------------------------------------------------------------------------
r4542 | wijnand | 2005-09-29 11:16:46 +0200 (Thu, 29 Sep 2005) | 4 lines

Also show the number of members of all queues, this way astiumop can work with lesser queries.

Credits go to Ivar.

------------------------------------------------------------------------
r4540 | raarts | 2005-09-29 10:37:54 +0200 (Thu, 29 Sep 2005) | 2 lines

And another timewarp fix..

------------------------------------------------------------------------
r4539 | raarts | 2005-09-29 10:26:35 +0200 (Thu, 29 Sep 2005) | 3 lines

Timewarped back in time, to fix a bug in the update for 
activate_channel trigger.

------------------------------------------------------------------------
r4537 | apache | 2005-09-29 09:27:26 +0200 (Thu, 29 Sep 2005) | 1 line

submitted database changes as 4537
------------------------------------------------------------------------
r4536 | raarts | 2005-09-29 09:27:22 +0200 (Thu, 29 Sep 2005) | 2 lines

Now finally activate the multiple-buttons-per-phone functionality

------------------------------------------------------------------------
r4530 | apache | 2005-09-28 15:40:21 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4530
------------------------------------------------------------------------
r4529 | wijnand | 2005-09-28 15:40:18 +0200 (Wed, 28 Sep 2005) | 4 lines

Add a additional rule for the v_my_account view to automatically create a activate record for the user who updates his pause status.

I also added the forgotten grants that are needed.

------------------------------------------------------------------------
r4528 | apache | 2005-09-28 15:19:31 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4528
------------------------------------------------------------------------
r4527 | raarts | 2005-09-28 15:19:28 +0200 (Wed, 28 Sep 2005) | 3 lines

Add button field so when assigning a phone line to someone 
you cal also determine a button on the phone for it.

------------------------------------------------------------------------
r4526 | raarts | 2005-09-28 15:03:57 +0200 (Wed, 28 Sep 2005) | 3 lines

Add script to fill the new channel table with info from 
the current phone records.

------------------------------------------------------------------------
r4525 | apache | 2005-09-28 15:01:44 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4525
------------------------------------------------------------------------
r4524 | raarts | 2005-09-28 15:01:40 +0200 (Wed, 28 Sep 2005) | 4 lines

It will be possible to define the button on the phone where 
a phoneline will be configured. These are the database changes
necessary.

------------------------------------------------------------------------
r4523 | apache | 2005-09-28 14:57:51 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4523
------------------------------------------------------------------------
r4522 | wijnand | 2005-09-28 14:57:47 +0200 (Wed, 28 Sep 2005) | 6 lines

New view v_my_account.
select returns the row of the current user.
updating works, but only for the pause field.

this is needed for perry's app.

------------------------------------------------------------------------
r4521 | apache | 2005-09-28 14:41:44 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4521
------------------------------------------------------------------------
r4520 | wijnand | 2005-09-28 14:41:41 +0200 (Wed, 28 Sep 2005) | 3 lines

Oops, last commit was committed from the src/ directory.
Redo it, but do it right this time.

------------------------------------------------------------------------
r4519 | apache | 2005-09-28 14:35:27 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4519
------------------------------------------------------------------------
r4518 | raarts | 2005-09-28 14:35:23 +0200 (Wed, 28 Sep 2005) | 2 lines

It's not easy being green, and also creating a new table isn't..

------------------------------------------------------------------------
r4517 | apache | 2005-09-28 14:25:16 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4517
------------------------------------------------------------------------
r4516 | raarts | 2005-09-28 14:25:12 +0200 (Wed, 28 Sep 2005) | 2 lines

Removed erroneous semicolon in DECLARE statement. Gives a syntax error

------------------------------------------------------------------------
r4515 | apache | 2005-09-28 14:14:09 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4515
------------------------------------------------------------------------
r4514 | wijnand | 2005-09-28 14:14:05 +0200 (Wed, 28 Sep 2005) | 2 lines

Trigger functions should run as user postgres. 

------------------------------------------------------------------------
r4513 | apache | 2005-09-28 13:59:50 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4513
------------------------------------------------------------------------
r4512 | raarts | 2005-09-28 13:59:46 +0200 (Wed, 28 Sep 2005) | 3 lines

Add column 'inuse' to channel table, so we canb disable
buttons on phones.

------------------------------------------------------------------------
r4511 | raarts | 2005-09-28 13:41:51 +0200 (Wed, 28 Sep 2005) | 4 lines

Moved foreign key definition for phoneline from the phone.sql
to the phoneline.sql file, because of circular references in foreign
key definitions.

------------------------------------------------------------------------
r4510 | raarts | 2005-09-28 12:58:24 +0200 (Wed, 28 Sep 2005) | 2 lines

Fix interface CREATE statement.

------------------------------------------------------------------------
r4509 | raarts | 2005-09-28 12:39:14 +0200 (Wed, 28 Sep 2005) | 2 lines

Added channel.sql to makefile

------------------------------------------------------------------------
r4508 | apache | 2005-09-28 12:35:59 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4508
------------------------------------------------------------------------
r4507 | raarts | 2005-09-28 12:35:55 +0200 (Wed, 28 Sep 2005) | 2 lines

Fomr now on the system knows how many buttons each phone is equipped with

------------------------------------------------------------------------
r4504 | raarts | 2005-09-28 11:21:24 +0200 (Wed, 28 Sep 2005) | 2 lines

Added channel.sql to the specfile

------------------------------------------------------------------------
r4503 | apache | 2005-09-28 11:13:16 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4503
------------------------------------------------------------------------
r4502 | raarts | 2005-09-28 11:13:13 +0200 (Wed, 28 Sep 2005) | 4 lines

Add new table 'channel'. This is needed to support more
then one button on a phone. We need this for independer 112
support.

------------------------------------------------------------------------
r4501 | apache | 2005-09-28 10:22:54 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4501
------------------------------------------------------------------------
r4500 | raarts | 2005-09-28 10:22:50 +0200 (Wed, 28 Sep 2005) | 3 lines

Fix triggers for contact and phonetype, and re-apply 
phonetype updates.

------------------------------------------------------------------------
r4499 | apache | 2005-09-28 09:17:11 +0200 (Wed, 28 Sep 2005) | 1 line

submitted database changes as 4499
------------------------------------------------------------------------
r4498 | raarts | 2005-09-28 09:17:07 +0200 (Wed, 28 Sep 2005) | 2 lines

Database changes for supporting swissvoice IP10S and Cisco 7905

------------------------------------------------------------------------
r4496 | apache | 2005-09-27 13:53:28 +0200 (Tue, 27 Sep 2005) | 1 line

submitted database changes as 4496
------------------------------------------------------------------------
r4495 | ivar | 2005-09-27 13:53:24 +0200 (Tue, 27 Sep 2005) | 1 line

altered view v_stats_queues to only show queue stats for any company the current user is in
------------------------------------------------------------------------
r4493 | raarts | 2005-09-27 12:07:35 +0200 (Tue, 27 Sep 2005) | 2 lines

Fix after/before update script

------------------------------------------------------------------------
r4491 | raarts | 2005-09-27 11:57:36 +0200 (Tue, 27 Sep 2005) | 2 lines

Had to fix an after script, sorry it's my first.

------------------------------------------------------------------------
r4490 | raarts | 2005-09-27 11:51:13 +0200 (Tue, 27 Sep 2005) | 2 lines

Commit the database changes

------------------------------------------------------------------------
r4489 | raarts | 2005-09-27 11:45:54 +0200 (Tue, 27 Sep 2005) | 7 lines

- Change the astium-setup procedure. You can now specify shell scripts
  which should be run before and after the upgrade.
  Give the shell scripts the names astium.changes.before or
  astium.changes.after (and don't forget to to svn add for them)
- Added dhcpd column to the interface table, to specifiy if the
  astium should respond to DHCP requests on that interface.

------------------------------------------------------------------------
r4480 | apache | 2005-09-25 12:31:53 +0200 (Sun, 25 Sep 2005) | 1 line

submitted database changes as 4480
------------------------------------------------------------------------
r4479 | raarts | 2005-09-25 12:31:46 +0200 (Sun, 25 Sep 2005) | 6 lines

Improved create-triggers.php. Now it will not generate dupe
generate() statements in the trigger for create and delete operations.
Added phoneline field to phones. This is the database part of implementing
the feature that phones can get their own extension (apart from the person
who is currently logged in).

------------------------------------------------------------------------
r4478 | apache | 2005-09-23 17:13:49 +0200 (Fri, 23 Sep 2005) | 1 line

submitted database changes as 4478
------------------------------------------------------------------------
r4477 | raarts | 2005-09-23 17:13:45 +0200 (Fri, 23 Sep 2005) | 3 lines

When converting to new db structure, I forgot to add
some help messages. Here they are.

------------------------------------------------------------------------
r4476 | apache | 2005-09-23 16:39:45 +0200 (Fri, 23 Sep 2005) | 1 line

submitted database changes as 4476
------------------------------------------------------------------------
r4475 | wijnand | 2005-09-23 16:39:42 +0200 (Fri, 23 Sep 2005) | 6 lines

Also rename the stats_queues view to v_stats_queues.
Give group astium_users select permissions.

Please note, this view is still not ready!
It still returns rows not belonging to the company of the current logged in postgresql user.

------------------------------------------------------------------------
r4473 | apache | 2005-09-23 16:31:43 +0200 (Fri, 23 Sep 2005) | 1 line

submitted database changes as 4473
------------------------------------------------------------------------
r4472 | wijnand | 2005-09-23 16:31:39 +0200 (Fri, 23 Sep 2005) | 2 lines

Rename stats_calls to v_stats_calls to make it more clear it is a view.

------------------------------------------------------------------------
r4471 | apache | 2005-09-23 16:29:03 +0200 (Fri, 23 Sep 2005) | 1 line

submitted database changes as 4471
------------------------------------------------------------------------
r4470 | wijnand | 2005-09-23 16:28:59 +0200 (Fri, 23 Sep 2005) | 2 lines

Oops, forgot the changes again.

------------------------------------------------------------------------
r4469 | wijnand | 2005-09-23 16:28:30 +0200 (Fri, 23 Sep 2005) | 4 lines

Rename my_queues to v_my_queues to make it more clear it is a view.

This view is done now and Perry can use it safely in astiumop.

------------------------------------------------------------------------
r4464 | apache | 2005-09-23 14:46:28 +0200 (Fri, 23 Sep 2005) | 1 line

submitted database changes as 4464
------------------------------------------------------------------------
r4463 | raarts | 2005-09-23 14:46:25 +0200 (Fri, 23 Sep 2005) | 3 lines

Fixes in generating trigger activate functions.
Add column didnumber to phoneline table.

------------------------------------------------------------------------
r4462 | wijnand | 2005-09-23 14:33:25 +0200 (Fri, 23 Sep 2005) | 3 lines

Unbreak, never assume ron is telling the truth :-D
It should work now.

------------------------------------------------------------------------
r4451 | apache | 2005-09-23 11:05:46 +0200 (Fri, 23 Sep 2005) | 1 line

submitted database changes as 4451
------------------------------------------------------------------------
r4450 | wijnand | 2005-09-23 11:05:40 +0200 (Fri, 23 Sep 2005) | 2 lines

Oops, I should have added this file too.

------------------------------------------------------------------------
r4447 | wijnand | 2005-09-23 10:52:19 +0200 (Fri, 23 Sep 2005) | 2 lines

Generate all astium users as postgresql users when this update gets installed.

------------------------------------------------------------------------
r4433 | wijnand | 2005-09-21 12:12:16 +0200 (Wed, 21 Sep 2005) | 2 lines

Skipping inbound-pri makes this script work again. Up2date cdr details in the database again :-)

------------------------------------------------------------------------
r4432 | perry | 2005-09-21 12:10:44 +0200 (Wed, 21 Sep 2005) | 1 line

fixed creation of a lockfile
------------------------------------------------------------------------
r4424 | apache | 2005-09-21 00:12:09 +0200 (Wed, 21 Sep 2005) | 1 line

submitted database changes as 4424
------------------------------------------------------------------------
r4423 | wijnand | 2005-09-21 00:12:05 +0200 (Wed, 21 Sep 2005) | 2 lines

Grant select access to the astium_users group to the my_queues and stats_calls views

------------------------------------------------------------------------
r4422 | apache | 2005-09-21 00:02:08 +0200 (Wed, 21 Sep 2005) | 1 line

submitted database changes as 4422
------------------------------------------------------------------------
r4421 | wijnand | 2005-09-21 00:02:05 +0200 (Wed, 21 Sep 2005) | 3 lines

Create a group for all normal astium users.
This is better then letting astcfgd grant access to tables for all users.

------------------------------------------------------------------------
r4420 | apache | 2005-09-20 23:03:35 +0200 (Tue, 20 Sep 2005) | 1 line

submitted database changes as 4420
------------------------------------------------------------------------
r4419 | wijnand | 2005-09-20 23:03:31 +0200 (Tue, 20 Sep 2005) | 4 lines

User astium should be able to create other postgresql users.

Probably changed too many files, but why the hell are they in SVN then?

------------------------------------------------------------------------
r4418 | apache | 2005-09-20 19:24:21 +0200 (Tue, 20 Sep 2005) | 1 line

submitted database changes as 4418
------------------------------------------------------------------------
r4417 | wijnand | 2005-09-20 19:24:18 +0200 (Tue, 20 Sep 2005) | 3 lines

The stats_calls view now also only outputs records belonging to the company('s ???) wich the database user belongs to.
Much safer for multi company astiums.

------------------------------------------------------------------------
r4416 | apache | 2005-09-20 16:21:29 +0200 (Tue, 20 Sep 2005) | 1 line

submitted database changes as 4416
------------------------------------------------------------------------
r4415 | wijnand | 2005-09-20 16:21:25 +0200 (Tue, 20 Sep 2005) | 4 lines

Create a view called my_queues. It takes the username of the database connection and returns the queue information for that user. 

Also give user astium the right to grant access to it.

------------------------------------------------------------------------
r4412 | apache | 2005-09-20 14:13:17 +0200 (Tue, 20 Sep 2005) | 1 line

submitted database changes as 4412
------------------------------------------------------------------------
r4411 | raarts | 2005-09-20 14:13:12 +0200 (Tue, 20 Sep 2005) | 2 lines

Add dialplan for Netherlands Antilles

------------------------------------------------------------------------
r4406 | apache | 2005-09-19 15:34:30 +0200 (Mon, 19 Sep 2005) | 1 line

submitted database changes as 4406
------------------------------------------------------------------------
r4405 | raarts | 2005-09-19 15:34:27 +0200 (Mon, 19 Sep 2005) | 2 lines

Remove old constraint on cardtypes.

------------------------------------------------------------------------
r4402 | raarts | 2005-09-19 14:55:48 +0200 (Mon, 19 Sep 2005) | 2 lines

Forgot to add files to the specfile. Happens every time.

------------------------------------------------------------------------
r4401 | apache | 2005-09-19 14:53:10 +0200 (Mon, 19 Sep 2005) | 1 line

submitted database changes as 4401
------------------------------------------------------------------------
r4400 | raarts | 2005-09-19 14:53:06 +0200 (Mon, 19 Sep 2005) | 2 lines

Databse changes for adding 2 ports ISDN-30 cards.

------------------------------------------------------------------------
r4397 | apache | 2005-09-18 11:52:51 +0200 (Sun, 18 Sep 2005) | 1 line

submitted database changes as 4397
------------------------------------------------------------------------
r4396 | raarts | 2005-09-18 11:52:47 +0200 (Sun, 18 Sep 2005) | 2 lines

For once and for all fix sunday redirection (I hope).

------------------------------------------------------------------------
r4393 | apache | 2005-09-16 17:07:12 +0200 (Fri, 16 Sep 2005) | 1 line

submitted database changes as 4393
------------------------------------------------------------------------
r4392 | raarts | 2005-09-16 17:07:08 +0200 (Fri, 16 Sep 2005) | 3 lines

Fix accountcodes in CDR. They are wrong! Should be shortname-userid
and not shortname-extension.

------------------------------------------------------------------------
r4371 | apache | 2005-09-14 10:54:08 +0200 (Wed, 14 Sep 2005) | 1 line

submitted database changes as 4371
------------------------------------------------------------------------
r4370 | raarts | 2005-09-14 10:54:04 +0200 (Wed, 14 Sep 2005) | 3 lines

Remove superfluous cards
Add new global: emailfrom

------------------------------------------------------------------------
r4364 | apache | 2005-09-13 23:52:07 +0200 (Tue, 13 Sep 2005) | 1 line

submitted database changes as 4364
------------------------------------------------------------------------
r4363 | raarts | 2005-09-13 23:52:02 +0200 (Tue, 13 Sep 2005) | 2 lines

Remove superfluous cards

------------------------------------------------------------------------
r4362 | apache | 2005-09-13 15:38:19 +0200 (Tue, 13 Sep 2005) | 1 line

submitted database changes as 4362
------------------------------------------------------------------------
r4361 | raarts | 2005-09-13 15:38:16 +0200 (Tue, 13 Sep 2005) | 2 lines

Fix bug where an empty IAX trunk exists, but shouldn't.

------------------------------------------------------------------------
r4355 | apache | 2005-09-13 11:22:43 +0200 (Tue, 13 Sep 2005) | 1 line

submitted database changes as 4355
------------------------------------------------------------------------
r4354 | wijnand | 2005-09-13 11:22:40 +0200 (Tue, 13 Sep 2005) | 3 lines

User astium should be allowed to grant permissions on the views Ivar created last week. 
We want to be able to configure user access through the astium confweb.

------------------------------------------------------------------------
r4334 | ivar | 2005-09-09 15:43:53 +0200 (Fri, 09 Sep 2005) | 1 line

don't reload asterisk every time an entry is written to this table
------------------------------------------------------------------------
r4333 | apache | 2005-09-09 15:20:11 +0200 (Fri, 09 Sep 2005) | 1 line

submitted database changes as 4333
------------------------------------------------------------------------
r4332 | raarts | 2005-09-09 15:20:08 +0200 (Fri, 09 Sep 2005) | 3 lines

Set default firmware version for cisco to 'P0S3-07-5-00'.
Added helptext for firmware_version field.

------------------------------------------------------------------------
r4330 | ivar | 2005-09-09 15:01:33 +0200 (Fri, 09 Sep 2005) | 1 line

added my two new cron job files in two placed Perry told me to add it
------------------------------------------------------------------------
r4326 | apache | 2005-09-09 14:07:09 +0200 (Fri, 09 Sep 2005) | 1 line

submitted database changes as 4326
------------------------------------------------------------------------
r4325 | ivar | 2005-09-09 14:07:06 +0200 (Fri, 09 Sep 2005) | 1 line

update to view 'stats_calls': include departments and companies by name
------------------------------------------------------------------------
r4324 | ivar | 2005-09-09 13:45:05 +0200 (Fri, 09 Sep 2005) | 1 line

2 new cron jobs, also included in setup.sh
------------------------------------------------------------------------
r4322 | apache | 2005-09-09 12:16:02 +0200 (Fri, 09 Sep 2005) | 1 line

submitted database changes as 4322
------------------------------------------------------------------------
r4321 | ivar | 2005-09-09 12:15:59 +0200 (Fri, 09 Sep 2005) | 2 lines

add 2 new views: stats_calls and stats_queues.
These can be combined with select * from stats_calls left outer join stats_queues on (stats_calls.uniqueid=stats_queues.uniqueid);
------------------------------------------------------------------------
r4319 | apache | 2005-09-09 11:27:55 +0200 (Fri, 09 Sep 2005) | 1 line

submitted database changes as 4319
------------------------------------------------------------------------
r4318 | ivar | 2005-09-09 11:27:52 +0200 (Fri, 09 Sep 2005) | 1 line

new field for queue_log: contact, add index on queue_log.uniqueid
------------------------------------------------------------------------
r4317 | apache | 2005-09-09 11:09:16 +0200 (Fri, 09 Sep 2005) | 1 line

submitted database changes as 4317
------------------------------------------------------------------------
r4316 | ivar | 2005-09-09 11:09:13 +0200 (Fri, 09 Sep 2005) | 1 line

add index on cdr.uniqueid
------------------------------------------------------------------------
r4315 | apache | 2005-09-09 11:07:11 +0200 (Fri, 09 Sep 2005) | 1 line

submitted database changes as 4315
------------------------------------------------------------------------
r4314 | ivar | 2005-09-09 11:07:07 +0200 (Fri, 09 Sep 2005) | 1 line

new table: cdr_astium which extends cdr and gets filled by a cron job
------------------------------------------------------------------------
r4282 | apache | 2005-09-07 17:20:06 +0200 (Wed, 07 Sep 2005) | 1 line

submitted database changes as 4282
------------------------------------------------------------------------
r4281 | raarts | 2005-09-07 17:20:03 +0200 (Wed, 07 Sep 2005) | 2 lines

Put in proper permissions for activate and service table.

------------------------------------------------------------------------
r4279 | apache | 2005-09-07 16:47:41 +0200 (Wed, 07 Sep 2005) | 1 line

submitted database changes as 4279
------------------------------------------------------------------------
r4278 | raarts | 2005-09-07 16:47:38 +0200 (Wed, 07 Sep 2005) | 3 lines

Fixed typo in adding queue_prio field. Thank god 
for transactions ;-)

------------------------------------------------------------------------
r4277 | apache | 2005-09-07 16:39:38 +0200 (Wed, 07 Sep 2005) | 1 line

submitted database changes as 4277
------------------------------------------------------------------------
r4276 | raarts | 2005-09-07 16:39:35 +0200 (Wed, 07 Sep 2005) | 3 lines

Add field queue_prio to inbound numbers, to make it possible to 
create high-priority numbers. Also add help, and make new trigger function.

------------------------------------------------------------------------
r4274 | apache | 2005-09-06 23:47:00 +0200 (Tue, 06 Sep 2005) | 1 line

submitted database changes as 4274
------------------------------------------------------------------------
r4273 | raarts | 2005-09-06 23:46:57 +0200 (Tue, 06 Sep 2005) | 3 lines

Did some performance measurements, and as result
created some indexes.

------------------------------------------------------------------------
r4252 | apache | 2005-09-06 11:41:05 +0200 (Tue, 06 Sep 2005) | 1 line

submitted database changes as 4252
------------------------------------------------------------------------
r4251 | ivar | 2005-09-06 11:41:02 +0200 (Tue, 06 Sep 2005) | 1 line

update redirect table to have accurate day of week numbers
------------------------------------------------------------------------
r4245 | raarts | 2005-09-05 01:15:27 +0200 (Mon, 05 Sep 2005) | 3 lines

/var/run/corefiles should be chmod 777 for all processes
to be able to dump core there.

------------------------------------------------------------------------
r4244 | apache | 2005-09-04 16:16:52 +0200 (Sun, 04 Sep 2005) | 1 line

submitted database changes as 4244
------------------------------------------------------------------------
r4243 | raarts | 2005-09-04 16:16:48 +0200 (Sun, 04 Sep 2005) | 3 lines

Add index on the fastdial_company.number field to speed
up searches.

------------------------------------------------------------------------
r4241 | raarts | 2005-09-04 01:44:34 +0200 (Sun, 04 Sep 2005) | 2 lines

Corrected the core patttern.

------------------------------------------------------------------------
r4232 | raarts | 2005-09-01 11:59:03 +0200 (Thu, 01 Sep 2005) | 2 lines

Adapted specfile.

------------------------------------------------------------------------
r4230 | apache | 2005-09-01 10:21:32 +0200 (Thu, 01 Sep 2005) | 1 line

submitted database changes as 4230
------------------------------------------------------------------------
r4229 | raarts | 2005-09-01 10:21:27 +0200 (Thu, 01 Sep 2005) | 17 lines

Split up astium.sql into separate files: one per table.
Also introduced the system where each field has separate
lines below it that define:
- configfiles to regenerated
- services to be restarted
- short and long field help in various languages
Two extra tables are defined: generate, and service.
All other tables now have trigger functions that ensure the tables
generate and service are automatically filled when a field changes.

Also ALL database fields have helptexts attached to them
in both Dutch and English

This is the first update to the 1.0 HEAD branch, still needs some
small testing, especially for upgrading existing systems.


------------------------------------------------------------------------
r4227 | apache | 2005-09-01 09:38:16 +0200 (Thu, 01 Sep 2005) | 1 line

submitted database changes as 4227
------------------------------------------------------------------------
r4226 | ivar | 2005-09-01 09:38:13 +0200 (Thu, 01 Sep 2005) | 1 line

new field for phone: description
------------------------------------------------------------------------
r4204 | apache | 2005-08-29 15:52:14 +0200 (Mon, 29 Aug 2005) | 1 line

submitted database changes as 4204
------------------------------------------------------------------------
r4203 | perry | 2005-08-29 15:52:12 +0200 (Mon, 29 Aug 2005) | 1 line

fixed a sql bug
------------------------------------------------------------------------
r4200 | apache | 2005-08-29 15:43:48 +0200 (Mon, 29 Aug 2005) | 1 line

submitted database changes as 4200
------------------------------------------------------------------------
r4199 | perry | 2005-08-29 15:43:45 +0200 (Mon, 29 Aug 2005) | 1 line

forgot to add the postgresql functions
------------------------------------------------------------------------
r4187 | perry | 2005-08-29 11:19:58 +0200 (Mon, 29 Aug 2005) | 1 line

copy custom crontab config file to /etc during installation of the astium
------------------------------------------------------------------------
r4186 | perry | 2005-08-29 11:18:24 +0200 (Mon, 29 Aug 2005) | 1 line

redirect all output from ntpdate to /dev/null
------------------------------------------------------------------------
r4185 | perry | 2005-08-29 11:17:30 +0200 (Mon, 29 Aug 2005) | 1 line

Added cron.5min to the crontab config
------------------------------------------------------------------------
r4140 | perry | 2005-08-22 12:09:59 +0200 (Mon, 22 Aug 2005) | 2 lines

Added sipgrep 

------------------------------------------------------------------------
r4135 | apache | 2005-08-15 11:26:50 +0200 (Mon, 15 Aug 2005) | 1 line

submitted database changes as 4135
------------------------------------------------------------------------
r4134 | ivar | 2005-08-15 11:26:47 +0200 (Mon, 15 Aug 2005) | 1 line

add column 'contact' to queue_log table
------------------------------------------------------------------------
r4132 | apache | 2005-08-05 11:34:58 +0200 (Fri, 05 Aug 2005) | 1 line

submitted database changes as 4132
------------------------------------------------------------------------
r4131 | ivar | 2005-08-05 11:34:56 +0200 (Fri, 05 Aug 2005) | 2 lines

re-create table queue_log: make some varchar fields longer.
Chosen to re-create because our postgres version doesn't allow altering field types
------------------------------------------------------------------------
r4130 | apache | 2005-08-05 11:02:49 +0200 (Fri, 05 Aug 2005) | 1 line

submitted database changes as 4130
------------------------------------------------------------------------
r4129 | ivar | 2005-08-05 11:02:46 +0200 (Fri, 05 Aug 2005) | 1 line

new table: queue_log for storing queue log data
------------------------------------------------------------------------
r4126 | apache | 2005-08-03 10:28:03 +0200 (Wed, 03 Aug 2005) | 1 line

submitted database changes as 4126
------------------------------------------------------------------------
r4125 | ivar | 2005-08-03 10:28:00 +0200 (Wed, 03 Aug 2005) | 1 line

new column in table contact: pause (yes/no)
------------------------------------------------------------------------
r4117 | apache | 2005-08-01 13:52:34 +0200 (Mon, 01 Aug 2005) | 1 line

submitted database changes as 4117
------------------------------------------------------------------------
r4116 | raarts | 2005-08-01 13:52:31 +0200 (Mon, 01 Aug 2005) | 2 lines

When logging in a user, don't check deleted users

------------------------------------------------------------------------
r4115 | apache | 2005-08-01 12:30:01 +0200 (Mon, 01 Aug 2005) | 1 line

submitted database changes as 4115
------------------------------------------------------------------------
r4114 | raarts | 2005-08-01 12:29:58 +0200 (Mon, 01 Aug 2005) | 2 lines

Removed call_waiting varialbe, we already had callwaiting...

------------------------------------------------------------------------
r4110 | apache | 2005-08-01 11:54:33 +0200 (Mon, 01 Aug 2005) | 1 line

submitted database changes as 4110
------------------------------------------------------------------------
r4109 | raarts | 2005-08-01 11:54:31 +0200 (Mon, 01 Aug 2005) | 2 lines

Add column call_waiting for phones

------------------------------------------------------------------------
r4106 | apache | 2005-08-01 09:05:11 +0200 (Mon, 01 Aug 2005) | 1 line

submitted database changes as 4106
------------------------------------------------------------------------
r4105 | raarts | 2005-08-01 09:05:08 +0200 (Mon, 01 Aug 2005) | 2 lines

Ignore deleted users in some functions.

------------------------------------------------------------------------
r4102 | apache | 2005-07-31 22:43:12 +0200 (Sun, 31 Jul 2005) | 1 line

submitted database changes as 4102
------------------------------------------------------------------------
r4101 | raarts | 2005-07-31 22:43:10 +0200 (Sun, 31 Jul 2005) | 2 lines

Added setting headset, and handset/headset volume for SNOM phones

------------------------------------------------------------------------
r4092 | apache | 2005-07-31 13:42:17 +0200 (Sun, 31 Jul 2005) | 1 line

submitted database changes as 4092
------------------------------------------------------------------------
r4091 | raarts | 2005-07-31 13:42:14 +0200 (Sun, 31 Jul 2005) | 3 lines

Added fields logo_url, directory_url, services_url to phone table.
Initially for use by cisco phones.

------------------------------------------------------------------------
r4089 | apache | 2005-07-30 20:08:03 +0200 (Sat, 30 Jul 2005) | 1 line

submitted database changes as 4089
------------------------------------------------------------------------
r4088 | raarts | 2005-07-30 20:08:00 +0200 (Sat, 30 Jul 2005) | 2 lines

Enlarge the username field to 40 chars

------------------------------------------------------------------------
r4080 | raarts | 2005-07-29 00:23:32 +0200 (Fri, 29 Jul 2005) | 3 lines

Added documentation on how to perform a database
change in HOWTO.CHANGE.

------------------------------------------------------------------------
r4078 | apache | 2005-07-29 00:07:36 +0200 (Fri, 29 Jul 2005) | 1 line

submitted database changes as 4078
------------------------------------------------------------------------
r4077 | raarts | 2005-07-29 00:07:34 +0200 (Fri, 29 Jul 2005) | 2 lines

Corrected SQL functions for logging in/out agents, and users.

------------------------------------------------------------------------
r4066 | apache | 2005-07-26 13:05:37 +0200 (Tue, 26 Jul 2005) | 1 line

submitted database changes as 4066
------------------------------------------------------------------------
r4065 | raarts | 2005-07-26 13:05:34 +0200 (Tue, 26 Jul 2005) | 4 lines

Previously you could only put PEOPLE in queues, but of course
that should be extensions (roles in the future). Fixed.
Also added a flag to honour call-forwards and voicemail in queues.

------------------------------------------------------------------------
r4062 | raarts | 2005-07-25 17:13:16 +0200 (Mon, 25 Jul 2005) | 2 lines

Forgot to add ntpdate.astium to the specfile

------------------------------------------------------------------------
r4060 | apache | 2005-07-25 15:53:46 +0200 (Mon, 25 Jul 2005) | 1 line

submitted database changes as 4060
------------------------------------------------------------------------
r4059 | raarts | 2005-07-25 15:53:42 +0200 (Mon, 25 Jul 2005) | 2 lines

Now login to your phone really works.

------------------------------------------------------------------------
r4049 | apache | 2005-07-18 17:40:26 +0200 (Mon, 18 Jul 2005) | 1 line

submitted database changes as 4049
------------------------------------------------------------------------
r4048 | raarts | 2005-07-18 17:40:24 +0200 (Mon, 18 Jul 2005) | 2 lines

Fixed permissions for redirect table.

------------------------------------------------------------------------
r4045 | apache | 2005-07-18 17:06:16 +0200 (Mon, 18 Jul 2005) | 1 line

submitted database changes as 4045
------------------------------------------------------------------------
r4044 | raarts | 2005-07-18 17:06:14 +0200 (Mon, 18 Jul 2005) | 2 lines

Ignore deleted records in phoneline table

------------------------------------------------------------------------
r4038 | raarts | 2005-07-15 16:24:45 +0200 (Fri, 15 Jul 2005) | 2 lines

Forgot to add ntpdate.astium to the rpm, and corrected default password for Polycom Phones

------------------------------------------------------------------------
r4036 | apache | 2005-07-15 13:58:39 +0200 (Fri, 15 Jul 2005) | 1 line

submitted database changes as 4036
------------------------------------------------------------------------
r4035 | raarts | 2005-07-15 13:58:37 +0200 (Fri, 15 Jul 2005) | 2 lines

Add support for Octo BRI card in the database

------------------------------------------------------------------------
r4028 | apache | 2005-07-12 15:48:59 +0200 (Tue, 12 Jul 2005) | 1 line

submitted database changes as 4028
------------------------------------------------------------------------
r4027 | raarts | 2005-07-12 15:48:57 +0200 (Tue, 12 Jul 2005) | 4 lines

SNOM360 support in the database
Create the correct trunk_sip table layout at initial install
Add empty iax and sip trunk records like the rest of all tables

------------------------------------------------------------------------
r4024 | apache | 2005-07-12 11:48:42 +0200 (Tue, 12 Jul 2005) | 1 line

submitted database changes as 4024
------------------------------------------------------------------------
r4023 | raarts | 2005-07-12 11:48:40 +0200 (Tue, 12 Jul 2005) | 2 lines

Forgot to set permissions for trunk_sip.

------------------------------------------------------------------------
r4022 | apache | 2005-07-12 11:32:18 +0200 (Tue, 12 Jul 2005) | 1 line

submitted database changes as 4022
------------------------------------------------------------------------
r4021 | raarts | 2005-07-12 11:32:15 +0200 (Tue, 12 Jul 2005) | 4 lines

Replace SIP table with a new one, nobody has been using
it anyway, but now the first customer will, so have
to really fix SIP trunk support.

------------------------------------------------------------------------
r3997 | apache | 2005-07-04 12:55:22 +0200 (Mon, 04 Jul 2005) | 1 line

submitted database changes as 3997
------------------------------------------------------------------------
r3996 | raarts | 2005-07-04 12:55:19 +0200 (Mon, 04 Jul 2005) | 2 lines

Now really drop the trigger to create a mail account

------------------------------------------------------------------------
r3983 | apache | 2005-06-24 14:52:10 +0200 (Fri, 24 Jun 2005) | 1 line

submitted database changes as 3983
------------------------------------------------------------------------
r3982 | raarts | 2005-06-24 14:52:08 +0200 (Fri, 24 Jun 2005) | 2 lines

Add database support for te110p

------------------------------------------------------------------------
r3962 | raarts | 2005-06-20 14:15:57 +0200 (Mon, 20 Jun 2005) | 3 lines

Re-organize order of creating tables, to eliminate errors
Added card_te110p and grants. Fixed small error in default companies.

------------------------------------------------------------------------
r3948 | raarts | 2005-06-08 22:33:33 +0200 (Wed, 08 Jun 2005) | 2 lines

Don't support Open Exchange any more, so dropped problematic trigger.

------------------------------------------------------------------------
r3947 | raarts | 2005-06-08 22:23:44 +0200 (Wed, 08 Jun 2005) | 2 lines

Extension number length was default '1', changed to '4'

------------------------------------------------------------------------
r3884 | wijnand | 2005-05-11 11:30:18 +0200 (Wed, 11 May 2005) | 2 lines

Make amavisd less verbose with logging in the template (if that is used). Level 0 is enough.

------------------------------------------------------------------------
r3880 | raarts | 2005-05-09 14:43:11 +0200 (Mon, 09 May 2005) | 2 lines

Reorganized tables, to fix dependency problem in FOREIGN KEY statements

------------------------------------------------------------------------
r3876 | apache | 2005-05-09 10:31:56 +0200 (Mon, 09 May 2005) | 1 line

submitted database changes as 3876
------------------------------------------------------------------------
r3875 | raarts | 2005-05-09 10:31:53 +0200 (Mon, 09 May 2005) | 2 lines

Added column 'company' to trunk_sip. Other trunktypes have it too.

------------------------------------------------------------------------
r3874 | apache | 2005-05-09 10:27:52 +0200 (Mon, 09 May 2005) | 1 line

submitted database changes as 3874
------------------------------------------------------------------------
r3873 | raarts | 2005-05-09 10:27:49 +0200 (Mon, 09 May 2005) | 2 lines

Add table card_te110p

------------------------------------------------------------------------
r3734 | ivar | 2005-04-14 16:19:16 +0200 (Thu, 14 Apr 2005) | 1 line

alias to enable user to play soundfiles of monitored calls
------------------------------------------------------------------------
r3710 | raarts | 2005-04-13 15:50:47 +0200 (Wed, 13 Apr 2005) | 2 lines

Now correctly enable services

------------------------------------------------------------------------
r3702 | raarts | 2005-04-12 16:08:06 +0200 (Tue, 12 Apr 2005) | 2 lines

From now on create all coredumps in /var/run/corefiles

------------------------------------------------------------------------
r3696 | apache | 2005-04-06 22:39:08 +0200 (Wed, 06 Apr 2005) | 1 line

submitted database changes as 3696
------------------------------------------------------------------------
r3695 | raarts | 2005-04-06 22:39:06 +0200 (Wed, 06 Apr 2005) | 2 lines

Added foreign keys for the phoneline field in trunk_*

------------------------------------------------------------------------
r3694 | apache | 2005-04-06 22:36:08 +0200 (Wed, 06 Apr 2005) | 1 line

submitted database changes as 3694
------------------------------------------------------------------------
r3693 | raarts | 2005-04-06 22:36:06 +0200 (Wed, 06 Apr 2005) | 5 lines

Added function to retrieve the actual voicemailbox for an extension,
so we can use that in the dialplan
Added phoneline reference to all trunks, so we can redirect incoming calls
immediately to a trunk.

------------------------------------------------------------------------
r3686 | apache | 2005-04-06 15:30:09 +0200 (Wed, 06 Apr 2005) | 1 line

submitted database changes as 3686
------------------------------------------------------------------------
r3685 | ivar | 2005-04-06 15:30:07 +0200 (Wed, 06 Apr 2005) | 1 line

re-activated trigger
------------------------------------------------------------------------
r3681 | apache | 2005-04-06 13:52:10 +0200 (Wed, 06 Apr 2005) | 1 line

submitted database changes as 3681
------------------------------------------------------------------------
r3680 | ivar | 2005-04-06 13:52:07 +0200 (Wed, 06 Apr 2005) | 1 line

make mailaccount.username varchar(8) instead of varchar(16)
------------------------------------------------------------------------
r3672 | raarts | 2005-04-01 21:35:33 +0200 (Fri, 01 Apr 2005) | 2 lines

Oops, trunk_iax2 was renamed to trunk_iax

------------------------------------------------------------------------
r3664 | apache | 2005-03-30 23:59:29 +0200 (Wed, 30 Mar 2005) | 1 line

submitted database changes as 3664
------------------------------------------------------------------------
r3663 | raarts | 2005-03-30 23:59:26 +0200 (Wed, 30 Mar 2005) | 2 lines

Added support for IAX trunks etc

------------------------------------------------------------------------
r3646 | raarts | 2005-03-21 12:05:08 +0100 (Mon, 21 Mar 2005) | 2 lines

Also start pptpd by default

------------------------------------------------------------------------
r3641 | apache | 2005-03-18 15:53:32 +0100 (Fri, 18 Mar 2005) | 1 line

submitted database changes as 3641
------------------------------------------------------------------------
r3640 | raarts | 2005-03-18 15:53:30 +0100 (Fri, 18 Mar 2005) | 4 lines

Added Notes to a trunk definition
Support Call recording in the dialplan. Next: listening from the web.
Support turning of voicemail altogether for an extension.

------------------------------------------------------------------------
r3634 | raarts | 2005-03-18 10:11:41 +0100 (Fri, 18 Mar 2005) | 2 lines

Improve sound quality when IDE drives are used.

------------------------------------------------------------------------
r3632 | raarts | 2005-03-17 22:04:57 +0100 (Thu, 17 Mar 2005) | 2 lines

Made apply-changes executable

------------------------------------------------------------------------
r3631 | raarts | 2005-03-17 21:51:12 +0100 (Thu, 17 Mar 2005) | 2 lines

Added apply-changes to the RPM

------------------------------------------------------------------------
r3630 | apache | 2005-03-17 21:15:24 +0100 (Thu, 17 Mar 2005) | 1 line

submitted database changes as 3630
------------------------------------------------------------------------
r3629 | raarts | 2005-03-17 21:15:22 +0100 (Thu, 17 Mar 2005) | 2 lines

first actual try of updating the database

------------------------------------------------------------------------
r3628 | raarts | 2005-03-17 21:09:05 +0100 (Thu, 17 Mar 2005) | 2 lines

More work for auto-updating database

------------------------------------------------------------------------
r3627 | apache | 2005-03-17 20:04:52 +0100 (Thu, 17 Mar 2005) | 1 line

submitted database changes as 3627
------------------------------------------------------------------------
r3626 | raarts | 2005-03-17 20:04:50 +0100 (Thu, 17 Mar 2005) | 2 lines

Another test. Keeps us busy.

------------------------------------------------------------------------
r3625 | apache | 2005-03-17 17:50:43 +0100 (Thu, 17 Mar 2005) | 1 line

submitted database changes as 3625
------------------------------------------------------------------------
r3624 | raarts | 2005-03-17 17:50:41 +0100 (Thu, 17 Mar 2005) | 2 lines

Another one

------------------------------------------------------------------------
r3623 | raarts | 2005-03-17 17:49:02 +0100 (Thu, 17 Mar 2005) | 2 lines

Why not another test??

------------------------------------------------------------------------
r3622 | raarts | 2005-03-17 17:47:28 +0100 (Thu, 17 Mar 2005) | 2 lines

Encore a test

------------------------------------------------------------------------
r3621 | raarts | 2005-03-17 17:46:14 +0100 (Thu, 17 Mar 2005) | 2 lines

Another one. Sorry.

------------------------------------------------------------------------
r3620 | raarts | 2005-03-17 17:44:41 +0100 (Thu, 17 Mar 2005) | 2 lines

Another test.

------------------------------------------------------------------------
r3619 | raarts | 2005-03-17 17:39:54 +0100 (Thu, 17 Mar 2005) | 2 lines

Test again

------------------------------------------------------------------------
r3618 | raarts | 2005-03-17 17:36:06 +0100 (Thu, 17 Mar 2005) | 2 lines

Whoops, test astium-setup auto-database change feature

------------------------------------------------------------------------
r3617 | raarts | 2005-03-17 17:26:53 +0100 (Thu, 17 Mar 2005) | 2 lines

Added changes directory

------------------------------------------------------------------------
r3615 | raarts | 2005-03-17 10:53:35 +0100 (Thu, 17 Mar 2005) | 2 lines

Added astglobals field: dbversion

------------------------------------------------------------------------
r3610 | raarts | 2005-03-16 18:33:22 +0100 (Wed, 16 Mar 2005) | 2 lines

Improved voicemail message layout.

------------------------------------------------------------------------
r3605 | raarts | 2005-03-16 09:00:03 +0100 (Wed, 16 Mar 2005) | 2 lines

Reboot the machine when an Oops or kernel panic happens

------------------------------------------------------------------------
r3357 | raarts | 2005-03-13 15:17:34 +0100 (Sun, 13 Mar 2005) | 1 line

create 1.0 branch for astium-setup
------------------------------------------------------------------------
r3127 | raarts | 2005-03-03 10:36:36 +0100 (Thu, 03 Mar 2005) | 2 lines

Aastra 480i support

------------------------------------------------------------------------
r3050 | raarts | 2005-02-26 23:18:11 +0100 (Sat, 26 Feb 2005) | 2 lines

Added function to put fastdial company name on phone display

------------------------------------------------------------------------
r3046 | raarts | 2005-02-25 14:09:28 +0100 (Fri, 25 Feb 2005) | 2 lines

Set proper defaults for busydetect

------------------------------------------------------------------------
r3036 | ivar | 2005-02-22 15:58:59 +0100 (Tue, 22 Feb 2005) | 1 line

replaced field phoneline in redirect by field inbound
------------------------------------------------------------------------
r3028 | ivar | 2005-02-22 11:17:10 +0100 (Tue, 22 Feb 2005) | 1 line

put redirect_on in inbound instead of phoneline
------------------------------------------------------------------------
r3027 | ivar | 2005-02-22 11:15:18 +0100 (Tue, 22 Feb 2005) | 1 line

use redirect_on in inbound instead of phoneline
------------------------------------------------------------------------
r3025 | ivar | 2005-02-22 10:51:08 +0100 (Tue, 22 Feb 2005) | 1 line

altered function mustredirect to work with redirect.inbound instead of redirect.phoneline
------------------------------------------------------------------------
r3021 | raarts | 2005-02-21 16:44:58 +0100 (Mon, 21 Feb 2005) | 2 lines

ntp1.netland.nl should be ntp1.neonova.nl

------------------------------------------------------------------------
r3019 | raarts | 2005-02-21 16:03:05 +0100 (Mon, 21 Feb 2005) | 2 lines

Add ntpdate to the Astium

------------------------------------------------------------------------
r3015 | raarts | 2005-02-21 14:18:39 +0100 (Mon, 21 Feb 2005) | 2 lines

LDAP should always run.

------------------------------------------------------------------------
r3014 | ivar | 2005-02-21 12:11:04 +0100 (Mon, 21 Feb 2005) | 1 line

de-activated one trigger which broke add-department
------------------------------------------------------------------------
r3008 | raarts | 2005-02-21 10:04:16 +0100 (Mon, 21 Feb 2005) | 2 lines

Fixed some defaults for zap channels: callwaiting defaults to off now.

------------------------------------------------------------------------
r3004 | raarts | 2005-02-20 23:47:28 +0100 (Sun, 20 Feb 2005) | 3 lines

Added column 'maxtime' to queue table, for telling how a long
a user can reside in a queue.

------------------------------------------------------------------------
r2999 | ivar | 2005-02-17 16:04:51 +0100 (Thu, 17 Feb 2005) | 1 line

new function: mustredirect(phonelineid) returns ivrmenu to redirect to (if any)
------------------------------------------------------------------------
r2991 | ivar | 2005-02-16 15:48:25 +0100 (Wed, 16 Feb 2005) | 1 line

new 'allow_add_fastdial' field should be default 'no'
------------------------------------------------------------------------
r2990 | ivar | 2005-02-16 15:46:13 +0100 (Wed, 16 Feb 2005) | 1 line

new field 'allow_add_fastdial' in contact table to specify this contact is allowed to add entries in company fastdial
------------------------------------------------------------------------
r2984 | ivar | 2005-02-16 11:46:27 +0100 (Wed, 16 Feb 2005) | 1 line

new table: redirect
------------------------------------------------------------------------
r2975 | ivar | 2005-02-09 12:13:54 +0100 (Wed, 09 Feb 2005) | 1 line

have default entries in domain table for all companies, because a trigger which creates mailaccounts when users are created relies on this
------------------------------------------------------------------------
r2960 | ivar | 2005-02-03 16:08:26 +0100 (Thu, 03 Feb 2005) | 1 line

added warning in astium.sql where special extensions are inserted
------------------------------------------------------------------------
r2949 | raarts | 2005-02-02 09:06:13 +0100 (Wed, 02 Feb 2005) | 2 lines

Added grants for calendar

------------------------------------------------------------------------
r2948 | raarts | 2005-02-02 09:02:03 +0100 (Wed, 02 Feb 2005) | 4 lines

Expanded personal contact list to match capabilities of
the Polycom phones.
Add logdirectory for polycom phones

------------------------------------------------------------------------
r2923 | raarts | 2005-01-29 13:30:41 +0100 (Sat, 29 Jan 2005) | 2 lines

Allow setting prilocaldialplan to 'dynamic'

------------------------------------------------------------------------
r2915 | raarts | 2005-01-28 17:26:28 +0100 (Fri, 28 Jan 2005) | 2 lines

Implemented '##' (redial last number)

------------------------------------------------------------------------
r2913 | raarts | 2005-01-28 12:52:57 +0100 (Fri, 28 Jan 2005) | 2 lines

Renamed lastnumber to lastdial

------------------------------------------------------------------------
r2912 | raarts | 2005-01-28 12:52:27 +0100 (Fri, 28 Jan 2005) | 3 lines

Added 'lastnumber' to the contact table, to remember the number
she last dialled.

------------------------------------------------------------------------
r2909 | raarts | 2005-01-28 12:45:29 +0100 (Fri, 28 Jan 2005) | 2 lines

Implemented fastdial support in the dialplan.

------------------------------------------------------------------------
r2907 | raarts | 2005-01-26 16:47:10 +0100 (Wed, 26 Jan 2005) | 2 lines

Support for dynamic PRI dialplan.

------------------------------------------------------------------------
r2899 | raarts | 2005-01-25 16:47:20 +0100 (Tue, 25 Jan 2005) | 2 lines

Implemented extension length handling

------------------------------------------------------------------------
r2892 | ivar | 2005-01-21 16:04:24 +0100 (Fri, 21 Jan 2005) | 1 line

also renamed & reordered default main menu for company 'owner'
------------------------------------------------------------------------
r2883 | raarts | 2005-01-19 09:51:56 +0100 (Wed, 19 Jan 2005) | 2 lines

Added function getuserbylogin which is needed by *1

------------------------------------------------------------------------
r2881 | raarts | 2005-01-17 16:59:22 +0100 (Mon, 17 Jan 2005) | 3 lines

Moved callrouting from the system menu to the company menu.
This involved adding a company field to the callrouting table.

------------------------------------------------------------------------
r2877 | ivar | 2005-01-17 16:25:25 +0100 (Mon, 17 Jan 2005) | 1 line

add database field for table company: deflang (default language)
------------------------------------------------------------------------
r2874 | raarts | 2005-01-16 23:52:28 +0100 (Sun, 16 Jan 2005) | 4 lines

Added column 'alarm' to zap_channel. In the near future
this column will reflect the physical status of the ISDN line
(is an ISDN line really present, is sync OK etc)

------------------------------------------------------------------------
r2873 | raarts | 2005-01-16 16:12:14 +0100 (Sun, 16 Jan 2005) | 2 lines

Only start astium services whem astium_on = yes in astglobals

------------------------------------------------------------------------
r2872 | raarts | 2005-01-16 16:09:12 +0100 (Sun, 16 Jan 2005) | 2 lines

Now only start nbs services when enabled in astglobals

------------------------------------------------------------------------
r2867 | raarts | 2005-01-16 01:19:10 +0100 (Sun, 16 Jan 2005) | 4 lines

Reordered phoneline function list
Added database queue function
Added penalty for queues

------------------------------------------------------------------------
r2865 | raarts | 2005-01-15 14:33:49 +0100 (Sat, 15 Jan 2005) | 4 lines

Put in a bit more reasonable defaults for queues:
- default wrapup time set to zero, same as asterisk default
- when a queue is empty (no agents) no customer can enter the queue.

------------------------------------------------------------------------
r2863 | matthias | 2005-01-14 16:53:06 +0100 (Fri, 14 Jan 2005) | 1 line

helper view for trigger to sync mail accounts with contacts
------------------------------------------------------------------------
r2862 | matthias | 2005-01-14 16:51:53 +0100 (Fri, 14 Jan 2005) | 1 line

add a trigger to add mailaccounts when a user is created, it depends on view domain_company to make it more readable for the developers. TODO: create a trigger to change mailaccount passwords when a contact password is changed
------------------------------------------------------------------------
r2861 | matthias | 2005-01-14 16:05:39 +0100 (Fri, 14 Jan 2005) | 1 line

mailbox mapper is obsolete
------------------------------------------------------------------------
r2860 | matthias | 2005-01-14 13:35:50 +0100 (Fri, 14 Jan 2005) | 1 line

astium backup fix for cron
------------------------------------------------------------------------
r2859 | matthias | 2005-01-14 11:22:53 +0100 (Fri, 14 Jan 2005) | 1 line

add a view to make mailaccount adding easier
------------------------------------------------------------------------
r2851 | matthias | 2005-01-12 11:08:55 +0100 (Wed, 12 Jan 2005) | 2 lines

changed ldap from wide open access to a restrictive access, drawback ldap clients who
read in OX cannot see their own contacts anymore
------------------------------------------------------------------------
r2849 | ivar | 2005-01-11 16:02:50 +0100 (Tue, 11 Jan 2005) | 1 line

have default 'main' ivrmenu be for company who is owner, not Neonova
------------------------------------------------------------------------
r2831 | matthias | 2005-01-06 15:17:33 +0100 (Thu, 06 Jan 2005) | 1 line

add status field for mailaccounts
------------------------------------------------------------------------
r2826 | ivar | 2005-01-05 15:53:44 +0100 (Wed, 05 Jan 2005) | 1 line

put standard functional extensions in database for company 'owner'
------------------------------------------------------------------------
r2820 | ivar | 2005-01-03 13:41:45 +0100 (Mon, 03 Jan 2005) | 2 lines

new field in contact: visible (yes/no)

------------------------------------------------------------------------
r2816 | raarts | 2004-12-31 13:43:50 +0100 (Fri, 31 Dec 2004) | 3 lines

We don't use runlevel 4 (yet), and I think it will be used
for Xen in the future.

------------------------------------------------------------------------
r2798 | matthias | 2004-12-28 11:26:57 +0100 (Tue, 28 Dec 2004) | 1 line


------------------------------------------------------------------------
r2793 | matthias | 2004-12-27 10:01:00 +0100 (Mon, 27 Dec 2004) | 1 line

make astium httpd work with its own ssl certificates
------------------------------------------------------------------------
r2783 | raarts | 2004-12-23 23:58:51 +0100 (Thu, 23 Dec 2004) | 2 lines

Implemented conference retention using an astglobal value

------------------------------------------------------------------------
r2782 | raarts | 2004-12-23 23:31:09 +0100 (Thu, 23 Dec 2004) | 3 lines

Implement absolute voicemail retention time, added grants
for certificate store

------------------------------------------------------------------------
r2772 | matthias | 2004-12-23 12:09:17 +0100 (Thu, 23 Dec 2004) | 1 line

fixed the view for matching users to their ox department groups
------------------------------------------------------------------------
r2765 | raarts | 2004-12-22 22:19:15 +0100 (Wed, 22 Dec 2004) | 6 lines

Implemented setting of:
- conference retention period
- voicemail retention period
- message waiting indication
- message waiting dialtone

------------------------------------------------------------------------
r2763 | ivar | 2004-12-22 16:24:52 +0100 (Wed, 22 Dec 2004) | 1 line

have first queue name be 'empty'
------------------------------------------------------------------------
r2762 | ivar | 2004-12-22 16:18:57 +0100 (Wed, 22 Dec 2004) | 1 line

added field 'name' to table 'queue'
------------------------------------------------------------------------
r2757 | ivar | 2004-12-22 12:09:26 +0100 (Wed, 22 Dec 2004) | 2 lines

default value for function field in phoneline becomes 'normal'

------------------------------------------------------------------------
r2752 | ivar | 2004-12-21 16:20:23 +0100 (Tue, 21 Dec 2004) | 1 line

new field in phoneline: function
------------------------------------------------------------------------
r2749 | matthias | 2004-12-21 14:51:47 +0100 (Tue, 21 Dec 2004) | 1 line

also backup ox database and the contents of ldap
------------------------------------------------------------------------
r2748 | matthias | 2004-12-21 14:50:01 +0100 (Tue, 21 Dec 2004) | 1 line

add triggers for activation of mailboxes
------------------------------------------------------------------------
r2744 | ivar | 2004-12-21 11:04:34 +0100 (Tue, 21 Dec 2004) | 1 line

two new fields for both fastdial_* tables
------------------------------------------------------------------------
r2738 | matthias | 2004-12-21 10:06:49 +0100 (Tue, 21 Dec 2004) | 1 line

allow spaces in astium serials
------------------------------------------------------------------------
r2735 | raarts | 2004-12-20 16:20:35 +0100 (Mon, 20 Dec 2004) | 12 lines

Completed macro(require-pin) support.
Also you can now do:

  select requeue(34);

instead of:

  update activate set status = 'QUEUED' where id = 34;

Do I make it easy for you or not?


------------------------------------------------------------------------
r2729 | ivar | 2004-12-20 12:54:05 +0100 (Mon, 20 Dec 2004) | 1 line

grant to astium on new tables
------------------------------------------------------------------------
r2728 | ivar | 2004-12-20 12:38:26 +0100 (Mon, 20 Dec 2004) | 1 line

inserted into astglobals, new group: fastdial, with two entries: fastdial number length for company & for contact
------------------------------------------------------------------------
r2727 | ivar | 2004-12-20 12:31:44 +0100 (Mon, 20 Dec 2004) | 1 line

oops small bug, fixed
------------------------------------------------------------------------
r2725 | matthias | 2004-12-20 12:16:49 +0100 (Mon, 20 Dec 2004) | 1 line

small bug fix in setup.sh
------------------------------------------------------------------------
r2724 | ivar | 2004-12-20 12:16:44 +0100 (Mon, 20 Dec 2004) | 1 line

split fastdial into two tables: fastdial_company & fastdial_contact
------------------------------------------------------------------------
r2719 | matthias | 2004-12-20 09:43:07 +0100 (Mon, 20 Dec 2004) | 1 line

insert the astium serial in the database
------------------------------------------------------------------------
r2718 | matthias | 2004-12-20 08:45:31 +0100 (Mon, 20 Dec 2004) | 1 line

add backup script for the astium
------------------------------------------------------------------------
r2713 | ivar | 2004-12-17 15:14:54 +0100 (Fri, 17 Dec 2004) | 1 line

added new empty entry in ivrmenu
------------------------------------------------------------------------
r2711 | ivar | 2004-12-17 13:47:54 +0100 (Fri, 17 Dec 2004) | 1 line

database astium is no longer created with apache as owner
------------------------------------------------------------------------
r2710 | ivar | 2004-12-17 12:14:31 +0100 (Fri, 17 Dec 2004) | 1 line

removed didnumber from database
------------------------------------------------------------------------
r2707 | matthias | 2004-12-17 10:43:20 +0100 (Fri, 17 Dec 2004) | 1 line

added serial number of the astium in the database
------------------------------------------------------------------------
r2691 | matthias | 2004-12-15 15:21:19 +0100 (Wed, 15 Dec 2004) | 1 line

entering astium serial
------------------------------------------------------------------------
r2690 | ivar | 2004-12-15 14:47:16 +0100 (Wed, 15 Dec 2004) | 1 line

have phone.codec* default be 'ulaw'
------------------------------------------------------------------------
r2688 | raarts | 2004-12-15 14:09:19 +0100 (Wed, 15 Dec 2004) | 3 lines

Ivar's fingers have a tendency to swap the letters 'p' and 't'
in the word 'empty'....

------------------------------------------------------------------------
r2683 | matthias | 2004-12-14 16:37:55 +0100 (Tue, 14 Dec 2004) | 1 line

add the certificate store for backing up certs
------------------------------------------------------------------------
r2679 | ivar | 2004-12-14 14:09:17 +0100 (Tue, 14 Dec 2004) | 1 line

put dns domain in astglobals
------------------------------------------------------------------------
r2676 | raarts | 2004-12-14 09:32:21 +0100 (Tue, 14 Dec 2004) | 5 lines

To ensure we can order SELECTs by position in the ivrmenu and that
the welcome menu comes first, changed the string 'welcome' into '!'
because the exclamation mark comes before '*', '#', and the digits
in the ascii table.

------------------------------------------------------------------------
r2675 | ivar | 2004-12-13 16:46:04 +0100 (Mon, 13 Dec 2004) | 1 line

typo: REATE should be CREATE
------------------------------------------------------------------------
r2674 | raarts | 2004-12-13 15:02:44 +0100 (Mon, 13 Dec 2004) | 2 lines

Added soundfile to the list of files to be distributed

------------------------------------------------------------------------
r2665 | matthias | 2004-12-10 13:53:35 +0100 (Fri, 10 Dec 2004) | 1 line

make sql changes for adding departments as groups to ox
------------------------------------------------------------------------
r2664 | matthias | 2004-12-10 11:34:50 +0100 (Fri, 10 Dec 2004) | 1 line

Make domain company linking work
------------------------------------------------------------------------
r2662 | matthias | 2004-12-09 12:34:47 +0100 (Thu, 09 Dec 2004) | 1 line

make mailbox 1 on 1 relation with contact
------------------------------------------------------------------------
r2661 | matthias | 2004-12-09 12:30:34 +0100 (Thu, 09 Dec 2004) | 1 line

make mailbox 1 on 1 relation with contact
------------------------------------------------------------------------
r2656 | raarts | 2004-12-08 17:47:19 +0100 (Wed, 08 Dec 2004) | 2 lines

Removed old gettrunk function

------------------------------------------------------------------------
r2652 | ivar | 2004-12-08 16:07:04 +0100 (Wed, 08 Dec 2004) | 1 line

fastdial becomes company-wide instead of per phoneline
------------------------------------------------------------------------
r2649 | ivar | 2004-12-08 15:41:12 +0100 (Wed, 08 Dec 2004) | 1 line

add some spacing, no real change
------------------------------------------------------------------------
r2643 | raarts | 2004-12-08 13:58:32 +0100 (Wed, 08 Dec 2004) | 2 lines

Put soundfile.sql also in .rpm

------------------------------------------------------------------------
r2642 | ivar | 2004-12-08 13:52:37 +0100 (Wed, 08 Dec 2004) | 1 line

fixed bugs
------------------------------------------------------------------------
r2641 | matthias | 2004-12-08 13:49:31 +0100 (Wed, 08 Dec 2004) | 1 line

changed the view so we can add in ox the user to a group matching his company
------------------------------------------------------------------------
r2640 | ivar | 2004-12-08 12:29:12 +0100 (Wed, 08 Dec 2004) | 1 line

company 'owner' had shortname 'reseller'. This is wrong, fixed it
------------------------------------------------------------------------
r2630 | ivar | 2004-12-08 09:28:05 +0100 (Wed, 08 Dec 2004) | 1 line

tables 'inbound' and 'ivrmenu' now have fields phoneline1..3
------------------------------------------------------------------------
r2624 | ivar | 2004-12-07 14:42:20 +0100 (Tue, 07 Dec 2004) | 1 line

updated astmessage list (help)
------------------------------------------------------------------------
r2617 | ivar | 2004-12-07 11:18:55 +0100 (Tue, 07 Dec 2004) | 1 line

have reference from ivrmenu to ivrmenu be based on name rather than id
------------------------------------------------------------------------
r2610 | ivar | 2004-12-06 14:31:00 +0100 (Mon, 06 Dec 2004) | 1 line

changed ivrmenu structure again; have welcome soundfile be named 'welcome'
------------------------------------------------------------------------
r2608 | ivar | 2004-12-06 12:23:02 +0100 (Mon, 06 Dec 2004) | 1 line

change to table ivrmenu: field position is now char
------------------------------------------------------------------------
r2607 | ivar | 2004-12-06 12:16:24 +0100 (Mon, 06 Dec 2004) | 1 line

varchar fields were too short, gone from 16 to 32
------------------------------------------------------------------------
r2606 | ivar | 2004-12-06 12:15:26 +0100 (Mon, 06 Dec 2004) | 1 line

changed type of queue.queue_* fields from integer to varchar (name)
------------------------------------------------------------------------
r2605 | raarts | 2004-12-06 11:44:24 +0100 (Mon, 06 Dec 2004) | 2 lines

Do not include customer sounds in our list.

------------------------------------------------------------------------
r2604 | raarts | 2004-12-06 11:18:19 +0100 (Mon, 06 Dec 2004) | 4 lines

Now imports the list of soundfiles from the cmsneonova
database on the cms-db server, so we can use these sounds
in IVR menu's and the like.

------------------------------------------------------------------------
r2603 | raarts | 2004-12-06 11:00:33 +0100 (Mon, 06 Dec 2004) | 2 lines

Added soundfile import

------------------------------------------------------------------------
r2599 | raarts | 2004-12-03 16:11:13 +0100 (Fri, 03 Dec 2004) | 2 lines

Added grants for national_dialplan table;

------------------------------------------------------------------------
r2598 | ivar | 2004-12-03 16:01:28 +0100 (Fri, 03 Dec 2004) | 1 line

set permissions for new tables
------------------------------------------------------------------------
r2596 | ivar | 2004-12-03 14:53:35 +0100 (Fri, 03 Dec 2004) | 1 line

new table: queue_contact
------------------------------------------------------------------------
r2583 | ivar | 2004-12-02 14:18:31 +0100 (Thu, 02 Dec 2004) | 1 line

i just threw out the Polycom phones - here they are agin
------------------------------------------------------------------------
r2582 | ivar | 2004-12-02 14:13:57 +0100 (Thu, 02 Dec 2004) | 1 line

new table: queue
------------------------------------------------------------------------
r2573 | raarts | 2004-12-01 17:13:13 +0100 (Wed, 01 Dec 2004) | 2 lines

Polycom SoundPoint IP support

------------------------------------------------------------------------
r2551 | raarts | 2004-12-01 12:15:59 +0100 (Wed, 01 Dec 2004) | 2 lines

Add default ftp user for phone configurations (Polycom support)

------------------------------------------------------------------------
r2550 | ivar | 2004-12-01 11:43:27 +0100 (Wed, 01 Dec 2004) | 1 line

soundfile now has default INSERT statement, id: 1 name: empty. ivrmenu by default references this entry
------------------------------------------------------------------------
r2549 | raarts | 2004-12-01 11:12:13 +0100 (Wed, 01 Dec 2004) | 3 lines

Polycom phones support: because Polycom phones need an FTP server 
for configuration/provisioning, enable vsftpd from now on.

------------------------------------------------------------------------
r2540 | raarts | 2004-11-30 15:04:03 +0100 (Tue, 30 Nov 2004) | 2 lines

dhcpd now defaults to OFF. Can be enabled though astglobals.

------------------------------------------------------------------------
r2533 | ivar | 2004-11-29 16:41:15 +0100 (Mon, 29 Nov 2004) | 1 line

new table: phoneline_member to create groups of phonelines which itself has characteristics of a phoneline
------------------------------------------------------------------------
r2531 | ivar | 2004-11-29 16:29:46 +0100 (Mon, 29 Nov 2004) | 1 line

new table: ivrmenu
------------------------------------------------------------------------
r2521 | raarts | 2004-11-29 11:52:03 +0100 (Mon, 29 Nov 2004) | 3 lines

Spelling error in cREATE statement, fixed some SQL functions,
due to database change related to hot-desking.

------------------------------------------------------------------------
r2515 | ivar | 2004-11-29 09:46:24 +0100 (Mon, 29 Nov 2004) | 1 line

astglobals:soundfilepath changed again - just made a mistake
------------------------------------------------------------------------
r2514 | ivar | 2004-11-29 09:35:19 +0100 (Mon, 29 Nov 2004) | 1 line

astglobals:soundfilepath changed.
------------------------------------------------------------------------
r2512 | raarts | 2004-11-26 09:59:39 +0100 (Fri, 26 Nov 2004) | 2 lines

Rearragned allow_* a bit. Split entertain into premium and entertain, added adult.

------------------------------------------------------------------------
r2509 | raarts | 2004-11-25 17:31:24 +0100 (Thu, 25 Nov 2004) | 4 lines

Created table for national dialplans containing numbers and their
type, like 0800 = tollfree etcetera. This differs per country.
Also fixed typo in defining pin numbers

------------------------------------------------------------------------
r2504 | ivar | 2004-11-25 13:41:54 +0100 (Thu, 25 Nov 2004) | 1 line

corrected spelling: multi-tenaNting
------------------------------------------------------------------------
r2496 | ivar | 2004-11-24 14:35:11 +0100 (Wed, 24 Nov 2004) | 1 line

give user astium permission to access new table soundfile
------------------------------------------------------------------------
r2494 | ivar | 2004-11-24 14:23:48 +0100 (Wed, 24 Nov 2004) | 1 line

added astglobals entry: sounfilepath for location of sound files
------------------------------------------------------------------------
r2493 | ivar | 2004-11-24 14:21:06 +0100 (Wed, 24 Nov 2004) | 1 line

added table: soundfile
------------------------------------------------------------------------
r2485 | raarts | 2004-11-24 12:38:27 +0100 (Wed, 24 Nov 2004) | 2 lines

Implemented hotdesking functions in the db

------------------------------------------------------------------------
r2483 | ivar | 2004-11-24 11:20:22 +0100 (Wed, 24 Nov 2004) | 1 line

gave 'emtpy' entry in table 'domain' status 'inactive'
------------------------------------------------------------------------
r2481 | ivar | 2004-11-23 17:29:12 +0100 (Tue, 23 Nov 2004) | 1 line

for empty company also give shortname=empty
------------------------------------------------------------------------
r2471 | ivar | 2004-11-22 10:30:37 +0100 (Mon, 22 Nov 2004) | 1 line

hotdesking in astglobals
------------------------------------------------------------------------
r2469 | ivar | 2004-11-19 16:52:54 +0100 (Fri, 19 Nov 2004) | 1 line

add field 'pin' to table 'contact'
------------------------------------------------------------------------
r2465 | ivar | 2004-11-19 16:27:10 +0100 (Fri, 19 Nov 2004) | 1 line

all companies must have shortname, including NeoNova, owner and reseller
------------------------------------------------------------------------
r2463 | ivar | 2004-11-19 16:03:07 +0100 (Fri, 19 Nov 2004) | 1 line

sip_incominglimit removed
------------------------------------------------------------------------
r2461 | matthias | 2004-11-19 15:57:03 +0100 (Fri, 19 Nov 2004) | 1 line

create view for friendly interfaces, done so postfix can differentiate between friendly en hostile LANs
------------------------------------------------------------------------
r2457 | matthias | 2004-11-19 13:36:21 +0100 (Fri, 19 Nov 2004) | 1 line

easier reading of the postfix configs
------------------------------------------------------------------------
r2456 | raarts | 2004-11-19 13:22:39 +0100 (Fri, 19 Nov 2004) | 2 lines

Phone numbers in Belgium are not 10 but 9 digits long.

------------------------------------------------------------------------
r2454 | matthias | 2004-11-19 12:31:42 +0100 (Fri, 19 Nov 2004) | 1 line

add virusscanner enable/disable to astglobals, due to license sophos is default off, clam is enabled
------------------------------------------------------------------------
r2446 | ivar | 2004-11-18 15:02:41 +0100 (Thu, 18 Nov 2004) | 1 line

nieuwe help teksten van JeroenB
------------------------------------------------------------------------
r2436 | matthias | 2004-11-17 16:37:26 +0100 (Wed, 17 Nov 2004) | 1 line

remove example line to make freshclam work
------------------------------------------------------------------------
r2433 | matthias | 2004-11-17 14:46:01 +0100 (Wed, 17 Nov 2004) | 1 line

make spamassassin work with dccifd
------------------------------------------------------------------------
r2428 | ivar | 2004-11-17 11:42:53 +0100 (Wed, 17 Nov 2004) | 1 line

oops - profile 3 was in use by analog, softphones now profile 4
------------------------------------------------------------------------
r2426 | ivar | 2004-11-17 11:34:41 +0100 (Wed, 17 Nov 2004) | 1 line

softphones now have their own profile (3)
------------------------------------------------------------------------
r2423 | matthias | 2004-11-16 15:56:35 +0100 (Tue, 16 Nov 2004) | 1 line

small db fix
------------------------------------------------------------------------
r2421 | matthias | 2004-11-16 15:35:13 +0100 (Tue, 16 Nov 2004) | 1 line

add pptp_ip to the pptpusers view
------------------------------------------------------------------------
r2419 | matthias | 2004-11-16 14:40:52 +0100 (Tue, 16 Nov 2004) | 1 line

add ip for pptp users
------------------------------------------------------------------------
r2415 | matthias | 2004-11-16 11:13:42 +0100 (Tue, 16 Nov 2004) | 1 line

add trigger for phone assignment
------------------------------------------------------------------------
r2412 | ivar | 2004-11-15 14:57:50 +0100 (Mon, 15 Nov 2004) | 1 line

re-arranged dependencies phone/contact/phoneline + reordered table creation
------------------------------------------------------------------------
r2409 | matthias | 2004-11-11 15:28:58 +0100 (Thu, 11 Nov 2004) | 1 line

small fix
------------------------------------------------------------------------
r2407 | matthias | 2004-11-11 13:22:56 +0100 (Thu, 11 Nov 2004) | 1 line

new settings for amavis
------------------------------------------------------------------------
r2406 | matthias | 2004-11-11 12:06:01 +0100 (Thu, 11 Nov 2004) | 1 line

add sophie to the serviceS
------------------------------------------------------------------------
r2400 | matthias | 2004-11-11 11:22:13 +0100 (Thu, 11 Nov 2004) | 1 line

make a template file for amavisd-config
------------------------------------------------------------------------
r2388 | matthias | 2004-11-09 16:46:20 +0100 (Tue, 09 Nov 2004) | 1 line

copy the new config files to the correct locations
------------------------------------------------------------------------
r2387 | matthias | 2004-11-09 16:43:51 +0100 (Tue, 09 Nov 2004) | 1 line

additions for content filtering
------------------------------------------------------------------------
r2368 | ivar | 2004-11-08 14:47:23 +0100 (Mon, 08 Nov 2004) | 1 line

made username unique, instead of username + password
------------------------------------------------------------------------
r2356 | ivar | 2004-11-05 14:09:24 +0100 (Fri, 05 Nov 2004) | 1 line

more help in table astmessage
------------------------------------------------------------------------
r2343 | raarts | 2004-11-03 12:55:00 +0100 (Wed, 03 Nov 2004) | 2 lines

Added inbound table

------------------------------------------------------------------------
r2337 | raarts | 2004-11-02 17:00:49 +0100 (Tue, 02 Nov 2004) | 3 lines

Added extension length to company table, some companies would like
4-digit extensions, but not all of them...

------------------------------------------------------------------------
r2326 | ivar | 2004-11-01 16:51:08 +0100 (Mon, 01 Nov 2004) | 1 line

removed trunk field from company
------------------------------------------------------------------------
r2325 | ivar | 2004-11-01 16:48:48 +0100 (Mon, 01 Nov 2004) | 1 line

nightsettings value in company is default 'no'
------------------------------------------------------------------------
r2317 | raarts | 2004-10-29 11:30:30 +0200 (Fri, 29 Oct 2004) | 2 lines

Added triggers to specfile

------------------------------------------------------------------------
r2316 | ivar | 2004-10-29 11:21:15 +0200 (Fri, 29 Oct 2004) | 1 line

again insert statement for country doesn't reflect latest changes correctly
------------------------------------------------------------------------
r2313 | raarts | 2004-10-28 15:42:50 +0200 (Thu, 28 Oct 2004) | 2 lines

Implemented followme, nationalprefix, internationalprefix

------------------------------------------------------------------------
r2310 | matthias | 2004-10-28 14:53:37 +0200 (Thu, 28 Oct 2004) | 1 line

added status field for table domain
------------------------------------------------------------------------
r2309 | ivar | 2004-10-28 14:33:40 +0200 (Thu, 28 Oct 2004) | 1 line

user 'openexchange' was lost in last commit - now also in .bash file
------------------------------------------------------------------------
r2308 | ivar | 2004-10-28 14:30:10 +0200 (Thu, 28 Oct 2004) | 1 line

regenerated to include callrouting (e.a.?)
------------------------------------------------------------------------
r2307 | ivar | 2004-10-28 14:22:54 +0200 (Thu, 28 Oct 2004) | 1 line

syntax error in inserting countries
------------------------------------------------------------------------
r2282 | matthias | 2004-10-27 15:44:27 +0200 (Wed, 27 Oct 2004) | 1 line

fix a typo in the trigger
------------------------------------------------------------------------
r2281 | matthias | 2004-10-27 15:16:46 +0200 (Wed, 27 Oct 2004) | 1 line

added 2 triggers for domain, a trigger for adding domains and a trigger for mutating domains
------------------------------------------------------------------------
r2280 | matthias | 2004-10-27 13:47:42 +0200 (Wed, 27 Oct 2004) | 1 line

added database trigger, when a domain status goes to deleted, the trigger sets the correct stuff in activate
------------------------------------------------------------------------
r2267 | raarts | 2004-10-25 17:41:57 +0200 (Mon, 25 Oct 2004) | 2 lines

Moved allow_tollfree etcetera from the phone to the user.

------------------------------------------------------------------------
r2262 | raarts | 2004-10-25 14:56:33 +0200 (Mon, 25 Oct 2004) | 3 lines

Added field for the length of the subscriber number
Added function for pre-auth support, checks if phone and pin correspond.

------------------------------------------------------------------------
r2257 | raarts | 2004-10-22 16:55:00 +0200 (Fri, 22 Oct 2004) | 2 lines

Added support for international dialplans, addded areacode to company table;

------------------------------------------------------------------------
r2254 | matthias | 2004-10-22 16:34:25 +0200 (Fri, 22 Oct 2004) | 1 line

small fix
------------------------------------------------------------------------
r2253 | ivar | 2004-10-22 14:57:16 +0200 (Fri, 22 Oct 2004) | 1 line

modified fastdial
------------------------------------------------------------------------
r2251 | raarts | 2004-10-22 13:47:12 +0200 (Fri, 22 Oct 2004) | 2 lines

Added Call Routing DB tables

------------------------------------------------------------------------
r2246 | raarts | 2004-10-21 17:01:28 +0200 (Thu, 21 Oct 2004) | 2 lines

Trunk support

------------------------------------------------------------------------
r2233 | perry | 2004-10-20 12:32:53 +0200 (Wed, 20 Oct 2004) | 1 line

removed smtp-amavis from postfix because amavis doe not work yet
------------------------------------------------------------------------
r2232 | perry | 2004-10-20 10:29:59 +0200 (Wed, 20 Oct 2004) | 1 line


------------------------------------------------------------------------
r2217 | matthias | 2004-10-18 11:00:26 +0200 (Mon, 18 Oct 2004) | 1 line

add extra fields in the view to accomadate module open-xchange
------------------------------------------------------------------------
r2215 | matthias | 2004-10-15 13:49:57 +0200 (Fri, 15 Oct 2004) | 1 line

THIS IS THE 3RD TIME THAT THIS IS FIXED, CHECK BEFORE YOU COMMIT
------------------------------------------------------------------------
r2198 | ivar | 2004-10-13 14:48:45 +0200 (Wed, 13 Oct 2004) | 1 line

add table for fastdial numbers
------------------------------------------------------------------------
r2185 | matthias | 2004-10-12 14:59:06 +0200 (Tue, 12 Oct 2004) | 1 line

add wins support in pptp
------------------------------------------------------------------------
r2181 | raarts | 2004-10-11 15:18:21 +0200 (Mon, 11 Oct 2004) | 2 lines

Added bri_dchan and pri_dchan to database

------------------------------------------------------------------------
r2177 | matthias | 2004-10-11 14:34:41 +0200 (Mon, 11 Oct 2004) | 1 line

small fixes for racoon
------------------------------------------------------------------------
r2174 | matthias | 2004-10-11 12:27:44 +0200 (Mon, 11 Oct 2004) | 1 line

when racoon stops all SPD and SAD entries must be flushed
------------------------------------------------------------------------
r2172 | matthias | 2004-10-11 11:43:46 +0200 (Mon, 11 Oct 2004) | 1 line

commit to bump rev nr
------------------------------------------------------------------------
r2171 | matthias | 2004-10-11 11:11:08 +0200 (Mon, 11 Oct 2004) | 1 line

added rc scripts for racoon
------------------------------------------------------------------------
r2164 | raarts | 2004-10-07 23:49:53 +0200 (Thu, 07 Oct 2004) | 2 lines

Added zap-adsi to zap_channel (renaming to 'adsi')

------------------------------------------------------------------------
r2162 | ivar | 2004-10-07 16:49:56 +0200 (Thu, 07 Oct 2004) | 1 line

ordered & updated phonelegend table
------------------------------------------------------------------------
r2161 | matthias | 2004-10-07 16:45:49 +0200 (Thu, 07 Oct 2004) | 1 line

add racoon rc script
------------------------------------------------------------------------
r2159 | ivar | 2004-10-07 15:42:56 +0200 (Thu, 07 Oct 2004) | 1 line

have default user 'system' be in default Neonova department
------------------------------------------------------------------------
r2154 | ivar | 2004-10-07 10:44:32 +0200 (Thu, 07 Oct 2004) | 1 line

typo
------------------------------------------------------------------------
r2151 | raarts | 2004-10-06 22:35:07 +0200 (Wed, 06 Oct 2004) | 3 lines

crc4 should default to 'no', because we only set it 
for an E1 line

------------------------------------------------------------------------
r2150 | raarts | 2004-10-06 22:14:45 +0200 (Wed, 06 Oct 2004) | 3 lines

Added tables for PBX devices. Extended zap_channel to include
all kinda setup fields

------------------------------------------------------------------------
r2135 | matthias | 2004-10-05 09:52:17 +0200 (Tue, 05 Oct 2004) | 1 line

support storage of public key in ast_globals
------------------------------------------------------------------------
r2130 | matthias | 2004-10-04 14:15:45 +0200 (Mon, 04 Oct 2004) | 1 line

2nd time fix because somebody made it disappear with his update
------------------------------------------------------------------------
r2128 | raarts | 2004-10-04 00:16:32 +0200 (Mon, 04 Oct 2004) | 5 lines

Allocated tables in the database for all types of supported
PBX cards. Extended zap_channel to be able to point
to the particular card and port the channel belongs to.
Also added cardtype.

------------------------------------------------------------------------
r2126 | perry | 2004-10-01 11:06:21 +0200 (Fri, 01 Oct 2004) | 1 line

Fixed a bug
------------------------------------------------------------------------
r2125 | perry | 2004-10-01 10:56:00 +0200 (Fri, 01 Oct 2004) | 2 lines

Astium setup script setup.sh wil now create file /usr/local/astium/etc/astium-installed. If this file exists setup.sh wil not run again.

------------------------------------------------------------------------
r2123 | raarts | 2004-10-01 10:25:34 +0200 (Fri, 01 Oct 2004) | 3 lines

Added test database, so we don't have to type everything
in everytime we re-install

------------------------------------------------------------------------
r2120 | matthias | 2004-09-30 17:00:54 +0200 (Thu, 30 Sep 2004) | 1 line

install the sign.sh script to sign certificates
------------------------------------------------------------------------
r2118 | matthias | 2004-09-30 15:12:36 +0200 (Thu, 30 Sep 2004) | 1 line

Somebody removed an essential line for open xchange, now it is back
------------------------------------------------------------------------
r2112 | raarts | 2004-09-29 15:28:29 +0200 (Wed, 29 Sep 2004) | 2 lines

Added conference support.

------------------------------------------------------------------------
r2102 | raarts | 2004-09-28 23:02:07 +0200 (Tue, 28 Sep 2004) | 2 lines

Add entry for WISIP WiFi VoIP SIP phone from Pulver Innovations

------------------------------------------------------------------------
r2100 | raarts | 2004-09-28 22:39:06 +0200 (Tue, 28 Sep 2004) | 3 lines

Added gateway field to phone table, for phones in
other offices that go to our DHCP server for IP information

------------------------------------------------------------------------
r2096 | ivar | 2004-09-28 14:35:08 +0200 (Tue, 28 Sep 2004) | 1 line

delete command was missing
------------------------------------------------------------------------
r2091 | raarts | 2004-09-27 17:31:02 +0200 (Mon, 27 Sep 2004) | 2 lines

Set correct defaults for allow_dial_*

------------------------------------------------------------------------
r2090 | raarts | 2004-09-27 17:24:30 +0200 (Mon, 27 Sep 2004) | 2 lines

The owner should be active.

------------------------------------------------------------------------
r2088 | raarts | 2004-09-27 15:41:46 +0200 (Mon, 27 Sep 2004) | 2 lines

Added functions for night setting and getting the main trunk

------------------------------------------------------------------------
r2084 | matthias | 2004-09-27 10:45:13 +0200 (Mon, 27 Sep 2004) | 1 line

small ldap fix for open-xchange
------------------------------------------------------------------------
r2050 | matthias | 2004-09-24 16:13:10 +0200 (Fri, 24 Sep 2004) | 1 line


------------------------------------------------------------------------
r2049 | matthias | 2004-09-24 16:03:43 +0200 (Fri, 24 Sep 2004) | 1 line

add openexchange fixes
------------------------------------------------------------------------
r2048 | matthias | 2004-09-24 15:58:19 +0200 (Fri, 24 Sep 2004) | 1 line

add install support for open-xchange
------------------------------------------------------------------------
r2046 | raarts | 2004-09-24 15:44:54 +0200 (Fri, 24 Sep 2004) | 2 lines

Added and activated our own sysctl.conf

------------------------------------------------------------------------
r2042 | ivar | 2004-09-24 15:24:09 +0200 (Fri, 24 Sep 2004) | 1 line

have phonelegend table reference astmessage name instead of id
------------------------------------------------------------------------
r2038 | ivar | 2004-09-24 14:53:18 +0200 (Fri, 24 Sep 2004) | 1 line

updated phonelegend references to phonetype
------------------------------------------------------------------------
r2035 | raarts | 2004-09-24 14:28:09 +0200 (Fri, 24 Sep 2004) | 2 lines

Fixed emailsubject and emailbody settings

------------------------------------------------------------------------
r2033 | ivar | 2004-09-24 14:21:34 +0200 (Fri, 24 Sep 2004) | 1 line

all help messages inserted
------------------------------------------------------------------------
r2031 | ivar | 2004-09-24 13:31:09 +0200 (Fri, 24 Sep 2004) | 1 line

empty insered by default in department shouldn't get explicit id - sequence not updated causes error inserting new department
------------------------------------------------------------------------
r2030 | ivar | 2004-09-24 13:24:55 +0200 (Fri, 24 Sep 2004) | 1 line

removed explicit values for 'id' inserting in table 'company' this causes the sequence not to update automatically -> duplicate key violates unique constraint errors when inserting new company
------------------------------------------------------------------------
r2027 | ivar | 2004-09-24 12:33:52 +0200 (Fri, 24 Sep 2004) | 1 line

grant statements for 2 new tables
------------------------------------------------------------------------
r2019 | ivar | 2004-09-24 12:16:07 +0200 (Fri, 24 Sep 2004) | 1 line

company with id=1 is 'empty' again. New status: 'inactive' for Neonova, reseller & owner
------------------------------------------------------------------------
r2018 | raarts | 2004-09-24 11:41:14 +0200 (Fri, 24 Sep 2004) | 2 lines

Re-added reseller, and adjusted id's in astglobals

------------------------------------------------------------------------
r2017 | raarts | 2004-09-24 11:36:32 +0200 (Fri, 24 Sep 2004) | 3 lines

Fixed database creation errors (missing semicolons etc)
Fixed voicemail function definition

------------------------------------------------------------------------
r2015 | ivar | 2004-09-24 11:04:40 +0200 (Fri, 24 Sep 2004) | 2 lines

dtmfmode default                                                                                             
rfc2833
------------------------------------------------------------------------
r2013 | ivar | 2004-09-24 10:30:47 +0200 (Fri, 24 Sep 2004) | 1 line

slight formatting change
------------------------------------------------------------------------
r2012 | ivar | 2004-09-24 10:27:31 +0200 (Fri, 24 Sep 2004) | 1 line

new astglobals, new tables, some updates
------------------------------------------------------------------------
r2008 | raarts | 2004-09-24 09:50:56 +0200 (Fri, 24 Sep 2004) | 2 lines

Added SQL functions for voicemail support

------------------------------------------------------------------------
r2003 | matthias | 2004-09-23 16:24:18 +0200 (Thu, 23 Sep 2004) | 1 line

kick out sendmail of the astium
------------------------------------------------------------------------
r1993 | ivar | 2004-09-23 14:48:11 +0200 (Thu, 23 Sep 2004) | 1 line

add: multi-tentating astglobal, removed commented wan-stuff
------------------------------------------------------------------------
r1991 | raarts | 2004-09-23 14:32:57 +0200 (Thu, 23 Sep 2004) | 2 lines

Added database functions for setting callforward parameters

------------------------------------------------------------------------
r1990 | matthias | 2004-09-23 13:34:03 +0200 (Thu, 23 Sep 2004) | 1 line

add script to setup build env
------------------------------------------------------------------------
r1987 | matthias | 2004-09-23 12:01:13 +0200 (Thu, 23 Sep 2004) | 1 line


------------------------------------------------------------------------
r1986 | matthias | 2004-09-23 11:56:52 +0200 (Thu, 23 Sep 2004) | 1 line

added files
------------------------------------------------------------------------
r1985 | matthias | 2004-09-23 11:22:28 +0200 (Thu, 23 Sep 2004) | 1 line

small spec file change
------------------------------------------------------------------------
r1983 | ivar | 2004-09-23 11:15:37 +0200 (Thu, 23 Sep 2004) | 1 line

fields added to tables phone, phoneline, company
------------------------------------------------------------------------
r1968 | matthias | 2004-09-22 16:12:27 +0200 (Wed, 22 Sep 2004) | 1 line

database fixes for open-xchange
------------------------------------------------------------------------
r1956 | matthias | 2004-09-22 11:46:59 +0200 (Wed, 22 Sep 2004) | 1 line

small fixes
------------------------------------------------------------------------
r1926 | raarts | 2004-09-20 17:21:14 +0200 (Mon, 20 Sep 2004) | 2 lines

tftp config was in /etc/xinetd.d under two names. Fixed.

------------------------------------------------------------------------
r1925 | raarts | 2004-09-20 17:12:42 +0200 (Mon, 20 Sep 2004) | 2 lines

Standardized phonetypes

------------------------------------------------------------------------
r1916 | matthias | 2004-09-20 14:39:28 +0200 (Mon, 20 Sep 2004) | 1 line

config for mod_jk2
------------------------------------------------------------------------
r1915 | matthias | 2004-09-20 14:31:43 +0200 (Mon, 20 Sep 2004) | 1 line

config for mod_jk2
------------------------------------------------------------------------
r1889 | raarts | 2004-09-17 12:21:13 +0200 (Fri, 17 Sep 2004) | 2 lines

Run depmod -a to be sure zaptel can be found

------------------------------------------------------------------------
r1888 | ivar | 2004-09-17 12:13:55 +0200 (Fri, 17 Sep 2004) | 1 line

set Neonova/owner/reseller id's straight
------------------------------------------------------------------------
r1887 | ivar | 2004-09-17 11:22:48 +0200 (Fri, 17 Sep 2004) | 1 line

updated phonetype-specific help, astmessage.name field made bigger
------------------------------------------------------------------------
r1884 | ivar | 2004-09-17 10:32:58 +0200 (Fri, 17 Sep 2004) | 1 line

shortname no longer unique, because deleted companies still have their shortname
------------------------------------------------------------------------
r1875 | raarts | 2004-09-14 22:18:06 +0200 (Tue, 14 Sep 2004) | 2 lines

Set default status to QUEUED for first activation record

------------------------------------------------------------------------
r1873 | raarts | 2004-09-14 21:14:34 +0200 (Tue, 14 Sep 2004) | 2 lines

Moved NeoNova to ID=1, remeoved reseller record. Added DIDnumber.

------------------------------------------------------------------------
r1871 | raarts | 2004-09-14 21:08:11 +0200 (Tue, 14 Sep 2004) | 2 lines

Oops, forgot to start services

------------------------------------------------------------------------
r1850 | raarts | 2004-09-13 17:03:28 +0200 (Mon, 13 Sep 2004) | 4 lines

insert into activate improved.
Typo in SQL script
Setup script typos removed

------------------------------------------------------------------------
r1847 | raarts | 2004-09-13 16:42:09 +0200 (Mon, 13 Sep 2004) | 2 lines

Completed list of emabled/disabled services

------------------------------------------------------------------------
r1845 | raarts | 2004-09-13 16:17:36 +0200 (Mon, 13 Sep 2004) | 3 lines

Fill default values in activate table so all services will
be preconfigured at installation time

------------------------------------------------------------------------
r1843 | ivar | 2004-09-13 16:11:18 +0200 (Mon, 13 Sep 2004) | 1 line

1. removed budgetone 100 type. 2. renamed budge 101 to budgetone 101
------------------------------------------------------------------------
r1842 | raarts | 2004-09-13 16:03:57 +0200 (Mon, 13 Sep 2004) | 3 lines


Rewrote setup script, not totally finished though

------------------------------------------------------------------------
r1839 | ivar | 2004-09-13 14:33:32 +0200 (Mon, 13 Sep 2004) | 1 line

For now we won't use seperate files for database updates; updated astium.sql to reflect the updates i allready separated.
------------------------------------------------------------------------
r1836 | raarts | 2004-09-13 13:43:27 +0200 (Mon, 13 Sep 2004) | 2 lines

ADded updatedb to setup script, so we can start immediately

------------------------------------------------------------------------
r1835 | raarts | 2004-09-13 13:38:08 +0200 (Mon, 13 Sep 2004) | 3 lines

Log all setup.sh output to /tmp/setup.sh.output
Add chkconfig --add astcfgd to setup.sh

------------------------------------------------------------------------
r1825 | raarts | 2004-09-11 23:33:06 +0200 (Sat, 11 Sep 2004) | 2 lines

Set the ftftpboot path correct

------------------------------------------------------------------------
r1824 | raarts | 2004-09-11 12:43:16 +0200 (Sat, 11 Sep 2004) | 5 lines

Added PostgreSQL functions
Added tftp xinetd.d config file
Removed opengroupware
set astglobal servername to localhost instead of empty

------------------------------------------------------------------------
r1816 | ivar | 2004-09-09 15:15:51 +0200 (Thu, 09 Sep 2004) | 1 line

have nat default be 'no' (table alteration now in seperate files)
------------------------------------------------------------------------
r1809 | perry | 2004-09-09 10:15:35 +0200 (Thu, 09 Sep 2004) | 1 line

THe astium astcfgd daemon wil startup after reboot
------------------------------------------------------------------------
r1806 | raarts | 2004-09-09 01:12:01 +0200 (Thu, 09 Sep 2004) | 3 lines

Redesigned interface table.
Renamed SNOM100 to SNOM200

------------------------------------------------------------------------
r1794 | perry | 2004-09-08 14:55:01 +0200 (Wed, 08 Sep 2004) | 2 lines

removed default gateway from astium globals.

------------------------------------------------------------------------
r1792 | perry | 2004-09-08 14:13:41 +0200 (Wed, 08 Sep 2004) | 3 lines

Astium uses ntp*.neonova.nl as time server instead of ntp*.netland.nl.
Service's ntpd and other service's wil be restarted after een reboot.

------------------------------------------------------------------------
r1782 | ivar | 2004-09-07 11:31:10 +0200 (Tue, 07 Sep 2004) | 1 line

added option for 3 ntp servers in astglobals table
------------------------------------------------------------------------
r1774 | ivar | 2004-09-06 16:20:35 +0200 (Mon, 06 Sep 2004) | 1 line

add one line to astglobal: internet_connected = yes|no default yes
------------------------------------------------------------------------
r1766 | ivar | 2004-09-06 12:28:59 +0200 (Mon, 06 Sep 2004) | 1 line

removed broadcast field from staticroute table
------------------------------------------------------------------------
r1757 | ivar | 2004-09-06 10:48:07 +0200 (Mon, 06 Sep 2004) | 1 line

in phone & phonetype: firmware_version & bootloader_version
------------------------------------------------------------------------
r1755 | ivar | 2004-09-06 10:26:41 +0200 (Mon, 06 Sep 2004) | 1 line

alter table phone add column timezone
------------------------------------------------------------------------
r1728 | ivar | 2004-09-02 14:33:16 +0200 (Thu, 02 Sep 2004) | 1 line

phone locations on picture for dutch messages were missing - added them
------------------------------------------------------------------------
r1719 | ivar | 2004-09-01 12:08:27 +0200 (Wed, 01 Sep 2004) | 1 line

altered help message for serial field in phone table
------------------------------------------------------------------------
r1715 | ivar | 2004-09-01 11:16:30 +0200 (Wed, 01 Sep 2004) | 1 line

filled astmessage and phonelegend with some basic values
------------------------------------------------------------------------
r1712 | perry | 2004-09-01 10:05:27 +0200 (Wed, 01 Sep 2004) | 1 line

Added tftpboot directory to the apache config
------------------------------------------------------------------------
r1698 | matthias | 2004-08-31 12:24:36 +0200 (Tue, 31 Aug 2004) | 1 line

 added pptp support to contacts table
------------------------------------------------------------------------
r1691 | ivar | 2004-08-31 11:58:40 +0200 (Tue, 31 Aug 2004) | 1 line

inserted 'delete from staticroute' query
------------------------------------------------------------------------
r1687 | ivar | 2004-08-31 11:35:15 +0200 (Tue, 31 Aug 2004) | 1 line

two fields in interface were char instead of varchar; fixed + insert/delete statements given for interface table
------------------------------------------------------------------------
r1674 | ivar | 2004-08-30 12:20:14 +0200 (Mon, 30 Aug 2004) | 1 line

all wan* variables in astglobals removed
------------------------------------------------------------------------
r1673 | ivar | 2004-08-30 12:15:06 +0200 (Mon, 30 Aug 2004) | 1 line

re-generated users.sql so firewall tables can be accessed through the web
------------------------------------------------------------------------
r1526 | ivar | 2004-08-26 16:31:55 +0200 (Thu, 26 Aug 2004) | 1 line

some changes to astium.sql
------------------------------------------------------------------------
r1501 | ivar | 2004-08-25 15:20:46 +0200 (Wed, 25 Aug 2004) | 1 line

default entry for ipsec_hosts
------------------------------------------------------------------------
r1495 | raarts | 2004-08-24 22:18:53 +0200 (Tue, 24 Aug 2004) | 2 lines

Set options ok for documentroot

------------------------------------------------------------------------
r1438 | ivar | 2004-08-23 12:43:36 +0200 (Mon, 23 Aug 2004) | 1 line

inserted missing table: 'phonelegend'
------------------------------------------------------------------------
r1435 | raarts | 2004-08-23 11:37:01 +0200 (Mon, 23 Aug 2004) | 2 lines

Fix DocumentRoot to point to /usr/local/astium/web/html

------------------------------------------------------------------------
r1422 | raarts | 2004-08-20 14:26:13 +0200 (Fri, 20 Aug 2004) | 2 lines

Imported and fixed astium-setup

------------------------------------------------------------------------
r1421 | raarts | 2004-08-20 14:20:01 +0200 (Fri, 20 Aug 2004) | 1 line

initial (non working) version
------------------------------------------------------------------------
