Re: [Serusers] SERWEB + PostgreSQL : Login trouble ( attached: my PostgreSQL database dump)
Hello John,
You will find attached my PostgreSQL database dump for Serweb; As I said I'm not sure that all the fields are good enough, maybe you will have to change some of them... Let me know if you make some modifications.
In order to run Serweb with PGSQL please do as follow: 1. load the SQL DDL file into your PGSQL
2. load at least one account with the same domain listed in /serweb/html/set_domain.php e.g. $config->domain = "your_domain.com";
2. modify: /serweb/html/config_data_layer.php $config->data_sql->type="pgsql";
$config->data_sql->host[$i]['host']="localhost"; //database host $config->data_sql->host[$i]['port']=""; //database port - leave empty for default $config->data_sql->host[$i]['name']="database_name"; //database name $config->data_sql->host[$i]['user']="your_login"; //database conection user $config->data_sql->host[$i]['pass']="your_password";
I'm using the last SERWEB from the CVS. I think that's all you need to do. If you succeed to connect please let me know.
Is there anybody using the last Serweb with Postgre ? Any chance to login ?
Thanks, SB
John Draper crunch@webcrunchers.com wrote: SB wrote:
Hello,
I'm using SERWEB but I have some trouble to login when the login/password is correct. If the password is wrong, I have an error message telling me "wrong password". But if the login/password is Ok, then the page start a long processing cycle without anything in return (after 5 minutes, blank page or server unreachable).
In my configuration, I have:
clear_text_pw=1
My default domain match with the admin user's domain i'm using to login. The database I'm using is PostgreSQL (all serweb sql scripts have been ported to PGSQL, I will provide all the sql files as soon as everything is running smoothly).
You have this running under PostGreSQL? WOW! Cool... I'm just now getting started setting up my SER server, but have no clue on how to get it hooked into PostGres. Could you point me to some documents you found that tells me how to do it?
I'm using 0.8.10 by the way, should I install a newer version?
John
Hi,
I just downloaded and extracted this file.... ser-0.8.14_openbsd_i386.tar.gz and it seems to be an "already built" SER server, as I see no build instructions, but I do see an "sbin" directory where "ser" exists. Am I to assume this is already built and ready to execute and run?
In looking at the document titled SER HowTo (HTML) I see this section....
2.5. DNS SVR Resource Records And it tells me how to setup my DNS... How important is this? I don't have control of the DNS server that serves our server, this is managed by our Co-Location.... AmI required to add these records to the DNS in order to get the server to work?
Is it possible to forgoe this step, or is it vital I have to have this done before I try and fire up the server.
My friend downloaded the ser-0.8.10 from the ports tree a while ago, and installed it, but I also extracted the binary and stuck this copy in a different place. I want to play with both versions.
Right now, I'm still in reading phase, but due to learning disability, it's taken me a long time to figure things out. So bear with me, as I'm sure I can really use some help on this.
John
On 26-08 16:58, John Draper wrote:
Hi,
I just downloaded and extracted this file.... ser-0.8.14_openbsd_i386.tar.gz and it seems to be an "already built" SER server, as I see no build instructions, but I do see an "sbin" directory where "ser" exists. Am I to assume this is already built and ready to execute and run?
In looking at the document titled SER HowTo (HTML) I see this section....
2.5. DNS SVR Resource Records And it tells me how to setup my DNS... How important is this? I don't have control of the DNS server that serves our server, this is managed by our Co-Location.... AmI required to add these records to the DNS in order to get the server to work?
No, it is not required but it is a generally good idea to have SRV records.
Is it possible to forgoe this step, or is it vital I have to have this done before I try and fire up the server.
You can use the server even if you do not have SRV, just use the hostname of the server in the domain part of SIP URIs.
Jan.
-
Jan Janak -
John Draper -
SB