Data Source Connection Errors

Resolve issues connecting to databases, APIs, and integrations.

Common Connection Issues

Authentication Failures

Error: "Authentication failed" or "Invalid credentials"

Causes:
- Incorrect username/password
- Expired credentials
- User lacks permissions

Solutions:
1. Verify credentials are correct
2. Check password hasn't expired
3. Ensure user has SELECT permissions
4. Try connecting with same credentials via other tool

Connection Refused

Error: "Connection refused" or "Cannot connect to host"

Causes:
- Wrong host/port
- Firewall blocking connection
- Service not running

Solutions:
1. Verify host address and port
2. Check database server is running
3. Whitelist clariBI IPs in firewall
4. Test with local connection tool

SSL/TLS Errors

Error: "SSL certificate problem" or "TLS handshake failed"

Causes:
- SSL not enabled on server
- Self-signed certificate
- Certificate expired

Solutions:
1. Verify SSL configuration on server
2. Use correct SSL mode setting
3. Update expired certificates
4. Try with SSL disabled (if internal network)

Timeout Errors

Error: "Connection timed out"

Causes:
- Network latency
- Server overloaded
- Wrong host address

Solutions:
1. Increase connection timeout setting
2. Check network connectivity
3. Verify server is responsive
4. Try during off-peak hours

Database-Specific Issues

PostgreSQL

```
Error: "no pg_hba.conf entry for host"
Solution: Add clariBI IP to pg_hba.conf

Error: "SSL off" when SSL required
Solution: Enable SSL in connection settings
```

MySQL

```
Error: "Host not allowed to connect"
Solution: GRANT access from clariBI IP

Error: "Unknown database"
Solution: Verify database name spelling
```

OAuth Integration Issues

Google Services

• Re-authorize if token expired
• Check required API scopes
• Verify API is enabled in Google Console

Meta/Facebook

• Re-connect if permissions changed
• Ensure ad account access
• Check app review status

Jira

• Verify Atlassian site URL
• Check API token validity
• Confirm project permissions

Testing Connections

Connection Test Button

1. Open data source settings
2. Click Test Connection
3. Review error details
4. Fix identified issues
5. Retry test

Manual Verification

Test from your server:
```bash

PostgreSQL

psql -h host -p 5432 -U user -d database

MySQL

mysql -h host -P 3306 -u user -p database
```

Getting Help

Information to Provide

When contacting support:
- Exact error message
- Data source type
- Connection method (direct, SSH, SSL)
- When issue started
- Any recent changes