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 <[email protected]> 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 <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > >> On Mon, Mar 28, 2016 at 4:52 PM, Yves Cloutier <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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! >> > >
_______________________________________________ Ur mailing list [email protected] http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
