<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Thank you very much for your help, I am able to login to SIREMIS now, I was only selected replace DB config on step 2 but this time I also selected create siremis DB and I am able to login<br>Thanks<br>Abdul <br><br><div><hr id="stopSpelling">Date: Mon, 17 Mar 2014 21:10:39 +0100<br>From: miconda@gmail.com<br>To: sr-users@lists.sip-router.org<br>Subject: Re: [SR-Users] login to siremis failed Column not found: 1054 Unknown column 'T0.id' in 'field list<br><br>
Most likely you didn't ckecked the options to create database for
siremis during the installation wizard step 2:<br>
<br>
- <a class="ecxmoz-txt-link-freetext" href="http://kb.asipto.com/siremis:install40x:main#step_2" target="_blank">http://kb.asipto.com/siremis:install40x:main#step_2</a><br>
<br>
There are 4 options there, you have to select all of them first
time.<br>
<br>
You should drop siremis database if you created some tables
manually.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
<div class="ecxmoz-cite-prefix">On 17/03/14 19:54, malik sherif wrote:<br>
</div>
<blockquote cite="mid:BLU174-W28BE5FBDB11739FFA261B6AE7D0@phx.gbl">
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr"><br>
<br>
<div>
<hr id="ecxstopSpelling">From: <a class="ecxmoz-txt-link-abbreviated" href="mailto:asherif74@hotmail.com">asherif74@hotmail.com</a><br>
To: <a class="ecxmoz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
Date: Mon, 17 Mar 2014 16:28:46 +0000<br>
Subject: [SR-Users] login to siremis failed 'siremis.user'
doesn't exist<br>
<br>
<style><!--
.ExternalClass .ecxhmmessage P {
padding:0px;
}
.ExternalClass body.ecxhmmessage {
font-size:12pt;
font-family:Calibri;
}
--></style>
<div dir="ltr">When I attempted to login to siremis , i got
the following errors "Base table or view not found: 1146
Table 'siremis.user' doesn't exist"<br>
<br>
<br>
And then I created the table manually using the following
commands<br>
<br>
CREATE TABLE `user` (<br>
<br>
`SYSID` int(11) NOT NULL auto_increment,<br>
<br>
`USERID` varchar(15) NOT NULL,<br>
<br>
`PASSWORD` varchar(15) default NULL,<br>
<br>
PRIMARY KEY (`SYSID`)<br>
<br>
);<br>
<br>
But I still have problem login with the following error
"Column not found: 1054 Unknown column 'T0.id' in 'field
list'".<br>
The I run describe user, i got the following; <br>
mysql> describe user;<br>
+----------+-------------+------+-----+---------+----------------+<br>
| Field | Type | Null | Key | Default |
Extra |<br>
+----------+-------------+------+-----+---------+----------------+<br>
| SYSID | int(11) | NO | PRI | NULL |
auto_increment |<br>
| USERID | varchar(15) | NO | | NULL
| |<br>
| PASSWORD | varchar(15) | YES | | NULL
| |<br>
+----------+-------------+------+-----+---------+----------------+<br>
3 rows in set (0.07 sec)<br>
<br>
Any idea? <br>
Your help is greatly appreciated<br>
Thanks<br>
Abdul<br>
</div>
<br>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></div>
</div>
<br>
<fieldset class="ecxmimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="ecxmoz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="ecxmoz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="ecxmoz-signature">--
Daniel-Constantin Mierla - <a class="ecxmoz-txt-link-freetext" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a class="ecxmoz-txt-link-freetext" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a class="ecxmoz-txt-link-freetext" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
<a class="ecxmoz-txt-link-freetext" href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
<br>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</div> </div></body>
</html>