yajra/homestead-oracle

Laravel local development environment with Oracle XE 11g

homestead-oracle's Issues

OCI doesn't work with current homestead / fresh install

Hi there,

First of all, I want to say thanks for your effort :)

I need to connect to a remote Oracle DB, so I tried out your Homestead version. I followed the instructions and updated the config/Homestead.yaml-file (= changing the provider to vmware_fusion & changing the tld to .test). After running vagrant up, it finished with the following warnings:

default: /tmp/vagrant-shell: line 5: /etc/php/mods-available/oci8.ini: No such file or directory
default: WARNING: Module oci8 ini file doesn't exist under /etc/php/7.0/mods-available
default: WARNING: Module oci8 ini file doesn't exist under /etc/php/7.0/mods-available

Therefore, I changed the scripts/install-oci8.sh:

-       echo 'extension=oci8.so' > /etc/php/mods-available/oci8.ini
+       echo 'extension=oci8.so' > /etc/php/7.0/mods-available/oci8.ini

Now comes the fun part ;) I checked phpinfo():

• @ webbrowser: PHP 7.0.26-1+ubuntu16.04.1+deb.sury.org+1
• oci8-section was missing!
• PHP @ CLI: PHP 7.2.0-1+ubuntu16.04.1+deb.sury.org+1 (cli)
• php -m | grep 'oci8' returns nothing
• as soon as I try to connect to an Oracle DB, I get the Call to undefined function Yajra\Pdo\oci_connect()-exception.
• changing PHP's CLI version throws the following warning:

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/20160303/oci8.so' - /usr/lib/php/20160303/oci8.so: cannot open shared object file: No such file or directory in Unknown on line 0

Also:
After running vagrant provision, it exits out with the following statement:

    default: Job for nginx.service failed. See "systemctl status nginx.service" and "journalctl -xe" for details.
    default: Job for php7.0-fpm.service failed. See "systemctl status php7.0-fpm.service" and "journalctl -xe" for details.
The SSH command responded with a non-zero exit status. Vagrant
assumes that this means the command failed. The output for this command
should be in the log above. Please read the output to determine what
went wrong.

Meh :(

Do you have any tips on how to proceed?

Thanks in advance and happy holidays :)

Provisioning failing

==> default: Running provisioner: shell...
    default: Running: inline script
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-1t351rh.sh
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-1gpdet5.sh
==> default: nginx stop/waiting
==> default: nginx start/running, process 16245
==> default: php5-fpm stop/waiting
==> default: php5-fpm start/running, process 16260
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-9pte1n.sh
==> default: Warning: Using a password on the command line interface can be insecure.
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-1fipykg.sh
==> default: createdb: database creation failed: ERROR:  database "homestead" already exists
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-q1grxo.sh
==> default: DROP USER homestead CASCADE
==> default:           *
==> default: ERROR at line 1:
==> default: ORA-01918: user 'HOMESTEAD' does not exist
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-1j500rx.sh
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-1sh9rqg.sh
==> default: pecl/oci8 requires PHP (version >= 7.0.0), installed version is 5.6.13-1+deb.sury.org~trusty+3
==> default: No valid packages found
==> default: install failed
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: php5-fpm stop/waiting
==> default: php5-fpm start/running, process 16539
==> default: Running provisioner: shell...
    default: Running: inline script
==> default: PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/20131226/oci8.so' - /usr/lib/php5/20131226/oci8.so: cannot open shared object file: No such file or directory in Unknown on line 0
==> default: Updating to version c9501a4cc164b176de48e44b239e619cfd5f14e5.
==> default:     Downloading: Connecting...
==> default: 
==> default:     Downloading: 100%
==> default:          
==> default: 
==> default: Use composer self-update --rollback to return to version 15face5432d7b7334db6ac69fac0190971cafa6e
==> default: Running provisioner: shell...
    default: Running: /tmp/vagrant-shell20151220-24822-2pab3p.sh

Any idea what could be the issue?

I guess the oci8 pecl install fails....trying to install latest 7.0 package is probably wrong

fix-ppa-php.sh

the commit 22d42b9 indicates that already repaired, but still showing an error loading my virtual machine.

http://prntscr.com/bbhsj3

but if the file is located in the scripts folder

Error vagrant provision

default: Reading state information...
default: The following additional packages will be installed:
default:   augeas-lenses debconf-utils facter fonts-lato hiera javascript-common
default:   libaugeas0 libjs-jquery libruby2.3 libyaml-0-2 puppet-common rake ruby
default:   ruby-augeas ruby-deep-merge ruby-did-you-mean ruby-json ruby-minitest
default:   ruby-net-telnet ruby-nokogiri ruby-power-assert ruby-rgen ruby-safe-yaml
default:   ruby-selinux ruby-shadow ruby-test-unit ruby2.3 rubygems-integration
default:   virt-what zip
default: Suggested packages:
default:   augeas-doc mcollective-common augeas-tools puppet-el vim-puppet etckeeper
default:   ruby-rrd ri ruby-dev bundler
default: The following NEW packages will be installed:
default:   augeas-lenses debconf-utils facter fonts-lato hiera javascript-common
default:   libaugeas0 libjs-jquery libruby2.3 libyaml-0-2 puppet puppet-common rake
default:   ruby ruby-augeas ruby-deep-merge ruby-did-you-mean ruby-json ruby-minitest
default:   ruby-net-telnet ruby-nokogiri ruby-power-assert ruby-rgen ruby-safe-yaml
default:   ruby-selinux ruby-shadow ruby-test-unit ruby2.3 rubygems-integration
default:   virt-what zip
default: 0 upgraded, 31 newly installed, 0 to remove and 3 not upgraded.
default: Need to get 2,999 kB/8,154 kB of archives.
default: After this operation, 37.8 MB of additional disk space will be used.
default: Err:1 http://security.ubuntu.com/ubuntu xenial-security/main amd64 libruby2.3 amd64 2.3.1-2~16.04.2
default:   404  Not Found [IP: 91.189.88.162 80]
default: Ign:2 http://security.ubuntu.com/ubuntu xenial-security/main amd64 ruby2.3 amd64 2.3.1-2~16.04.2
default: Err:1 http://security.ubuntu.com/ubuntu xenial-security/main amd64 libruby2.3 amd64 2.3.1-2~16.04.2
default:   404  Not Found [IP: 91.189.88.162 80]
default: Err:2 http://security.ubuntu.com/ubuntu xenial-security/main amd64 ruby2.3 amd64 2.3.1-2~16.04.2
default:   404  Not Found [IP: 91.189.88.162 80]
default: E: Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/r/ruby2.3/libruby2.3_2.3.1-2~16.04.2_amd64.deb  404  Not Found [IP: 91.189.88.162 80]
default:
default: E: Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/r/ruby2.3/ruby2.3_2.3.1-2~16.04.2_amd64.deb  404  Not Found [IP: 91.189.88.162 80]
default:
default: E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Please help me

I found the problem in the new Laravel Homestead

I found the problem in the new Laravel Homestead

homestead-oracle\scripts\homestead.rb
Original

  config.vm.provision :shell, :inline => "sudo add-apt-repository ppa:ondrej/php"

  # Install puppet for oracle installation
  config.vm.provision :shell, :inline => "apt-get -y install puppet"

Modify

  config.vm.provision :shell, :inline => "sudo add-apt-repository ppa:ondrej/php"

  config.vm.provision :shell, :inline => "sudo rm /var/lib/dpkg/lock"

  config.vm.provision :shell, :inline => "sudo rm /var/cache/apt/archives/lock"

  # Install puppet for oracle installation
  config.vm.provision :shell, :inline => "apt-get -y install puppet"

homestead-oracle\scripts\install-oci8.sh
Original
echo 'extension=oci8.so' > /etc/php/mods-available/oci8.ini

Modify
echo 'extension=oci8.so' > /etc/php/7.0/mods-available/oci8.ini

Update According to Official

Do you have any intention to update the homestead according to the official?
As an example, using php7

Development server in DigitalOcean

Any idea how can I use this for my development server in DigitalOcean?

I'm having trouble starting the homestead.

It happens:

==> default: Failed to restart php7.0-fpm.service: Unit php7.0-fpm.service not found.
The SSH command responded with a non-zero exit status. Vagrant
assumes that this means the command failed. The output for this command
should be in the log above. Please read the output to determine what
went wrong.

Vagrant Up Issue

Hello,

After putting the oracle-xe-11.2.0-1.0.x86_64.rpm.zip file into the puppet/modules/oracle/files directory and running "vagrant up" I get the following error:

"The following SSH command responded with a non-zero exit status.
Vagrant assumes that this means the command failed!

apt-get install -y linux-headers-uname -r dkms

Stdout from the command:

Reading package lists...
Building dependency tree...
Reading state information...
dkms is already the newest version (2.2.0.3-2ubuntu11.3).
linux-headers-4.4.0-51-generic is already the newest version (4.4.0-51.72).
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
google-chrome-stable : Depends: libpango1.0-0 (>= 1.14.0) but it is not going to be installed
Depends: fonts-liberation but it is not going to be installed

Stderr from the command:

E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution)."

Do you know how to correct this issue? Thanks for any help you can provide.

Master (PHP 5.x) branch giving PHP 7

Hi @yajra

When I do a fresh clean clone of the master branch and do vagrant up it does the base box import and a whole bunch of provisioning, and then it says php5-fpm: unrecognized service. And when I vagrant SSH in to the box and do service --status-all it has php7.0-fpm in the list but not php5-fpm.

So I'm fairly sure it's installing PHP 7 and not PHP 5.x. So I tried changing "php": ">=5.4" to "php": "~5.4" in composer.json, but that hasn't helped.

Also I'm guessing I probably need to specify version 0.3.x of the base box, not 0.4.0, because 0.4.0 is on PHP7. So I've added a config.vm.box_version = "~> 0.3" line right under config.vm.box = settings["box"] ||= "laravel/homestead" in scripts/homestead.rb, but that hasn't helped either. Even after I did a vagrant destroy && vagrant up, just to be sure. (You can see my attempts in this branch.)

Do you happen to have any suggestions on what I might need to do to get PHP 5 working again?

With many thanks,
@BrendanTWhite.