[Ur] Error while loading shared libraries: liburweb_http.so.0

[Ziv Scully]

Don't give up yet—I think you're almost there! You just need to run the
Ur/Web-generated SQL script to create the tables. (As you figured out, you
need to create the database yourself.)

In your .urp file should be a line that says "sql somefile.sql" (with a
possibly more informative file name). If it's not there, add it. When this
line is there, Ur/Web will generate a file called "somefile.sql" when it
compiles that project. That file contains a SQL script that creates all the
necessary tables in the database. I believe the syntax to run it is "psql
portfolipro -f somefile.sql". After running it, try running portfolipro.exe
again.


On Tuesday, March 29, 2016, Yves Cloutier <yves.cloutier at gmail.com> wrote:

> Benjamin,
>
> I modified the line and ran the command as you suggested.  This took care
> of the error.
>
> However, when I ran my binary I then got:
>
> ./portfolipro.exe
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
>
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
>
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
>
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
>
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
>
> Fatal initialization error (out of retries): Connection to Postgres server
> failed: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/run/postgresql/.s.PGSQL.5432"?
>
> I thought perhaps the postgresql installation via octopi was not done
> properly,so I tried to reinstall it using the instructions here:
>
>
> http://www.netarky.com/programming/arch_linux/Arch_Linux_PostgreSQL_database_setup.html
>
> I recompiled and ran my binary again, but then got:
>
> ./portfolipro.exe
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: FATAL:  database "portfolipro" does not exist
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: FATAL:  database "portfolipro" does not exist
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: FATAL:  database "portfolipro" does not exist
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: FATAL:  database "portfolipro" does not exist
> Initialization error triggers bounded retry: Connection to Postgres server
> failed: FATAL:  database "portfolipro" does not exist
> Fatal initialization error (out of retries): Connection to Postgres server
> failed: FATAL:  database "portfolipro" does not exist
>
> So I then tried to create a db manually with:  createdb portfolipro
>
> I ran my binary again and got:
>
> Fatal initialization error: Table 'uw_portfolipro_experiencetable' does
> not exist.
>
> I don't know what it is with Arch, but I didn't have to do any or this on
> debian.  I also don't recall having to manually create databases and tables
> for my app to run properly.
>
> Maybe I should give up on Arch.  It just seems like I'm way over my head
> here.  I'm not much of a hacker!
>
>
>
>
>
> On Tue, Mar 29, 2016 at 11:10 AM, Benjamin Barenblat <bbaren at mit.edu
> <javascript:_e(%7B%7D,'cvml','bbaren at mit.edu');>> wrote:
>
>> On Mon, Mar 28, 2016 at 4:52 PM, Yves Cloutier <yves.cloutier at gmail.com
>> <javascript:_e(%7B%7D,'cvml','yves.cloutier at gmail.com');>> wrote:
>> > But now when executing the binary, I get the following:
>> >
>> > error while loading shared libraries: liburweb_http.so.0: cannot open
>> > shared object file: No such file or directory
>> >
>> > Using "whereis" gives the following:
>> >
>> > /usr/local/lib/liburweb_http.so
>> >
>> > […]
>> >
>> > So I assume the library is there in /usr/local/lib, but that the urweb
>> > compiler doesn't know about it somehow, and that I need to add this to
>> > path so that it knows where to find it.
>>
>> Not quite.  The compiler does know about it, but the dynamic linker on
>> your system is in the dark, because Arch doesn’t configure the dynamic
>> linker to look in /usr/local/lib by default.
>>
>> > I tried modifying /etc/ld.so.conf to:
>> >
>> > #
>> > # /etc/ld.so.conf
>> > #
>> >
>> > include /etc/ld.so.conf.d/*.conf
>> > include /usr/local/lib/*.so*
>> >
>> > # End of file
>>
>> You’re on the right track, but that’s not quite the correct syntax.
>> Please replace the line you added with just
>>
>>     /usr/local/lib
>>
>> and run
>>
>>     ldconfig
>>
>> as root.  If you still have issues, please send us the output of
>>
>>     ldd your_binary.exe
>>
>> Good luck!
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.impredicative.com/pipermail/ur/attachments/20160329/741ddc06/attachment-0001.html>