[Release] devMX TeamSpeak3 ChannelWatcher - Auto delete unvisited Channels

[SilentStorm]

There is no PHP Database Driver for the Database you selected.

[Maxe___]

There is no PHP Database Driver for the Database you selected.

Try (on Debian based systems)

sudo apt-get install sqlite php5-sqlite

[drak3]

@Ar2rJke
If you want to customize the location of your database you can do that by assigning it to the 'path' key. For example:

<?php

    $c['db']['connection.params'] = array(
    'driver' => 'pdo_sqlite',
    'path' => '/path/to/your/database.sqlite',
    );
?>

You just have to make sure that you use another database for each configuration
By default the database will be under storage/<config_name>_db.sqlite.
It is recommended to use the default preconfigured settings for the path.

[Ar2rJke]

did as you wrote! As a result, errors are not any no

Creating storage directory
Creating database table

in the folder with the server, a new file "ts3server.sqlite", and next to it a standard base "ts3server.sqlitedb"

[Ar2rJke]

php app.php delete channel

There were just 0.0 crawls per hour. At least 2.0 crawls per hour are needed
Rerun with --trust-crawls if you want to delete based on this insufficent data

so that the use of parameter

php app.php delete channel

[Ar2rJke]

Dear developers of this program, please feel free to throw off already set up ready-configuration of this script, under the base sqlite, as guided by your futile FAQ, There are many shortcomings that are not in your FAQ, error points and etc, Please download the configuration is already configured for sqlite, to him for us to understand and change the fact that we need to. What configs except example.php, need to edit for themselves? in app.php need to configure something? in FAQ - nothing is written.

I understand the crontab we add: */5 * * * * cd /path/your/script && php app.php crawl example - it's running.
I removed as I understand, the command: php app.php delete example - it just needed to add crontab ?

You wrote all the FAQ quite competent and understandable, BUT! it's not clear, at least show an example, in steps, how-what-where-why.

Not who did not wish to offend - just write as it is.

[barricas]

This is not creating tables in database, either in sqlite and mysql. So when I run the app.php it tells the table X doesn't exist.
Is there any .sql file to do it manually?

[drak3]

@Ar2rJke
I hope I understand what you mean:
There is no need to configure the sqlite database further, simply uncommenting the sqlite section should be enough. There is no need to edit something in the app.php.
Also note that the database used by the ChannelWatcher is NOT the teamspeak3-database (used by your teamspeak3-server).
The Channelwatcher maintains it own database, that's also why the "There were just 0.0 crawls per hour. At least 2.0 crawls per hour are needed" error occurs: there must be enough runs of

php app.php crawl <your_config>

, so the ChannelWatcher can connect to the query and update its database. So you should make sure that you run the crawl command regulary for some time before using the delete command. You should run the delete command only after you ran the crawl command for at least the time you specified in the config file as time to live for the channels, otherwhise it will throw the error you described.
Thanks for your feedback though, we will try to update and clarify the documentation within the next days.

@barricas
You may try to run "php app.php db:migrate" (if you are using sqlite you might have to delete the old database under storage/<your_config>_db.sqlite).
If this command does not work for you please give a short reply, so i can generate the sql for your database and investigate this issue further.

[barricas]

I get this:
http://gyazo.com/bb1f78a33d978be5a67662d9ec5f7f1d

[Firenz]

Can I ask you to make it compatible with older php versions? It might sound funny but it's some kind of a barrier, because some linux systems doesn't have php 5.3.7+, even if 5.4.4 is already released... e.g. linux-pld has 5.2.14, centos has 5.3.3 and even if I rewrite the repository, php update still forces mess with apache, which puts us in a lost position already, mainly because of that error, which requires 5.3+ to make that work:

php app.php crawl test
PHP Parse error:  syntax error, unexpected T_STRING, expecting T_CONSTANT_ENCAPSED_STRING or '(' in /home/users/firenz/TeamSpeak3-ChannelWatcher/app.php on line 23

I hope you'll consider that, because linux users apart from debian-based needs that tool,
Thanks in advance and regards

[drak3]

@barricas
You have to run db:migrate with your config name as parameter e.g: "php app.php db:migrate <your_config>"

@Firenz
We are not planning to port this application back to 5.2 which is not longer officially supported by the php-devs.
Back-porting would require a complete rewrite because our application depends on new features introduced in 5.3 and all external libraries we use require php 5.3.

Supporting versions prior 5.3.7 (5.3.2 namely) is probably possible but relatively unlikely, because before 5.3.7 a segmentation fault is occuring which is clearly a php bug. This makes it relatively hard to track and fix the segmentation fault.

However we can ensure that we will NOT raise the required php-version in any of the 1.x releases.

Edit: you might use phpenv to manage multiple php versions. I'm using this to test the ChannelWatcher against 5.3.7 while running a new 5.4 as dev version. It is somewhat tricky to set up, but it will enable you to run a newer php version in parallel to your needed legacy versions

[barricas]

Hmmm sorry Thought it was telling something about config parameters or something. Working OK now
Btw would be nice to have also to only scan sub channels of a given channel ID

[drak3]

Hmmm sorry Thought it was telling something about config parameters or something. Working OK now

Good to hear

Btw would be nice to have also to only scan sub channels of a given channel ID

This should be easy to implement.
I've opened a new issue for that. We will try to include this feature in the 1.1.0 release

[barricas]

Thanks Looking forward for the update. Since I have people to create channels in the site below a main channel. So if they get inactive will be easier since I only want to check those.

[Firenz]

Ok, I've managed to use phpenv and installed php 5.3.8, It's working now. I started to use channel watcher but from unknown for me reasons I have certain situation now. I have 2 remote servers, entered everything properly in configs and I'm trying to crawl my main ts3, that's what happening in instance log:

2012-07-16 06:54:14.115169|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.6.1 (2012-06-29 07:59:05)
2012-07-16 06:54:14.116837|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2012-07-16 06:54:14.116906|INFO    |DatabaseQuery |   | dbPlugin version: 1
2012-07-16 06:54:14.413559|INFO    |Accounting    |   | Licensing Information
2012-07-16 06:54:14.413654|INFO    |Accounting    |   | type              : Non-profit
2012-07-16 06:54:14.413718|INFO    |Accounting    |   | starting date     : Mon Aug 15 00:00:00 2011
2012-07-16 06:54:14.413786|INFO    |Accounting    |   | ending date       : Wed Aug 15 00:00:00 2012
2012-07-16 06:54:14.413834|INFO    |Accounting    |   | max virtualservers: 10
2012-07-16 06:54:14.413885|INFO    |Accounting    |   | max slots         : 512
2012-07-16 06:54:14.450767|INFO    |FileManager   |   | listening on (cut):30033
2012-07-16 06:54:14.725176|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: (cut)
2012-07-16 06:54:14.726328|INFO    |Query         |   | listening on (cut):8797
< here php app.php crawl main >
2012-07-16 06:56:50.248437|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_login_name = 'serveradmin' and clie error: Table 'ts3.clients' doesn't exist
2012-07-16 06:56:50.255031|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 06:57:14.142394|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'ts3.clients' doesn't exist
2012-07-16 06:59:09.188813|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 06:59:29.706532|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 06:59:36.016579|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 06:59:43.911631|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:00:14.110394|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:00:14.141716|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'ts3.clients' doesn't exist
2012-07-16 07:00:23.031266|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:00:32.832054|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:00:36.864232|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:00:55.317567|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:01:13.704700|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:01:19.290335|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:01:27.214187|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:01:30.537555|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:01:49.347821|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:01:52.178499|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:02:03.962337|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:02:22.024379|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:02:24.950346|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:02:30.965406|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:02:31.804482|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:03:03.106188|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:03:06.153526|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:03:08.822163|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'ufiOBzwKe0Gbxo8HYyBrSN error: Table 'ts3.clients' doesn't exist
2012-07-16 07:03:13.966216|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'ufiOBzwKe0Gbxo8HYyBrSN error: Table 'ts3.clients' doesn't exist
2012-07-16 07:03:14.140921|ERROR   |DatabaseQuery |   | db_open() select * from clients where not exists (select id1 from group_server_t error: Table 'ts3.clients' doesn't exist
2012-07-16 07:03:17.665523|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:03:37.214198|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:03:39.981572|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:04:03.335309|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:04:15.552191|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist
2012-07-16 07:05:45.742999|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'aeoGtSCEsAaQJzXqdOJ+xa error: Table 'ts3.clients' doesn't exist
2012-07-16 07:05:53.463156|ERROR   |DatabaseQuery |   | db_open() select * from clients where client_unique_id = 'aeoGtSCEsAaQJzXqdOJ+xa error: Table 'ts3.clients' doesn't exist
2012-07-16 07:06:02.844930|ERROR   |DatabaseQuery |   | db_open() select * from servers where server_port = 9987; error: Table 'ts3.servers' doesn't exist

Don't know why, error from channel watcher:

[firenz@nocgier TeamSpeak3-ChannelWatcher]$ php app.php init main
Creating storage directory
Creating database table
[firenz@nocgier TeamSpeak3-ChannelWatcher]$ php app.php crawl main



  [devmx\Teamspeak3\Query\Exception\CommandFailedException]
  Command "channellist" caused error with message "invalid serverID" and id 1
  024.



crawl config


[firenz@nocgier TeamSpeak3-ChannelWatcher]$

Edit: To be exact, mysql db just dropped everything just like that exactly in that second I used that script.
That will be spamming until I restart the ts3, which will automatically drop everything and install a new database, just scheluded backups every 3hrs in 2 remote places rescued me. I hope you'll help me with this because I didn't expect that heavy one above