Hi, I've got an issue where I can setup a realtime connection to listen to some tables, but some not all.
I have two tables history and users. Both can be queried by .listRows() and return results.
However when I listen to the databases.695d8f210018cf35bba0.tables.history.rows.* there are no events being sent to the client. databases.695d8f210018cf35bba0.tables.users.rows.* actually receives events.
My first thought was a permission issue, however both permissions are exactly the same (see screenshots).
The Appwrite instance is self-hosted and the domain is behind Cloudflare
// tables.history.rows.* doesn't work. tables.users.rows.* does work
this.appwriteRealtime?.subscribe(
"databases.695d8f210018cf35bba0.tables.history.rows.*",
(data) => {
console.log(data);
}
);
// how the history entries are created
this.appwriteTables?.createRow<History>({
databaseId: this.DATABASE_ID,
tableId: "history",
data,
rowId: ID.unique(),
});
Returned by the realtime connection:
{
"type": "connected",
"data": {
"channels": [
"databases.695d8f210018cf35bba0.tables.history.rows.*"
],
"user": {
"$id": "69627fa28bf6f1e551ce",
"$createdAt": "2026-01-10T16:34:42.574+00:00",
"$updatedAt": "2026-01-10T16:34:42.574+00:00",
"name": "",
"registration": "2026-01-10T16:34:42.573+00:00",
"status": true,
"labels": [],
"passwordUpdate": "",
"email": "",
"phone": "",
"emailVerification": false,
"phoneVerification": false,
"mfa": false,
"prefs": {},
"targets": [],
"accessedAt": "2026-01-10T16:34:42.573+00:00"
}
}
}
Can you try adding the permissions in this part:
// how the history entries are created
this.appwriteTables?.createRow<History>({
databaseId: this.DATABASE_ID,
tableId: "history",
data,
rowId: ID.unique(),
});
I mean, something like this:
this.appwriteTables.createRow<History>({
databaseId: this.DATABASE_ID,
tableId: "history",
rowId: ID.unique(),
data,
permissions: [
Permission.read(Role.user(userId)),
Permission.update(Role.user(userId)),
Permission.delete(Role.user(userId)),
],
});
Thanks, unfortunately this didn't solve the issue
And I just found out, that appearently the table users doesnt send any events anymore
I'm also seeing that there are no auth cookies passed over the wss. Not sure if that's something to do with it
This issue is a duplicate of https://github.com/appwrite/appwrite/issues/10923
Recommended threads
- Bulk API limitations in self-hosted serv...
Environment: Appwrite Selfhost SDK: node-appwrite 28.0 Calling `upsertRows` (also applies to `createRows`/`updateRows`/`deleteRows`) with more than 100 rows fa...
- Self Hosted GitHub connection not adding...
After upgrading to 1.9.6 i noticed that i cannot search for new repositories when trying to add new functions. I removed the existing github connection via Set...
- Unable to init function via cli
Hello! I have created a new self hosted instance of appwrite 1.9.6 and have connected to that insatnce with the cli 27.2.0 that was released a few hours ago. Wh...