madlib-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neki, Atsushi" <neki.atsu...@jp.fujitsu.com>
Subject RE: Installation issue - OSError: [Errno 2] No such file or directory: '/usr/local/madlib/Versions/1.10.0/ports/postgres'
Date Tue, 09 May 2017 06:53:00 GMT
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 <louisleblanc01@gmail.com<mailto:louisleblanc01@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 <riyer@apache.org<mailto:riyer@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<mailto: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 <riyer@apache.org<mailto:riyer@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<mailto: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
Mime
View raw message