Backpack admin panel with firebase

[nasma321]

Hello team,

I am new to the backpack admin panel package and am trying to install it in one of my Laravel projects. The project is connected with Firebase and it is working fine. But when I install the backpack package, it throws me the unknown database error and it is trying to access the MySQL database. Below am attaching the error I get:

[2023-04-04 15:58:46] local.ERROR: SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 1049): SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE') at C:\\xampp\\htdocs\\winged\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712)

And below is my .env file:

With this error I cannot move forward with my project, any help would be appreciated. Thanks!

[tabacitu]

Hi @nasma321 ,

I haven't used Firebase with Backpack. But Backpack doesn't work directly with any database, it works with Eloquent models. So if the Eloquent models are properly set up, it should work fine. What are you using to connect Eloquent models to Firebase, is it Marcel's https://github.com/mpociot/laravel-firebase-sync?

Your error seems pretty clear - the database doesn't exit. Your config/db.php file is probably set up with the default configs, which point to a MySQL database... but that MySQL database doesn't exist. To fix this, make sure you can run migrations in your project.

This is a Laravel problem, not a Backpack problem, so you can look for general tutorials about Laravel + Firebase like this one - https://pociot.dev/16-using-eloquent-models-with-the-firebase-realtime-database Heads-up, one thing I notice about Marcel's package is that it's NOT an Eloquent adapter for Firebase. So it might not be a 100% solution. It only advertises doing "sync" which I assume will need to hold the info somewhere (MySQL, SQLite, flatfile, array) then only sync it to Firebase.

Hope it helps.
Cheers!

[o15a3d4l11s2]

What package did you use? What we described with Tabacitu is that we see no possible solution at the moment. Backpack uses Eloquent models. I could not find any package that uses Firebase and still goes through Eloquent. You current error just shows that the host (Google Firebase) refuses a database connection and this is normal, because Firebase uses other way of communicating and does not work in the conventional database way.

[nasma321]

@tabacitu @o15a3d4l11s2 finally I had to use a mysql database for the backpack at the same time accessing data from firebase :/

[o15a3d4l11s2]

If you are storing data both in the mysql database and the Firebase storage, does this mean that you need different data in the different places? Depending on the exact use-case it might be better to use different tools from the ones you are currently trying to connect?

[tabacitu]

Heads-up - if MySQL is too much for your use case (it just holds a few users, or something like that), you could use an SQLite db too.

[jcastroa87]

Due to no activity, I will close this issue, but please feel free to reopen or create a new one if needed.

Cheers