This page describes the Sumo pipeline for ingesting logs from Google Cloud Platform (GCP) services, and provides instructions for collecting logs from Google Cloud SQL.
Collection process for GCP services
The key components in the collection process for GCP services are: Google Stackdriver, Google Cloud Pub/Sub, and Sumo’s Google Cloud Platform (GCP) source running on a hosted collector.
The integration works like this: Google Stackdriver collects logs from GCP services. Once you’ve configured the pipeline shown below, the logs collected by Stackdriver will be published to a Google Pub/Sub topic. A Sumo GCP source on a hosted collector subscribed to that topic ingests the logs into Sumo.
The configuration process is as follows.
- Configure a GCP source on a hosted collector. You'll obtain the HTTP URL for the source, and then use Google Cloud Console to register the URL as a validated domain.
- Create a topic in Google Pub/Sub and subscribe the GCP source URL to that topic.
- Create an export of GCP logs from Stackdriver. Exporting involves writing a filter that selects the log entries you want to export, and choosing a Pub/Sub as the destination. The filter and destination are held in an object called a sink.
See the sections below for instructions.
Configure a Google Cloud Platform Source
The Google Cloud Platform (GCP) Source receives log data from Google Pub/Sub.
In this section, you add the Source URL as an allowed domain to your GCP account. This Source will be a Google Pub/Sub-only Source, which means that it will only be usable for log data formatted as data coming from Google Pub/Sub.
- In Sumo Logic select Manage Data > Collection > Collection.
- Select an existing Hosted Collector upon which to add the Source. If you don't already have a Collector you'd like to use, create one, using the instructions on Configure a Hosted Collector.
- Click Add Source next to the Hosted Collector and click Google Cloud Platform.
- Enter a Name to display for the source in the Sumo web application. Description is optional.
- (Optional) For Source Host and Source Category, enter any string to tag the output collected from the source. Category metadata is stored in a searchable field called _sourceCategory, for example "gcp".
- Log File Discovery. To set up the subscription you need to get an endpoint URL from Sumo to provide to Google. Click on Copy URL and use the provided URL as an allowed domain in GCP.
Steps to add the Source's URL as an allowed domain in GCP:
- Open your Google Cloud Console.
- Select Products and services > APIs & Services > Credentials.
- Select Domain Verification > Add Domain.
- In the Configure webhook notifications for … dialog, add the Source URL as valid domain and click Add Domain.
- Click Take Me There to verify ownership of the URL at Google’s webmaster central page. You are taken to the Google’s Webmaster Central interface to verify the URL.
- Click Add Property in the Webmaster Central site and add the Source URL.
- Do not click Verify yet. Download and open the HTML verification file. Complete the next steps before clicking Verify. You will verify in step 11.
- Return to the Source configuration page in Sumo under Log File Discovery.
- For Verification File Name input the verification file's name.
- For Verification File Contents copy and paste the full string from verification file's body contents.
Continue configuring the Source in Sumo.
- Advanced Options for Logs.
- Enable Timestamp Parsing. This option is selected by default. If it's deselected, no timestamp information is parsed at all.
- Time Zone. There are two options for Time Zone. You can use the time zone present in your log files, and then choose an option in case time zone information is missing from a log message. Or, you can have Sumo Logic completely disregard any time zone information present in logs by forcing a time zone. It's very important to have the proper time zone set, no matter which option you choose. If the time zone of logs can't be determined, Sumo Logic assigns logs UTC; if the rest of your logs are from another time zone your search results will be affected.
- Timestamp Format. By default, Sumo Logic will automatically detect the timestamp format of your logs. However, you can manually specify a timestamp format for a Source. See Timestamps, Time Zones, Time Ranges, and Date Formats for more information.
- Processing Rules for Logs. Configure desired filters—such as include, exclude, hash, or mask—as described in Create a Processing Rule. Processing rules are applied to log data, but not to metric data. Note that while the Sumo service will receive your data, data ingestion will be performed in accordance with the regular expressions you specify in processing rules.
- When you are finished configuring the Source click Save.
- Return to Google's Webmaster Central and click Verify. It should verify successfully.
- Finally, in your GCP console return to Products and services > APIs & Services > Credentials and add the Sumo Logic endpoint URL that you just verified to have the endpoint show up as a verified domain in GCP.
Configure a Pub/Sub topic for GCP projects
In this step, you configure a Pub/Sub topic in GCP and add a subscription to the above source URL. Once you configure the Pub/Sub, you can export data from Stackdriver to the Pub/Sub. For example, you can export Google App Engine logs, as described on Collect Logs for Google App Engine.
- In GCP, select Pub/Sub in the left navigation pane.
- In the Pub/Sub pane, select Topics, then click Create Topic in the Topics pane.
Name the topic and click Create.
Select the new topic in the Topics pane, and select New subscription from the options menu.
- In the Create a subscription pane:
- Subscription Name. Enter a name for the subscription.
- Delivery Type. Choose “Push into an endpoint url”, and enter the upload URL for the Sumo HTTP source you created above.
- Click Create.
Create export of Cloud SQL logs from Stackdriver
- Go to Logging and click Exports.
- Click Create Export.
Select a GCP service to filter the logs. The recommended GCP service to create sinks for is "Cloud SQL Database", which sends the service’s logs to Sumo Logic. In the Edit Export window on the right:
- Enter a Sink Name. For example, "gce-vm-instance".
- Select "Cloud Pub/Sub" as the Sink Service.
- Set Sink Destination to the Pub/Sub topic you created in the Google Cloud Platform Source procedure. For example, "pub-sub-logs".
- Click Create Sink.
Created Resources Over Time
_sourceCategory=*gcp* data "type":"cloudsql_database" methodName | parse regex "\"logName\":\"(?<log_name>[^\"]+)\"" | where log_name matches "projects/*/logs/*" | json "message.data.resource.labels", "message.data.protoPayload.methodName" as labels, method | json field=labels "database_id", "project_id", "region" as instance, project, region | json "message.data.protoPayload.authorizationInfo[*]" as permissions | parse regex field=permissions "\"permission\":\"(?<resource_type>[^\"]+)\.(?<method>[^\"]+?)\"" multi | where method = "create" | timeslice 1h | count as creations by _timeslice, resource_type | transpose row _timeslice column resource_type