How to Compile?


#1

Any can give me idea how to compile the Escargot Server Files?

Thanks You!


#2

Python is not a compiled language but an interpreted one. You just type “python dev” from the folder you extracted the files to in order to start Escargot.


#3

That’s okay xD…

I download the escargot-msn and msn-server

all run okay… but…

when, i try to create account: http://127.0.0.1:8080/
i can complete the form and … it go to…

http://127.0.0.1:8080/#create-account

and show this error:

    500 Internal Server Error

Server got itself in trouble

and in the escargot-msn console:

c:\msn-escargot>runserver.py
======== Running on http://0.0.0.0:8080 ========
(Press CTRL+C to quit)
Error handling request
Traceback (most recent call last):
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\b
ase.py”, line 1182, in _execute_context
context)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\d
efault.py”, line 470, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: t_user

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “C:\Program Files (x86)\Python36-32\lib\site-packages\aiohttp\web_protoco
l.py”, line 422, in start
resp = yield from self._request_handler(request)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\aiohttp\web.py”, li
ne 306, in _handle
resp = yield from handler(request)
File “C:\msn-escargot\ctrl_site.py”, line 39, in page_index
errors = create_user(email, pw1, pw2, support_old)
File “C:\msn-escargot\ctrl_site.py”, line 150, in create_user
user = _get_user(email)
File “C:\msn-escargot\ctrl_site.py”, line 223, in _get_user
return sess.query(User).filter(User.email == email).one_or_none()
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\orm\quer
y.py”, line 2784, in one_or_none
ret = list(self)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\orm\quer
y.py”, line 2855, in iter
return self._execute_and_instances(context)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\orm\quer
y.py”, line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\b
ase.py”, line 945, in execute
return meth(self, multiparams, params)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\sql\elem
ents.py”, line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\b
ase.py”, line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\b
ase.py”, line 1189, in _execute_context
context)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\b
ase.py”, line 1402, in _handle_dbapi_exception
exc_info
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\util\com
pat.py”, line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\util\com
pat.py”, line 186, in reraise
raise value.with_traceback(tb)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\b
ase.py”, line 1182, in execute_context
context)
File “C:\Program Files (x86)\Python36-32\lib\site-packages\sqlalchemy\engine\d
efault.py”, line 470, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: t_use
r [SQL: 'SELECT t_user.id AS t_user_id, t_user.type AS t_user_type, t_user.date

created AS t_user_date_created, t_user.date_login AS t_user_date_login, t_user.u
uid AS t_user_uuid, t_user.email AS t_user_email, t_user.verified AS t_user_veri
fied, t_user.name AS t_user_name, t_user.message AS t_user_message, t_user.passw
ord AS t_user_password, t_user.password_md5 AS t_user_password_md5, t_user.setti
ngs AS t_user_settings, t_user.groups AS t_user_groups, t_user.contacts AS t_use
r_contacts \nFROM t_user \nWHERE t_user.email = ?’] [parameters: (‘usuario@hotma
il.com’,)]


#4

I can’t help you but @valtron will when he will be back :wink:

It seems it’s missing a table in the database. I don’t really know how it’s suposed to be created. Have you tried “python db.py” because the table definition is in this file?

There is also a test mode that can be called using “python tests” maybe this can create the table…


#5

Yes, i try it but not work.

im working in a multi version client… in PHP AJAX and CSS and i need test it ^^.


#6

Interesting.

But how will you maintain the connection to the MSNP server? We have no gateway yet (HTTP, websocket or XMPP) that would accept disconnection. You will have to create one on your server to sit as a middle man between your PHP client and the MSNP Escargot server. Most (if not all) old web clients used one of these gateways that were supported by Microsoft servers.

Indeed, the actual MSNP protocol over TCP is not really suitable for web clients because the socket needs to stay connected. Once the socket is closed, you will appear offline and will need to reconnect and restart everything.

You can develop a gateway for us in Python :slight_smile:

Or, you can create your own gateway by having a service on your server handling all MSNP connections to the Escargot server for your users. This service would then communicate itself or through a gateway with your PHP client. This gateway has to be able to send the commands received by your service to a format understood by your client. It should also be able to convert commands from your client to MSNP (if they are not in MSNP format) and forward them to your service for them to be sent to the correct socket.


#7

Hi, thanks for the information in the PM.

I will be studying the subject, to be able to contribute within the possibilities, in everything that is necessary.

Best Regards!


#8

Do you have to run under linux or windows?
I wanted to use an old pc with windows xp as a server but I can not start it because don’t recognize the python command.
Thank you