Category : amazon-rds

my first database host in aws and secound database host in diedem server. and I want to reference one column from laravel_1.uesrs table to multiple other database server in employees table . Host: 192.168.0.100 Database:[laravel_1.uesrs]: https://i.stack.imgur.com/Tq5Mm.png CreateUsersTable Schema::create(‘users’, function (Blueprint $table) { $table->bigIncrements(‘id’); $table->string(‘name’); $table->string(’email’); } Host: 10.0.0.12 (different server) Database: [laravel_2.employees]: https://i.stack.imgur.com/QcLY5.png CreateEmployeesTable Schema::create(’employees’, ..

Read more

In my laravel 8 app I am calling a mysql stored procedure by following code: $query = DB::select("call rule_sets(?, ?)",[(int)$dataset_id, Auth::user()->id]); $query_result = $query[0]; The code snippet works fine in my local environment. However in my production server (aws ec2 instance + aws rds mysql database) it is throwing QueryException with error message packets out ..

Read more

The Laravel Vapor database documentation states: To quickly create a publicly accessible database of the smallest performance class, you may use the –dev flag when creating your database. These small, affordable databases are perfect for testing or staging environments I have created a dev database with the suggested vapor database dev-db –dev command, and a ..

Read more

Laravel Migration One of my table have grater then 250 columns. When I run migration its showing Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. In local system I have resolved this error by editing file – nano /etc/mysql/my.cnf ..

Read more

Currently in a Laravel project using AWS EB with RDS. When I run php artisan migrate –seed then I get PHP Notice: Undefined index: RDS_HOSTNAME in /var/app/current/config/database.php on line 5 PHP Notice: Undefined index: RDS_USERNAME in /var/app/current/config/database.php on line 6 PHP Notice: Undefined index: RDS_PASSWORD in /var/app/current/config/database.php on line 7 PHP Notice: Undefined index: RDS_DB_NAME ..

Read more

I have a working Laravel application running on CentOS 7. After cloning the application whenever it tries to connect to the database the logs shows production.ERROR: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client Besides cloning the application, I also cloned the database so I’ve also tried pointing the cloned application to ..

Read more

I have create laravel rds mysql database but not that rds database is not connecting with ec2 instance laravel project . it is giving this error SQLSTATE[HY000] [2002] Connection timed out (SQL: select * from information_schema.tables where table_schema = asfalconsd and table_name = migrations and table_type = ‘BASE TABLE’) at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 667| // If an ..

Read more

There is the project on Laravel, which has DB on Amazon RDS. It works well, but sometimes I found such kind of error in the logs: ErrorException: PDO::prepare(): SSL operation failed with code 1. OpenSSL Error messages: error:0407008A:rsa routines:RSA_padding_check_PKCS1_type_1:invalid padding error:04067072:rsa routines:rsa_ossl_public_decrypt:padding check failed in /var/www/html/backend/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61 I googled that problem but can’t found the solution. ..

Read more

The application is deployed at http://impexonlinedata.com/ . This is the only application deployed on EC2 instance of t2.xlarge instance size. Barely any CPU usage (less than 1 %). Same for memory. There is enough space on the server. The database is an RDS instance(t2.small) with barely any CPU usage as well. Every page is taking ..

Read more

If I try to connect the Laravel 7 (PHP 7.3) app with PostgreSQL 12.4 in AWS RDS through SSL, it’s throwing this error SQLSTATE[08006] [7] SSL SYSCALL error: Connection reset by peer (SQL: select column_name from information_schema.columns where table_schema = public and table_name = roles) It is working fine with PostgreSQL 11.8, the above error ..

Read more

I am using an Ubuntu 20.04 EC2 instance with php7.4/NGINX and Laravel 8.4 point to a PostgreSQL RDS instance (no public access) in AWS. When I try to migrate (php artisan migrate) I am getting the following error: IlluminateDatabaseQueryException could not find driver (SQL: select * from information_schema.tables where table_schema = xxxxx-db-prod and table_name = ..

Read more

I am hosting my laravel website on AWS Server, after I uploaded a new version using Elastic Bean Stalk it worked fine, but after 10 – 12 hours suddenly it showed the below error, at home page and my site was not working. sqlstate hy000 error 2002 connection refused I double checked the .env file ..

Read more