Saturday, September 3, 2016

Username and Password not accepted at Gmail SMTP Laravel 5.2

Whoops, looks like something went wrong.

1/1 Swift_TransportException in AbstractSmtpTransport.php line 383: Expected response code 250 but got code "535", with message "535-5.7.8 Username and Password not accepted. Learn more at
535 5.7.8 https://support.google.com/mail/answer/14257 yu7sm18711248pab.45 - gsmtp
"

  1. in AbstractSmtpTransport.php line 383
  2. at Swift_Transport_AbstractSmtpTransport->_assertResponseCode('535-5.7.8 Username and Password not accepted. Learn more at 535 5.7.8 https://support.google.com/mail/answer/14257 yu7sm18711248pab.45 - gsmtp ', array('250')) in AbstractSmtpTransport.php line 281
  3. at Swift_Transport_AbstractSmtpTransport->executeCommand('RSET ', array('250'), array()) in EsmtpTransport.php line 270
  4. at Swift_Transport_EsmtpTransport->executeCommand('RSET ', array('250')) in XOAuth2Authenticator.php line 55
  5. at Swift_Transport_Esmtp_Auth_XOAuth2Authenticator->authenticate(object(Swift_SmtpTransport), 'adiatstei07@gmail.com', 'hisoka@adi@187') in AuthHandler.php line 176
  6. at Swift_Transport_Esmtp_AuthHandler->afterEhlo(object(Swift_SmtpTransport)) in EsmtpTransport.php line 334
  7. at Swift_Transport_EsmtpTransport->_doHeloCommand() in AbstractSmtpTransport.php line 118
  8. at Swift_Transport_AbstractSmtpTransport->start() in Mailer.php line 79
  9. at Swift_Mailer->send(object(Swift_Message), array()) in Mailer.php line 385
  10. at Mailer->sendSwiftMessage(object(Swift_Message)) in Mailer.php line 171
  11. at Mailer->send(null, array('message' => object(Message)), object(Closure)) in Mailer.php line 125
  12. at Mailer->raw('email.welcome', object(Closure)) in Facade.php line 219
  13. at Facade::__callStatic('raw', array('email.welcome', object(Closure))) in HomeController.php line 44
  14. at HomeController->defaultSend()
  15. at call_user_func_array(array(object(HomeController), 'defaultSend'), array()) in Controller.php line 80
  16. at Controller->callAction('defaultSend', array()) in ControllerDispatcher.php line 146
  17. at ControllerDispatcher->call(object(HomeController), object(Route), 'defaultSend') in ControllerDispatcher.php line 94
  18. at ControllerDispatcher->Illuminate\Routing\{closure}(object(Request))
  19. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  20. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  21. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  22. at Pipeline->then(object(Closure)) in ControllerDispatcher.php line 96
  23. at ControllerDispatcher->callWithinStack(object(HomeController), object(Route), object(Request), 'defaultSend') in ControllerDispatcher.php line 54
  24. at ControllerDispatcher->dispatch(object(Route), object(Request), 'App\Http\Controllers\HomeController', 'defaultSend') in Route.php line 174
  25. at Route->runController(object(Request)) in Route.php line 140
  26. at Route->run(object(Request)) in Router.php line 724
  27. at Router->Illuminate\Routing\{closure}(object(Request))
  28. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  29. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 64
  30. at VerifyCsrfToken->handle(object(Request), object(Closure))
  31. at call_user_func_array(array(object(VerifyCsrfToken), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  32. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  33. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  34. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  35. at ShareErrorsFromSession->handle(object(Request), object(Closure))
  36. at call_user_func_array(array(object(ShareErrorsFromSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  37. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  38. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  39. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  40. at StartSession->handle(object(Request), object(Closure))
  41. at call_user_func_array(array(object(StartSession), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  42. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  43. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  44. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  45. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
  46. at call_user_func_array(array(object(AddQueuedCookiesToResponse), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  47. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  48. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  49. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  50. at EncryptCookies->handle(object(Request), object(Closure))
  51. at call_user_func_array(array(object(EncryptCookies), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  52. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  53. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  54. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  55. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  56. at Pipeline->then(object(Closure)) in Router.php line 726
  57. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 699
  58. at Router->dispatchToRoute(object(Request)) in Router.php line 675
  59. at Router->dispatch(object(Request)) in Kernel.php line 246
  60. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
  61. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 52
  62. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 44
  63. at CheckForMaintenanceMode->handle(object(Request), object(Closure))
  64. at call_user_func_array(array(object(CheckForMaintenanceMode), 'handle'), array(object(Request), object(Closure))) in Pipeline.php line 136
  65. at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
  66. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 32
  67. at Pipeline->Illuminate\Routing\{closure}(object(Request))
  68. at call_user_func(object(Closure), object(Request)) in Pipeline.php line 102
  69. at Pipeline->then(object(Closure)) in Kernel.php line 132
  70. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 99
  71. at Kernel->handle(object(Request)) in index.php line 53
  72. at require_once('C:\xampp\htdocs\TestQueue2\queuelagi\public\index.php') in server.php line 21


Open these links and turn it on/activate the service :
1. https://www.google.com/settings/security/lesssecureapps 
2. https://accounts.google.com/b/0/DisplayUnlockCaptcha {This is an optional step}





After setting above config, restart your laravel server... Turn off your antivirus... aaaand... you are good to rock... :)

Sunday, August 28, 2016

Playing with PHP Artisan Migration Commands in Laravel 5.3 - Executing Migrations File

In previous post, we have created some migration files so rightnow we can run migration command to add tables to our database. Here's our migrations files :
Then let's run "php artisan migrate" to execute those files....
So... There is only one table created in database but actually we were executing 3 migrations files that we created before. Why is that happened? because 2 files contains no tables... :D only migration_2 files has table and column inside...
Sooo... mmm... let's get back to migration_1 file and put some columns there like this one :
So we added 4 columns, id, myAwesomeColumn, created_at & updated_at from timestamps...So let's run or execute this file again by using "php artisan migrate".. :D
Ooops... We have executed php artisan migrate before, so there is nothing to migrate... So we know that migrate is only work for new migration file. So for the old one, we can use three options, migrate:refresh,reset, and rollback :
We will try all of those commands one by one.. :D
First let's try rollback.....So type php artisan migrate:rollback
Rollback is almost same with reset... It will remove all of our last migration table. So our DB will contain just migration table. Then run "php artisan migrate" again aaand....

So...be carefull when using this rollback command because it will gonna delete all of your data... :D
Next... Let's try migrate:reset...
aaand... waaaw... database is empy again.. :v
So what's the different between rollback and reset...??? mmm... let's find out later.. :)
Then let's see migrate:refresh....
So refresh is using rollback first and then migrate all of the migration file... :)

One thing to note that if have put some data in our database, the refresh will also delete all data in database because it's using rollback... So becarefull with this one too.. :v

So how to add new column without deleting our data...??? This will be covered in the next post...:)
See yaaaa......

Go to the next post....