You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@madlib.apache.org by Louis Leblanc <lo...@gmail.com> on 2017/05/03 23:17:47 UTC
Installation issue - OSError: [Errno 2] No such file or directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Hello,
I'm experiencing issues installing madlib on Ubuntu 16.04 with Postgresql 9.5.6.
I followed the installation process, but I have an issue when I try to
install madlib into postgres. I can't find the solution that's why I
am hoping to get some help from you.
Here is what I tried:
~$ /usr/local/madlib/bin/madpack -p postgres -c
postgres@localhost:5432/testing install
Traceback (most recent call last):
File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
line 1574, in <module>
main(sys.argv[1:])
File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
line 1163, in main
supportedVersions = [dirItem for dirItem in os.listdir(portdir)
OSError: [Errno 2] No such file or directory:
'/usr/local/madlib/Versions/1.10.0/ports/postgres'
Thanks for your help,
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Frank McQuillan <fm...@pivotal.io>.
Oh, thanks Orhan. It was a good idea to update the rpm.
On Tue, May 9, 2017 at 2:08 PM, Orhan Kislal <ok...@pivotal.io> wrote:
> Hi MADlib community,
>
> I sincerely apologize for the error. The RPM for MADlib v1.10.0 and its
> signatures have been updated. Note that the new features/improvements of
> v1.11 will not be available with this file (feel free to check the v1.11
> RPM Rahul and Frank mentioned for them). Please let us know if you have any
> questions.
>
> Thanks,
>
> Orhan Kislal
>
>
> On Tue, May 9, 2017 at 9:47 AM, Frank McQuillan <fm...@pivotal.io>
> wrote:
>
> > Apologies on the RPM error, Atsushi.
> >
> > The 1.11 release candidate is posted now
> > https://dist.apache.org/repos/dist/dev/incubator/madlib/1.
> > 11-incubating-rc3/
> > so you could use that RPM.
> >
> > As Rahul mentioned, we are in the process of voting on the 1.11 release
> > currently. However, I don't expect it to change. Official release will
> > hopefully happen later this week.
> >
> > Frank
> >
> >
> >
> > On Tue, May 9, 2017 at 9:13 AM, Rahul Iyer <ri...@apache.org> wrote:
> >
> >> +dev for the problem with RPM
> >>
> >> Hi Atsushi,
> >>
> >> Thanks for bringing this to our notice!
> >>
> >> We might have to remove the 1.10 binary from the Apache dist to avoid
> >> others from having this problem. We're in the process of releasing 1.11
> >> and
> >> would redirect to that binary once that goes through the voting process.
> >>
> >> @Louis, could you please clear the `/usr/local/madlib` folder and try
> >> again
> >> with pgxn (or compiling from source as suggested by Markus)?
> >>
> >>
> >>
> >>
> >> On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <
> >> neki.atsushi@jp.fujitsu.com>
> >> wrote:
> >>
> >> > Hi Louis, Rahul,
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > It seems that the installation using RPM binary doesn’t work for
> 1.10.0.
> >> >
> >> > The RPM doesn’t have anything but hawq under ports directory.
> >> >
> >> >
> >> >
> >> > $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep
> >> ports
> >> >
> >> >
> >> >
> >> > /usr/local/madlib/Versions/1.10.0/ports/hawq
> >> >
> >> > (snip)
> >> >
> >> >
> >> >
> >> > For 1.9.1 RPM binary, it doesn’t look so.
> >> >
> >> >
> >> >
> >> > /usr/local/madlib/Versions/1.9.1/ports/greenplum
> >> >
> >> > /usr/local/madlib/Versions/1.9.1/ports/hawq
> >> >
> >> > /usr/local/madlib/Versions/1.9.1/ports/postgres
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > Unfortunately, I have no idea about the problem with pgxn.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > Regards,
> >> >
> >> > Atsushi Neki
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
> >> > *Sent:* Saturday, May 6, 2017 2:02 PM
> >> > *To:* user@madlib.incubator.apache.org
> >> > *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
> >>
> >> > directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >> >
> >> >
> >> >
> >> > Hi Louis,
> >> >
> >> >
> >> >
> >> > I have installed madlib on Ubuntu 16.04 using following commands:
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > PSQL_HOST="127.0.0.1"
> >> >
> >> > PSQL_DB="testing"
> >> >
> >> > PSQL_USER="testuser"
> >> >
> >> > PSQL_PASS="<some_strong_password_here>"
> >> >
> >> >
> >> >
> >> > psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
> >> > '$PSQL_PASS'"
> >> >
> >> > createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
> >> >
> >> >
> >> >
> >> > sudo apt install -y cmake m4
> >> >
> >> > wget https://github.com/apache/incubator-madlib/archive/rel/v1.
> >> 10.0.tar.gz
> >> >
> >> > tar -xzf v1.10.0.tar.gz
> >> >
> >> > cd incubator-madlib-rel-v1.10.0
> >> >
> >> > ./configure
> >> >
> >> > cd build
> >> >
> >> > make
> >> >
> >> > sudo make install
> >> >
> >> >
> >> >
> >> > MADLIB_USER="mad"
> >> >
> >> > MADLIB_PASS="$(openssl rand -base64 32)"
> >> >
> >> > psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
> >> > PASSWORD '$MADLIB_PASS'"
> >> >
> >> > PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
> >> > $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
> >> >
> >> >
> >> >
> >> > psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib
> TO
> >> > $PSQL_USER"
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > Best Regards,
> >> >
> >> > Markus Paaso
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
> >> >
> >> > Thanks Rahul,
> >> >
> >> >
> >> >
> >> > I tried both solutions (with pgxn and with the RPM package).
> >> >
> >> >
> >> >
> >> > I didn't make any change to `/usr/local/madlib/Versions` after the
> >> > installation?
> >> >
> >> >
> >> >
> >> > Thanks.
> >> >
> >> >
> >> >
> >> > 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >> >
> >> > Hi Louis,
> >> >
> >> > Just to clarify: did you use the pgxn to install or the RPM package
> >> > downloaded from Apache dist?
> >> >
> >> > And was there any change made to `/usr/local/madlib/Versions` after
> the
> >> > installation?
> >> >
> >> >
> >> >
> >> > I'm going to try to reproduce the issue on an Ubuntu VM, so would
> >> > appreciate your exact steps.
> >> >
> >> >
> >> >
> >> > - Rahul
> >> >
> >> >
> >> >
> >> > On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <
> louisleblanc01@gmail.com
> >> >
> >> > wrote:
> >> >
> >> > Thanks Rahul,
> >> >
> >> >
> >> >
> >> > - I used the process described here ==> https://cwiki.apache.org/
> >> > confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> >> > PGXNInstallingfromPGXN(PostgreSQL)
> >> >
> >> > - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> >> > <https://dist.apache.org/repos/dist/release/incubator/madlib
> >> /1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
> >>
> >> >
> >> > - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
> >> >
> >> >
> >> >
> >> > Louis
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >> >
> >> > Hi Louis,
> >> >
> >> > Please help us understand the problem further.
> >> >
> >> > - What was the process you used to install MADlib?
> >> > - Which version of MADlib did you install?
> >> > - Please print the contents of `/usr/local/madlib/Versions`
> >> >
> >> > - Rahul
> >> >
> >> >
> >> > On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <
> louisleblanc01@gmail.com
> >> >
> >> > wrote:
> >> > > Hello,
> >> > >
> >> > > I'm experiencing issues installing madlib on Ubuntu 16.04 with
> >> Postgresql
> >> > > 9.5.6.
> >> > >
> >> > > I followed the installation process, but I have an issue when I try
> to
> >> > > install madlib into postgres. I can't find the solution that's why I
> >> am
> >> > > hoping to get some help from you.
> >> > >
> >> > > Here is what I tried:
> >> > >
> >> > > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> >> > > postgres@localhost:5432/testing install
> >> > >
> >> > > Traceback (most recent call last):
> >> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.
> py",
> >> > line
> >> > > 1574, in <module>
> >> > > main(sys.argv[1:])
> >> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.
> py",
> >> > line
> >> > > 1163, in main
> >> > > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> >> > > OSError: [Errno 2] No such file or directory:
> >> > > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >> > >
> >> > >
> >> > > Thanks for your help,
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> > Markus Paaso
> >> > Tel: +358504067849 <+358%2050%204067849>
> >> >
> >>
> >
> >
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Frank McQuillan <fm...@pivotal.io>.
Oh, thanks Orhan. It was a good idea to update the rpm.
On Tue, May 9, 2017 at 2:08 PM, Orhan Kislal <ok...@pivotal.io> wrote:
> Hi MADlib community,
>
> I sincerely apologize for the error. The RPM for MADlib v1.10.0 and its
> signatures have been updated. Note that the new features/improvements of
> v1.11 will not be available with this file (feel free to check the v1.11
> RPM Rahul and Frank mentioned for them). Please let us know if you have any
> questions.
>
> Thanks,
>
> Orhan Kislal
>
>
> On Tue, May 9, 2017 at 9:47 AM, Frank McQuillan <fm...@pivotal.io>
> wrote:
>
> > Apologies on the RPM error, Atsushi.
> >
> > The 1.11 release candidate is posted now
> > https://dist.apache.org/repos/dist/dev/incubator/madlib/1.
> > 11-incubating-rc3/
> > so you could use that RPM.
> >
> > As Rahul mentioned, we are in the process of voting on the 1.11 release
> > currently. However, I don't expect it to change. Official release will
> > hopefully happen later this week.
> >
> > Frank
> >
> >
> >
> > On Tue, May 9, 2017 at 9:13 AM, Rahul Iyer <ri...@apache.org> wrote:
> >
> >> +dev for the problem with RPM
> >>
> >> Hi Atsushi,
> >>
> >> Thanks for bringing this to our notice!
> >>
> >> We might have to remove the 1.10 binary from the Apache dist to avoid
> >> others from having this problem. We're in the process of releasing 1.11
> >> and
> >> would redirect to that binary once that goes through the voting process.
> >>
> >> @Louis, could you please clear the `/usr/local/madlib` folder and try
> >> again
> >> with pgxn (or compiling from source as suggested by Markus)?
> >>
> >>
> >>
> >>
> >> On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <
> >> neki.atsushi@jp.fujitsu.com>
> >> wrote:
> >>
> >> > Hi Louis, Rahul,
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > It seems that the installation using RPM binary doesn’t work for
> 1.10.0.
> >> >
> >> > The RPM doesn’t have anything but hawq under ports directory.
> >> >
> >> >
> >> >
> >> > $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep
> >> ports
> >> >
> >> >
> >> >
> >> > /usr/local/madlib/Versions/1.10.0/ports/hawq
> >> >
> >> > (snip)
> >> >
> >> >
> >> >
> >> > For 1.9.1 RPM binary, it doesn’t look so.
> >> >
> >> >
> >> >
> >> > /usr/local/madlib/Versions/1.9.1/ports/greenplum
> >> >
> >> > /usr/local/madlib/Versions/1.9.1/ports/hawq
> >> >
> >> > /usr/local/madlib/Versions/1.9.1/ports/postgres
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > Unfortunately, I have no idea about the problem with pgxn.
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > Regards,
> >> >
> >> > Atsushi Neki
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
> >> > *Sent:* Saturday, May 6, 2017 2:02 PM
> >> > *To:* user@madlib.incubator.apache.org
> >> > *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
> >>
> >> > directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >> >
> >> >
> >> >
> >> > Hi Louis,
> >> >
> >> >
> >> >
> >> > I have installed madlib on Ubuntu 16.04 using following commands:
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > PSQL_HOST="127.0.0.1"
> >> >
> >> > PSQL_DB="testing"
> >> >
> >> > PSQL_USER="testuser"
> >> >
> >> > PSQL_PASS="<some_strong_password_here>"
> >> >
> >> >
> >> >
> >> > psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
> >> > '$PSQL_PASS'"
> >> >
> >> > createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
> >> >
> >> >
> >> >
> >> > sudo apt install -y cmake m4
> >> >
> >> > wget https://github.com/apache/incubator-madlib/archive/rel/v1.
> >> 10.0.tar.gz
> >> >
> >> > tar -xzf v1.10.0.tar.gz
> >> >
> >> > cd incubator-madlib-rel-v1.10.0
> >> >
> >> > ./configure
> >> >
> >> > cd build
> >> >
> >> > make
> >> >
> >> > sudo make install
> >> >
> >> >
> >> >
> >> > MADLIB_USER="mad"
> >> >
> >> > MADLIB_PASS="$(openssl rand -base64 32)"
> >> >
> >> > psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
> >> > PASSWORD '$MADLIB_PASS'"
> >> >
> >> > PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
> >> > $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
> >> >
> >> >
> >> >
> >> > psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib
> TO
> >> > $PSQL_USER"
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > Best Regards,
> >> >
> >> > Markus Paaso
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
> >> >
> >> > Thanks Rahul,
> >> >
> >> >
> >> >
> >> > I tried both solutions (with pgxn and with the RPM package).
> >> >
> >> >
> >> >
> >> > I didn't make any change to `/usr/local/madlib/Versions` after the
> >> > installation?
> >> >
> >> >
> >> >
> >> > Thanks.
> >> >
> >> >
> >> >
> >> > 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >> >
> >> > Hi Louis,
> >> >
> >> > Just to clarify: did you use the pgxn to install or the RPM package
> >> > downloaded from Apache dist?
> >> >
> >> > And was there any change made to `/usr/local/madlib/Versions` after
> the
> >> > installation?
> >> >
> >> >
> >> >
> >> > I'm going to try to reproduce the issue on an Ubuntu VM, so would
> >> > appreciate your exact steps.
> >> >
> >> >
> >> >
> >> > - Rahul
> >> >
> >> >
> >> >
> >> > On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <
> louisleblanc01@gmail.com
> >> >
> >> > wrote:
> >> >
> >> > Thanks Rahul,
> >> >
> >> >
> >> >
> >> > - I used the process described here ==> https://cwiki.apache.org/
> >> > confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> >> > PGXNInstallingfromPGXN(PostgreSQL)
> >> >
> >> > - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> >> > <https://dist.apache.org/repos/dist/release/incubator/madlib
> >> /1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
> >>
> >> >
> >> > - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
> >> >
> >> >
> >> >
> >> > Louis
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >> >
> >> > Hi Louis,
> >> >
> >> > Please help us understand the problem further.
> >> >
> >> > - What was the process you used to install MADlib?
> >> > - Which version of MADlib did you install?
> >> > - Please print the contents of `/usr/local/madlib/Versions`
> >> >
> >> > - Rahul
> >> >
> >> >
> >> > On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <
> louisleblanc01@gmail.com
> >> >
> >> > wrote:
> >> > > Hello,
> >> > >
> >> > > I'm experiencing issues installing madlib on Ubuntu 16.04 with
> >> Postgresql
> >> > > 9.5.6.
> >> > >
> >> > > I followed the installation process, but I have an issue when I try
> to
> >> > > install madlib into postgres. I can't find the solution that's why I
> >> am
> >> > > hoping to get some help from you.
> >> > >
> >> > > Here is what I tried:
> >> > >
> >> > > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> >> > > postgres@localhost:5432/testing install
> >> > >
> >> > > Traceback (most recent call last):
> >> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.
> py",
> >> > line
> >> > > 1574, in <module>
> >> > > main(sys.argv[1:])
> >> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.
> py",
> >> > line
> >> > > 1163, in main
> >> > > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> >> > > OSError: [Errno 2] No such file or directory:
> >> > > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >> > >
> >> > >
> >> > > Thanks for your help,
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> > Markus Paaso
> >> > Tel: +358504067849 <+358%2050%204067849>
> >> >
> >>
> >
> >
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Orhan Kislal <ok...@pivotal.io>.
Hi MADlib community,
I sincerely apologize for the error. The RPM for MADlib v1.10.0 and its
signatures have been updated. Note that the new features/improvements of
v1.11 will not be available with this file (feel free to check the v1.11
RPM Rahul and Frank mentioned for them). Please let us know if you have any
questions.
Thanks,
Orhan Kislal
On Tue, May 9, 2017 at 9:47 AM, Frank McQuillan <fm...@pivotal.io>
wrote:
> Apologies on the RPM error, Atsushi.
>
> The 1.11 release candidate is posted now
> https://dist.apache.org/repos/dist/dev/incubator/madlib/1.
> 11-incubating-rc3/
> so you could use that RPM.
>
> As Rahul mentioned, we are in the process of voting on the 1.11 release
> currently. However, I don't expect it to change. Official release will
> hopefully happen later this week.
>
> Frank
>
>
>
> On Tue, May 9, 2017 at 9:13 AM, Rahul Iyer <ri...@apache.org> wrote:
>
>> +dev for the problem with RPM
>>
>> Hi Atsushi,
>>
>> Thanks for bringing this to our notice!
>>
>> We might have to remove the 1.10 binary from the Apache dist to avoid
>> others from having this problem. We're in the process of releasing 1.11
>> and
>> would redirect to that binary once that goes through the voting process.
>>
>> @Louis, could you please clear the `/usr/local/madlib` folder and try
>> again
>> with pgxn (or compiling from source as suggested by Markus)?
>>
>>
>>
>>
>> On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <
>> neki.atsushi@jp.fujitsu.com>
>> wrote:
>>
>> > Hi Louis, Rahul,
>> >
>> >
>> >
>> >
>> >
>> > It seems that the installation using RPM binary doesn’t work for 1.10.0.
>> >
>> > The RPM doesn’t have anything but hawq under ports directory.
>> >
>> >
>> >
>> > $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep
>> ports
>> >
>> >
>> >
>> > /usr/local/madlib/Versions/1.10.0/ports/hawq
>> >
>> > (snip)
>> >
>> >
>> >
>> > For 1.9.1 RPM binary, it doesn’t look so.
>> >
>> >
>> >
>> > /usr/local/madlib/Versions/1.9.1/ports/greenplum
>> >
>> > /usr/local/madlib/Versions/1.9.1/ports/hawq
>> >
>> > /usr/local/madlib/Versions/1.9.1/ports/postgres
>> >
>> >
>> >
>> >
>> >
>> > Unfortunately, I have no idea about the problem with pgxn.
>> >
>> >
>> >
>> >
>> >
>> > Regards,
>> >
>> > Atsushi Neki
>> >
>> >
>> >
>> >
>> >
>> > *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
>> > *Sent:* Saturday, May 6, 2017 2:02 PM
>> > *To:* user@madlib.incubator.apache.org
>> > *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
>>
>> > directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>> >
>> >
>> >
>> > Hi Louis,
>> >
>> >
>> >
>> > I have installed madlib on Ubuntu 16.04 using following commands:
>> >
>> >
>> >
>> >
>> >
>> > PSQL_HOST="127.0.0.1"
>> >
>> > PSQL_DB="testing"
>> >
>> > PSQL_USER="testuser"
>> >
>> > PSQL_PASS="<some_strong_password_here>"
>> >
>> >
>> >
>> > psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
>> > '$PSQL_PASS'"
>> >
>> > createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
>> >
>> >
>> >
>> > sudo apt install -y cmake m4
>> >
>> > wget https://github.com/apache/incubator-madlib/archive/rel/v1.
>> 10.0.tar.gz
>> >
>> > tar -xzf v1.10.0.tar.gz
>> >
>> > cd incubator-madlib-rel-v1.10.0
>> >
>> > ./configure
>> >
>> > cd build
>> >
>> > make
>> >
>> > sudo make install
>> >
>> >
>> >
>> > MADLIB_USER="mad"
>> >
>> > MADLIB_PASS="$(openssl rand -base64 32)"
>> >
>> > psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
>> > PASSWORD '$MADLIB_PASS'"
>> >
>> > PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
>> > $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
>> >
>> >
>> >
>> > psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
>> > $PSQL_USER"
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Best Regards,
>> >
>> > Markus Paaso
>> >
>> >
>> >
>> >
>> >
>> > 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
>> >
>> > Thanks Rahul,
>> >
>> >
>> >
>> > I tried both solutions (with pgxn and with the RPM package).
>> >
>> >
>> >
>> > I didn't make any change to `/usr/local/madlib/Versions` after the
>> > installation?
>> >
>> >
>> >
>> > Thanks.
>> >
>> >
>> >
>> > 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>> >
>> > Hi Louis,
>> >
>> > Just to clarify: did you use the pgxn to install or the RPM package
>> > downloaded from Apache dist?
>> >
>> > And was there any change made to `/usr/local/madlib/Versions` after the
>> > installation?
>> >
>> >
>> >
>> > I'm going to try to reproduce the issue on an Ubuntu VM, so would
>> > appreciate your exact steps.
>> >
>> >
>> >
>> > - Rahul
>> >
>> >
>> >
>> > On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <louisleblanc01@gmail.com
>> >
>> > wrote:
>> >
>> > Thanks Rahul,
>> >
>> >
>> >
>> > - I used the process described here ==> https://cwiki.apache.org/
>> > confluence/display/MADLIB/Installation+Guide#InstallationGuide-
>> > PGXNInstallingfromPGXN(PostgreSQL)
>> >
>> > - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
>> > <https://dist.apache.org/repos/dist/release/incubator/madlib
>> /1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
>>
>> >
>> > - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>> >
>> >
>> >
>> > Louis
>> >
>> >
>> >
>> >
>> >
>> > 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>> >
>> > Hi Louis,
>> >
>> > Please help us understand the problem further.
>> >
>> > - What was the process you used to install MADlib?
>> > - Which version of MADlib did you install?
>> > - Please print the contents of `/usr/local/madlib/Versions`
>> >
>> > - Rahul
>> >
>> >
>> > On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <louisleblanc01@gmail.com
>> >
>> > wrote:
>> > > Hello,
>> > >
>> > > I'm experiencing issues installing madlib on Ubuntu 16.04 with
>> Postgresql
>> > > 9.5.6.
>> > >
>> > > I followed the installation process, but I have an issue when I try to
>> > > install madlib into postgres. I can't find the solution that's why I
>> am
>> > > hoping to get some help from you.
>> > >
>> > > Here is what I tried:
>> > >
>> > > ~$ /usr/local/madlib/bin/madpack -p postgres -c
>> > > postgres@localhost:5432/testing install
>> > >
>> > > Traceback (most recent call last):
>> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>> > line
>> > > 1574, in <module>
>> > > main(sys.argv[1:])
>> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>> > line
>> > > 1163, in main
>> > > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
>> > > OSError: [Errno 2] No such file or directory:
>> > > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>> > >
>> > >
>> > > Thanks for your help,
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> >
>> > Markus Paaso
>> > Tel: +358504067849 <+358%2050%204067849>
>> >
>>
>
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Orhan Kislal <ok...@pivotal.io>.
Hi MADlib community,
I sincerely apologize for the error. The RPM for MADlib v1.10.0 and its
signatures have been updated. Note that the new features/improvements of
v1.11 will not be available with this file (feel free to check the v1.11
RPM Rahul and Frank mentioned for them). Please let us know if you have any
questions.
Thanks,
Orhan Kislal
On Tue, May 9, 2017 at 9:47 AM, Frank McQuillan <fm...@pivotal.io>
wrote:
> Apologies on the RPM error, Atsushi.
>
> The 1.11 release candidate is posted now
> https://dist.apache.org/repos/dist/dev/incubator/madlib/1.
> 11-incubating-rc3/
> so you could use that RPM.
>
> As Rahul mentioned, we are in the process of voting on the 1.11 release
> currently. However, I don't expect it to change. Official release will
> hopefully happen later this week.
>
> Frank
>
>
>
> On Tue, May 9, 2017 at 9:13 AM, Rahul Iyer <ri...@apache.org> wrote:
>
>> +dev for the problem with RPM
>>
>> Hi Atsushi,
>>
>> Thanks for bringing this to our notice!
>>
>> We might have to remove the 1.10 binary from the Apache dist to avoid
>> others from having this problem. We're in the process of releasing 1.11
>> and
>> would redirect to that binary once that goes through the voting process.
>>
>> @Louis, could you please clear the `/usr/local/madlib` folder and try
>> again
>> with pgxn (or compiling from source as suggested by Markus)?
>>
>>
>>
>>
>> On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <
>> neki.atsushi@jp.fujitsu.com>
>> wrote:
>>
>> > Hi Louis, Rahul,
>> >
>> >
>> >
>> >
>> >
>> > It seems that the installation using RPM binary doesn’t work for 1.10.0.
>> >
>> > The RPM doesn’t have anything but hawq under ports directory.
>> >
>> >
>> >
>> > $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep
>> ports
>> >
>> >
>> >
>> > /usr/local/madlib/Versions/1.10.0/ports/hawq
>> >
>> > (snip)
>> >
>> >
>> >
>> > For 1.9.1 RPM binary, it doesn’t look so.
>> >
>> >
>> >
>> > /usr/local/madlib/Versions/1.9.1/ports/greenplum
>> >
>> > /usr/local/madlib/Versions/1.9.1/ports/hawq
>> >
>> > /usr/local/madlib/Versions/1.9.1/ports/postgres
>> >
>> >
>> >
>> >
>> >
>> > Unfortunately, I have no idea about the problem with pgxn.
>> >
>> >
>> >
>> >
>> >
>> > Regards,
>> >
>> > Atsushi Neki
>> >
>> >
>> >
>> >
>> >
>> > *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
>> > *Sent:* Saturday, May 6, 2017 2:02 PM
>> > *To:* user@madlib.incubator.apache.org
>> > *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
>>
>> > directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>> >
>> >
>> >
>> > Hi Louis,
>> >
>> >
>> >
>> > I have installed madlib on Ubuntu 16.04 using following commands:
>> >
>> >
>> >
>> >
>> >
>> > PSQL_HOST="127.0.0.1"
>> >
>> > PSQL_DB="testing"
>> >
>> > PSQL_USER="testuser"
>> >
>> > PSQL_PASS="<some_strong_password_here>"
>> >
>> >
>> >
>> > psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
>> > '$PSQL_PASS'"
>> >
>> > createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
>> >
>> >
>> >
>> > sudo apt install -y cmake m4
>> >
>> > wget https://github.com/apache/incubator-madlib/archive/rel/v1.
>> 10.0.tar.gz
>> >
>> > tar -xzf v1.10.0.tar.gz
>> >
>> > cd incubator-madlib-rel-v1.10.0
>> >
>> > ./configure
>> >
>> > cd build
>> >
>> > make
>> >
>> > sudo make install
>> >
>> >
>> >
>> > MADLIB_USER="mad"
>> >
>> > MADLIB_PASS="$(openssl rand -base64 32)"
>> >
>> > psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
>> > PASSWORD '$MADLIB_PASS'"
>> >
>> > PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
>> > $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
>> >
>> >
>> >
>> > psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
>> > $PSQL_USER"
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Best Regards,
>> >
>> > Markus Paaso
>> >
>> >
>> >
>> >
>> >
>> > 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
>> >
>> > Thanks Rahul,
>> >
>> >
>> >
>> > I tried both solutions (with pgxn and with the RPM package).
>> >
>> >
>> >
>> > I didn't make any change to `/usr/local/madlib/Versions` after the
>> > installation?
>> >
>> >
>> >
>> > Thanks.
>> >
>> >
>> >
>> > 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>> >
>> > Hi Louis,
>> >
>> > Just to clarify: did you use the pgxn to install or the RPM package
>> > downloaded from Apache dist?
>> >
>> > And was there any change made to `/usr/local/madlib/Versions` after the
>> > installation?
>> >
>> >
>> >
>> > I'm going to try to reproduce the issue on an Ubuntu VM, so would
>> > appreciate your exact steps.
>> >
>> >
>> >
>> > - Rahul
>> >
>> >
>> >
>> > On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <louisleblanc01@gmail.com
>> >
>> > wrote:
>> >
>> > Thanks Rahul,
>> >
>> >
>> >
>> > - I used the process described here ==> https://cwiki.apache.org/
>> > confluence/display/MADLIB/Installation+Guide#InstallationGuide-
>> > PGXNInstallingfromPGXN(PostgreSQL)
>> >
>> > - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
>> > <https://dist.apache.org/repos/dist/release/incubator/madlib
>> /1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
>>
>> >
>> > - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>> >
>> >
>> >
>> > Louis
>> >
>> >
>> >
>> >
>> >
>> > 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>> >
>> > Hi Louis,
>> >
>> > Please help us understand the problem further.
>> >
>> > - What was the process you used to install MADlib?
>> > - Which version of MADlib did you install?
>> > - Please print the contents of `/usr/local/madlib/Versions`
>> >
>> > - Rahul
>> >
>> >
>> > On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <louisleblanc01@gmail.com
>> >
>> > wrote:
>> > > Hello,
>> > >
>> > > I'm experiencing issues installing madlib on Ubuntu 16.04 with
>> Postgresql
>> > > 9.5.6.
>> > >
>> > > I followed the installation process, but I have an issue when I try to
>> > > install madlib into postgres. I can't find the solution that's why I
>> am
>> > > hoping to get some help from you.
>> > >
>> > > Here is what I tried:
>> > >
>> > > ~$ /usr/local/madlib/bin/madpack -p postgres -c
>> > > postgres@localhost:5432/testing install
>> > >
>> > > Traceback (most recent call last):
>> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>> > line
>> > > 1574, in <module>
>> > > main(sys.argv[1:])
>> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>> > line
>> > > 1163, in main
>> > > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
>> > > OSError: [Errno 2] No such file or directory:
>> > > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>> > >
>> > >
>> > > Thanks for your help,
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> >
>> > Markus Paaso
>> > Tel: +358504067849 <+358%2050%204067849>
>> >
>>
>
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Frank McQuillan <fm...@pivotal.io>.
Apologies on the RPM error, Atsushi.
The 1.11 release candidate is posted now
https://dist.apache.org/repos/dist/dev/incubator/madlib/1.11-incubating-rc3/
so you could use that RPM.
As Rahul mentioned, we are in the process of voting on the 1.11 release
currently. However, I don't expect it to change. Official release will
hopefully happen later this week.
Frank
On Tue, May 9, 2017 at 9:13 AM, Rahul Iyer <ri...@apache.org> wrote:
> +dev for the problem with RPM
>
> Hi Atsushi,
>
> Thanks for bringing this to our notice!
>
> We might have to remove the 1.10 binary from the Apache dist to avoid
> others from having this problem. We're in the process of releasing 1.11 and
> would redirect to that binary once that goes through the voting process.
>
> @Louis, could you please clear the `/usr/local/madlib` folder and try again
> with pgxn (or compiling from source as suggested by Markus)?
>
>
>
>
> On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <
> neki.atsushi@jp.fujitsu.com>
> wrote:
>
> > Hi Louis, Rahul,
> >
> >
> >
> >
> >
> > It seems that the installation using RPM binary doesn’t work for 1.10.0.
> >
> > The RPM doesn’t have anything but hawq under ports directory.
> >
> >
> >
> > $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep ports
> >
> >
> >
> > /usr/local/madlib/Versions/1.10.0/ports/hawq
> >
> > (snip)
> >
> >
> >
> > For 1.9.1 RPM binary, it doesn’t look so.
> >
> >
> >
> > /usr/local/madlib/Versions/1.9.1/ports/greenplum
> >
> > /usr/local/madlib/Versions/1.9.1/ports/hawq
> >
> > /usr/local/madlib/Versions/1.9.1/ports/postgres
> >
> >
> >
> >
> >
> > Unfortunately, I have no idea about the problem with pgxn.
> >
> >
> >
> >
> >
> > Regards,
> >
> > Atsushi Neki
> >
> >
> >
> >
> >
> > *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
> > *Sent:* Saturday, May 6, 2017 2:02 PM
> > *To:* user@madlib.incubator.apache.org
> > *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
> > directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >
> >
> >
> > Hi Louis,
> >
> >
> >
> > I have installed madlib on Ubuntu 16.04 using following commands:
> >
> >
> >
> >
> >
> > PSQL_HOST="127.0.0.1"
> >
> > PSQL_DB="testing"
> >
> > PSQL_USER="testuser"
> >
> > PSQL_PASS="<some_strong_password_here>"
> >
> >
> >
> > psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
> > '$PSQL_PASS'"
> >
> > createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
> >
> >
> >
> > sudo apt install -y cmake m4
> >
> > wget https://github.com/apache/incubator-madlib/archive/rel/
> v1.10.0.tar.gz
> >
> > tar -xzf v1.10.0.tar.gz
> >
> > cd incubator-madlib-rel-v1.10.0
> >
> > ./configure
> >
> > cd build
> >
> > make
> >
> > sudo make install
> >
> >
> >
> > MADLIB_USER="mad"
> >
> > MADLIB_PASS="$(openssl rand -base64 32)"
> >
> > psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
> > PASSWORD '$MADLIB_PASS'"
> >
> > PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
> > $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
> >
> >
> >
> > psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
> > $PSQL_USER"
> >
> >
> >
> >
> >
> >
> >
> > Best Regards,
> >
> > Markus Paaso
> >
> >
> >
> >
> >
> > 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
> >
> > Thanks Rahul,
> >
> >
> >
> > I tried both solutions (with pgxn and with the RPM package).
> >
> >
> >
> > I didn't make any change to `/usr/local/madlib/Versions` after the
> > installation?
> >
> >
> >
> > Thanks.
> >
> >
> >
> > 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >
> > Hi Louis,
> >
> > Just to clarify: did you use the pgxn to install or the RPM package
> > downloaded from Apache dist?
> >
> > And was there any change made to `/usr/local/madlib/Versions` after the
> > installation?
> >
> >
> >
> > I'm going to try to reproduce the issue on an Ubuntu VM, so would
> > appreciate your exact steps.
> >
> >
> >
> > - Rahul
> >
> >
> >
> > On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
> > wrote:
> >
> > Thanks Rahul,
> >
> >
> >
> > - I used the process described here ==> https://cwiki.apache.org/
> > confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> > PGXNInstallingfromPGXN(PostgreSQL)
> >
> > - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> > <https://dist.apache.org/repos/dist/release/incubator/
> madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
> >
> > - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
> >
> >
> >
> > Louis
> >
> >
> >
> >
> >
> > 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >
> > Hi Louis,
> >
> > Please help us understand the problem further.
> >
> > - What was the process you used to install MADlib?
> > - Which version of MADlib did you install?
> > - Please print the contents of `/usr/local/madlib/Versions`
> >
> > - Rahul
> >
> >
> > On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
> > wrote:
> > > Hello,
> > >
> > > I'm experiencing issues installing madlib on Ubuntu 16.04 with
> Postgresql
> > > 9.5.6.
> > >
> > > I followed the installation process, but I have an issue when I try to
> > > install madlib into postgres. I can't find the solution that's why I am
> > > hoping to get some help from you.
> > >
> > > Here is what I tried:
> > >
> > > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> > > postgres@localhost:5432/testing install
> > >
> > > Traceback (most recent call last):
> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> > line
> > > 1574, in <module>
> > > main(sys.argv[1:])
> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> > line
> > > 1163, in main
> > > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> > > OSError: [Errno 2] No such file or directory:
> > > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> > >
> > >
> > > Thanks for your help,
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> > Markus Paaso
> > Tel: +358504067849 <+358%2050%204067849>
> >
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Frank McQuillan <fm...@pivotal.io>.
Apologies on the RPM error, Atsushi.
The 1.11 release candidate is posted now
https://dist.apache.org/repos/dist/dev/incubator/madlib/1.11-incubating-rc3/
so you could use that RPM.
As Rahul mentioned, we are in the process of voting on the 1.11 release
currently. However, I don't expect it to change. Official release will
hopefully happen later this week.
Frank
On Tue, May 9, 2017 at 9:13 AM, Rahul Iyer <ri...@apache.org> wrote:
> +dev for the problem with RPM
>
> Hi Atsushi,
>
> Thanks for bringing this to our notice!
>
> We might have to remove the 1.10 binary from the Apache dist to avoid
> others from having this problem. We're in the process of releasing 1.11 and
> would redirect to that binary once that goes through the voting process.
>
> @Louis, could you please clear the `/usr/local/madlib` folder and try again
> with pgxn (or compiling from source as suggested by Markus)?
>
>
>
>
> On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <
> neki.atsushi@jp.fujitsu.com>
> wrote:
>
> > Hi Louis, Rahul,
> >
> >
> >
> >
> >
> > It seems that the installation using RPM binary doesn’t work for 1.10.0.
> >
> > The RPM doesn’t have anything but hawq under ports directory.
> >
> >
> >
> > $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep ports
> >
> >
> >
> > /usr/local/madlib/Versions/1.10.0/ports/hawq
> >
> > (snip)
> >
> >
> >
> > For 1.9.1 RPM binary, it doesn’t look so.
> >
> >
> >
> > /usr/local/madlib/Versions/1.9.1/ports/greenplum
> >
> > /usr/local/madlib/Versions/1.9.1/ports/hawq
> >
> > /usr/local/madlib/Versions/1.9.1/ports/postgres
> >
> >
> >
> >
> >
> > Unfortunately, I have no idea about the problem with pgxn.
> >
> >
> >
> >
> >
> > Regards,
> >
> > Atsushi Neki
> >
> >
> >
> >
> >
> > *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
> > *Sent:* Saturday, May 6, 2017 2:02 PM
> > *To:* user@madlib.incubator.apache.org
> > *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
> > directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >
> >
> >
> > Hi Louis,
> >
> >
> >
> > I have installed madlib on Ubuntu 16.04 using following commands:
> >
> >
> >
> >
> >
> > PSQL_HOST="127.0.0.1"
> >
> > PSQL_DB="testing"
> >
> > PSQL_USER="testuser"
> >
> > PSQL_PASS="<some_strong_password_here>"
> >
> >
> >
> > psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
> > '$PSQL_PASS'"
> >
> > createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
> >
> >
> >
> > sudo apt install -y cmake m4
> >
> > wget https://github.com/apache/incubator-madlib/archive/rel/
> v1.10.0.tar.gz
> >
> > tar -xzf v1.10.0.tar.gz
> >
> > cd incubator-madlib-rel-v1.10.0
> >
> > ./configure
> >
> > cd build
> >
> > make
> >
> > sudo make install
> >
> >
> >
> > MADLIB_USER="mad"
> >
> > MADLIB_PASS="$(openssl rand -base64 32)"
> >
> > psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
> > PASSWORD '$MADLIB_PASS'"
> >
> > PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
> > $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
> >
> >
> >
> > psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
> > $PSQL_USER"
> >
> >
> >
> >
> >
> >
> >
> > Best Regards,
> >
> > Markus Paaso
> >
> >
> >
> >
> >
> > 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
> >
> > Thanks Rahul,
> >
> >
> >
> > I tried both solutions (with pgxn and with the RPM package).
> >
> >
> >
> > I didn't make any change to `/usr/local/madlib/Versions` after the
> > installation?
> >
> >
> >
> > Thanks.
> >
> >
> >
> > 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >
> > Hi Louis,
> >
> > Just to clarify: did you use the pgxn to install or the RPM package
> > downloaded from Apache dist?
> >
> > And was there any change made to `/usr/local/madlib/Versions` after the
> > installation?
> >
> >
> >
> > I'm going to try to reproduce the issue on an Ubuntu VM, so would
> > appreciate your exact steps.
> >
> >
> >
> > - Rahul
> >
> >
> >
> > On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
> > wrote:
> >
> > Thanks Rahul,
> >
> >
> >
> > - I used the process described here ==> https://cwiki.apache.org/
> > confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> > PGXNInstallingfromPGXN(PostgreSQL)
> >
> > - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> > <https://dist.apache.org/repos/dist/release/incubator/
> madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
> >
> > - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
> >
> >
> >
> > Louis
> >
> >
> >
> >
> >
> > 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> >
> > Hi Louis,
> >
> > Please help us understand the problem further.
> >
> > - What was the process you used to install MADlib?
> > - Which version of MADlib did you install?
> > - Please print the contents of `/usr/local/madlib/Versions`
> >
> > - Rahul
> >
> >
> > On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
> > wrote:
> > > Hello,
> > >
> > > I'm experiencing issues installing madlib on Ubuntu 16.04 with
> Postgresql
> > > 9.5.6.
> > >
> > > I followed the installation process, but I have an issue when I try to
> > > install madlib into postgres. I can't find the solution that's why I am
> > > hoping to get some help from you.
> > >
> > > Here is what I tried:
> > >
> > > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> > > postgres@localhost:5432/testing install
> > >
> > > Traceback (most recent call last):
> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> > line
> > > 1574, in <module>
> > > main(sys.argv[1:])
> > > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> > line
> > > 1163, in main
> > > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> > > OSError: [Errno 2] No such file or directory:
> > > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> > >
> > >
> > > Thanks for your help,
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> >
> > Markus Paaso
> > Tel: +358504067849 <+358%2050%204067849>
> >
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Rahul Iyer <ri...@apache.org>.
+dev for the problem with RPM
Hi Atsushi,
Thanks for bringing this to our notice!
We might have to remove the 1.10 binary from the Apache dist to avoid
others from having this problem. We're in the process of releasing 1.11 and
would redirect to that binary once that goes through the voting process.
@Louis, could you please clear the `/usr/local/madlib` folder and try again
with pgxn (or compiling from source as suggested by Markus)?
On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <ne...@jp.fujitsu.com>
wrote:
> Hi Louis, Rahul,
>
>
>
>
>
> It seems that the installation using RPM binary doesn’t work for 1.10.0.
>
> The RPM doesn’t have anything but hawq under ports directory.
>
>
>
> $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep ports
>
>
>
> /usr/local/madlib/Versions/1.10.0/ports/hawq
>
> (snip)
>
>
>
> For 1.9.1 RPM binary, it doesn’t look so.
>
>
>
> /usr/local/madlib/Versions/1.9.1/ports/greenplum
>
> /usr/local/madlib/Versions/1.9.1/ports/hawq
>
> /usr/local/madlib/Versions/1.9.1/ports/postgres
>
>
>
>
>
> Unfortunately, I have no idea about the problem with pgxn.
>
>
>
>
>
> Regards,
>
> Atsushi Neki
>
>
>
>
>
> *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
> *Sent:* Saturday, May 6, 2017 2:02 PM
> *To:* user@madlib.incubator.apache.org
> *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
> directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>
>
>
> Hi Louis,
>
>
>
> I have installed madlib on Ubuntu 16.04 using following commands:
>
>
>
>
>
> PSQL_HOST="127.0.0.1"
>
> PSQL_DB="testing"
>
> PSQL_USER="testuser"
>
> PSQL_PASS="<some_strong_password_here>"
>
>
>
> psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
> '$PSQL_PASS'"
>
> createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
>
>
>
> sudo apt install -y cmake m4
>
> wget https://github.com/apache/incubator-madlib/archive/rel/v1.10.0.tar.gz
>
> tar -xzf v1.10.0.tar.gz
>
> cd incubator-madlib-rel-v1.10.0
>
> ./configure
>
> cd build
>
> make
>
> sudo make install
>
>
>
> MADLIB_USER="mad"
>
> MADLIB_PASS="$(openssl rand -base64 32)"
>
> psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
> PASSWORD '$MADLIB_PASS'"
>
> PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
> $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
>
>
>
> psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
> $PSQL_USER"
>
>
>
>
>
>
>
> Best Regards,
>
> Markus Paaso
>
>
>
>
>
> 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
>
> Thanks Rahul,
>
>
>
> I tried both solutions (with pgxn and with the RPM package).
>
>
>
> I didn't make any change to `/usr/local/madlib/Versions` after the
> installation?
>
>
>
> Thanks.
>
>
>
> 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>
> Hi Louis,
>
> Just to clarify: did you use the pgxn to install or the RPM package
> downloaded from Apache dist?
>
> And was there any change made to `/usr/local/madlib/Versions` after the
> installation?
>
>
>
> I'm going to try to reproduce the issue on an Ubuntu VM, so would
> appreciate your exact steps.
>
>
>
> - Rahul
>
>
>
> On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
> wrote:
>
> Thanks Rahul,
>
>
>
> - I used the process described here ==> https://cwiki.apache.org/
> confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> PGXNInstallingfromPGXN(PostgreSQL)
>
> - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> <https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
>
> - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>
>
>
> Louis
>
>
>
>
>
> 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>
> Hi Louis,
>
> Please help us understand the problem further.
>
> - What was the process you used to install MADlib?
> - Which version of MADlib did you install?
> - Please print the contents of `/usr/local/madlib/Versions`
>
> - Rahul
>
>
> On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
> wrote:
> > Hello,
> >
> > I'm experiencing issues installing madlib on Ubuntu 16.04 with Postgresql
> > 9.5.6.
> >
> > I followed the installation process, but I have an issue when I try to
> > install madlib into postgres. I can't find the solution that's why I am
> > hoping to get some help from you.
> >
> > Here is what I tried:
> >
> > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> > postgres@localhost:5432/testing install
> >
> > Traceback (most recent call last):
> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> line
> > 1574, in <module>
> > main(sys.argv[1:])
> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> line
> > 1163, in main
> > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> > OSError: [Errno 2] No such file or directory:
> > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >
> >
> > Thanks for your help,
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
> Markus Paaso
> Tel: +358504067849 <+358%2050%204067849>
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Rahul Iyer <ri...@apache.org>.
+dev for the problem with RPM
Hi Atsushi,
Thanks for bringing this to our notice!
We might have to remove the 1.10 binary from the Apache dist to avoid
others from having this problem. We're in the process of releasing 1.11 and
would redirect to that binary once that goes through the voting process.
@Louis, could you please clear the `/usr/local/madlib` folder and try again
with pgxn (or compiling from source as suggested by Markus)?
On Mon, May 8, 2017 at 11:53 PM, Neki, Atsushi <ne...@jp.fujitsu.com>
wrote:
> Hi Louis, Rahul,
>
>
>
>
>
> It seems that the installation using RPM binary doesn’t work for 1.10.0.
>
> The RPM doesn’t have anything but hawq under ports directory.
>
>
>
> $ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep ports
>
>
>
> /usr/local/madlib/Versions/1.10.0/ports/hawq
>
> (snip)
>
>
>
> For 1.9.1 RPM binary, it doesn’t look so.
>
>
>
> /usr/local/madlib/Versions/1.9.1/ports/greenplum
>
> /usr/local/madlib/Versions/1.9.1/ports/hawq
>
> /usr/local/madlib/Versions/1.9.1/ports/postgres
>
>
>
>
>
> Unfortunately, I have no idea about the problem with pgxn.
>
>
>
>
>
> Regards,
>
> Atsushi Neki
>
>
>
>
>
> *From:* Markus Paaso [mailto:markus.paaso@gmail.com]
> *Sent:* Saturday, May 6, 2017 2:02 PM
> *To:* user@madlib.incubator.apache.org
> *Subject:* Re: Installation issue - OSError: [Errno 2] No such file or
> directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>
>
>
> Hi Louis,
>
>
>
> I have installed madlib on Ubuntu 16.04 using following commands:
>
>
>
>
>
> PSQL_HOST="127.0.0.1"
>
> PSQL_DB="testing"
>
> PSQL_USER="testuser"
>
> PSQL_PASS="<some_strong_password_here>"
>
>
>
> psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
> '$PSQL_PASS'"
>
> createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
>
>
>
> sudo apt install -y cmake m4
>
> wget https://github.com/apache/incubator-madlib/archive/rel/v1.10.0.tar.gz
>
> tar -xzf v1.10.0.tar.gz
>
> cd incubator-madlib-rel-v1.10.0
>
> ./configure
>
> cd build
>
> make
>
> sudo make install
>
>
>
> MADLIB_USER="mad"
>
> MADLIB_PASS="$(openssl rand -base64 32)"
>
> psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER
> PASSWORD '$MADLIB_PASS'"
>
> PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
> $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
>
>
>
> psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
> $PSQL_USER"
>
>
>
>
>
>
>
> Best Regards,
>
> Markus Paaso
>
>
>
>
>
> 2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
>
> Thanks Rahul,
>
>
>
> I tried both solutions (with pgxn and with the RPM package).
>
>
>
> I didn't make any change to `/usr/local/madlib/Versions` after the
> installation?
>
>
>
> Thanks.
>
>
>
> 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>
> Hi Louis,
>
> Just to clarify: did you use the pgxn to install or the RPM package
> downloaded from Apache dist?
>
> And was there any change made to `/usr/local/madlib/Versions` after the
> installation?
>
>
>
> I'm going to try to reproduce the issue on an Ubuntu VM, so would
> appreciate your exact steps.
>
>
>
> - Rahul
>
>
>
> On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
> wrote:
>
> Thanks Rahul,
>
>
>
> - I used the process described here ==> https://cwiki.apache.org/
> confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> PGXNInstallingfromPGXN(PostgreSQL)
>
> - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> <https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
>
> - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>
>
>
> Louis
>
>
>
>
>
> 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>
> Hi Louis,
>
> Please help us understand the problem further.
>
> - What was the process you used to install MADlib?
> - Which version of MADlib did you install?
> - Please print the contents of `/usr/local/madlib/Versions`
>
> - Rahul
>
>
> On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
> wrote:
> > Hello,
> >
> > I'm experiencing issues installing madlib on Ubuntu 16.04 with Postgresql
> > 9.5.6.
> >
> > I followed the installation process, but I have an issue when I try to
> > install madlib into postgres. I can't find the solution that's why I am
> > hoping to get some help from you.
> >
> > Here is what I tried:
> >
> > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> > postgres@localhost:5432/testing install
> >
> > Traceback (most recent call last):
> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> line
> > 1574, in <module>
> > main(sys.argv[1:])
> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> line
> > 1163, in main
> > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> > OSError: [Errno 2] No such file or directory:
> > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >
> >
> > Thanks for your help,
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
> Markus Paaso
> Tel: +358504067849 <+358%2050%204067849>
>
RE: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by "Neki, Atsushi" <ne...@jp.fujitsu.com>.
Hi Louis, Rahul,
It seems that the installation using RPM binary doesn’t work for 1.10.0.
The RPM doesn’t have anything but hawq under ports directory.
$ rpm -qlpi ./apache-madlib-1.10.0-incubating-bin-Linux.rpm | grep ports
/usr/local/madlib/Versions/1.10.0/ports/hawq
(snip)
For 1.9.1 RPM binary, it doesn’t look so.
/usr/local/madlib/Versions/1.9.1/ports/greenplum
/usr/local/madlib/Versions/1.9.1/ports/hawq
/usr/local/madlib/Versions/1.9.1/ports/postgres
Unfortunately, I have no idea about the problem with pgxn.
Regards,
Atsushi Neki
From: Markus Paaso [mailto:markus.paaso@gmail.com]
Sent: Saturday, May 6, 2017 2:02 PM
To: user@madlib.incubator.apache.org
Subject: Re: Installation issue - OSError: [Errno 2] No such file or directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Hi Louis,
I have installed madlib on Ubuntu 16.04 using following commands:
PSQL_HOST="127.0.0.1"
PSQL_DB="testing"
PSQL_USER="testuser"
PSQL_PASS="<some_strong_password_here>"
psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD '$PSQL_PASS'"
createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
sudo apt install -y cmake m4
wget https://github.com/apache/incubator-madlib/archive/rel/v1.10.0.tar.gz
tar -xzf v1.10.0.tar.gz
cd incubator-madlib-rel-v1.10.0
./configure
cd build
make
sudo make install
MADLIB_USER="mad"
MADLIB_PASS="$(openssl rand -base64 32)"
psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER PASSWORD '$MADLIB_PASS'"
PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c $MADLIB_USER@$PSQL_HOST/$PSQL_DB install
psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO $PSQL_USER"
Best Regards,
Markus Paaso
2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>>:
Thanks Rahul,
I tried both solutions (with pgxn and with the RPM package).
I didn't make any change to `/usr/local/madlib/Versions` after the installation?
Thanks.
2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>>:
Hi Louis,
Just to clarify: did you use the pgxn to install or the RPM package downloaded from Apache dist?
And was there any change made to `/usr/local/madlib/Versions` after the installation?
I'm going to try to reproduce the issue on an Ubuntu VM, so would appreciate your exact steps.
- Rahul
On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>> wrote:
Thanks Rahul,
- I used the process described here ==> https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide#InstallationGuide-PGXNInstallingfromPGXN(PostgreSQL)
- I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm<https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
- Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
Louis
2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>>:
Hi Louis,
Please help us understand the problem further.
- What was the process you used to install MADlib?
- Which version of MADlib did you install?
- Please print the contents of `/usr/local/madlib/Versions`
- Rahul
On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>> wrote:
> Hello,
>
> I'm experiencing issues installing madlib on Ubuntu 16.04 with Postgresql
> 9.5.6.
>
> I followed the installation process, but I have an issue when I try to
> install madlib into postgres. I can't find the solution that's why I am
> hoping to get some help from you.
>
> Here is what I tried:
>
> ~$ /usr/local/madlib/bin/madpack -p postgres -c
> postgres@localhost:5432/testing install
>
> Traceback (most recent call last):
> File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py", line
> 1574, in <module>
> main(sys.argv[1:])
> File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py", line
> 1163, in main
> supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> OSError: [Errno 2] No such file or directory:
> '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>
>
> Thanks for your help,
--
Markus Paaso
Tel: +358504067849
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Markus Paaso <ma...@gmail.com>.
Hi Louis,
I have installed madlib on Ubuntu 16.04 using following commands:
PSQL_HOST="127.0.0.1"
PSQL_DB="testing"
PSQL_USER="testuser"
PSQL_PASS="<some_strong_password_here>"
psql -h $PSQL_HOST template1 -c "CREATE ROLE $PSQL_USER PASSWORD
'$PSQL_PASS'"
createdb -h $PSQL_HOST $PSQL_DB -O $PSQL_USER
sudo apt install -y cmake m4
wget https://github.com/apache/incubator-madlib/archive/rel/v1.10.0.tar.gz
tar -xzf v1.10.0.tar.gz
cd incubator-madlib-rel-v1.10.0
./configure
cd build
make
sudo make install
MADLIB_USER="mad"
MADLIB_PASS="$(openssl rand -base64 32)"
psql -h $PSQL_HOST $PSQL_DB -c "CREATE USER $MADLIB_USER SUPERUSER PASSWORD
'$MADLIB_PASS'"
PGPASSWORD="$MADLIB_PASS" /usr/local/madlib/bin/madpack -p postgres -c
$MADLIB_USER@$PSQL_HOST/$PSQL_DB install
psql -h $PSQL_HOST $PSQL_DB -c "GRANT ALL PRIVILEGES ON SCHEMA madlib TO
$PSQL_USER"
Best Regards,
Markus Paaso
2017-05-05 20:11 GMT+03:00 Louis Leblanc <lo...@gmail.com>:
> Thanks Rahul,
>
> I tried both solutions (with pgxn and with the RPM package).
>
> I didn't make any change to `/usr/local/madlib/Versions` after the
> installation?
>
> Thanks.
>
> 2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>
>> Hi Louis,
>>
>> Just to clarify: did you use the pgxn to install or the RPM package
>> downloaded from Apache dist?
>> And was there any change made to `/usr/local/madlib/Versions` after the
>> installation?
>>
>> I'm going to try to reproduce the issue on an Ubuntu VM, so would
>> appreciate your exact steps.
>>
>> - Rahul
>>
>> On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
>> wrote:
>>
>>> Thanks Rahul,
>>>
>>> - I used the process described here ==> https://cwiki.apache.org/c
>>> onfluence/display/MADLIB/Installation+Guide#InstallationGuid
>>> e-PGXNInstallingfromPGXN(PostgreSQL)
>>> - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
>>> <https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
>>> - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>>>
>>> Louis
>>>
>>>
>>> 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>>>
>>>> Hi Louis,
>>>>
>>>> Please help us understand the problem further.
>>>>
>>>> - What was the process you used to install MADlib?
>>>> - Which version of MADlib did you install?
>>>> - Please print the contents of `/usr/local/madlib/Versions`
>>>>
>>>> - Rahul
>>>>
>>>> On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
>>>> wrote:
>>>> > Hello,
>>>> >
>>>> > I'm experiencing issues installing madlib on Ubuntu 16.04 with
>>>> Postgresql
>>>> > 9.5.6.
>>>> >
>>>> > I followed the installation process, but I have an issue when I try to
>>>> > install madlib into postgres. I can't find the solution that's why I
>>>> am
>>>> > hoping to get some help from you.
>>>> >
>>>> > Here is what I tried:
>>>> >
>>>> > ~$ /usr/local/madlib/bin/madpack -p postgres -c
>>>> > postgres@localhost:5432/testing install
>>>> >
>>>> > Traceback (most recent call last):
>>>> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>>>> line
>>>> > 1574, in <module>
>>>> > main(sys.argv[1:])
>>>> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>>>> line
>>>> > 1163, in main
>>>> > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
>>>> > OSError: [Errno 2] No such file or directory:
>>>> > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>>>> >
>>>> >
>>>> > Thanks for your help,
>>>>
>>>
>>>
>>
>
>
--
Markus Paaso
Tel: +358504067849
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Louis Leblanc <lo...@gmail.com>.
Thanks Rahul,
I tried both solutions (with pgxn and with the RPM package).
I didn't make any change to `/usr/local/madlib/Versions` after the
installation?
Thanks.
2017-05-05 10:54 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> Hi Louis,
>
> Just to clarify: did you use the pgxn to install or the RPM package
> downloaded from Apache dist?
> And was there any change made to `/usr/local/madlib/Versions` after the
> installation?
>
> I'm going to try to reproduce the issue on an Ubuntu VM, so would
> appreciate your exact steps.
>
> - Rahul
>
> On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
> wrote:
>
>> Thanks Rahul,
>>
>> - I used the process described here ==> https://cwiki.apache.org/c
>> onfluence/display/MADLIB/Installation+Guide#InstallationGuid
>> e-PGXNInstallingfromPGXN(PostgreSQL)
>> - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
>> <https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
>> - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>>
>> Louis
>>
>>
>> 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>>
>>> Hi Louis,
>>>
>>> Please help us understand the problem further.
>>>
>>> - What was the process you used to install MADlib?
>>> - Which version of MADlib did you install?
>>> - Please print the contents of `/usr/local/madlib/Versions`
>>>
>>> - Rahul
>>>
>>> On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
>>> wrote:
>>> > Hello,
>>> >
>>> > I'm experiencing issues installing madlib on Ubuntu 16.04 with
>>> Postgresql
>>> > 9.5.6.
>>> >
>>> > I followed the installation process, but I have an issue when I try to
>>> > install madlib into postgres. I can't find the solution that's why I am
>>> > hoping to get some help from you.
>>> >
>>> > Here is what I tried:
>>> >
>>> > ~$ /usr/local/madlib/bin/madpack -p postgres -c
>>> > postgres@localhost:5432/testing install
>>> >
>>> > Traceback (most recent call last):
>>> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>>> line
>>> > 1574, in <module>
>>> > main(sys.argv[1:])
>>> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>>> line
>>> > 1163, in main
>>> > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
>>> > OSError: [Errno 2] No such file or directory:
>>> > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>>> >
>>> >
>>> > Thanks for your help,
>>>
>>
>>
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Rahul Iyer <ri...@apache.org>.
Hi Louis,
Just to clarify: did you use the pgxn to install or the RPM package
downloaded from Apache dist?
And was there any change made to `/usr/local/madlib/Versions` after the
installation?
I'm going to try to reproduce the issue on an Ubuntu VM, so would
appreciate your exact steps.
- Rahul
On Thu, May 4, 2017 at 8:41 AM, Louis Leblanc <lo...@gmail.com>
wrote:
> Thanks Rahul,
>
> - I used the process described here ==> https://cwiki.apache.org/
> confluence/display/MADLIB/Installation+Guide#InstallationGuide-
> PGXNInstallingfromPGXN(PostgreSQL)
> - I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
> <https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
> - Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
>
> Louis
>
>
> 2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
>
>> Hi Louis,
>>
>> Please help us understand the problem further.
>>
>> - What was the process you used to install MADlib?
>> - Which version of MADlib did you install?
>> - Please print the contents of `/usr/local/madlib/Versions`
>>
>> - Rahul
>>
>> On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
>> wrote:
>> > Hello,
>> >
>> > I'm experiencing issues installing madlib on Ubuntu 16.04 with
>> Postgresql
>> > 9.5.6.
>> >
>> > I followed the installation process, but I have an issue when I try to
>> > install madlib into postgres. I can't find the solution that's why I am
>> > hoping to get some help from you.
>> >
>> > Here is what I tried:
>> >
>> > ~$ /usr/local/madlib/bin/madpack -p postgres -c
>> > postgres@localhost:5432/testing install
>> >
>> > Traceback (most recent call last):
>> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>> line
>> > 1574, in <module>
>> > main(sys.argv[1:])
>> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
>> line
>> > 1163, in main
>> > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
>> > OSError: [Errno 2] No such file or directory:
>> > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>> >
>> >
>> > Thanks for your help,
>>
>
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Louis Leblanc <lo...@gmail.com>.
Thanks Rahul,
- I used the process described here ==>
https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide#InstallationGuide-PGXNInstallingfromPGXN(PostgreSQL)
- I used the version apache-madlib-1.10.0-incubating-bin-Linux.rpm
<https://dist.apache.org/repos/dist/release/incubator/madlib/1.10.0-incubating/apache-madlib-1.10.0-incubating-bin-Linux.rpm>
- Content of the folder `/usr/local/madlib/Versions` ==> 1.10.0
Louis
2017-05-03 17:31 GMT-06:00 Rahul Iyer <ri...@apache.org>:
> Hi Louis,
>
> Please help us understand the problem further.
>
> - What was the process you used to install MADlib?
> - Which version of MADlib did you install?
> - Please print the contents of `/usr/local/madlib/Versions`
>
> - Rahul
>
> On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com>
> wrote:
> > Hello,
> >
> > I'm experiencing issues installing madlib on Ubuntu 16.04 with Postgresql
> > 9.5.6.
> >
> > I followed the installation process, but I have an issue when I try to
> > install madlib into postgres. I can't find the solution that's why I am
> > hoping to get some help from you.
> >
> > Here is what I tried:
> >
> > ~$ /usr/local/madlib/bin/madpack -p postgres -c
> > postgres@localhost:5432/testing install
> >
> > Traceback (most recent call last):
> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> line
> > 1574, in <module>
> > main(sys.argv[1:])
> > File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py",
> line
> > 1163, in main
> > supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> > OSError: [Errno 2] No such file or directory:
> > '/usr/local/madlib/Versions/1.10.0/ports/postgres'
> >
> >
> > Thanks for your help,
>
Re: Installation issue - OSError: [Errno 2] No such file or
directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Posted by Rahul Iyer <ri...@apache.org>.
Hi Louis,
Please help us understand the problem further.
- What was the process you used to install MADlib?
- Which version of MADlib did you install?
- Please print the contents of `/usr/local/madlib/Versions`
- Rahul
On Wed, May 3, 2017 at 4:17 PM, Louis Leblanc <lo...@gmail.com> wrote:
> Hello,
>
> I'm experiencing issues installing madlib on Ubuntu 16.04 with Postgresql
> 9.5.6.
>
> I followed the installation process, but I have an issue when I try to
> install madlib into postgres. I can't find the solution that's why I am
> hoping to get some help from you.
>
> Here is what I tried:
>
> ~$ /usr/local/madlib/bin/madpack -p postgres -c
> postgres@localhost:5432/testing install
>
> Traceback (most recent call last):
> File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py", line
> 1574, in <module>
> main(sys.argv[1:])
> File "/usr/local/madlib/Versions/1.10.0/bin/../madpack/madpack.py", line
> 1163, in main
> supportedVersions = [dirItem for dirItem in os.listdir(portdir)
> OSError: [Errno 2] No such file or directory:
> '/usr/local/madlib/Versions/1.10.0/ports/postgres'
>
>
> Thanks for your help,