Accessing Servers#

This page details how to access the Squirro Server, Squirro Application, Redis Server, and MariaDB Server.

Warning

Squirro cannot provide support for issues that arise as a consequence of updating data directly in MariaDB or Redis.

Default Logins#

MariaDB User#

The root user is typically configured for passwordless login to MariaDB.

This is done with the /root/.my.cnf configuration file, specifically using the password option in the client section.

Tip: If you change the root password, it is recommended you also update this configuration file.

An example file looks like this:

[client]
password=MyRootPasswordExample!

Redis Password#

The passwords for Redis instances are defined in the two configuration files using the masterauth directive and can be looked up there.

The two configuration files are /etc/redis/redis.conf and /etc/redis/cache.conf.

The relevant part of the configuration file will look like this:

# If the master is password protected (using the "requirepass" configuration
# directive below) it is possible to tell the replica to authenticate before
# starting the replication synchronization process, otherwise the master will
# refuse the replica request.
#
masterauth MyRedisPassword!

Accessing the Squirro Server#

Login#

For administrative access, you can connect to the server using SSH. Mac and Linux come with a built-in SSH client, on Windows Squirro recommends PuTTy.

If you do not know the IP address of the server, see Finding the IP Address on this page.

Root Access#

Once logged in you can gain root access using sudo by typing this command:

$ sudo -s

Sudo will ask you for your password again.

Which version of Squirro#

cat /etc/squirro/version.ini

Accessing Squirro Application#

Introduction#

With the Squirro cluster running you can access the Squirro app via:

https://<ip-address>

Creating a Squirro user#

By default there is no user set up for the Squirro web interface. To create a new admin user proceed as follows:

  1. Visit https://<ip-address> (see below if you don’t know the IP address)

  2. Click the Signup Button: image1

  3. Create a a user with a valid email address and a secure password. This will become the admin user.

  4. To prevent further user from being created this way, you can disable the signup option as documented in Configuration.

Finding the IP Address#

If you do not know the IP address of the machine, there are several ways to find it.

After booting the IP address is displayed in the console on the login screen. It might take a while for this address to update after booting.

Alternatively, you can also log into the machine using a username and password. Reference the next section for information.

Once you have a session on the server, type the following command:

ifconfig eth0

This will output the machine’s IP address.

Accessing Redis Server#

Redis is used by Squirro for caching, queuing and some ephemeral data. See Flushing Caches for more information.

Warning

Squirro cannot provide support for issues that arise as a consequence of updating data directly in Redis.

Login#

Default firewall settings do not allow for direct Redis connections from the outside. To gain administrative Redis access, you have to connect to the server using SSH first.

Access#

Once logged in you can access Redis using the redis-cli command line tool. There are two ways of providing the Redis password - directly on the command line, or using the AUTH command.

Command Line Login#

Start the redis-cli application by specifying the password using the -a option.

[squirro@localhost ~]$ redis-cli -a REDIS_PASSWORD
127.0.0.1:6379>

AUTH Login#

Start the redis-cli application, then specify the password in the Redis command line:

[squirro@localhost ~]$ redis-cli
127.0.0.1:6379> auth REDIS_PASSWORD
OK
127.0.0.1:6379>

Instances#

A standard Squirro installation comes with two instances of Redis: redis-server and redis-server-cache. redis-server runs on the standard Redis port 6379 and is used for storage and queueing. redis-server-cache runs on the port 6380 and is used for caching. To connect to the redis-server-cache instance add the -p parameter to redis-cli with a value of 6380. E.g.:

[squirro@localhost ~]$ redis-cli -p 6380 -a REDIS_PASSWORD
127.0.0.1:6380>

Databases#

Squirro uses different Redis databases. To see the used databases and their usage, use the info command:

127.0.0.1:6379> info
…
# Keyspace
db0:keys=3,expires=0,avg_ttl=0
db7:keys=82,expires=66,avg_ttl=10570724
db9:keys=114,expires=88,avg_ttl=89586306
db10:keys=2,expires=0,avg_ttl=0127.0.0.1:6379>

The default database is db0. To switch to a different database for subsequent commands, use the select command:

127.0.0.1:6379> select 7
OK
127.0.0.1:6379[7]>

The prompt of the Redis tool now shows the selected database.

Here is an overview of all Redis databases that are in use:

DB Number

Used for

Use Case

Redis-Server Instance

0

  1. ContentDb temporarily “queued” items before pipeline can get to them

  2. Task Queue (Kombu) in various services

  3. Bloom filter of pipeline duplication hashes

Storage and Queuing

redis-server (port 6379)

1

Near duplicate detection (for duplicates, code not in use, but we might bring this back)

Storage

redis-server (port 6379)

2

Near duplicate detection (near-duplicates) for recent history

Storage

redis-server (port 6379)

3

Provider item deduplication

Storage

redis-server (port 6379)

6

Key-value store for the dataloader plugins (Used by the dataloader provider)

Storage

redis-server (port 6379)

6

Key-value cache for the dataloader plugins (Used by the dataloader provider)

Caching

redis-server-cache (port 6380)

7

Query cache (used by the Topic API)

Caching

redis-server-cache (port 6380)

8

Filtering service sent email items

Storage

redis-server (port 6379)

9

HTTP request cache

Caching

redis-server-cache (port 6380)

12

Squirro Studio Storage

Storage

redis-server (port 6379)

12

Squirro Studio Cache

Cache

redis-server-cache (port 6380)

15

Applications should add their data in databases 15 or use a dedicated process/Redis-Cloud instance

Accessing MariaDB Server#

MariaDB is used by Squirro for metadata storage (see Services for more information). To investigate this metadata, MariaDB can be accessed directly.

Warning

Squirro cannot provide support for issues that arise as a consequence of updating data directly in MariaDB.

Login#

Default firewall settings do not allow for direct MariaDB connections from the outside. To gain administrative MariaDB access, you have to connect to the server using SSH first.

Root Access#

Once logged in you can gain MariaDB root access using mysql by typing this command:

[squirro@localhost ~]$ mysql -u root -p

You will be asked you for the MariaDB root password.