A Service of Softnik Technologies

SED-CLI: Command Line Interface

SED-CLI is the command-line interface for Watch My Domains SED. You can update the application, change settings, test configurations and much more, without using a web browser.

Using sed.php

php sed.php

Watch My Domains Server Edition, May 15 2020
Command Line Tool


Show version.

Drop all tables.

Reset all tables except the settings table.

Drop the specified table.

Empty the specified table.

Reset the specified empty table to default (if any).

index=<indexname> <new|drop|cleanup> table=<tablename> type=<primary|unique|simple> columns=<columnnames>
Create a new index, drop an existing index from table or cleanup all 
manually created indexes. The 'type' and 'columns' are required if 
creating a new index. The column names should be comma separated.
Index name and extra options are not required if 'cleanup' is specified.
Use cleanup=all to drop indexes on single custom domain columns too.
You can also use -s option along with the 'cleanup' to only simulate 
and not actually drop or create indexes.

List all tables, indexes, users or last audit entries.
Optionally specify table=<tablename> when using this option to 
get list of indexes to get data for a specific table.

report=<reportname> email=[no,auto]
Email a report to the configured address. When set to auto the emailing 
will be done only if the current time matches with the report scheduler 

mailtest=<email> debug=[0,1,2,3,4]
Test Emailing (please make sure that all Email Settings are completed)

import=<profile> (please make sure that the data provider details 
are already setup).

Brute force scan for TXT records in all domains.

update [--force] [-y]
Check for minor version updates. Download the latest version, if available, 
and unzip into the installation folder after confirming.
Use --force to download even if the installation is current.
Use -y to overwrite current installation folder without confirming.

Check for Minor Version Updates, Install if Available.

php sed.php update

The above will ask for installation confirmation if a new version is available. Use '-y' to install without confirming first.

php sed.php update -y

Testing Email

php sed.php mailtest=contact@softnik.com debug=2

Here is a sample output. The debug setting can be a number from 0 (no debug info) to 4 (maximum debug info). For most practical purposes use debug=2.

php sed.php mailtest=contact@softnik.com debug=2
2019-03-22 11:37:10	SERVER -> CLIENT: 220 smtp.gmail.com ESMTP 17sm11272228pgt.0 - gsmtp
2019-03-22 11:37:10	CLIENT -> SERVER: EHLO Adria.local
2019-03-22 11:37:10	SERVER -> CLIENT: 250-smtp.gmail.com at your service, []
                   	                  250-SIZE 35882577
                   	                  250 SMTPUTF8
2019-03-22 11:37:10	CLIENT -> SERVER: STARTTLS
2019-03-22 11:37:10	SERVER -> CLIENT: 220 2.0.0 Ready to start TLS
2019-03-22 11:37:10	CLIENT -> SERVER: EHLO Adria.local
2019-03-22 11:37:10	SERVER -> CLIENT: 250-smtp.gmail.com at your service, []
                   	                  250-SIZE 35882577
                   	                  250 SMTPUTF8
2019-03-22 11:37:10	CLIENT -> SERVER: AUTH LOGIN
2019-03-22 11:37:10	SERVER -> CLIENT: 334 VXNlcm5hbWU6
2019-03-22 11:37:10	CLIENT -> SERVER: 

Listing all Unique Indexes

php sed.php list=indexes type=unique

1] wmdsed_auth_catconn

        1       Name: wmdsed_auth_catconn_1_uidx
                Type: unique
                Columns: cid, userid

2] wmdsed_auth_groupconn

        1       Name: wmdsed_auth_groupconn_1_uidx
                Type: unique
                Columns: gid, userid

3] wmdsed_auth_users

        1       Name: wmdsed_auth_users_1_uidx
                Type: unique
                Columns: name


11] wmdsed_queries

        1       Name: wmdsed_queries_1_uidx
                Type: unique
                Columns: name

12] wmdsed_report_scheduler

        1       Name: wmdsed_report_scheduler_1_uidx
                Type: unique
                Columns: name

13] wmdsed_settings

        1       Name: wmdsed_settings_1_uidx
                Type: unique
                Columns: name, server

14] wmdsed_api_profiles

15] wmdsed_audit_log


24] wmdsed_tlds

25] wmdsed_whoisservers

Listing all Indexes for a Table

php sed.php list=indexes table=domains

1] wmdsed_domains

        1       Name: PRIMARY
                Type: unique primary
                Columns: sid

        2       Name: wmdsed_domains_1_uidx
                Type: unique
                Columns: domain

        3       Name: wmdsed_domains_2_idx
                Type: simple
                Columns: registry_expiry

        4       Name: wmdsed_domains_3_idx
                Type: simple
                Columns: registrar_expiry

        5       Name: wmdsed_domains_4_idx
                Type: simple
                Columns: created_on

        6       Name: wmdsed_domains_5_idx
                Type: simple
                Columns: primary_whois_checked_at

        7       Name: wmdsed_domains_6_idx
                Type: simple
                Columns: secondary_whois_checked_at

        8       Name: wmdsed_domains_7_idx
                Type: simple
                Columns: edited

        9       Name: wmdsed_domains_8_idx
                Type: simple
                Columns: write_protect

        10      Name: wmdsed_domains_9_idx
                Type: simple
                Columns: status

        11      Name: wmdsed_domains_10_idx
                Type: simple
                Columns: availability

Creating a New Index

php sed.php index=domain_new_index new table=domains columns=customer_invoice type=simple

The above will attempt to create a new simple index named domain_new_index in the domain table for the column named customer_invoice.

You can specify more than one column (separate them with commas) for the 'column's parameter.

Deleting an Index

php sed.php index=domain_new_index drop table=domains

The above will attempt to delete the index named domain_new_index in the domain table.