Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - psyche

Pages: [1]
1
Development Deliberation /
« on: February 22, 2005, 08:32:47 pm »
Thank you.

2
Development Deliberation / World creation.
« on: February 20, 2005, 02:57:49 pm »
I\'m still looking for an eventual world editor program in planeshift ... I found no document about it and no file that could correspond in the planeshift main directory.

So I tried to open the npcroom.zip file in the art/world directory and see it contains pictures and two other files : sound.xml and world.

\"world\" seem to be a xml file, but there are so many informations in it, that I can\'t imagine someone enter them manually ...

Could someone give me more information please. Is there a information source I still don\'t know ?

3
Development Deliberation /
« on: February 20, 2005, 02:45:45 pm »
This problem was finally resolved by manualy editing mysql records and using md5(); php function to encode the password.

Maybe it would have been possible to use the php pages in the \"www\" directory in the main path of planeshift too ...

4
This time I have a problem with creating an account on my local test server.

I\'m sure it work perfectly because after I finished the installation, I managed to connect on it with the client (witch was still configured with the \"vengeance\" account). After that, I tried to create a new account (with the newacct command on the server) and to use it but I receave the error message : \"invalid password\". In the database I can see that the account has been created but, strangely the password isn\'t coded as it is for other account.

If anyone has an idea ...

5
Development Deliberation / "db connection attempt failed" width the server
« on: February 19, 2005, 10:35:43 am »
After I finally compile the server successfully, I tried to run it, but another error appear :

db connection attempt failed

Initialize:
  Could not create database or connect to it.

Other applications (such as MySQLCC) had no problems to connect, the user and the databases needed by planeshift were created. So I decide to look in the source where the error exactly append ... It was this line (/src/server/database/mysql/dal.cpp, line 62) :

conn = mysql_real_connect(conn,host,user,pwd,
database,0,NULL,CLIENT_FOUND_ROWS);

It returned NULL instead of a MySQL*. I first thought it could be the host, user pwd etc that were false. So I \"printf\" them. They were normal. I finally replace the NULL, by the exact socket adress :

conn = mysql_real_connect(conn,host,user,pwd,
database,0,\"/var/lib/mysql/mysql.sock\",CLIENT_FOUND_ROWS);

Jam, try ... and it was working. Can anyone explain me ? Is something false in my linux configuration ? My method isn\'t clean ... Can anybody suggest me a better one ?

6
Development Deliberation /
« on: February 19, 2005, 10:19:29 am »
This problem was finally resolved by installing the mysql-devel package (not include in my distribution but available on the web ...). Thank  to everyone who helped me.

7
Development Deliberation /
« on: February 17, 2005, 08:31:00 pm »
Thank you for your answer. I already did it, but even if all the packages were installed and even if mysql worked perfectly fine, I didn\'t found the headers and libraries files usually used to build mysql applications.

Maybe I will have to install mysql from the sources ...

8
Development Deliberation / MySQL Problem compiling the server.
« on: February 17, 2005, 07:19:22 pm »
When I try to configure Planeshift, I\'v got this warning message :

checking for libmysqlclient... ***
*** mysqlclient test source had problems, check your config.log ..
*** Also try one of the following switches :
***   --with-mysqlclient-prefix=PFX
***

The client work perfectly, but when I try to execute the server (psserver), this error append :

Initialize:
  Could not create database or connect to it.

Mysql runs without any problem on my computer, I use it for other things, but I heard my distibution is something special about mysql : it is the Suse 9.2 ...

If anyone could help ...
Thank you.
Nicolas E.

Pages: [1]