Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sendmail on IIS 7.5 #841

Closed
cbinstead opened this issue Jun 9, 2015 · 7 comments
Closed

Sendmail on IIS 7.5 #841

cbinstead opened this issue Jun 9, 2015 · 7 comments

Comments

@cbinstead
Copy link

Hi,

Please can we get some advice.

Snipe is working except for being ables to send mail.
We are running this on IIS7.5 on server 2008R2
We have tried both SSL 587 and TLS 465 no mails are still being sent out from the system
We have also tried a combinationation of both SSL and TLS with the MAIL and SENDMAIL driver to no avail.

Where else can we check and look to resolve this?
Where are the logs stored for this? this is the only log I have found, below the mail.php

Our mail.php is as below:

'smtp', /* |-------------------------------------------------------------------------- | SMTP Host Address |-------------------------------------------------------------------------- | | Here you may provide the host address of the SMTP server used by your | applications. A default option is provided that is compatible with | the Postmark mail service, which will provide reliable delivery. | */ 'host' => 'smtp.gmail.com', /* |-------------------------------------------------------------------------- | SMTP Host Port |-------------------------------------------------------------------------- | | This is the SMTP port used by your application to delivery e-mails to | users of your application. Like the host we have set this value to | stay compatible with the Postmark e-mail application by default. | */ 'port' => 587, /* |-------------------------------------------------------------------------- | Global "From" Address |-------------------------------------------------------------------------- | | You may wish for all e-mails sent by your application to be sent from | the same address. Here, you may specify a name and address that is | used globally for all e-mails that are sent by your application. | */ 'from' => array('notify@domain.com' => null, 'notify@domain.com' => null), /* |-------------------------------------------------------------------------- | E-Mail Encryption Protocol |-------------------------------------------------------------------------- | | Here you may specify the encryption protocol that should be used when | the application send e-mail messages. A sensible default using the | transport layer security protocol should provide great security. | */ 'encryption' => 'ssl', /* |-------------------------------------------------------------------------- | SMTP Server Username |-------------------------------------------------------------------------- | | If your SMTP server requires a username for authentication, you should | set it here. This will get used to authenticate with your server on | connection. You may also set the "password" value below this one. | */ 'username' => 'notify@domain.com', /* |-------------------------------------------------------------------------- | SMTP Server Password |-------------------------------------------------------------------------- | | Here you may set the password required by your SMTP server to send out | messages from your application. This will be given to the server on | connection so that the application will be able to send messages. | */ 'password' => '*********', /* |-------------------------------------------------------------------------- | Sendmail System Path |-------------------------------------------------------------------------- | | When using the "sendmail" driver to send e-mails, we will need to know | the path to where Sendmail lives on this server. A default path has | been provided here, which will work well on most of your systems. | */ 'sendmail' => '/usr/sbin/sendmail -bs', /* |-------------------------------------------------------------------------- | Mail "Pretend" |-------------------------------------------------------------------------- | | When this option is enabled, e-mail will not actually be sent over the | web and will instead be written to your application's logs files so | you may inspect the message. This is great for local development. | */ 'pretend' => false, ``` ); LOG: [2015-06-09 05:34:28] production.ERROR: exception 'ErrorException' with message 'mcrypt_encrypt(): Size of key is too large for this algorithm' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php:78 Stack trace: #0 [internal function]: Illuminate\Exception\Handler->handleError(2, 'mcrypt_encrypt(...', 'D:\Published Si...', 78, Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(78): mcrypt_encrypt('rijndael-256', 'Change_this_key...', 's:40:"48f2f6eca...', 'cbc', ']|?????????????...') #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(57): Illuminate\Encryption\Encrypter->padAndMcrypt('48f2f6eca0c13db...', ']|?????????????...') #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(118): Illuminate\Encryption\Encrypter->encrypt('48f2f6eca0c13db...') #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Guard->encrypt(Object(Illuminate\Http\RedirectResponse)) #5 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #7 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #8 {main} [] [] [2015-06-09 05:35:34] production.ERROR: exception 'ErrorException' with message 'mcrypt_encrypt(): Size of key is too large for this algorithm' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php:78 Stack trace: #0 [internal function]: Illuminate\Exception\Handler->handleError(2, 'mcrypt_encrypt(...', 'D:\Published Si...', 78, Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(78): mcrypt_encrypt('rijndael-256', 'Change_this_key...', 's:40:"4987000ed...', 'cbc', '\????5?&?'dc?b?...') #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(57): Illuminate\Encryption\Encrypter->padAndMcrypt('4987000ed5c28a0...', '\????5?&?'dc?b?...') #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(118): Illuminate\Encryption\Encrypter->encrypt('4987000ed5c28a0...') #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Guard->encrypt(Object(Illuminate\Http\RedirectResponse)) #5 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #7 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #8 {main} [] [] [2015-06-09 05:35:45] production.ERROR: exception 'ErrorException' with message 'mcrypt_encrypt(): Size of key is too large for this algorithm' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php:78 Stack trace: #0 [internal function]: Illuminate\Exception\Handler->handleError(2, 'mcrypt_encrypt(...', 'D:\Published Si...', 78, Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(78): mcrypt_encrypt('rijndael-256', 'Change_this_key...', 's:40:"d9416a293...', 'cbc', '_?{Z?????v???Fn...') #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(57): Illuminate\Encryption\Encrypter->padAndMcrypt('d9416a2936a5fd8...', '_?{Z?????v???Fn...') #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(118): Illuminate\Encryption\Encrypter->encrypt('d9416a2936a5fd8...') #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Guard->encrypt(Object(Illuminate\Http\RedirectResponse)) #5 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #7 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #8 {main} [] [] [2015-06-09 05:36:33] production.ERROR: exception 'ErrorException' with message 'mcrypt_encrypt(): Size of key is too large for this algorithm' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php:78 Stack trace: #0 [internal function]: Illuminate\Exception\Handler->handleError(2, 'mcrypt_encrypt(...', 'D:\Published Si...', 78, Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(78): mcrypt_encrypt('rijndael-256', 'Change_this_key...', 's:40:"2918a2371...', 'cbc', 'X!sd??????B??2b...') #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Encryption\Encrypter.php(57): Illuminate\Encryption\Encrypter->padAndMcrypt('2918a2371735b0c...', 'X!sd??????B??2b...') #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(118): Illuminate\Encryption\Encrypter->encrypt('2918a2371735b0c...') #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Guard->encrypt(Object(Illuminate\Http\RedirectResponse)) #5 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #7 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #8 {main} [] [] [2015-06-09 06:42:47] production.ERROR: exception 'Swift_TransportException' with message 'Cannot send message without a sender address' in D:\Published Sites\ictassets\snipe-it\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Transport\AbstractSmtpTransport.php:162 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Mailer.php(85): Swift_Transport_AbstractSmtpTransport->send(Object(Swift_Message), Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Mail\Mailer.php(329): Swift_Mailer->send(Object(Swift_Message), Array) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Mail\Mailer.php(151): Illuminate\Mail\Mailer->sendSwiftMessage(Object(Swift_Message)) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(214): Illuminate\Mail\Mailer->send('emails.send-log...', Array, Object(Closure)) #4 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(159): Illuminate\Support\Facades\Facade::__callStatic('send', Array) #5 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(159): Illuminate\Support\Facades\Mail::send('emails.send-log...', Array, Object(Closure)) #6 [internal function]: Controllers\Admin\UsersController->postCreate() #7 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('postCreate', Array) #9 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(Controllers\Admin\UsersController), Object(Illuminate\Routing\Route), 'postCreate') #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'Controllers\Adm...', 'postCreate') #11 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}() #12 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #13 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #14 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #15 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #16 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #17 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #18 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #19 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #20 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #21 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #22 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #23 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #24 {main} [] [] [2015-06-09 06:48:18] production.ERROR: exception 'Swift_TransportException' with message 'Connection could not be established with host smtp.gmail.com [ #0]' in D:\Published Sites\ictassets\snipe-it\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Transport\StreamBuffer.php:265 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Transport\StreamBuffer.php(62): Swift_Transport_StreamBuffer->_establishSocketConnection() #1 D:\Published Sites\ictassets\snipe-it\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Transport\AbstractSmtpTransport.php(113): Swift_Transport_StreamBuffer->initialize(Array) #2 D:\Published Sites\ictassets\snipe-it\vendor\swiftmailer\swiftmailer\lib\classes\Swift\Mailer.php(79): Swift_Transport_AbstractSmtpTransport->start() #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Mail\Mailer.php(329): Swift_Mailer->send(Object(Swift_Message), Array) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Mail\Mailer.php(151): Illuminate\Mail\Mailer->sendSwiftMessage(Object(Swift_Message)) #5 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(214): Illuminate\Mail\Mailer->send('emails.send-log...', Array, Object(Closure)) #6 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(159): Illuminate\Support\Facades\Facade::__callStatic('send', Array) #7 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(159): Illuminate\Support\Facades\Mail::send('emails.send-log...', Array, Object(Closure)) #8 [internal function]: Controllers\Admin\UsersController->postCreate() #9 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('postCreate', Array) #11 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(Controllers\Admin\UsersController), Object(Illuminate\Routing\Route), 'postCreate') #12 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'Controllers\Adm...', 'postCreate') #13 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}() #14 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #15 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #16 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #17 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #18 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #19 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #20 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #21 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #22 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #23 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #24 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #25 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #26 {main} [] [] [2015-06-09 06:58:35] production.INFO: Pretending to mail message to: dsmyth@cmc-corporate.co.za [] [] [2015-06-09 07:00:15] production.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\RouteCollection.php:148 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1054): Illuminate\Routing\RouteCollection->match(Object(Illuminate\Http\Request)) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1022): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #5 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #7 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #9 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #11 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #12 {main} [] [] [2015-06-09 07:06:43] production.ERROR: exception 'PDOException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'phone' at row 1' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:369 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(369): PDOStatement->execute(Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(617): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'insert into `us...', Array) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(581): Illuminate\Database\Connection->runQueryCallback('insert into `us...', Array, Object(Closure)) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(370): Illuminate\Database\Connection->run('insert into `us...', Array, Object(Closure)) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(327): Illuminate\Database\Connection->statement('insert into `us...', Array) #5 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(30): Illuminate\Database\Connection->insert('insert into `us...', Array) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1910): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `us...', Array, 'id') #7 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(972): call_user_func_array(Array, Array) #9 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id') #11 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1550): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #12 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1456): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array) #13 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\User.php(317): Illuminate\Database\Eloquent\Model->save(Array) #14 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\Provider.php(297): Cartalyst\Sentry\Users\Eloquent\User->save() #15 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(134): Cartalyst\Sentry\Users\Eloquent\Provider->create(Array) #16 [internal function]: Controllers\Admin\UsersController->postCreate() #17 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #18 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('postCreate', Array) #19 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(Controllers\Admin\UsersController), Object(Illuminate\Routing\Route), 'postCreate') #20 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'Controllers\Adm...', 'postCreate') #21 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}() #22 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #23 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #24 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #25 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #26 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #27 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #28 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #29 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #30 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #31 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #32 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #33 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #34 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'phone' at row 1 (SQL: insert into `users` (`first_name`, `last_name`, `email`, `employee_num`, `jobtitle`, `location_id`, `phone`, `password`, `activated`, `notes`, `permissions`, `updated_at`, `created_at`) values (test, test, christopher.binstead@cengence.com, , , 1, support@cmc-corporate.co.za, y$FWIrLpfwZBFJcwmfFmEbHOTWrsEvYhDA4Dk1Momc3aFWNuaPTzAC., 1, , {"superuser":-1}, 2015-06-09 07:06:43, 2015-06-09 07:06:43))' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:625 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(581): Illuminate\Database\Connection->runQueryCallback('insert into `us...', Array, Object(Closure)) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(370): Illuminate\Database\Connection->run('insert into `us...', Array, Object(Closure)) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(327): Illuminate\Database\Connection->statement('insert into `us...', Array) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(30): Illuminate\Database\Connection->insert('insert into `us...', Array) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1910): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `us...', Array, 'id') #5 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(972): call_user_func_array(Array, Array) #7 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id') #9 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1550): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1456): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array) #11 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\User.php(317): Illuminate\Database\Eloquent\Model->save(Array) #12 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\Provider.php(297): Cartalyst\Sentry\Users\Eloquent\User->save() #13 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(134): Cartalyst\Sentry\Users\Eloquent\Provider->create(Array) #14 [internal function]: Controllers\Admin\UsersController->postCreate() #15 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #16 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('postCreate', Array) #17 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(Controllers\Admin\UsersController), Object(Illuminate\Routing\Route), 'postCreate') #18 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'Controllers\Adm...', 'postCreate') #19 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}() #20 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #21 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #22 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #23 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #24 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #25 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #26 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #27 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #28 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #29 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #30 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #31 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #32 {main} [] [] [2015-06-09 07:09:10] production.ERROR: exception 'Symfony\Component\HttpKernel\Exception\NotFoundHttpException' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\RouteCollection.php:148 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1054): Illuminate\Routing\RouteCollection->match(Object(Illuminate\Http\Request)) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1022): Illuminate\Routing\Router->findRoute(Object(Illuminate\Http\Request)) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #5 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #7 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #9 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #11 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #12 {main} [] [] [2015-06-09 07:29:47] production.ERROR: exception 'PDOException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'phone' at row 1' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:369 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(369): PDOStatement->execute(Array) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(617): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'insert into `us...', Array) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(581): Illuminate\Database\Connection->runQueryCallback('insert into `us...', Array, Object(Closure)) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(370): Illuminate\Database\Connection->run('insert into `us...', Array, Object(Closure)) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(327): Illuminate\Database\Connection->statement('insert into `us...', Array) #5 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(30): Illuminate\Database\Connection->insert('insert into `us...', Array) #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1910): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `us...', Array, 'id') #7 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(972): call_user_func_array(Array, Array) #9 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id') #11 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1550): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #12 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1456): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array) #13 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\User.php(317): Illuminate\Database\Eloquent\Model->save(Array) #14 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\Provider.php(297): Cartalyst\Sentry\Users\Eloquent\User->save() #15 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(134): Cartalyst\Sentry\Users\Eloquent\Provider->create(Array) #16 [internal function]: Controllers\Admin\UsersController->postCreate() #17 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #18 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('postCreate', Array) #19 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(Controllers\Admin\UsersController), Object(Illuminate\Routing\Route), 'postCreate') #20 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'Controllers\Adm...', 'postCreate') #21 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}() #22 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #23 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #24 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #25 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #26 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #27 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #28 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #29 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #30 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #31 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #32 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #33 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #34 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'phone' at row 1 (SQL: insert into `users` (`first_name`, `last_name`, `email`, `employee_num`, `jobtitle`, `location_id`, `phone`, `password`, `activated`, `notes`, `permissions`, `updated_at`, `created_at`) values (testuser, testsurname, christopher.binstead@cengence.com, , , 1, support@cmc-corporate.co.za, yX5Shs1qbsDCZwPwQ2lxaeDNJN4fC4od69w3FaudF9SC8feKBLCnm, 1, , {"superuser":-1}, 2015-06-09 07:29:47, 2015-06-09 07:29:47))' in D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php:625 Stack trace: #0 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(581): Illuminate\Database\Connection->runQueryCallback('insert into `us...', Array, Object(Closure)) #1 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(370): Illuminate\Database\Connection->run('insert into `us...', Array, Object(Closure)) #2 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Connection.php(327): Illuminate\Database\Connection->statement('insert into `us...', Array) #3 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Processors\Processor.php(30): Illuminate\Database\Connection->insert('insert into `us...', Array) #4 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php(1910): Illuminate\Database\Query\Processors\Processor->processInsertGetId(Object(Illuminate\Database\Query\Builder), 'insert into `us...', Array, 'id') #5 [internal function]: Illuminate\Database\Query\Builder->insertGetId(Array, 'id') #6 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php(972): call_user_func_array(Array, Array) #7 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->__call('insertGetId', Array) #8 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1580): Illuminate\Database\Eloquent\Builder->insertGetId(Array, 'id') #9 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1550): Illuminate\Database\Eloquent\Model->insertAndSetId(Object(Illuminate\Database\Eloquent\Builder), Array) #10 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php(1456): Illuminate\Database\Eloquent\Model->performInsert(Object(Illuminate\Database\Eloquent\Builder), Array) #11 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\User.php(317): Illuminate\Database\Eloquent\Model->save(Array) #12 D:\Published Sites\ictassets\snipe-it\vendor\cartalyst\sentry\src\Cartalyst\Sentry\Users\Eloquent\Provider.php(297): Cartalyst\Sentry\Users\Eloquent\User->save() #13 D:\Published Sites\ictassets\snipe-it\app\controllers\admin\UsersController.php(134): Cartalyst\Sentry\Users\Eloquent\Provider->create(Array) #14 [internal function]: Controllers\Admin\UsersController->postCreate() #15 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Controller.php(231): call_user_func_array(Array, Array) #16 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(93): Illuminate\Routing\Controller->callAction('postCreate', Array) #17 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php(62): Illuminate\Routing\ControllerDispatcher->call(Object(Controllers\Admin\UsersController), Object(Illuminate\Routing\Route), 'postCreate') #18 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(967): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'Controllers\Adm...', 'postCreate') #19 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}() #20 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Route.php(109): call_user_func_array(Object(Closure), Array) #21 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1033): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) #22 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Routing\Router.php(1001): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #23 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(775): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #24 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(745): Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) #25 D:\Published Sites\ictassets\snipe-it\vendor\barryvdh\laravel-debugbar\src\Middleware\Stack.php(34): Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), 1, true) #26 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Session\Middleware.php(72): Barryvdh\Debugbar\Middleware\Stack->handle(Object(Illuminate\Http\Request), 1, true) #27 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Queue.php(47): Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, true) #28 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Cookie\Guard.php(51): Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) #29 D:\Published Sites\ictassets\snipe-it\vendor\stack\builder\src\Stack\StackedHttpKernel.php(23): Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) #30 D:\Published Sites\ictassets\snipe-it\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(641): Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) #31 D:\Published Sites\ictassets\snipe-it\public\index.php(49): Illuminate\Foundation\Application->run() #32 {main} [] []
@snipe
Copy link
Owner

snipe commented Jun 9, 2015

I can't really tell what's going on in those error logs, since there's some stuff in there that's clearly not related to this, and I presume was from previous setup troubleshooting. Can you attempt to send mail using the system and just show me what shows up in new in the error logs, so I can see what the specific error is that gets triggered by trying to send mail?

Also, this bit in your config is definitely wrong:

'from' => array('notify@domain.com' => null, 'notify@domain.com' => null),

As you've substituted the wrong thing. Should be something like:

'from' => array('address' => 'notify@domain.com', 'name' => 'My Company'),

@cbinstead
Copy link
Author

Hi,

We have made the change to the MAIL.PHP file as per your outline, I have used the password reset form as a test and still no mail coming through. There is nothing displayed in the log file, I copied the original and deleted the contents just to be sure I could provide just the updated log entries.

@snipe
Copy link
Owner

snipe commented Jun 9, 2015

The settings here are what you should be using:
http://code.tutsplus.com/tutorials/sending-emails-with-laravel-4-gmail--net-36105

(Also make sure that the server is configured to be able to talk to outside services.)

@cbinstead
Copy link
Author

Hi,

The mail.php is configured as per the link you provided for us.

The server is able to communicate as we also use this for bug.net and
this is able to email out.

Is there anything else I can check?

Regards,

Chris Binstead

------ Original Message ------
From: "snipe" notifications@github.com
To: "snipe/snipe-it" snipe-it@noreply.github.com

Sent: 09/06/2015 10:50:01
Subject: Re: [snipe-it] Sendmail on IIS 7.5 (#841)

The settings here are what you should be using:
http://code.tutsplus.com/tutorials/sending-emails-with-laravel-4-gmail--net-36105

(Also make sure that the server is configured to be able to talk to
outside services.)


Reply to this email directly or view it on GitHub.

@snipe
Copy link
Owner

snipe commented Jun 9, 2015

Possibly locked via captcha? I don't know. Try this maybe.

http://stackoverflow.com/questions/26679021/laravel-gmail-smtp-not-sending-mail-through-from-address

@cbinstead
Copy link
Author

Cool thanks for assisting us.

We believe this was a TLS error.

All working correctly...

@snipe snipe closed this as completed Jun 9, 2015
@snipe
Copy link
Owner

snipe commented Jun 9, 2015

Glad you got it sorted :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants